Reblog: MDS – A Database Error Has Occurred

I recently came across the following error message when I tried to look at the batches in the Integration Management...

SQL Server on Linux Authentication

Yesterday Microsoft announced that they will now support SQL Server on Linux.  They are targeting mid-2017, but you can download...

SQL Server on Linux Authentication

Yesterday Microsoft announced that they will now support SQL Server on Linux.  They are targeting mid-2017, but you can download...

The Shield

How many of you are known as the “Grumpy DBA” or have a bad reputation with users because you are...

The Virginia Tour 2016

Three days of presentations in Richmond Virginia. From Naked SQL to Wheel of Doom - there is a wide breadth of knowledge to be shared.
Related Posts:

An Experiment with Deadlocks...

The Virginia Tour 2016

Long Time Coming
With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.
This...

Using SELECT INTO with UNION Statements

On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table....

Using SELECT INTO with UNION Statements

On occassion, I need to take a number of different result sets and combine them into a single output, which...

Availability Group DMVs Reporting Incorrect Values

In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism for AlwaysOn Availability Groups. Check out the many new...

Different ways to find Data, log and DB Size

Different ways to get the size of the data , log files and Databases
Using CountersQuerying sysaltfiles & sys.databasesQuerying sys.master_files 
SELECT instance_name AS DatabaseName,
[Data...