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 #28: Why does SQL SERVER Management Studio report that my Azure SQL Database version is 12?

Very often, our customers are asking about why does SQL Server Management Studio report that my Azure SQL Database versions is 12? Does it mean that I’m using SQL SERVER 2014? Why does it mean that is not updated? The explaination is that if your application check the version of SQL using select @@version the…


Lesson Learned #22: How to identify blocking issues?

Today, we were working on a service request where our customer reported that, some TRUNCATE executions are taking more time that they expected. Normally, these TRUNCATE commands just only take 3 or 5 seconds to complete, however, this time, the problem is that they never finish. Using the following TSQL command: select conn.session_id as blockerSession,conn2.session_id as…