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

Updated SQLSaturday Advisory Council

About a year and a half ago we put together the first advisory council consisting of Andy Leonard, Kevin Kline,...

SQLRally Nordic

With all the talk about SQLRally Orlando you may have missed that we’ve got another SQLRally event in the pipeline...

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

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

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

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

Using an Excel Destination in SSIS with x64

My first real experience with SSIS began in late Feb of this year.  I was upgrading a system from SQL...

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

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