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

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

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

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

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