Alex Rosa & SQL Server & Microsoft Azure

DECLARE dba AS human … SET dba = family + rdbms + friends + career + day_by_day + certifications + theory + real_life_experience

Azure SQL Database v12 – Object Explorer wrong version and unable to rename a database in SSMS

Few weeks ago I was creating a demonstration using Azure SQL Database v12 and I notice that the version shown in SSMS Object Explorer was different than it was shown through T-SQL commands, like @@version. So, let me share with you what I found so far regarding to this situation.   01 Problem SSMS Object Explorer… Read more

Comparing DMVs between Azure SQL Database V11 and V12

As we know, the Azure SQL Database V12 had a huge improvement in terms of features available. Per consequence, more DMVs were enabled. You can check it out what’s new in SQL Database V12 in the following link: http://azure.microsoft.com/en-us/documentation/articles/sql-database-v12-whats-new/   In V12, there are: 117 new DMVs, 28 were kept and 4 were removed. It’s… Read more