SimonS' SQL Server Stuff :

Documentation (RSS)

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

posted Sunday, October 07, 2007 9:18 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

Whats in URL?

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

Folowing on from my previous post about BOL URLs I thought it would be a good idea for there to be an option in BOL to display the web URL for a page as these are much easier to provide to people.

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

posted Friday, August 17, 2007 4:54 AM by SimonSabin with 0 Comments

Whats in a BOL link?

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 in a BOL link?
The new RSS feed is here

In using BOLyou will have noticed that the links in BOL contain some lovely guids. I often want to reference BOL in documents, forum posts etc but was concerned that the guids might change. So I asked Alan Brewer whether they change or not. He gave me a great response which I've got his permission to publish here.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Whats in a BOL link?

posted Thursday, August 16, 2007 10:44 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

SQL Server Trace Event Definitions

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

If you are using Event Notifications or capturing events in Profiler you undoubtedly have noticed that MS have used the same columns (xml elements) for storing different data for each event. For example there is an element called "integer data". You may ask what is stored in here cos it ain't obvious from the name of the element.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server Trace Event Definitions

posted Friday, March 23, 2007 10:18 AM by SimonSabin with 0 Comments

Online Index White Paper

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

Paul Randal recently informed me of a new white paper on online index operations. The whitepaper can be found here Online Index White Paper.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Online Index White Paper

posted Friday, March 16, 2007 7:27 AM by SimonSabin with 0 Comments

SQL Server documentation sucks

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

If you think that SQL Server Documentation is lacking then make sure you provide feedback using the links at the bottom of the page. There is a big push to make sure the content of books online is what users want. There are regular releases of BOL which means that any suggestions you make you can be incorporates and available very soon.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server documentation sucks

posted Friday, November 17, 2006 11:05 AM by SimonSabin with 3 Comments