Downloads (RSS)

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

posted Wednesday, July 18, 2007 12:10 AM by SimonSabin with 0 Comments

SSIS - Enhanced Error Component

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
The new RSS feed is here

For those that downloaded the enhanced error component I forgot to make it clear that the new version requires you to have service pack 1 installed. The reason being is that we are using an interface that allows us to look at the whol package in the component UI.

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

posted Thursday, July 26, 2007 11:17 PM by SimonSabin with 0 Comments

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 finally got round to looking into the error reports and found a few bugs in this component.

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

posted Thursday, June 28, 2007 12:55 AM by SimonSabin with 0 Comments

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

posted Thursday, June 07, 2007 4:52 PM by SimonSabin with 0 Comments

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

posted Monday, June 04, 2007 7:55 PM by SimonSabin with 0 Comments

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

posted Tuesday, May 08, 2007 12:51 PM by SimonSabin with 0 Comments

Whats the quickest way to get a hotfix?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Whats the quickest way to get a hotfix?
The new RSS feed is here

I just blogged about an incompatibility between Office and the Infromation Bridge Framework which causes Excel to hang when using pivot tables. EXCEL 7 hangs when using pivot tables and other external data sources

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Whats the quickest way to get a hotfix?

posted Saturday, April 14, 2007 1:51 PM by SimonSabin with 0 Comments

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

posted Wednesday, March 28, 2007 10:21 AM by SimonSabin with 0 Comments