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 […]
(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, 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
Hey, Just want to say thank you to everyone who came out to the talk on Friday, I really do appreciate all the support and feedback. Below are links to the Powerpoint and Word doc on server builds. If anyone ever has any questions please contact me whenever. Here’s the link to a skydrive folder
Hey, Updates are few and far between at the moment due to my own learning, but this one I’ve had a few questions on recently, so I thought it might be worthwhile sticking up a quick post. Building a server to host a SQL database is slightly different to building a regular App server, so
Afternoon all, Sorry for the absence of updates recently, I’ve been getting stuck into certifications and unfortunately between studying and a full work schedule, finding time for updates has been hard to come by. Hope to get a break soon though and get back to updating regularly. Just a quick one this time, it’s based
Hey, A short one today, but I thought it might be nice to have some hard facts on the performance tuning I had been doing, rather than all hypotheticals. I’m happy to report that it went very smoothly, applying two indexes, identified by Database Engine Tuning Advisor, has eliminated all timeouts, and dropped our average
Follow up on last weeks problem : Performance results Read More »
Just a short one again today, as an issue came up today which required some new indexes to resolve the problem, and I wanted to stick it up while it was fresh in my mind. There are many great articles out there on SQL Profiler and Database Tuning Advisor, and Microsoft provide detailed overviews also
Evening all, hope the weekend went well for everyone. Just a short one today as I’m still in the thick of it with my SAN, oh the joys! This topic cropped up yesterday when a colleague of mine was setting up a 60GB database for mirroring, and after spending hours transferring the file, discovered he
Another one close to my heart today, and apologies for it being a little shorter than usual, a problem with table locking is taking up all of my free time! This is just a short guide to what locking is, how it works, why each different type is good and bad, and in turn how
How locking works on a table, and how it can affect your applications Read More »
