The Recursive CTE

(Yet another boring org chart example – except this one has multiple roots)
One of my apps has a hierarchial org chart...

Where to put the logic? SQL? Code?

A discussion of where logic should go and why SQL might be the best place.
SQL is a powerful language and...

Checking Permissions

Someone posted this query recently:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b

where permission_name = 'INSERT'
and
b.grantee_principal_id = a.principal_idThat’s a little ugly, so let’s fix...

DBA Brush-Up

I have a session I like to give called “Forgotton T-SQL”, or sometimes “T-SQL Brush-Up”.  The idea is that there’s...

NJ SQL UG Event: SQL Server 2008 Database mirroring - MAK

May 17th NJSQL UG Meeting - SQL Server 2008 Database mirroring with MAK
Date: Tuesday, May 17th

Topic: SQL Server 2008...

Not. Quite. There. This Time I Failed the Lab

Since I’ve been blogging about my progress through the SQL Server MCM certification, it makes sense to follow-up with my...

On Transactions, errors and rollbacks

Do errors encountered within a transaction result in a rollback?
It seems, at first, to be a simple question with an...

PASS SQLRally Orlando–We took the Checkered Flag

We did it!  SQLRally happened and, from everything I heard, it was a success!  That’s not to say that there...

PASS SQLRally Orlando–We took the Checkered Flag

We did it!  SQLRally happened and, from everything I heard, it was a success!  That’s not to say that there weren’t some glitches and lessons learned, but we accomplished...

Presenting at Denver SQL Server User’s Group on May 19

I will be giving the main presentation at this month’s meeting of the Denver SQL Server User’s Group on May...