What is a Good Way to Get the SQL Server Log Directory?

Introduction
Today’s post is going to be a quick one to get back in the saddle again. I have been on...

When Did SQL Server Restart?

I saw Joe Webb’s post, and then Gethryn Ellis’ post as well on when SQL Server last restarted. It’s something...

SQL Server 2008(R2) and Win Server 2008 R2 Core Edition

The WinServer 2008 Core Edition was the server that you cannot install the SQL Server 2008. The Win Server 2008...

SQLSaturday #39 NYC Presentations available online....

SQLSaturday #39 NYC Presentations available online....
If you were at SQLSaturday in NYC and want to see it again, or, you...

With Great Advice Comes Great Responsibility

I know that you have seen it yourself too. That forum or blog post that contains “advice” that is daft,...

A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s

 A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
I just want to pass along a few...

SSIS : Data Flow paths

I had a very interesting bug that had me running around for over a week.  Turns out the bug was...

TempDB Internals

TempDB Internals: TempDB is very important DB in sql server, generally sql server automatically takes care of the storage management...

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

Marathon Schedule

Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are...