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

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

Visualizing the Tally Table

I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem...