SimonS' SQL Server Stuff

SQLBits Registration is open

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

We have now opened the full registration for www.SQLBits.com

You will need to register on the site and then select the 10 sessions (http://www.sqlbits.com/information/PublicSessions.aspx)  you would most like to see. We will use this voting to help decide which sessions are to be run. We have 36 sessions and only 20 slots. Even I can do those maths.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQLBits Registration is open

PDF 64 bit iFilter at last

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/PDF 64 bit iFilter at last
The new RSS feed is here

If you use full text and wat to index pdf documents you might have found you run into problems on a 64 bit machine. This is because there is no 64 bit iFilter for pdfs. The iFiliter is the bit of code that interprets the code and spits out the information for the search service (full text) to use to generate its indexes.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/PDF 64 bit iFilter at last

SQLBits - Free SQL Server Conference October 2007

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQLBits - Free SQL Server Conference October 2007
The new RSS feed is here

I have pleasure in announcing SQLBits Community Day.On the 6th October we will be taking over building 3 at Microsoft's Head offices in Reading. To hold a full day of SQL Server content with speakers from the UK. There will be 20 sessions over 3 tracks of BI, Dev and DBA, plus some of the first content on Katmai.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQLBits - Free SQL Server Conference October 2007

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

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

Using SMO from 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/Using SMO from TSQL
The new RSS feed is here

If you are desperate to get your hands on the code I used in the SMO in TSQL demo I did at the usergroup meeting you can download it now from codeplex.

http://www.codeplex.com/SMOinTSQL

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

Free 2GB SQL Server USB Keys

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Free 2GB SQL Server USB Keys
The new RSS feed is here

We are holding the next UK SQL User group meeting in Central London on the 26th April from 6pm - 9pm (later if you fancy a drink)

The eveneing will have a SQL event and BI event running side by side with 8 presenters and loads of giveaways including t-shirts, books and USB keys.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Free 2GB SQL Server USB Keys

Update to the taskpad custom report

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

Thank you to those people that informed me that my taskpad report was incorrectly reporting the backups times against the wrong type of backup.

I have now fixed the report and have also included the backup types that are supported by SQL 2005.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Update to the taskpad custom report

SQL Server Samples are now live on Codeplex

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 Samples are now live on Codeplex
The new RSS feed is here

Microsoft are in the process of retiring GotDotNet and replacing it with CodePlex.

CodePlex is a shared source website which allows you to upload projects and give access to other people to view/maintain.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server Samples are now live on Codeplex

SSIS : How do I add rownumber/line number to a data flow

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 : How do I add rownumber/line number to a data flow
The new RSS feed is here

There are a number of options to achieve a row number /line number in a data flow.

One of the easiest solutions is to use script component.

This video shows you how to,

http://sqlblogcasts.com/files/folders/ssis_tools/entry1591.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS : How do I add rownumber/line number to a data flow

Raw file reader has been updated

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Raw file reader has been updated
The new RSS feed is here

My raw file reader has now been updated, the following are the changes from the previous version

I am working on the following,

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Raw file reader has been updated

Task pad report

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

Following feedback I have issued another version of the taskpad report. This now works with databases that have been created by users that have access to the sql server via a group membership

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Task pad report

Developer Day 4 Demo - 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/Developer Day 4 Demo - Now available
The new RSS feed is here

The demo files associated with are now available.

Make sure you read the description first as it includes how to deploy the demo.

http://sqlblogcasts.com/files/folders/servicebrokerdemos/entry1472.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Developer Day 4 Demo - Now available

Two Free MSDN Team Suite Subscriptions

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Two Free MSDN Team Suite Subscriptions
The new RSS feed is here

If you want to win one of two MSDN Team Suite Subscriptions worth in excess of £5,000 then its simple. Start contributing the SQL Blog sitte sqlblogcasts.com and you'll be in with a chance. Its free to join up and start blogging so whats stopping you.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Two Free MSDN Team Suite Subscriptions

SQL Server 2005 Service Pack 2 CTP - Downloads

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 Service Pack 2 CTP - Downloads
The new RSS feed is here

If like be you're eager to try the new features in SP2. The following are the direct links for the CTP,

What's New doc

Upgrade Pkg x86

Upgrade Pkg x64

Upgrade Pkg ia64

Express (core) x86

Express Advanced x86

Express Toolkit x86

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2005 Service Pack 2 CTP - Downloads