SQL Server A to Z – Views

Happy Wednesday folks! Hope everyone’s having a great week. This episode of SQL Server A to Z is brought to...

Identify Risk Early

One of the mistakes I see a lot is teams failing to identify risks early and failing to leave time...

DBA in Space: Behind the Scenes Part 3

This is a continuation of my DBA in Space journal.
 

Friday, September 16, 2011
OMG. (This is the first time in my...

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

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

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