Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2006

Data Dude

I went to an abbreviated version of the Visual Studio 2005 Team Edition for Database Professionals launch this morning. The reason for the shorter than usual launch is because freezing rain began falling mid-morning making roads treacherous. They thought we would appreciate getting out of there early. St. Louis has… Read more

2 comments, 968 reads

Posted in Advice from Aunt Kathi on 30 November 2006

Microsoft Network Monitor 3.0 Released

If you aren't familiar with Network Monitor, it's a packet sniffer that's a Windows component on the server builds (Control Panel >> Add/Remove Programs >> Add/Remove Windows Components >> Management and Monitoring Tools >> Network Monitor Tools if you're using Windows Server 2003). The version that has previously been released…

Read more

0 comments, 1,007 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 November 2006

ApexSQL SQL Server VIP/MVP Offer

ApexSQL has an offer to anyone who is a SQL Server MVP or VIP for a gratuity of their ApexSQL Universal Studio package. In a thread post here (Editor in Chief editorial), Brian Lockwood re-extended the offer to any who qualified. MVP status certainly does. VIP he said he'd…

Read more

0 comments, 1,221 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 November 2006

Measuring pi by throwing frozen hot dogs?

I saw this today on my Google front page under the How To section:

How to Calculate Pi by Throwing Frozen Hot Dogs

And the first thing that came to mind was, "Would this work?" As an adult and a father of three small children, my thought should have been,…

Read more

SSMS and scripting

I've heard a lot of complaints about SQL Server Management Studio concerning slowness and some of the things, like scripting out objects into individual files, that are missing.  I have been using it to manage my SQL Server 2000 and 2005 servers for several months and have gotten used to… Read more

0 comments, 895 reads

Posted in Advice from Aunt Kathi on 28 November 2006

Default schema

Sadly, I haven't had much experience yet with SQL Server 2005 except for Reporting Services and SSIS. The majority of my databases are for third-party
applications that are not yet certified for SQL Server 2005 or require an upgrade so I'll be running 2000 for quite awhile at work.

This… Read more

0 comments, 882 reads

Posted in Advice from Aunt Kathi on 27 November 2006

SysInternals now on Microsoft TechNet

It wasn't too long ago that Mark Russinovich announced he was becoming a Microsoft employee (new link as his old blog redirects to his new blog on TechNet). Now there is a new SysInternals section of the TechNet website. You can find the majority of the old SysInternals tools…

Read more

NGSSoftware compares Oracle and SQL Server security

I first saw this at SQL Server MVP Jasper Smith's blog post Which database is more secure? Oracle vs. Microsoft:

     NGSSoftware Whitepaper: Which database is more secure? Oracle vs. Microsoft?

Noted security research David Litchfield did a comparison of reported security vulnerabilities in both database platforms. He excluded…

Read more

0 comments, 1,047 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 November 2006

SSC bought out by Red Gate... Now what?

One of the highlights of my weekday mornings is reading the editorial by Steve Jones of  However, this past Tuesday's newsletter was particularly newsworthy: Steve announced the sale of the site to Red Gate software, a UK-based manufacturer of SQL Server tools.

Though the timing came as a…

Read more

0 comments, 951 reads

Posted in Tim Mitchell on 23 November 2006

Teaching Children to Program

One of the blogs I follow is Andrew Coates' blog over at MSDN. He has posted about starting to help a group of children learn how to program. It's a very interesting read with respect to what the children came up with as what they wanted to do and how…

Read more

Back from PASS

While at PASS, I created a thread in the forums: .  It was an incredible week.  I look forward to implementing many of the things I learned about.

Attending the Summit as a volunteer is a totally different experience.  You meet someone like Bill Graziano from working on a… Read more

0 comments, 832 reads

Posted in Advice from Aunt Kathi on 20 November 2006

Mixed Feelings about the SQL Server Central Sale to Red Gate

I've read numerous posts and several blogs discussing the SQL Server Central sale to Red Gate and at the end of the day I can only say I have mixed feelings about it. I'm very glad for Brian, Andy, and Steve, who have worked very hard on the site (on…

Read more

0 comments, 1,039 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 20 November 2006

PASS Summit 2006

It's the last day of the show and  my apologies for not blogging. I haven't carried my laptop around this year so much and I'm thinking I need a smaller solution for next year since I'm anticipating more remote writing.

This has been a strange conference for me with a…

Read more

0 comments, 890 reads

Posted in The Voice of the DBA on 17 November 2006


I usually set aside Tues afternoons and Friday afternoons for my Database Daily work. Scanning a couple hundred links takes some time and rather than worry about it everyday or try to figure out what's new, I devoted those two afternoons to Database Daily.

Except this week. A few others…

Read more

0 comments, 1,074 reads

Posted in The Voice of the DBA on 11 November 2006

SQL Server 2005 SP2 CTP Available for Download

The Community Technology Preview (CTP) version SQL Server 2005 SP2 has been released by Microsoft. You can find the download here:

There appear to be some changes on the database engine side that may raise a few eyebrows:
  • SP2 Maintenance Plans cannot be read by earlier versions of the…

Read more

3 comments, 1,348 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 8 November 2006


Recently I started getting back into the game of chess as I began coaching my boys. Chess is a great game which teaches a multitude of skills including critical thinking, planning, perseverance, problem solving, and creativity. It also helps children learn about delayed rewards, fortitude, and courage. Needless to say,…

Read more

1 comments, 1,078 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 2 November 2006