Finding Ad Hoc Queries with Query Hash

I was presenting a session on how to read execution plans when I received a question: Do you have a...

Brad Shultz's blog on reviewing your database

Reblogged from SQL Studies: This is possibly the best blog I have every read on the subject of reviewing a...

CIO Report; 14 things you need to know about Data Storage Management

Reblogged from Imtech ICT UK Blog:   Original Article: CIO recently published a detailed article on the 14 things you need...

Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012

Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket...

Cumulative Updates - SQL Server 2012 SP1 CU6

As part of their Incremental Service Modelling, Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #6.To apply this cumulative update package, you must be running SQL...

Brad Shultz’s blog on reviewing your database

This is possibly the best blog I have every read on the subject of reviewing a database. It is witty,...

SQL 2014 SSMS is Killing my C:

I could hear SQL saying to my C: Drive "Why You Little...." Hello Dear Reader! 

The Blog about SQL Saturday 232 coming...

SQL Server – How to Add More Than One Column as a Primary Key

Sometimes you might want to add more than one column as primary key. For example, if you have three columns...

SQL Server Data Tools (SSDT) – August 2013 update

SQL Server Data Tools (SSDT) has a new update:
VS 2010: August 2013 version: 10.3.30822.0, June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0,...

Manage your SQL Server databases with SQL DMVs

Microsoft ships SQL Server with several built-in tools that database administrators (DBAs) can use to manage their SQL Server environment....