First Steps Understand the subtle difference between being an Engineer, and a Data Engineer. The difference between a Data Engineer and an Engineer, is an understanding of the importance of data, and how introducing pollution to a data set, can have catastrophic consequences downstream If this is all new to you, Data Warehousing concepts can […]
I recently spoke at SQL Rally Nordic in Stockholm, and they have kindly made the recordings available for general viewing! I can’t watch it myself, because then I’d have to hear my voice, and I can’t bring myself to do it… But hopefully you enjoy it a little more than me! I cover File and
Getting the most from your SAN – SQL Rally 2013 Session Read More »
(Note, going to start updating this along with the Prodata blog, some of the stuff crosses over, so why not!) I was lucky enough to take and pass the MCM lab exam this week, which as anyone who is in the depths of it knows, qualifies you as a Microsoft Certified Master in SQL Server.
Hey, With the release of MAP toolkit 7.0, Microsoft have taken a huge leap in making this tool more useful across the board. Previously, if you didn’t have the CPT Excel plugin also, manipulating data coming out of the tool wasn’t the most fun. Now however, it puts so much information at your fingertips so
Hey, Not a technical post today, nor a long one, but just a little bookmark to signify the end of a chapter in my career. I finished up with Payzone last week, and have started work with Prodata as of Monday. It is a massive step up in trying to take my SQL knowledge to the
You can if you want, but there’s no need really. But go on, have a bit of a panic…. Done? Great! Going through some stuff here in preparation for me leaving my current job, and it occurred to me that while I have experienced this, and dealt with it now, that back when I first
Hey, This is something I’ve been wanting to blog about for a while, because I’m a big fan of database mirroring, however in a lot of scenarios (And I have been guilty of this in the past too), it’s almost a false safety net. Yes, your data is on a separate server in case your
Hey, Apologies for the continued absence of posting, work is a harsh mistress… Anyway, something I wanted to share with you as part of my ongoing virtualization learnings (AKA Hiccups). When you have limited resources you may find yourself needing to get deeper with how you dole out the resources to your SQL instance. Setting
Resource governor – Making VM’s a safer place to be Read More »
Hey, I may be alone on this ship, but migrations from SQL 2005 to SQL 2008 are a happening all over my office, and one of the pains is migrating the non database services surrounding SQL, such as Analysis Services, Reporting Services etc. So after one pain staking migration of Reporting Services, I thought I’d
Hey, I wanted to get back to the original theme of the blog for a bit, making stupid mistakes! I reckon I can fill the internet with these… But one in particular I wanted to share with you real quick. I get where Rick Deckard (Blog) was coming from. I’ve often thought of shooting rogue
