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

SSWUG SSIS Expo Event This Friday

Home Sweet Cubicle
If you are looking for a little training on SQL Server Integration Services (SSIS) without having to leave...

Stop SOPA…it already happened in Denmark #StopSOPA

I put out the call to stop SOPA, and one Twitter friend wrote back:
Good luck! We have it in Denmark....

Table Hierarchy goes CS

At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity.  The first few rounds, I neglected Case Sensitivity and never...

Table Hierarchy goes CS

At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity.  The...

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 I wrote here and here. Since writing those last...

A Trio of Tools

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

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