SQL Server Code-Named “Denali” - T-SQL Debugger Enhancements in CTP1

The debugger feature in SQL Server Management Studio gives us tools to debug T-SQL scripts, stored procedures, functions and triggers.  In this article, I am going to discuss some of the newly added functionalities in T-SQL debugger in SQL 11 CTP1. These enhancements are mainly aimed at bridging the gap between T-SQL and C# debugging experience…

1

SQL Server 2008 R2 Management Studio Express and SQL Azure

If you want to get started right away using tools like SSMS against SQL Azure, you are in luck. It turns out that the SQL Server 2008 R2 November CTP release includes SSMS Express package for 32 and 64 bit systems. Check out the Tools Only section on the Nov CTP download page. Once you…

0

Multiple Server Query Execution in SQL Server 2008

SQL Server 2008 SSMS introduces a new feature, Multiple Server Query Execution, in Query Editor. This feature intends to increase the productivity of running same query against multiple servers at once. Some of useage include: ·         Configure group of servers or server farm ·         Generate report or document from multiple servers ·         Analyze result from multiple servers ·         or Run…

9

Performance Data Collector for SQL Server 2008 - Revealed

I’ve been getting many requests on what is this new Performance Data Collector  tool and how does it work. First off, Performance Data Collector is simply a component as one of the tools in Management Studio (SSMS) involved in performance troubleshooting. These tools include the new Data Collector, System Collection Sets, the Management Data Warehouse, and…

3

November CTP News: Workaround fix for query execution issue

SQL Server 2008 November CTP (CTP5) has a known issue that any query execution hangs indefinitely. Fortunately, there is a quick and simple workaround to fix the issue. Cause & Problem: User changes the default setup directory to a custom one during the initial setup. Query Editor hangs indefinitely when user execute any query, even a simple…

2

How do you like to learn? *or* SQL Server Agent Proxy Accounts

One of my favorite parts of my job as a Program Manager is evangelizing our products.  I love teaching people how to be more effective by introducing them to new features or tying many existing features together in an end-to-end scenario. I like to learn about technology and I’d imagine that the majority of my…

13

SQL Connections 2007 (Orlando, FL) -- Follow-up

After one heck of a trip to Orlando, FL for SQL Connections, I’m back in Redmond.  Here is a quick re-cap of my sessions and links to session content…   SMS312 — Be More Productive with SQL Server 2005 Tools SMS313 — Deep Dive into Database Mail SMS315 — Solving Common Scenarios with Management Studio Reports…

2

SQL Server Manageability Webcast - SP2 Improvements - Resources

Thank you to those who attended today’s webcast.  As promised, here are links to the resources associated with the demos. Downloads:SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspxSQL Server 2005 Feature Pack (February 2007): http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en SQL Server 2005 Performance Dashboard Reports: http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en SQL Server 2005 Best Practices Analyzer: http://www.microsoft.com/downloads/details.aspx?FamilyId=da0531e4-e94c-4991-82fa-f0e3fbd05e63MVP Custom Reports (e.g. EM Taskpad View): http://blogs.msdn.com/sqlrem/archive/2006/12/19/SP2-Dec-CTP.aspx Community Links:Microsoft…

0

SQL Server Manageability Webcast - SP2 Improvements

I’ll be giving a webcast in one week on the manageability improvements introduced in SQL Server 2005 Service Pack 2.  Feel free to post questions/comments to this blog that you’d like me to address during the webcast. Date: Tuesday, March 20, 2007 1:00 PM Pacific Time Event Overview In this webcast, we discuss the broad…

0