Plagiarism

It seems to rear it’s ugly head more and more these days. Once again I found some content from my...

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