Aggregate queries

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

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...

Salary Survey

SQL Server Magazine has just published its annual salary survey.  I don’t really recall how they did it in past...

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,...

Early Christmas

At least for me 🙂

My wife and I put an offer in on a house this past Monday and spent...

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...

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...

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....

Denver Launch

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

First, apologies for not blogging...

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:

Download

A quick...