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 weren’t some glitches and lessons learned, but we accomplished...

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

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

SQL Server 2008 SP1 CU14 and SQL Server 2008 SP2 CU4 Released

Microsoft has released two new Cumulative Updates for SQL Server 2008 SP1 and SQL Server 2008 SP2. The first one...

SQL Server News, Upcoming Local Events & Webinars.........

Wow! It's only Tuesday, and there's so much going on in the SQL Server World! I wanted to share some...