Query Hash Formula Changes Between Versions

The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...

How to Configure E-mail in SQL Server Step by Step–TIP #96

 
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL ...

Follow the yellow brick what? My road to public speaking.

Follow the yellow brick Road!
Original Image Credit: airdiogo on flickr
If you would have asked me 2 years ago if...

Moving SQL Server data between filegroups – Part 1 – Database Structures

Why is moving data between filegroups hard?
****As a consultant its common to walk into a customer site and find databases that are contained in one very large file. For...

SQL 2014 CU5

By David Postlethwaite

If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited...

In-Memory OLTP: Part 3 – Checkpoints

This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...

In-Memory OLTP: Part 3 – Checkpoints

This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...

The MERGE Statement – One Statement for INSERT, UPDATE and DELETE

Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant...

T-SQL HOST_ID and HOST_NAME

HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL...

The hidden security of msdb

To be fair it’s not actually hidden, just not so well known.
Have you ever wondered how to grant permissions...