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…