Upgrading your databases link

I got the link from Kirk about the couse: http://www.maxtrain.com/classes/classInfo.aspx?id=SQLADV .

Upgrading your databases to SQL Server 2005 class

I attended a two day class this week that was fantastic.  It was taught by the author of the course material,...

What's new with SSIS?

With the release of SQL Server 2005, there have been many changes in the product, but probably none as dramatic as the changes to the ETL tool. Data Transformation Services has become SQL Server Integration Services, or SSIS. It has been completely redesigned with a whole new paradigm for developing data movements. Kathi Kellenberger brings us a short introduction to this new tool.

Pro SSIS is Here!

My box of books arrived today!  For me, a first-time author (actually co-author), this is very surreal. I remember it was...

Cast vs Convert

Sometimes you must "convert" a column or variable from one data type to another.  For example, if you want to...

Assume that the column and table names are...

Cute comic

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

Aggregate queries

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

Assume that the column and table names are...

Salary Survey

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