Whoa!!!

Yeah…that about covers it I think. The other day I was sitting at my desk, like always, nose down and figuring out our latest issue with the migration process at my current client. I had my headphones in streaming something from Pandora (probably AWOLNation’s ‘SAIL’ channel I created – listen here) when my phone bleeped. “You have mail” it implied. …

Becoming Brave

If you had a chance to change your fate, would you? – Princess Merida For many years I worked as a full time employee (FTE) at many places. The majority of DBAs I have met state that they became a DBA by “accident”. They worked as something else and had to eventually take over the roles of a DBA due …

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 …