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 …
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 …
- Page 2 of 2
- 1
- 2