I'm not entirely consistent on writing dates. I try to use YYYY-MM-DD whenever I can but I do accept that it is not what people outside East Asia expect.
 Whenever...

I did the 70-461 last year. Now that I'm looking at new MCPs to study for, I see that the 70-761 is very, very similar to the 70-461. I probably...

I understand the need for all Internet-facing machines, let alone DB-servers, to be up to date with their patches. This is perfectly sensible.
 I think I've asked this question before....

Most of my pet peeves have already been mentioned here and it was almost always caused by the developers not caring about the database when they were developing. Not every...

I don't really see the point of table variables.
How are they an improvement on temporary tables? Is the absence of CREATE TABLE (or INTO, if you that way inclined)...

Hi Jeff,
I will indeed read up on it.
Thanks for the very prompt reply,
Sean.

I'm preparing a pilot-study on Full-Text Search and this script will go part of the way towards it. The extended procedure master.dbo.xp_DirTree will be useful anyway.
The aim is to...

I've thought about the cost of switching too.

It comes down to resources.
If you have time, say 5 years and some people (DBAs, developers & sysadmins) whose time...

I've often wondered as to whether the model of offering university students (or even prospective university students) a starting position in a company with half of the university tuition covered...

In regards to training, I can't really complain. The company has a budget for training set aside every year and for this I am thankful.

 Often though, I'd...

I do agree with you Andy. Find the tools that make your life easier and make sense to you. I love SQL Prompt, for example, while others on my team...