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

A Trio of Tools

I have talked about tools for SQL server a few times in the past.  You can read some of what...

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

ColoradoSQL in November (2011)

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...

DBA in Space: Behind the Scenes Part 2

This is a continuation of my DBA in Space journal.
 

 
Monday & Tuesday, September 12-13, 2011
Today I make my “secret” journey to...

Going to PASS 2012!

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

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?

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

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

Quotename in SQL

Quotename() is a SQL Server String function.
It accepts an input string of of up to 128 characters. Which is a...