Monday, July 24, 2006

New Microsoft SQL Server 2005 Business Intelligence Example

I have just come across a new set of sample databases for SQL Server 2005. Some of the examples are based on Project Real Business Intelligence best practices project. Based on a real world implementation of SQL Server 2005 by Microsoft.

Check out:
SQL Server 2005 Samples and Sample Databases (July 2006)

Thursday, July 20, 2006

Installation of SQL Server Service Pack 1 by Windows Update???

The other day something happened to my laptop that took me completely by surprise. Windows Update decided SQL2005 SP1 was a critical patch. And proceeded to download and install SP1.

Although this isn’t an issue for me at then moment as I was going to install the Service Pack. I was taken a back with Windows Update installing it in the first place.

Like most DB pros I prefer to manage the database patch level on my own. I can see this kind of service pack roll out causing problems for IT Administrators and DBAs a like. Particularly with SQL express instances that are managed by business users.

Monday, July 17, 2006

Kimball Group Webcasts

I have just come across a series of must see webcasts by the Kimball Group consultants that wrote The Microsoft Data Warehouse Toolkit. I have not viewed them all yet. I am currently viewing the MSDN Architecture Webcast: Using SQL Server 2005 Integration Services to Populate a Kimball Method Data Warehouse (Level 200). Which I highly recomend.

Check out the other Kimball Group Webcasts at:

Tuesday, July 04, 2006

Free Tools that have made my SQL life a bit better

I normally don’t recommend tools on this blog. But over last month I have been working with couple of tools that are worth a mention.

The first tool on the list is SQL Prompt by Red-Gate. I have been a fan of red gate bloggers for a while now at SQL Prompt is without a doubt one of the most useful ad-ins for SQL Management Studio and Query Analyzer. This little tool is Intellisense for SQL Server. This tool dynamically looks up common functions and syntax as you type. It’s a free download until September 2006.

Check out:
SQL Prompt

The second tool was recommended to me by
Chris Webb. It’s a replacement for SQL Manager for stoping and starting all of SQL Server 2000/2005 services created by Jasper Smith at

Check out:
SQL Manager

The last tool on my list is a new migration script by Marco Russo. If you were like me and followed the DTS best practices guide that MS put out and used UDL data sources. You will find that are unable to migrate your DTS packages. Marco has put together a great tool for converting UDL and other DTS objects that do not migrate.

Check out:
A tool to improve DTS to SSIS migration