THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Aaron Bertrand

Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.

It's Saturday, are you ready to vote?

I'm going to try to do this weekly; bring attention to some Connect items that I or colleagues nearby think are important but could use a nudge toward greater visibility.  This week I only have a few issues that I want to point out:

====================

More disclosure in sys.dm_exec_requests

Erland is asking for a column in the sys.dm_exec_requests DMV that shows when a statement started executing (currently it shows when the request started).  While you can get this information in other ways, it is much more cumbersome than being able to compare request time to execution start time.  I voted 5.

#435083 : Add column to dm_exec_requests that reports when the current statement started
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=435083

====================

Giving us access to the "Connect to Server" MRU list

I wrote about this here a few weeks ago, but feel that a bit more exposure can't hurt (only 18 people have voted so far).  I think it's overkill that you have to destroy all of your preferences to remove one or two obsolete servers from the MRU list that populates the "Connect to Server" dropdowns within SSMS.

#424800 : SSMS : Expose "Connect to Server" MRU list to users
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=424800

====================

Providing a real fix for the MSXML6 SP2 issue

Many people are still blocked by the fact that SQL Server 2005's installer is not smart enough to ignore the presence of MSXML6 when it tries to lay down those bits on an updated operating system (e.g. XP SP3).  While I don't use XP, and haven't suffered this issue personally, I have to agree that the workaround in KB #968749 is simply not sufficient.  At least for the SQL Server Express redistributable packages, the installer should be updated to simply skip MSXML6 if it is already there (in the current scenario the entire setup operation simply fails).  So I filed a suggestion for this:

#435245 : Update the SQL Server 2005 SP3 Express installers to bypass MSXML6 SP2
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=435245

====================

That's all I have for now.  Please vote on any issue that you deem worthy!

Published Saturday, April 25, 2009 8:03 PM by AaronBertrand

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Alexander Kuznetsov said:

Voted. The MSXML6 SP2 one is a shame - I saw it myself recently. Thank you for the digest, Aaron!

April 25, 2009 8:44 PM
 

Terry Walker said:

That's great, I thought about SQL Server like that before.

June 17, 2009 1:39 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About AaronBertrand

...about me...

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement