Last Weeks Top 10 “Reading” Links #4

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out...

Microsoft Surface RT Review

Last Friday, pretty much on impulse, I decided to go to the Microsoft Store in the Park Meadows Mall in...

Monitor Blocking with Extented Events in SQL 2012

1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO

here we...

Virtualizing Your Business Critical SQL Servers Anthology

This week I completed a six-part blog series (more like five plus one) on the path to virtualizing your business-critical...

Advanced TSQL training

Over the past few years, Ive had it on my to do list to write and deliver and full-scale SQLServer...

Countdown to PASS Summit 2012 – 9 to Go – My First Summit

We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to...

[off topic] I crossed a milestone today

Hey everyone,
I have been nearing this goal for some time (a few times coming within fractions) so this is somewhat...

Database Mirroring Error

I have been setting up multi instance database mirroring for the last couple of days along with some other DR...

DBA Question of the Day: Statistic

http://www.flickr.com/photos/_barney/5177975707/Hello Dear Reader, yesterday I posed the question to you what are Statistics?  We could get down and dirty of...

Decoding first, root, and FirstIAM in Sysindexes

Have you ever looked at the first, root, and FirstIAM columns in sysindexes and wondered…
“What do these values mean?”
Recently, I...