SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2011

Free SQL Exam cram sessions from Microsoft.


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

2 comments, 2,862 reads

Posted in measure twice, cut once. on 31 May 2011

A curious case of a missing configuration group.


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

2 comments, 1,477 reads

Posted in measure twice, cut once. on 12 May 2011

Catalog view or compatibility view?


The recommended way to access SQL SERVER metadata is through the catalog views.

The challenge is to be able to distinguish between the catalog views and the compatibility views, because we always want to use the catalog views rather that the compatibility views.

The compatibility views basically… Read more

0 comments, 2,843 reads

Posted in measure twice, cut once. on 8 May 2011

Certifications – and a survey.


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…

Read more

2 comments, 708 reads

Posted in measure twice, cut once. on 5 May 2011

How do you create or update stored procedures.


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


Read more

5 comments, 17,753 reads

Posted in measure twice, cut once. on 4 May 2011

Meme Monday – “I got 99 problems but a disk ain’t one”


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

1 comments, 720 reads

Posted in measure twice, cut once. on 2 May 2011

Checkpoints and the Lazy writer


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

4 comments, 16,986 reads

Posted in measure twice, cut once. on 2 May 2011