SQL Server 2008 R2 SP3 Install Errors

Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong.  I would...

Notes on the May 27, 2015 PASS Town Hall

I attended the online Town Hall yesterday, the second one that PASS has held this year. The recording should be...

Creating a SQL 2016 CTP2 Virtual Machine in Azure

With the CTP2 of SQL Server 2016 now released you may be eager to try it out.  One of the...

SQL Server 2016 Live Query Statistics

So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the...

Multiple Windows Groups with different default databases

A question came up at work the other day, mostly as a mind game, but you never know it might...

Microsoft Azure SQL Databases – Power and Performance

By David Postlethwaite
On the Database Scale page we can decide on the performance level that we want our database to...

SQL 2016 Preview has been released!

For those who haven’t noticed already:
SQL Server 2016 CTP2 (or Preview as some call it) has just been released!

This means...

Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5

Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account...

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
MAY 28, 2015

For those of you who have been following along with this series of posts,...

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...