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

Archives: March 2009

Buying A Plane

There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes themselves have issues, but rather many questions about whether corporations are spending shareholder dollars appropriately. It's not a simple topic, but clearly there did seem to be a lack of… Read more

6 comments, 1,456 reads

Posted in SQLAndy on 31 March 2009

Orlando .NET Code Camp 2009 Recap

On Saturday, 3/28, I presented Useful T-SQL Statements You May Not Be Aware Of at the 2009 Orlando .NET Code Camp. Despite some glitches with the projector I think the presentation went well. About 20 people came and there was a lot of good dialog, a few laughs, and… Read more

0 comments, 1,428 reads

Posted in Kendal Van Dyke on 31 March 2009

Lunch in Town

One of the guys I met at the Denver User Group pinged me last week for lunch, and I agreed. Today I headed into town and we had a long lunch, almost 90 minutes, while we chatted about business, life, kids, and more.

It’s interesting to get a new perspective… Read more

1 comments, 1,801 reads

Posted in The Voice of the DBA on 31 March 2009

Microsoft Project Migration Template for the move to SQL 2008

If you are planning a move to SQL Server 2008, although this process can apply for many Database Migrations, perhaps this Microsoft Project Migration Template could help? * There are perhaps steps that I’ve missed out, or you know of an existing template that’s even better – by all… Read more

0 comments, 4,770 reads

Posted in The Database Hive for SQL Server DBAs on 31 March 2009

SQLSaturday #15 in Jacksonville

The call for speakers is still open and will close April 6th, there's still from for a few more sessions. it's coming up on May 2, 2009, at The University of North Florida Campus, 1 UNF Drive, Jacksonville, FL 32224 (same location as last year). I've submitted two sessions and… Read more

0 comments, 1,333 reads

Posted in SQLAndy on 31 March 2009

The Prius Update

Our second major repair will take place on the Prius, and once again it’s a cosmetic item. In fact, we’ve had 3 incidents in the Prius, none of which has affected the mechanical or electrical systems. It’s 2 years today what I bought the car, and so far we’ve had: Read more

1 comments, 1,892 reads

Posted in The Voice of the DBA on 31 March 2009

Keeping Relevant in the Face of Changing Technologies

I was recently asked by a co-worker on my team at work what he should do to keep up with changing technologies in our career field.  I was slightly amazed at the question, as I know I have made my thoughts on the matter fairly clear for several years.  My… Read more

2 comments, 1,874 reads

Posted in SQL Musings from the Desert on 31 March 2009

Notes on the 2009 MVP Summit

Note: I was working on this at the Summit and then it got lost in the draft folder, so unfashionably late here are a few comments about the event.

I flew out from Orlando on Sunday, had a reasonably pleasant flight to Dallas, actually arriving 15 minutes early. So far… Read more

0 comments, 1,461 reads

Posted in SQLAndy on 30 March 2009

Submit your PASS abstracts now!

Hey, there are probably some other blogs here letting you know that the PASS call for speakers is open right now, but another reminder can't hurt. Here is the link to the new Speaker Resource page that will give you all the information you need and the link to the… Read more

0 comments, 1,337 reads

Posted in Advice from Aunt Kathi on 30 March 2009

Until You Know Better…

Stick with the defaults. In fact, as Andy Warren has told me many times, unless you know better and have a reason to not do so, always go with the defaults. I think that’s good advice, and it’s why I think that defaults in applications, especially SQL Server, should be… Read more

0 comments, 1,655 reads

Posted in The Voice of the DBA on 30 March 2009

Notes on the 2009 Orlando Code Camp

This was an interesting year to watch the local Code Camp. Shawn Weisfeld organized it the previous two years, but following his move to Dallas Jessica Sterner become the power behind the Code Camp this year and as much as she was involved in the prior two years, leadership transitions… Read more

1 comments, 1,429 reads

Posted in SQLAndy on 29 March 2009

SQLBits a Smashing Success

SQLBits IV was held in Manchester, England, Saturday March 28th, 2009, and was attended by more than 360 attendees. This free SQL Server event is the largest of its kind in Europe. It included 28 sessions by 28 different speakers. Below are a few photographs from the event.


Simon… Read more

7 comments, 2,081 reads

Posted in SQL Aloha on 29 March 2009

Coming Soon: Pro SQL Server 2008 Mirroring

Coming Soon: Pro SQL Server 2008 Mirroring

Pro SQL Server 2008 Mirroring will be the first book dedicated to the subject of database mirroring. Most books only gloss over the topic of database mirroring. Even books that claim to be dedicated to failover clustering and database mirroring only have a… Read more

Do You Support the Ancient Ones?

Do You Support the Ancient Ones?

Are you still supporting SQL Server 2000? How about 7.0 or 6.5?

Officially, Microsoft support has ended for these products. I know plenty of companies that are still using SQL Server 2000. Even within Microsoft SQL 2000 is still in use. Mostly it's old… Read more

Tweet Your Job Away

A great example of how to “Tweet” poorly. This guy got fired before he started work.

Twitter is a series of hallway conversations. I think that’s a great description, and I’ll write more about that at some point. However just like those hallways, you need to be aware that… Read more

4 comments, 1,748 reads

Posted in The Voice of the DBA on 27 March 2009

Featured Blog - Brian Kelley

My friend Brian writes Databases, Infrastructure, and Security and like me, he writes about an eclectic mix that goes beyond SQL to Windows and life, but the part that makes me recommend that you visit his blog is the emphasis on security. Brian is always there with reminders about vulnerabilities… Read more

0 comments, 1,439 reads

Posted in SQLAndy on 26 March 2009

Android v Windows Mobile

I’ve had a number of cell phones in my life, probably more than many people. Typically I’ve just grabbed a low end phone that serves as a phone and does a good job there. However as I’ve traveled more over the last few years, and have a need to be… Read more

3 comments, 3,944 reads

Posted in The Voice of the DBA on 26 March 2009

Minimalist Design

I'm been in tactical mode lately, building an advertising management system for one of our projects. Actually it's v2, the first one is working and doing what needs to be done (definitely minimalist), but as we started looking at wrapping up the major development we decided to add a few… Read more

4 comments, 1,593 reads

Posted in SQLAndy on 25 March 2009

Some Common Date Routines

I'm sure that these routines are available in a variety of locations, this just adds one more place that people can find them if they need them.  These are some common routines for generating commonly needed dates.  I hope people find them useful in MS SQL Server.


declare @ThisDate…

Read more

18 comments, 25,074 reads

Posted in SQL Musings from the Desert on 25 March 2009

Gone Dark

This afternoon was quite interesting around the office.  A strong thunderstorm moved through the area, a common occurrence in Texas during the spring.  However, this storm took out a critical transformer nearby and knocked out the power grid for some time.  Our emergency generators roared to life without a hitch,… Read more

1 comments, 1,394 reads

Posted in Tim Mitchell on 25 March 2009

Older posts