SimonS' SQL Server Stuff

Welcome to the world of blogging

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Welcome to the world of blogging
The new RSS feed is here

Continuing the new blogs beeing added to sqlblogcasts.com I'd loke to welcome Ray into the blogging world

http://sqlblogcasts.com/blogs/rayb/archive/2007/06/28/microsoft-sql-server-2005.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Welcome to the world of blogging

SSIS : Enhanced Error Component - Update

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS : Enhanced Error Component - Update
The new RSS feed is here

I have uploaded a new install for this component including the fixes. The component now validates correctly that the correct inputs are attached to the component.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS : Enhanced Error Component - Update

Blobs block online indexing

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Blobs block online indexing
The new RSS feed is here

If you are lucky enough to be running enterprise edition of SQL you may have looked or want to look into online index rebuilds. Unfortunately having blobs in your index blocks you from being able to do online rebuild of that index. Cruically what that means is that if your table is clustered then you cannot rebuild the clustered index on that table

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Blobs block online indexing

Do you want my job?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Do you want my job?
The new RSS feed is here

I've decided its time to move on from Totaljobs Group to work for myself. That leaves an opportunity for someone to join Totaljobs Group and be responsible for a really challenging database architecture.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Do you want my job?

To cluster of not

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/To cluster of not
The new RSS feed is here

Tony's blogged about the use of heaps http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/24/row-fragmentation-hopscotch-heap-v-clustered-and-io-cost.aspx. Whilst this highlights data on a page being out of sequence and thus yoyoing when you scan the data, it doesn't mean you should always have a clustered index.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/To cluster of not

Time dimension - What should the key be?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Time dimension - What should the key be?
The new RSS feed is here

We are currently implementing a data warehouse and the design of the time dimension was recently being done.

Firstly it was agreed that day and time should be split out. Combining the two into one dimension is nuts your dimension would be huge and unworkable.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Time dimension - What should the key be?

Service Broker - Asynchronous/Multi threaded File Upload

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Asynchronous/Multi threaded File Upload
The new RSS feed is here

The code and slides from my presentation from today (Service Broker - Asynchronous processing in SQL )are now online.

The code is on codplex http://www.codeplex.com/MultiThreadedSQL,

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Asynchronous/Multi threaded File Upload

Service Broker - Reliable processing

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Reliable processing
The new RSS feed is here

I have just finished my presentation on asynchronous process/parallel processing using Service Broker at the Microsoft Technology Conference in Ireland. I was a bit tentative after deciding last night, after a few guinesses and whisky (thanks Barry), to add a new feature to my presentation, failure.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Reliable processing

SSIS - Sweet sight - Visual Studio 2005 Tools For Applications

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - Sweet sight - Visual Studio 2005 Tools For Applications
The new RSS feed is here

I've metioned it before but the proof is in the pudding.

On doing an install of Sql Server 2008 (Katmai) I was very pleased to see a step installing Visual Studio 2005 Tools for Applications

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - Sweet sight - Visual Studio 2005 Tools For Applications

SMO - Using SQL authentication

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SMO - Using SQL authentication
The new RSS feed is here

I recently had a question about trying to get Mark's scripts (http://blogs.msdn.com/mattm/ ) to work when the servers are only configured for SQL authentication.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SMO - Using SQL authentication

SQL Server 2005 May 2007 BOL now available

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server 2005 May 2007 BOL now available
The new RSS feed is here

Thanks to Gail Erickson of the SQL Server Documentation Team notifying me of the availability of May BOL.

The May 2007 release of Books Online is available on MSDN and on the
download site. This is a very targeted update to BOL and is limited to
correcting technical inaccuracies in a handful of topics that describe the
protection provided when using the WITH ENCRYPTION option. That is, these
topics now clearly state you're only getting obfuscation, not encryption
when using this clause. The updated topics are listed in the topic New and
Updated Books Online Topics.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2005 May 2007 BOL now available

SQL Server 2008 (Katmai) June CTP available for download

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server 2008 (Katmai) June CTP available for download
The new RSS feed is here

If you haven't heard the June CTP of SQL Server 2008 (Katmai) is available for download from connect.

When you go to the download if you are based in Europe I suggest that you select Europe as the download site, which for once provides a fantastic download rate. I'm currently getting 1.4Mb/s :)

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2008 (Katmai) June CTP available for download

Parallel processing in TSQL

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Parallel processing in TSQL
The new RSS feed is here

I will be over in Ireland on Thursday presenting on Service Broker .

It appears few people are actually using it for two way messaging (conversations). 

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Parallel processing in TSQL

Office 2007 - Powerpoint 2007 rocks

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Office 2007 - Powerpoint 2007 rocks
The new RSS feed is here

As mentioned previously I am now using office 2007. Ive been using Powerpoint every since university many years ago and have always been frustrated by the time it takes to get a professional looking presentation together.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Office 2007 - Powerpoint 2007 rocks

Great article on the fetaures of Katmai

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found