March 2005 - Posts

Jim Gray words of wisdom

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

Very interesting interview with Jim Gray on channel9

http://channel9.msdn.com/ShowPost.aspx?PostID=50428

What I found interesting is the configuration of terraserver is now commodity servers and not clusters on a SAN.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Jim Gray words of wisdom

posted Thursday, March 31, 2005 6:54 PM by SimonSabin with 0 Comments

Only display accessible objects in Enterprise Manager

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Only display accessible objects in Enterprise Manager
The new RSS feed is here

The SQL team have come up with an amended sp_MSdbuseraccess that only runs in the databases a use has access to, so for hosting services and other situations where many databases exist but a user only has access to a few this will increase their performance in EM

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Only display accessible objects in Enterprise Manager

posted Thursday, March 31, 2005 4:48 PM by SimonSabin with 0 Comments

Run SQL Profiler as non-admin

So you can't wait until Yukon and your developers want profiler access but you don't want to give them sysadmin access. The options available are detailed in the following post,

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47384

Thanks to adam machanic for highlighting the post.

posted Wednesday, March 23, 2005 10:21 PM by SimonSabin with 0 Comments

Debugging CLR in Yukon

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

Debugging CLR code when manually registering

http://blogs.msdn.com/ericnel/archive/2005/03/18/398534.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Debugging CLR in Yukon

posted Friday, March 18, 2005 9:08 PM by SimonSabin with 0 Comments

SQL 2005 Profiler and windows 2003

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 2005 Profiler and windows 2003
The new RSS feed is here

Not sure if this will still apply to Feb CTP but for December at least running profiler on a windows 2003 server machine may hang. This is due to digitally signed apps.

See the following article for more detail

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL 2005 Profiler and windows 2003

posted Friday, March 04, 2005 12:30 AM by SimonSabin with 0 Comments