SQL Triggers - An Introduction

Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...

The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.

Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my...

The First Thing To Do After Creating Keys

I’ve been looking at some security code in preparation for a few talks I plan on doing next year and...

Last Week's DB Security Workshop @ Oracle Montreal

DB Security Workshop @ Oracle Montreal
I have
dedicated several posts on the importance of being a Data Steward, and the
consequences of not...

PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?

Subject:  On beyond Zebra AdventureWorks or where did I go wrong?

Level: 200 (Intermediate)
Start Time: Thursday, November 17, 2011 8:00...

PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?

PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject:On beyond Zebra AdventureWorks or where...

Un-SQL Friday: Stop SOPA!

This will be an unusually political Un-SQL Friday – and it’s two days early, to boot – but I’m making an exception...

The Calendar Driven Organization

I’ve had jobs where I might have one meeting a week, I’ve had a few with some type of daily...

Going to PASS 2012!

As I have previously written about in this space, I have recently moved to House of Brick Technologies.  Part of...

A Trio of Tools

I have talked about tools for SQL server a few times in the past.  You can read some of what I wrote here and here. Since writing those last...