Simons SQL Blog : SQL Server 2005, Downloads

SSIS - Enhanced Error Component

simonsabin — Thu, 26 Jul 2007 22:17:07 GMT

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.

If you were around at a SSIS presentation in 2005 you will have seen the statements on the extensibility. The statement from MS was that they have used exactly the interfaces we do to create their components. However on investigation we couldn't figure out how they had written the Slowly Changing Dimension to add components using the public interfaces. Well what was missing was the pipelineService that was made public in Service Pack 1.

So you can now write components just like Microsoft. If you are interested in the code for the error component let me know.

In the meantime feel free to download the component from here

http://sqlblogcasts.com/files/folders/transforms/entry2.aspx

PDF 64 bit iFilter at last

simonsabin — Tue, 17 Jul 2007 23:10:35 GMT

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.

Well now one is available, not from adobe or Microsoft but a company called Foxit The file can be downloaded here http://www.foxitsoftware.com/pdf/ifilter/

Thanks to the iFIlter blog for pointing this outhttp://blogs.msdn.com/ifilter/archive/2007/05/10/long-awaited-64-bit-pdf-ifilter-finally-available.aspx

Service Broker - Asynchronous/Multi threaded File Upload

simonsabin — Thu, 07 Jun 2007 15:52:36 GMT

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,

The slides are on http://sqlblogcasts.com/files/folders/servicebrokerpresentations/entry1885.aspx

and a video of the service broker restaring after I stopped SQL Server is here http://sqlblogcasts.com/files/folders/servicebrokerdemos/entry1884.aspx

SQL Server 2005 May 2007 BOL now available

simonsabin — Mon, 04 Jun 2007 18:55:45 GMT

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.

Also released on MSDN today is the Feb 2007 version of BOL in all 9 localized languages. http://msdn2.microsoft.com/de-de/library/ms130214.aspx German

http://msdn2.microsoft.com/fr-fr/library/ms130214.aspx French

http://msdn2.microsoft.com/es-es/library/ms130214.aspx Spanish

http://msdn2.microsoft.com/it-it/library/ms1301214.aspx Italian

http://msdn2.microsoft.com/ja-jap/library/ms1301214.aspx Japanese

http://msdn2.microsoft.com/ko-kr/library/ms1301214.aspx Korean

http://msdn2.microsoft.com/ru-ru/library/ms1301214.aspx Russian

http://msdn2.microsoft.com/zh-cn/library/ms1301214.aspx Chinese Simplified

http://msdn2.microsoft.com/zh-tw/library/ms1301214.aspx Chinese Traditional

Using SMO from TSQL

simonsabin — Tue, 08 May 2007 11:51:42 GMT

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

There are 2 projects in there one an SSMS project and one a C# project. Both can be opened using the TFS in codeplex. Or you can just download the code.

The instructions are non-existent at the moment but I am sure you can figure it out.

I am going to be posting my demo code to codeplex, if you are interested in contributing let me know and I will give you rights.

http://www.sqlskills.com/blogs/bobb/2007/03/13/TwoThingsYouCantDoInSQLCLR.aspx

Update to the taskpad custom report

simonsabin — Wed, 28 Mar 2007 09:21:05 GMT

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.

You can downlaod the new version of the taskpad custom report

You will need SQL Server 2005 SP2 to use the custom report.