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. Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

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 ...

Ok, so I was looking around for a blurb about plan guides for my anti ad hoc SQL section of my book (ok, maybe not completely anti- but that isn't the point,) when I found this blog: http://geekswithblogs.net/Sreeblog/articles/117576.aspx that basically just lists some new features in 2008.  One that I hadn't seen I feel the need to ...

Katmai Management Studio has the Way Cool ability to send T-SQL to multiple servers with a single F5 Execute. Watch the Screencast (4:00). Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

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 ...

After attending a few sessions at PASS, based on much newer builds of SQL Server 2008, I have some additional information to complement what I have published in my slides (since I am not scheduled to present the talk further, I am not going to go back and re-vamp the slides every time I find out a new piece of information).One important change ...

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL ...