What is the current database context?

Every now and again it can be very helpful to know what the current database context is when you are...

When naming transactions causes an error

For the last part of the series on transactions, I’m going to look at a problem that I ran across...

The Unconventional Guide to How to Implement Lookup Transformations TIP #124

This is one the articles in the series of step by step SSIS tutorial. In this post, we are going...

A Few Days Off in Space Country

The new Star Wars film opens today, and while I won’t see it then, perhaps I’ll get to it early...

Advent of Code

I ran across this site after reading a post from Jeremiah Peschka. It’s an interesting idea, and since I’m trying...

Advent of Code Contest

I saw the post from Steve Jones about the Advent of Code contest and decided to take a look. The first...

Monday Morning SQL Break – December 28, 2015

It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...

One More PASS Board Update for 2015

Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?

Never mind.*
Instead, it seems I’ll be...

Speaker of the Month: December 2015

The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...

Can we get a license for DDL Triggers?

There are several types of triggers.
Logon triggers – Fired when someone tries to connect to the instance.DML triggers – Fired after...