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...

Author: Alex Rosa [MSFT] Date: 05/15/2015

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...

Author: Alex Rosa [MSFT] Date: 05/12/2015

Mind Map - Windows Server 2008 R2 Failover Cluster

During my studies, I use to create mind maps to help me memorize or remember key words of a topic....

Author: Alex Rosa [MSFT] Date: 04/12/2015

Installing SQL Server 2008 + Windows Server 2012 = Cluster Service Verification FAILED

Last week I was working with Marcelo Fernandes (SQL Server MVP) and he asked for help to try to find...

Author: Alex Rosa [MSFT] Date: 08/17/2014

Extended Events - Table of events per SQL version

I was reviewing XEvents and I've decided to share the file attached where you can find the Extended...

Author: Alex Rosa [MSFT] Date: 08/07/2014

Max Worker Threads - Lower and Upper Bounds - The Correct Formula

Last week I was discussing with some friends, how SQL Server works with threads: Max Worker Threads...

Author: Alex Rosa [MSFT] Date: 08/05/2014

PerfMon - Where are the process counters?

Almost everybody knows how to use Windows Performance Monitor, or just PerfMon, but there are some...

Author: Alex Rosa [MSFT] Date: 07/12/2014