Hi @Advissor-6856, welcome to Microsoft Q&A forum.

I am checking on this and will get back to you at the earliest possible.

Hi @ManishYadav-9834, thanks for your patience.

Please check below link that includes examples of session state providers and also various parameters that can be defined in connection.

Configuration

StackExchange.Redis

Sorry for the delayed response @ManishYadav-9834,, actually mutual authentication (two way ssl) is not a supported feature for the Azure Redis Session State providers and there is currently no plan as well to implement the functionality in the future. We might need to come up with some workaround on this. I will keep this thread posted in case I am able to figure out any way to achieve this. Sorry for the inconvenience.

Hi @RussellHDeGrove-7123, welcome to Microsoft Q&A forum and sorry for delayed response.

Could you please confirm if you want to create deny policy to check for max cores? Meanwhile I am checking this same, correct me if I am wrong here.

Hi @RussellHDeGrove-7123, could you please check the above response and let us know if you want to create a deny policy.

Hi @AnoopMohanan-5010 , just wanted to check if you were able to check the reply provided by @ChaitanyaNaykodiMSFT-9638. If you need any other details please let us know.

Thanks for replying back. I am not 100% clear about the ask, please check below if this is what you are looking for:

 select LEFT(id, PATINDEX('%[0-9][^0-9]%', id)),LEFT(details, PATINDEX('%[0-9][^0-9]%', details)) from test1

Or else you can provide the output you want and I can try to work upon.

Hi @ShambhuRai-4099, welcome to Microsoft Q&A platform.

If the number always comes at the start, then you can use below:

 select LEFT('3ddf', PATINDEX('%[0-9][^0-9]%', '3ddf'))

You can also use the same in insert statement before inserting it to database:

 insert into test1
     values(LEFT('20kjk', PATINDEX('%[0-9][^0-9]%', '20kjk' )) ,LEFT('3ddf', PATINDEX('%[0-9][^0-9]%', '3ddf' )))

Please let me know if this helps or else we can discuss further.

Reference: split alpha and numeric using sql

Hi @55574596, were you able to check on this as suggested in my previous comment.

Thanks for replying back.

Yes you are right, if we don't use the partition key which in this case is concatenated value then performance will be impacted as the search will not be restricted to single partition.

Thanks for your patience. Please check if below response from the product team helps:

"ODBC Driver for SQL Server does not have the same set of features (AAD auth) between Windows and Linux. So, it depends on the authentication option. For example, interactive auth with MFA is supported only on Windows. Using Access token with PyODBC / ODBC is one option. See thread below for a solution"

odbc - Connect to Azure SQL in Python with MFA Active Directory Interactive Authentication without using Microsoft.IdentityModel.Clients.ActiveDirectory dll - Stack Overflow

Thanks for replying back. I am checking on this and will get back to you at the earliest.

Hi @BubbaJones-9922, welcome to Microsoft Q&A forum.

Could you please clarify when you say you want to select random items from one of your documents, do you mean random selection of documents from entire container or random properties from one document?

Hi @zr123, welcome to Microsoft Q&A forum.

I am checking on this with internal team and will get back to you once I receive the response.

Hi @RamonLipparoni-6246, welcome to Microsoft Q&A forum.

Please let us know if you are using SQL Server on VM or Azure SQL Database as paas. Also if possible to provide the screenshot of usage of the capacity, it would help us in understanding the issue more.