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

T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore

T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore

This blog entry is participating in T-SQL Tuesday #31, hosted this month...

SQL Server 2005 Diagnostic Information Queries (June 2012)

Here is the latest version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements, including...