Were the Mayans right all along?

A few weeks ago I had just disembarked from SQLCruise Alaska 2012 and was in a great mood. I decided to head on up to Philadelphia for SQL Saturday #121 to keep learning SQL and to meet up with a couple of cruisers that happened to be presenting there. My wife and I wound up volunteering and meeting even more …

Where do you draw the line?

Yesterday was an interesting day to say the least. I was in one of our weekly data team meetings when the topic of our release notes came up. Needless to say a very heated discussion arose from it. Apparently after Monday afternoon’s database change roll out occurred there were 2 stored procedures that broke due to a column being renamed …

To Test or not to Test – That is the question

To test or not to test, that is the question: Would you rather have a person that takes longer to find, but knows what you need and is skilled, or a body to throw at a project to get things done. We have adopted a new interview process: a 3 hr ‘skills’ test with full internet access (since we all …

Data driven cursors to encrypt values in table

The following code is some I whipped up this morning to use a lookup table to then go and encrypt values in a table. This way the data team does not have to even look at the data reducing the risk of sensitive information leaking out. It is all still being worked on but I wanted to make sure I …

I know exactly how he feels

It is like building a DB system with no specs or guidelines as to what needs to be done. You do the best you can and then the client says something and you wind up here. From: This cartoon had a bad day at work.

SQL 2008 CDC – Net vs All and Slow Changing Dimensions of type 2

As noted before I am using SQL 2008 CDC to incrementally update a data warehouse for the project I’m currently working on. I found this snippet of code that inserts a new record. If matching an existing row, it marks that row as no longer active and then inserts the new row as the new active row. A process I’ve …