Identifying Blocking via Extended Events

There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...

Speaking at SQLBits and SQLRally

Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and...

Preparing a Technical Session Part 3: Writing an Abstract

So you’ve come up with a great idea for a session and now you have to translate that idea into...

How easy to determine table dependencies ? TIP # 86

 
Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which ...

Missing Full Text Extensions in Express

I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were...

Book Review: Virtualizing SQL Server with VMware

It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to...

Exam Prep 70-463: Variables and Parameters

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

Join me for Dashboards in a Day

Seats are limited – act fast!

This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA...

Tales of a DBA fed up with NOLOCK. Part 2

Feb 16, 2015

Dear Diary,

A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were...

T-SQL EXCEPT and INTERSECT

T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...