A few days ago I posted a list of Management Studio issues I hope they will add or fix for the next version of SQL Server (or sooner).  Comments there and elsewhere, as well as some afterthoughts, have led me to publish an addendum.  Again I will present them in separate categories. Filtering There are several issues about filtering, ...

Inspired both directly and indirectly by fellow MVP Erland Sommarskog, whose programming wishlist I talked about the other day, I have decided to compile a list of my own wish list items, in the same spirit of, ''it's never too early.''  This list is restricted to issues involving Management Studio; I was going to cover all of ...

just posted - SSMS T-SQL Debugger ScreenCast 5:58 - focuses on the call stack. If you haven't played with the new Debugger, this is an easy way to get a look-see.

For those of you who connect to database servers where you are not in full control over all databases, or where some of your databases are ever offline (or auto-closed), the new version of Management Studio that is shipping with SQL Server 2008 is going to bring you some surprises, when you try to present a list of databases in Object Explorer.It ...

Today I've been working on the SSMS chapter for SQL Server 2008 Bible. The list of new features for SSMS is rather impressive. Here’s a copy/paste from the book… SQL Server 2008’s Management Studio is an evolution of the SQL Server 2005’s Management Studio, which was a merger of the old Enterprise Manager and Query Analyzer. For SQL Server ...

Buck Woody, Microsoft SQL Server Program Manager, recently posted a list of enhancements in the works for SQL Server 2008 RTM in the SQL Server MVP newsgroup. The usual suspects were included in the list: Policy-Based Management (formerly DMF), Resource Governor, Multi-Server Query, PowerShell, and IntelliSense - but there are also some ...

The SQL team seems to have been quite busy recently, commenting on and closing out many bugs and suggestions that have been raised, I suppose as they close out work on the SQL Server 2008 codebase. Some (like Buck Woody and Bill Ramos, among others) have been very good about commenting that while they can't address the issue(s) for SQL Server ...

In playing with the latest CTP for SQL Server 2008, I stumbled across some new context menu items for a server group node in Registered Servers.  You can now right-click a group node and choose options such as ''New Query'' or ''Object Explorer.''  When I first saw the items in the list, I thought it was some kind of bug, because how can ...

[Updates below in BOLD.]On loading SSMS for the first time, I noticed a few things.  First of all, the row(s) affected message is now prefixed with information on the instance and login relevant to the query execution: As illustrated in the graphic, this information is already available in the status bar.  Why are they spoon-feeding ...