SimonS' SQL Server Stuff

Bye Bye SQLJunkies

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

My main blog has been on www.SQLBlogcasts.com/blogs/simons for some time now and I've been cross posting to sqljunkies.

My SQLBlogcasts blog is now getting the majority of the traffic and I realised that recently ~50% of the posts on SQLjunkies are mine. So I've decided to stop cross posting to SQLJunkies,

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

SQL Injection in the real world

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 Injection in the real world
The new RSS feed is here

Are you worried about SQLInjection attacks then you should be. This is a prime real world example.

http://xkcd.com/327/

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Injection in the real world

OCR for free from any image

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/OCR for free from any image
The new RSS feed is here

There are always features of products that you never now about. It is rare to go on training courses and so its up to you and your favourtie search engine to find out what a product does.

Onenote is a product I like. I'm not nuts about it but it is useful. One feature that I've always loved is the screen clipping feature. You always see users doing ALT+PRINT SCREEN to get a screen print, and then pasting into word and emailing 2Mb word documents with screen captures in them. The One Note feature allows you to not only select the section of the screen you want but also the file sizes aren't huge.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/OCR for free from any image

SQLBits 2007 - What a blast

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 2007 - What a blast
The new RSS feed is here

Its now sunday evening and SQLBits finished just over 24hrs ago. We had 321 delegates turn up and have some fantastic feedback. Not everything went perfectly but the feedback we have had has been great and so the next on should be even better.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQLBits 2007 - What a blast

SQL Server Samples - How to install

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

I've seen confusion over the SQL Server samples recently.

The most recent samples should be downloaded from codeplex. http://codeplex.com/SqlServerSamples

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server Samples - How to install

SQLBits 14 hours to go - giveaway tastic

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 14 hours to go - giveaway tastic
The new RSS feed is here

Not long to go until the first SQLBits. We've spent some time sorting out the giveaways and there is a lot. In addition the sponsors have some great stuff to give away from Ipods to XBoxs.... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQLBits 14 hours to go - giveaway tastic

SQLBits Final Agenda

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

The SQLBits Final Agenda is now live on the SQLBits site. www.sqlbits.com/information/agenda.aspx and can be downloaded here www.sqlbits.com/information/agenda.pdf

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

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

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

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

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

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

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

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

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