Installing SQL Server 2016 CTP2 – UI Changes

SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No,...

Query Progress Tracking in SQL Server for the DBA VC

This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter.
The session covers...

Refactoring Mistakes Are Why We Write Tests

I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s...

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

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

Creating an Azure SQL Database

By David Postlethwaite
Once you have logged in to the Azure Management Portal you can start to  create an Azure SQL...

Earning my MCSE: Business Intelligence Certification

I earned my MCSE: Business Intelligence Certification on May 27, 2015. It was a long road, but I did it....

Extending your metadata with Extended Properties

Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on...

Integrating Other Data Mining Tools with SQL Server, Part 1.1: The Weaknesses of WEKA

By Steve Bolton
…………The same rules that applied to my amateur mistutorial series on A Rickety Stairway to SQL Server Data...

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