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

Archives: December 2005

The Perils of Java Schools

This is great, another rant from Joel, this time on the state of CS Degrees.

I didn't grow up in the punch card days, though I heard about it from my oldest step-brother, who did. Instead, I grew up with early PCs (TRS-80s) in school where time was limited,…

Read more

0 comments, 1,154 reads

Posted in The Voice of the DBA on 30 December 2005

Last Minute Testing

I've had a new web server for a couple months and I've been slowly testing things as I can in preparation for a move of the main SQLServerCentral.com site. What I thought would be a simple, click on everything test, has turned into quite a challenge, and more tedious than…

Read more

0 comments, 1,016 reads

Posted in The Voice of the DBA on 28 December 2005

Unpatched Microsoft Windows WMF Vulnerability

If you haven't heard by now, there is an unpatched exploit in how Windows handles WMF files. Since this handling is done with System level privileges, you guessed it, complete control of the system. Secunia sent out an advisory this morning and I noticed that Sunbelt Software had posted about…

Read more

0 comments, 1,027 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 December 2005

Cute comic

My son ran across this comic and was sure I would enjoy it: http://www.qwantz.com/index.pl?comic=153

  Read more

0 comments, 1,126 reads

Posted in Advice from Aunt Kathi on 23 December 2005

SQL Server Connections

I found out today that I will get to attend the SQL Server Magazine Connections conference (part of the DevConnections megaconference) in Las Vegas next month.  On the heels of the SQL PASS conference in Grapevine last month, I'm still on a 'high' from what I learned there.  I was… Read more

0 comments, 1,028 reads

Posted in Tim Mitchell on 21 December 2005

Aggregate queries

Be sure to read my article on SQLServerCentral on building aggregate queries: http://www.sqlservercentral.com/columnists/kKellenberger/aggregatequeries.asp Read more

0 comments, 1,172 reads

Posted in Advice from Aunt Kathi on 21 December 2005

SQL Server 2005 Administrator's Pocket Consultant available

Saw this at the book store this evening and picked it up.

SQL Server 2005 Administrator's Pocket Consultant

I'll spend the next couple of days looking it over and seeing what I think. I usually grab the server OS versions and they've always been good for what they are intended:…

Read more

0 comments, 1,032 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 18 December 2005

Salary Survey

SQL Server Magazine has just published its annual salary survey.  I don’t really recall how they did it in past years, but this year they used a lot of ink talking about career satisfaction as well as money.  There is a sidebar where they discuss the lack of… Read more

0 comments, 1,159 reads

Posted in Advice from Aunt Kathi on 17 December 2005

Crypt Packages for Perl

This is one of those "bang head here" issues. I was trying to install Net::SSH::Perl, which basically drives SSH through Perl, on a Win32 client today. First I couldn't locate Net-SSH-Perl in the ActiveState repositories. Odd, but we can overcome that. A quick search and I have several locations where…

Read more

0 comments, 1,306 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 16 December 2005

Early Christmas

At least for me :)

My wife and I put an offer in on a house this past Monday and spent all week kind of on pins and needles. It was a foreclosure, so someone lost it and the bank owns it. There were two offers in on Monday, so…

Read more

0 comments, 1,031 reads

Posted in The Voice of the DBA on 16 December 2005

Missing some folks

In a community the size of SQL Server Central, it's natural for people to come and go, especially with contributions to the forums. I still remember the early days of the site, when Brian, Steve, and Andy moved over from swynk.com. As I reflected on times gone by, I thought…

Read more

Anyone want to handle this?

I get a lot of email at SQLServerCentral.com on a variety of topics. Complaints about my writing, comments on the site, problems, etc. But there are a couple things I don't understand. The first is the amount of stuff submitted through our problem report page.

It plainly says in…

Read more

0 comments, 1,101 reads

Posted in The Voice of the DBA on 14 December 2005

Simple script to show what drives all databases are on

Had a need for this the other day. We just needed a quick dump of which drives each database was using. Don't know if it's good enough to make the useful script category for SSC as I wrote it on the fly (so use at your own risk), but here…

Read more

Denver Launch

I wrote a little in the editorial, but I wanted to drop some other observations here.

First, apologies for not blogging more, but I've been buried with kid stuff. Had my son move to a new school and it added much confusion and uproar in the home schedule.

At the…

Read more

0 comments, 1,033 reads

Posted in The Voice of the DBA on 7 December 2005

New SQL Server 2005 Books Online available

I saw this first on Karen Watterson's blog. Microsoft has released an update to SQL Server 2005's Books Online:


A quick way to tell the difference between the two is to navigate to the Legal Notice by:

 SQL Server 2005 Books Online >>
Getting Started with SQL Server…

Read more

0 comments, 1,052 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 7 December 2005

SQL 2005 Certified

Maybe not certified, but I took the 70-441 test today and I thought it was relatively easy. The format was also quite a change and I did like that.

Look for some writeups coming soon on the site, but I wouldn't cram and worry too much about upgrading the development…

Read more

0 comments, 993 reads

Posted in The Voice of the DBA on 2 December 2005