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

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

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