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

Archives: March 2007

Post Timeouts

Well one problem was solved. Or at least identified.

We've had an issue for a few years where you'd hit the reply button in the forums, then type in a message and when you hit "Post", the session disappeared. Actually I think this happens with the signup page sometimes as…

Read more

0 comments, 1,390 reads

Posted in The Voice of the DBA on 31 March 2007

Late Projects

I was talking with Andy Warren, my partner and fellow partner here, today about the Code Camp in Orlando last week. He was down there with Steve McConnell trying to promote our training business and the local user group. So when I got home and saw this thread on late…

Read more

0 comments, 1,415 reads

Posted in The Voice of the DBA on 27 March 2007


I was always someone that was ambitious as a kid. For whatever reason, I've been driven most of my life to succeed. Maybe it comes from being fairly poor as a kid. When my parents split, I was about 7, and my brother, I and my Mom lived in a…

Read more

0 comments, 1,413 reads

Posted in The Voice of the DBA on 22 March 2007

Whitepaper on ESX Server 3.0 and SAN-attached Storage

First saw this at Blade Watch. VMWare has released a white paper on using SANs with VMWare ESX Server 3.0. You can get the whitepaper here:


It's a hefty document at well over 200 pages. This will be something I'll be delving into over the next week,…

Read more

Updated Website

I've taken some time to update my website. In particular I have updated:
Nothing fancy or special, but just some needed updates.

Technorati Tags: Chess | SQL Server | Microsoft SQL Server | Reading | Writing

Read more

Windows PowerShell and Windows Server 2003 SP2

Saw this on the Windows PowerShell blog:

Since W2K3 SP2 is an update to W2K3 SP1, if you install Powershell on W2K3 SP1 and upgrade to W2K3 SP2, to uninstall PowerShell you first have to uninstall W2K3 SP2.

You can read the whole post here: Windows Server 2003 SP2…

Read more

SQL Server 2005 Security Best Practices Whitepaper Released

Saw this first here: SQL Server 2005 Security Best Practices. It's on the blog for Microsoft UK's SQL Server Premier Field Engineers. There's also some security-related webcast information on that blog post, so check it out!

Microsoft has released a whitepaper on best practices for SQL Server 2005…

Read more

"Wet" Pet Food Recall

Animals are near and dear to my heart, to the point where I have a cat even though I am partially allergic to them. Therefore, even though the following story has nothing to do with computers, it's something I feel compelled to post to get the word out:


Read more

Windows Mobile Security

I'm working on a new article for SQL Server Central talking about physical security and SQL Server and I was going to include coverage outside of the data center, especially with products like Microsoft CRM 3.0 putting potentially sensitive data on a laptop. There are significant legitimate business drivers to…

Read more

The Great Migration

We migrated to a new set of servers tonight. Actually am for the Red Gate folks and a late, 11pm-2am night for me. Things went pretty smooth. I disabled the web site to prevent access, then ran diff's of all the databases. We'd moved fulls over earlier, so once these…

Read more

0 comments, 1,430 reads

Posted in The Voice of the DBA on 17 March 2007

SQL Server 2005 SP2 and Maintenance Plans - Still not fixed yet

SQL Server MVP Aaron Bertrand has posted that there is still a bug with maintenance plans for SQL Server 2005 SP2. There looks to be another release coming to fix the issue. More here:

  More news on Service Pack 2 and Maintenance Plans

His advice is that if you're…

Read more

New Version of ApexSQL Doc (2005.11.0203)

ApexSQL announced that a new version of ApexSQL doc is available.

  News Announcement

The latest version is 2005.11.0203 and there are several fixes, which can be found here:

  Release Notes

You'll need to download the executable, as the announcement mentions, the built-in update doesn't work as of yet.…

Read more

Conditional formatting in Reporting Services

Yesterday's post reminded me of another interesting technique I have used to change the color of the values on a report based on a range. Let's say I wanted the color of a field to be black if the value was between 0 and 10, blue if between 11 and…

Read more

0 comments, 1,295 reads

Posted in Advice from Aunt Kathi on 11 March 2007

Using IIF in Reporting Services

I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide a report of users and the schedule date for migrating them to our new workstation image or the date that they were migrated. The people viewing the report are mostly…

Read more

0 comments, 1,678 reads

Posted in Advice from Aunt Kathi on 10 March 2007

SQL Server Learning Opportunities!

There are two big SQL Server learning opportunities I want to remind you about.  First, DevTeach/SQLTeach will be held in Montreal May 14 - 18.  I will be speaking there this year on beginning T-SQL and new T-SQL features of SQL Server 2005.  The second talk will cover error trapping,… Read more

1 comments, 1,774 reads

Posted in Advice from Aunt Kathi on 9 March 2007