Find unused indexes using sys.dm_db_index_usage_stats

The SQL Server maintains all indexes defined against a table regardless of their usage. Index maintenance can cause significant amounts...

TechEd North America 2012 videos online

Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free!  What a...

Slacking Off: The Right Side of the Brain

I think it’s only fitting to follow up a post about performance reviews and self-evaluations with a post about slacking...

Connection Pooling :At a Glance

What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...

PASS Data Architecture VC presents Neil Hambly–Improve Data Quality & Integrity using Constraint

Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity...

Running for the #SQLPass #NomCom

Guess, what?  I’ve thrown my hat in to the elections for the Nomination Committee for PASS.  That means that I...

Latest Presentation on SQL Server Mirroring Given at Transcontinental's Offices

With a handful of System Administrators, Network Specialists and DBAs, I gave my third presentation on SQL Server Mirroring this...

NomCom, what it’s all about

I submitted my application for the NomCom last week and the polls opened up yesterday.  I’ve seen an amazing amount...

JSON and the NoSQL “advantage” over SQL Server

First what is JSON?

JSON: JavaScript Object Notation.
JSON is syntax for storing and exchanging text information, similar to XML.
JSON is smaller...

Indexed view deadlocking

Deadlocks can be a really tricky thing to track down the root cause of.  There are lots of articles on...