SimonS' SQL Server Stuff : September 2007

September 2007 - Posts

SSRS Getting pounds instead of dollars

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSRS Getting pounds instead of dollars
The new RSS feed is here

As much as I hate to admit it Microsoft is a US company which means everything defaults to US. So dates are in mmddyyyy not ddmmyyy format, words are missing letters such as color instead of colour and the currency is dollars and not the Great British pound.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSRS Getting pounds instead of dollars

posted Thursday, September 27, 2007 11:21 AM by SimonSabin with 0 Comments

SSIS Pipeline performance changes in Katmai

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 Pipeline performance changes in Katmai
The new RSS feed is here

The SSIS pipeline is being changed in Katmai to allow more parallel processing. For any multi processor machine this should result in a performance improvement.

Essentially each arrow in your data flow can now have an active buffer, where as in SQL 2005 you only have 1 active buffer from the source to the next asynchronous component. Many people put in a UNION ALL component (which is asynchronous) to allow more buffers to be used.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Pipeline performance changes in Katmai

posted Tuesday, September 25, 2007 10:11 PM by SimonSabin with 0 Comments

SSIS change to pipeline for custom components

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 change to pipeline for custom components
The new RSS feed is here

If you've written your own custom components then you should read this post on the SSIS forum about a possible change to the pipeline that may affect your component.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2190281&SiteID=1&mode=1

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS change to pipeline for custom components

posted Tuesday, September 25, 2007 10:01 PM by SimonSabin with 0 Comments

SSIS Dates aren't very precise

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 Dates aren't very precise
The new RSS feed is here

I'm implementing some SSIS packages at the moment and started looking at logging with the event handlers. I simply wanted task start and end times etc and so used the start time system variables.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Dates aren't very precise

posted Tuesday, September 25, 2007 9:33 PM by SimonSabin with 0 Comments

Full text thesaurus files bug in documentation

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Full text thesaurus files bug in documentation
The new RSS feed is here

I don't normally blog about documentation errors generally because they're often not that major however this one is fundamental what is being explained.

This is the page online http://msdn2.microsoft.com/en-us/library/7f5424a4-a72c-44dc-b455-786a12767c99.aspx It talks about creating new thesaurus files. Unfortunately the XML example is wrong. When I looked at it intially I was suprised because the diacritics element wasn't valid XML. Well looking at the examples in the <SQL install folder>/FTData/ts????.xml you can see that the example in the documentation is wrong.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Full text thesaurus files bug in documentation

posted Saturday, September 22, 2007 11:00 PM by SimonSabin with 0 Comments

XmlTextWriter produces processing instruction

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

This week I've been producing XML Thesaurus files for SQL Server. The prupose is to enable spell checking in full text. The thesaurus file is an XML file wih a defined schema, I was creating the file with an XmlTextWriter but couldn't for hte life of me get it to load.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/XmlTextWriter produces processing instruction

posted Saturday, September 22, 2007 10:51 PM by SimonSabin with 0 Comments

SQLBits Agenda is now live along with more Information

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 Agenda is now live along with more Information
The new RSS feed is here

The agenda for SQLBits is now live at http://www.sqlbits.com/information/Agenda.aspx.

There is also more information on the Group By http://www.sqlbits.com/information/GroupBy.aspx. This is being sponsored by Solid Quality Mentors. We have hired a bowling alley in Reading so it should be a good laugh, we'll have some prizes for best score, worst score etc. If you have registered for SQLBits can you please update whether you are coming to the Group By as we need to know numbers ASAP.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQLBits Agenda is now live along with more Information

posted Saturday, September 22, 2007 8:15 AM by SimonSabin with 0 Comments

AddIns in SSMS

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

Jon has posted a great summary of Addins in SSMS. Including many features you should consider voting on.

http://sqlblogcasts.com/blogs/jonsayce/archive/2007/09/01/recent-queries.aspx

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

posted Monday, September 03, 2007 10:49 PM by SimonSabin with 0 Comments

How to get the name of the day of date

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/How to get the name of the day of date
The new RSS feed is here

Do you have a date and you want the day of the week but not the number but the name i.e. Monday, Tuesday etc. Well there are two functions that you can use with dates that can be used to extract a part of the date. One function returns the number and one returns text version. The functions are DATEPART and DATENAME respectively.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/How to get the name of the day of date

posted Monday, September 03, 2007 10:44 PM by SimonSabin with 0 Comments