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

Database Tables

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

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

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

Service Broker: What does a DBA need to know?

Service Broker is SQL Server’s internal messaging system. It has been designed as an asynchronous, reliable and transactional messaging system...

Do You Document Your SQL Server Instances?

When I was a novice DBA, I spent little time documenting my SQL Servers. But as I became more experienced,...

SQL Saturday Pensacola presentation file downloads

I had a great weekend at my fourth annual visit to Pensacola for SQL Saturday, which had many great sponsors,...

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

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