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...

Database Tables

Today I was asked for "a list of all tables in all databases" on a particular instance of SQL Server. ...

PASS 2012 NomCom

I’m officially on the slate and running for the PASS 2012 Nomination Committee!
I love the SQL Community and everything it embodies. ...

PASS Nomination Committee

For some reason, which isn’t completely clear to me, we’re voting for part of the members of the Nomination Committee...

Guest Post – The Last Starfighter

Today I am delighted to be able to share with you a guest post from one of my all time...

@LearningTree: 2108 SQL Server 2012 Database Administration

This past week my international adventures have continued. As some of you know, for the past couple of years, I...

Command Line Prompts for Checking Active Directory Membership

Using Active Directory groups are a great way to manage and maintain security for a solution.  Think about if you...