Monthly Archives: October 2010

Happy Halloween 2010

I know Halloween was yesterday, but since it’s a holiday, and I continue to make plenty of mistakes, I’m putting out the blooper reel today. As I get ready for my trip to SQL Server Connections this week, I’m entering … Continue reading

Posted in Editorial | Tagged ,

Shopping

In about a week and a half, the SQLServerCentral opening night party takes place at the PASS Summit. And while I won’t be there, I’m in charge of the prizes that will be going out to everyone attending. In the … Continue reading

Posted in Blog | Tagged , ,

My Bucket List

I actually built on in 1999 and called it a Life List. Over the years I’ve tried to work on the list each year, knocking off something, but I also learned something. I learned that as I grew, and my … Continue reading

Posted in Blog | Tagged ,

Overwhelmed, Stress, and Planning

It’s been a bit hectic this year. In fact, it feels crazy most weeks as I try to manage work, home life, and free time. More and more I have been having a night or two a week where I … Continue reading

Posted in Blog | Tagged ,

The Growth of Professional Development

When I started in my career, it seemed that there wasn’t a good way to grow your career. Myself, and many others, somewhat fumbled around, looking for jobs with bigger databases or more money. We thought that learning to be … Continue reading

Posted in Editorial | Tagged

The Hybrid

I’m off to SQL Server Connections next week and looking forward to the conference. This is my first time attending, but I have wanted to go for some time. This is one of the few events that is not specifically … Continue reading

Posted in Editorial | Tagged

The SQL Rally – Who Would I Vote For?

I was looking over the pre-conference sessions submitted for the SQL Rally event taking place next May in Orlando. I think it’s great that the community gets the chance to vote on the submissions and help decide what will be … Continue reading

Posted in Blog | Tagged , | 1 Comment

Common SQL Server Mistakes – Functions in the WHERE Clause

This continues my series on Common SQL Server mistakes, looking at more T-SQL mistakes. What’s Wrong? If you saw a query like this, would you see a problem? select   o.OrderID   , o.CustomerID   , o.Qty from Orders o where datepart( yyyy, … Continue reading

Posted in Blog | Tagged , , , ,

The SQL Rally Pre Conference Seminars

There’s a change in how pre-conference seminars are being picked for the SQL Rally event next year in Orlando, FL. You, as the people that may attend, are getting the chance to vote on which sessions you’d like to see. … Continue reading

Posted in Blog | Tagged , ,

SQL Server 2008 – CDC Retention

I had done a little work with CDC last year, experimenting with the way that it handles changes in your database. Someone had asked me the question about the retention period since the default of 3 days was not sufficient … Continue reading

Posted in Blog | Tagged , ,