March 2006 - Posts

New sub query

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

You might have noticed I haven't posted anything for a few days. Thats because on Sunday my first son was born.

I don't normally do non technical stuff but this is a vaid exception.

Charles Mark Sabin was born on Sunday and weighed in at 8lb 6oz, not bad, looks like he might be following in his Dad's big footsteps.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/New sub query

posted Wednesday, March 29, 2006 12:59 PM by SimonSabin with 4 Comments

Query Optimisation in SQL Server 2005

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

Of the questions that get asked on the forums many are wround query optimisation and trying to understand why certain queries run one way and others another, hopefully the new blog from the query optimiser team will help the understanding.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Query Optimisation in SQL Server 2005

posted Saturday, March 25, 2006 5:14 PM by SimonSabin with 0 Comments

Developer Day 3 - Vote for the sessions you want

The sessions have now been submitted for Developer Day 3.

You can now vote on the sessions that you would like to see. Based on the voting you will be able to determine what the content of the day will be.

http://www.developerday.co.uk/ddd/votesessions.asp

PS my session is in the Data and Systems section :)

TSQL or not TSQL that is the question for DBAs

With the introduction of CLR in SQL Server 2005 many DBAs are reluctant to enable this feature due to worries of what could be done. I will show some practical reasons for using SQLCLR functions, procedures and how to manage them. We will cover some of the major concerns including, security, performance, management and support, performance and security. ', WIDTH, 500, SNAPX, 5, SNAPY, 5);" onmouseout="return nd();">Do you want to use the CLR in SQL Server and need to convince your DBA? Then this is the session for you. With the introduction of CLR in SQL Server 2005 many DBAs are reluctant to enable this feature due to worries of what could be done. I will show some practical reasons for using SQLCLR functions, procedures and how to manage them. We will cover some of the major concerns including, security, ...
posted Thursday, March 23, 2006 4:46 AM by SimonSabin with 0 Comments

SQL Server 2005 SP1 Webcast starting shortly

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 SP1 Webcast starting shortly
The new RSS feed is here

If you've got some time free and want to know about SQL Server 2005 SP1 then the webchat is starting in a few minutes.

http://www.microsoft.com/technet/community/chats/default.mspx#06_0322_TN_SQL

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2005 SP1 Webcast starting shortly

posted Wednesday, March 22, 2006 11:57 AM by SimonSabin with 0 Comments

Sorting files in Management Studio Projects

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

If you've used projects and solutions in management studio, you will have noticed that the files aren't sorted.

I posted a tool to do this a while back, however Jasper has a better tool and his site also details how to setup a button in Management Studio to do it.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Sorting files in Management Studio Projects

posted Tuesday, March 21, 2006 5:28 AM by SimonSabin with 0 Comments

SQL Server 2005 SP1 Webcast

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 SP1 Webcast
The new RSS feed is here

Do you want to know about SP1 for SQL Server 2005?

Whats been changed, fixed, updated. There is a webcast tomorrow on this from teh SQL Developer team

http://www.microsoft.com/technet/community/chats/default.mspx#06_0322_TN_SQL

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

posted Tuesday, March 21, 2006 5:03 AM by SimonSabin with 0 Comments

.Net Code deploy

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=288119&SiteID=1
posted Monday, March 20, 2006 9:42 AM by SimonSabin with 0 Comments

Ever fancied presenting

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

If you've ever fancied a go at presenting then why not do a stint at Developer Day 3. Submissions were supposed to close yesterday but it looks like you can still submit a session

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Ever fancied presenting

posted Saturday, March 18, 2006 1:11 PM by SimonSabin with 0 Comments

Order by views

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

http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=4f7

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Order by views

posted Friday, March 17, 2006 2:22 PM by SimonSabin with 0 Comments

Are you up with Web 2.0

This really made me chortle. If you think you know about web 2.0 then you should do well

http://www.cerado.com/web20quiz.htm

posted Thursday, March 16, 2006 12:06 PM by SimonSabin with 0 Comments

SSIS doesn't do what I want

On answering posts in the SSIS forum I have noticed quite a few where the answer is use a script task/component.

Whereas with DTS the use of the activex script was painful the use of the script component/task in SSIS is a pure joy.

Why?

Because you have the full ability of a proper editor, intellisense, and all the lovely features of .Net, generics, string manipulation etc.

Recently I have used script components to achieve, reading a locked file, handling an unknown number of columns, doing a performan distinct operation (using aggregate requires all data to be processed before rows are output)

So if someone says use a script component in SSIS don't be concerned, this is not vbscript its VB.Net compiled code with all the wonders on .Net.

posted Thursday, March 16, 2006 5:24 AM by SimonSabin with 1 Comments

Advanced edition of SQL Express

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

I mentioned previously about an "Advanced edition of SQL Express" that was coming out. Well they were going to have a private beta but instead have opted for a public CTP. It seems it is going to coincide with a CTP for service pack1 of SQL 2005.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Advanced edition of SQL Express

posted Thursday, March 16, 2006 3:27 AM by SimonSabin with 5 Comments

Yorkshire SQL Usergroup

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

So you live in the North and hate us Southerners cos everything always happens in London.

Well if you are a SQL bod, interested in SQL want to meet other like minded fellows to discuss the inner workings of heaps and database mirroring. Then Mitesh is trying to put together a usergroup up in the cold dark north.

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

posted Wednesday, March 15, 2006 5:26 PM by SimonSabin with 0 Comments

Performance when migrating from SQL 2000 to SQL 2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Performance when migrating from SQL 2000 to SQL 2005
The new RSS feed is here

If you are restoring a SQL 2000 DB to SQL 2005, make sure you rebuild your indexes and update your statistics. A number of people have found performance poor after the upgrade but sorted out once the above has been done.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Performance when migrating from SQL 2000 to SQL 2005

posted Tuesday, March 14, 2006 8:04 PM by SimonSabin with 1 Comments

Performance of formatDateTime SQLCLR function

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

Following my previous post I have been asked on the performance of the function I wrote. This is an area I am keen to press on people.

Any one questioning SQLCLR performance should have come to my launch event.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Performance of formatDateTime SQLCLR function