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…


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: Server 2005 Feature Pack (February 2007): SQL Server 2005 Performance Dashboard Reports: SQL Server 2005 Best Practices Analyzer: Custom Reports (e.g. EM Taskpad View): Community Links:Microsoft…


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…


SQL Server Best Practices Analyzer – Webcast – Resources

Resources for today’s webcast.   Webcast:   Upgrade Advisor Tool:   TechNet Webcast: Upgrade and Migration: Planning Considerations for SQL Server 2005 (Level 300) Presenters: Michael Raheem and Euan Garden   Self-help resources from Microsoft:   Paul A. Mestemaker II Program Manager Microsoft SQL Server


SQL Server Best Practices Analyzer – Webcast

There will be a webcast on Thursday, September 7, 2006 at 9:30am on the next version of SQL Server Best Practices Analyzer.  You can follow the link below to register for the event.  I will try to address the questions and concerns that were brought up in previous blog entries.  If you’d like to ask…


Overview of SSMS-E Webcast URLs and Code Snippets

As part of my web cast, there are several URLs and sample scripts that I’d like to share with you.   Demo 0 – Downloading. The URL that I use to find the download site for SQL Server Express is to start at: It’s not direct, but it gets you close. Over in the…


Learn about SQL Server Management Studio Express (SSMS-E) May 12 9am

Now that SQL Server Express and SQL Server Management Studio Express are out the door as part of the SQL Server 2005 SP1 release, it’s time to take a close look at SSMS-E. I will be presenting a 60 minute web cast to show how the tools work great together. To register for this web cast,…


Webcast – SQL Server 2005 Performance Troubleshooting and Tuning (Part 2 of 2)

Here is the link to my presentation:   The Demo scripts for this presentation can be found in the attachment.   Thanks, Hongfei Guo   Note: The diagnosis scripts are missing from the zip file (Thanks Ed for letting me know). Unfortunately, the machine with those files has been re-imaged. Once I find time to re-work on the…


SQL Server 2005 Performance Troubleshooting and Tuning (Part 1 of 2) Webcast

Today I presented my first public webcast: SQL Server 2005 Performance Troubleshooting and Tuning.  During the webcast, I promised that I would post references to the resources that were mentioned.  See below for the links as well as the demo SQL scripts.   If you have any recommendations how we could make our webcasts better,…


SQLCMD Webcast demo scripts & link

Last month, as part of the TechNet Webcast: Manage SQL Server 2005 Using Command Line Tools and the SQLCMD Utility (Level 200) I had used a number of scripts for the demos. During the Q&A, number of attendees had requested access to these scripts. Thanks to Paul’s efforts the SQLREM team now has its own blogs site & a…