When Do We Say Enough Is Enough? Recently Anthem Blue Cross Blue Shield announced that the ‘private’ information of up to 80 million customer was stolen. It wasn’t anything about medical history taken, just all their customer’s personal data. You know, the stuff that can be used to fake someone’s identity and make their life a living hell? If that …
When Do You Ask for Help?
Stepping Back I am taking this moment to step back to try to process a few things myself in this post to hopefully gain some clarity. These are my ramblings on the state of things with WaterOx Consulting and my efforts to make it into a successful venture. What Have I Been Doing All This Time? Great question. What have …
Friends of Redgate 2015
It’s official, I am in Friends Of Redgate for 2015! Ok, the last few months have been an absolute whirlwind of activity for me. Back in October I was recognized by Microsoft by joining the ranks of the SQL MVPs out there, and now Redgate has added me to the Friends of Redgate program for 2015. I am beyond words! …
Identify Primary Keys That Are Not Identity Columns
Continuing the thoughts of knowing what is going on in your database let’s talk a little bit about primary keys. Primary Keys A primary key is one that uniquely identifies a given row in a given table. They are a requirement to be able to use foreign key restraints that help to retain referential integrity throughout your database along with …
Have We Devalued SQL Server Consulting?
Have we given too much away? SQL Server has an amazing community. It freely provides information and training of SQL Server technologies via the internet and even in person events like SQL Saturday’s. This is fantastic for anyone who works in SQL Server. It has even been noted that having SQL Server skills can increase your base salary rate with …
12 Things To Check With SQL Server To Prepare For Winter
There you sit, watching TV, when you hear it: “Analysts are predicting massive cold fronts this winter! Learn 12 tips to prepare for winter and the storm of the century tonight at 11!” “Oh my gosh!” you think, “I’d better pay attention and record that for future reference” Yeah. You are probably like me and just get back to trying …