SQL Server 2012 Diagnostic Information Queries (August 2012)

Here is the August 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...

SQL Server: List Explicit Permission on Database for Login and Database Role

As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...

Three Generations of Toshiba Portege Laptops Compared

Since I am a bit of a hardware enthusiast, I tend to buy new computer hardware a little more often...

View Flat File Contents Using PowerShell

We have all been there; you need to take a look at the data inside a file. Sure you can...

Blocking in SQL Server by SPID -2 (Orphan distributed transactions)

Blocking in in SQL Server by SPID -2 happens due to Orphan DTC transaction, for instance whenever a data source...

How to Find Bad Page Splits

http://www.flickr.com/photos/brickapolis/5474835288/

I was working with a friend last week, doing SQL related teaching and tune ups.  Earlier this week I had...

Jump start your SQL 2012 Certification for FREE

Hey all you proactive SQL junkies, want to jump start your SQL 2012 Certification? Or are you just here because...

Learn to Use Books Online

One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer...

Recovering from out-of-disk space conditions for tempdb

Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...

Rollback TRUNCATE TABLE statement

Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...