Monthly Archives: February 2011

2011 MVP Summit – Day 1

I’m glad I went running this morning. It’s been a long day, in and out of sessions and meetings all day on the Microsoft campus. I didn’t get to a lot of sessions, preferring to meet with people in the … Continue reading

Posted in Blog | Tagged ,

Test Complete – MCM

I took the MCM test today, and finished it. I needed the time allotted and it was, well, an experience. I’m glad it’s done as I have a number of other things to work on. I’ll get results in a … Continue reading

Posted in Blog | Tagged ,

Test Day

Heading out to get coffee in a few minutes. And then on to the testing center for my MCM Knowledge Exam. I’ve reviewed a number of things in the past week and have been studying regularly, but not overly hard … Continue reading

Posted in Blog | Tagged ,

Odd Questions

Most people are aware that there are certain questions that you cannot ask someone in an interview. There are also a much larger list of questions you should not ask, but that still leaves you with a huge number of … Continue reading

Posted in Editorial | Tagged

Drive

At every company I’ve ever worked, it’s been easy to tell the high performers from the low ones. There’s often a correlation between those the level of performance and the satisfaction people have in their jobs. Higher performers are often … Continue reading

Posted in Editorial | Tagged

You Can’t Disable the CLR in SQL Server – MCM Prep

At least not completely. There are some functions in SQL Server that are built on the SQL CLR, and even if you have disabled the CLR for user written code, it still loads app domains and functions for system code. … Continue reading

Posted in Blog | Tagged , ,

Commuting Pain

It’s hard to believe that I have been running SQLServerCentral for almost ten years. I’ve thoroughly enjoyed it, hope I get to do it another ten years, and am thankful every day for having one of the best jobs in … Continue reading

Posted in Editorial | Tagged

T Minus Three Days to the MCM Test

I take the MCM test on Friday. I’ve been watching videos and reading white papers and blogs for the last few weeks and I know that I don’t necessarily know enough. To some extent I have an advantage since I … Continue reading

Posted in Blog | Tagged ,

Archiving Little Used Data

Someone asked the question lately about archiving old data. This person wanted to purge data from old tables and was wondering if there was a way in SQL Server 2005 to detect the last time a table was accessed. While … Continue reading

Posted in Editorial | Tagged

Catching Up

It’s President’s Day in the US, and technically a holiday for me (I think). Hard to tell since my company is a UK company and the holidays get a little weird for me. However it’s a holiday for my wife … Continue reading

Posted in Blog | Tagged , ,