PASS Update #2 - February 2012 Recap

During the January board meeting we were told that attendance at the 2011 Summit exceeded expectations and as a result...

Removing a DDL Trigger

In a recent post I talked about how to create a DDL trigger. You’d think to drop that trigger, I’d...

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