Lesson Learned #40: Could it be possible to use Intellisense with an Azure Active Directory user in SQL Server Management Studio?

The answer is Yes! but we need to do some additional steps in our environment.   If you are the SQL Login administrator or Azure Active Directory administrator user you will have the list of the objects using Intellisense, but, what happens if I’m connecting with non-adminstrator Azure Active Directory user. Let me show you…


Lesson Learned #34: Does Azure SQL Database support OPENJSON?

The answer is Yes! but your database needs to have in the compatibility level 130 or above. If your database compatibility level is less than 130 you could get an error about “incorrect syntax near the keywork with” or “invalid syntax”.   Please, follow these steps to read a JSON file from a Azure Blob…


What will happen with CATALOG_COLLATION and Case Sensitive vs Case Insensitive

One of the options available when creating a database is the CATALOG_COLLATION, by default this is going to be SQL_Latin1_General_CP1_CI_AS , even if you take the trouble of specifying a database collation , the catalog collation will be SQL_Latin1_General_CP1_CI_AS unless you say otherwise. If you do not set this parameter it will not use the…