Creating a DDL Trigger

One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to...

PASS Update #1 - January 2012 Recap

When I ran for the PASS Board of Directors last year I committed to providing a monthly update on PASS...

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