March 2006 - Posts

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.

Normal postng will resume either during late night baby sessions or once my sleep patter has returned.

Simon

-
Posted by simonsabin | with no comments

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.

I for one will add this to the top of my blog role.

The first blog is how to get the build statistics on the results of expressions, including the use of user defined functions.

http://blogs.msdn.com/queryoptteam/archive/2006/03/24/560089.aspx

-
Posted by simonsabin | with no comments
Filed under:

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 by simonsabin | with no comments

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

-
Posted by simonsabin | with no comments

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.

http://www.sqldbatips.com/showarticle.asp?ID=78

-
Posted by simonsabin | with no comments

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

-
Posted by simonsabin | with no comments
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=288119&SiteID=1-
Posted by simonsabin | with no comments

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

So why not have a go

-
Posted by simonsabin | with no comments
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=4f7e383a-ad4c-4ffb-80d1-44a160cc0015-
Posted by simonsabin | with no comments

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 by simonsabin | with no comments
More Posts Next page »