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

SQLbits recap

It’s already a long time ago, since I spoke at SQLbits (first week of April), but
yesterday the speakers got their...

What Are You Waiting For?

I know what I am waiting for. I know exactly what every SQL Server instance in my care is waiting...

Shuttle Endeavor last mission STS-134: I felt the shockwave

I witnessed a piece of history today at 8:56am; the last voyage of shuttle Endeavor on its STS-134 mission. It was...