Archives: May 2011
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at a task, especially if you don’t use that particular piece of a technology in your day job.
One good way of measuring these skills is to sit certifications and… Read more
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things that I did was install SQL SERVER 2008 developer edition on it.
As I’d expect, this was a pretty straight forward task and before long I had… Read more
The recommended way to access SQL SERVER metadata is through the catalog views.
The compatibility views basically… Read more
There’s a lot of mixed opinions around about certifications.
Are they worth while, do they mean anything, do employers value them and the like.
I’m personally in the “certifications are definatly” worth while camp. For a few reasons,
- Certifications test my knowledge to a certain standard and give me…
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system is being built in an agile manner. Stored procedures get created and altered all the time.
Very often I used to see code like this
IF EXISTS (…
Apparently “Meme Monday” was started by Thomas Larock (Blog | Twitter) , as a way for getting people writing. I haven’t been tagged or anything, I just thought that I’d gate crash the party. It was also Tuesday (here in New Zealand), when I seen this weeks… Read more
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason that I’m blogging about that is because I can completely understand how people can confuse these two events – however they are totally different. This post… Read more