SimonS' SQL Server Stuff : December 2006

December 2006 - Posts

Full text indexing is going first class 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/Full text indexing is going first class in Katmai
The new RSS feed is here

Full text as an oledb service has long been a pain. If you need to combine full text and a relational filter your performance could be really bad. 2005 improved this somewhat but not as much as I would have liked.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Full text indexing is going first class in Katmai

posted Wednesday, December 20, 2006 11:51 PM by SimonSabin with 0 Comments

SQL Server 2005 SP2 - December CTP

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

Thanks to Paul the December CTP is now available.

The first notable change is that custom reports now use the .rdl extension and not the .rdlc extension. This means that you can easily develop reports in BI studio and use them in Management Studio.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2005 SP2 - December CTP

posted Wednesday, December 20, 2006 9:43 AM by SimonSabin with 0 Comments

Outlook 2007 Nice touch

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

One thing that always bugged me was that reminders set on emails didn't appear with the tasks I had set up.

Well in Outlook 2007 they have not got a To-Do list which incorporates all the tasks and emails with reminders in one view.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Outlook 2007 Nice touch

posted Tuesday, December 12, 2006 9:10 AM by SimonSabin with 0 Comments

Performant isn't a word

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Performant isn't a word
The new RSS feed is here

We've been having a discussion at work around a few commonly used words. My reporting analyst's pet hate is ad-hoc being referred to as one work and written without the -. He does need to get out more.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Performant isn't a word

posted Monday, December 18, 2006 4:29 PM by SimonSabin with 0 Comments

When is full recovery mode not full recovery mode

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

I was recently trying to develop a test for DBAs. The scenario of the test was that you have taken over responsibility of a server what needs to be done to make it production ready. The server is really badly configured and the aim is for the tester to find them and make suggestions of what needs to be done.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/When is full recovery mode not full recovery mode

posted Wednesday, December 13, 2006 9:16 AM by SimonSabin with 0 Comments

The best RSS and NNTP reader is now Free

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/The best RSS and NNTP reader is now Free
The new RSS feed is here

Jetbrains have announced that Omea is going open source. This is going to involve a steps before it will be available including releasing 2.2, moving to VS2005, changing the source control and moving the build to TeamCity.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/The best RSS and NNTP reader is now Free

posted Monday, December 11, 2006 4:54 PM by SimonSabin with 0 Comments

Office 2007 - First thoughts

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

I've finally taken the plunge and installed Office 2007 and thought I would blog my first thoughts (I still have Office 2003 just in case)

As always with a new version there are some things that you think "thats neat". An example is the 3 column view in Outlook that provides task and calendar summary whilst in the mail section. I know something similar was in outlook today but that was useless as I never went to Outlook Today.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Office 2007 - First thoughts

posted Thursday, December 07, 2006 8:20 AM by SimonSabin with 0 Comments

Developer Day 4 Demo - 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/Developer Day 4 Demo - Now available
The new RSS feed is here

The demo files associated with are now available.

Make sure you read the description first as it includes how to deploy the demo.

http://sqlblogcasts.com/files/folders/servicebrokerdemos/entry1472.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Developer Day 4 Demo - Now available

posted Tuesday, December 05, 2006 10:15 PM by SimonSabin with 0 Comments

Developer Day 4 - Feedback

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

Thanks all that attended my session at Developer Day. It was great to have such an enthusiastic crowd and some very interesting questions raised. If you have thought of anything since then feel free to contact me.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Developer Day 4 - Feedback

posted Tuesday, December 05, 2006 8:40 AM by SimonSabin with 0 Comments