A DMV A Day – Day 30

The DMV for Day 30 is sys.dm_os_buffer_descriptors, which is described by BOL as:

Returns information about all the data pages that...

News

If you follow me on Twitter or are my friend on Facebook, you might already know the news. I am joining...

When was SQL Server last restarted?

How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...

SQLSaturday #41 - Atlanta Session Recap

Last Saturday, April 24, I presented my session, Why I Use Stored Procedures and You Should Too, at SQLSaturday #41-Atlanta, see...

PASS Update #29

By the time you read this we’ll have completed the transfer of the SQLSaturday web sites and data to PASS...

A DMV a Day – Day 29

The DMV for Day 29 is sys.dm_exec_connections, which is described by BOL as:
Returns information about the connections established to this...

A Identity Bug

Someone asked an interesting question recently. If they had this code:
if OBJECT_ID('aa') is not null
   drop table aa
create table...

How to Tell When SQL Server Started?

As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to...

SQL Server Connection Strings

The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...

Undocumented Capabilities of Extended Event Objects

Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...