SQL Server 2005 Service Pack 2 – December CTP

Before I go on vacation, I’d like to send a quick thank you to the community for giving us their thoughts on the November CTP of SP2.  There were many thousands of downloads and a lot of people have started posting their suggestions and bug reports on Microsoft Connect. I’d like to call out a…


SQL Server 2005 – Service Pack 2 – Web Chat

Whenever something you use every day changes, it’s not always easy to put down what you’re doing, find out what changes and determine if it’s right for you/your team.  For some environments, it will take a great amount of effort to investigate and adopt SQL Server 2005.  We in the SQL Server Product Team would like to help…


Custom Reports in Management Studio

One of the improvement areas we’ve introduced in Service Pack 2 is the ability to run your own reports inside Management Studio. Here is a draft of the Books Online topics. This is subject to change at any time. The November CTP of Service Pack 2 can be obtained here: http://www.microsoft.com/sql/ctp.mspx. Paul A. Mestemaker IIProgram…


SQL Server 2005 Service Pack 2 – November CTP

SQL Server 2005 Service Pack 2 – November CTP is available for download.  For more information please visit: http://www.microsoft.com/sql/ctp.mspx. Over the next few weeks, we will be posting blogs on some of the improvements the SQL Server Manageability team has made in Service Pack 2. Visit the SQL Server Tools General Forum if you have any…


SQL Server Best Practices Analyzer – Webcast – Resources

Resources for today’s webcast.   Webcast: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032306503&EventCategory=4&culture=en-US&CountryCode=US   Upgrade Advisor Tool: http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en   TechNet Webcast: Upgrade and Migration: Planning Considerations for SQL Server 2005 (Level 300) Presenters: Michael Raheem and Euan Garden http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032292288&EventCategory=3&culture=en-US&CountryCode=US   Self-help resources from Microsoft: http://www.MicrosoftELearning.com/ http://msdn.microsoft.com/ http://www.microsoft.com/sql/   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…


Management Studio Reports – Part 3 – Standard Reports

Sorry for the delay for part 3.  I have not been able to take our existing standard reports and make them work properly in a Reporting Services environment.  I’m going to release the files anyway, in case one of you can figure out what is wrong.  I’m not a Reporting Services guru, but I hope…


Management Studio Reports – Part 2 – Disk Usage Report

One of my favorite reports is Disk Usage.  It prepares two useful graphs breaking down the MDF and LDF space usage.  It also provides information about disk space used by tables, partitions, and indexes.  This data can also be exported to Excel so you can perform your own calculations.  (To export, right-click on the report…


Management Studio Reports – Part 1 – Finding the Reports

Did you know that there is a set of pre-made reports in Management Studio that can help database administrators gather information in many common areas?  There are reports for CPU, memory, disk, sessions, queries, transactions, and more baked right into Management Studio.  You can access these reports in SQL Server 2005 and SQL Server 2005…


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: http://msdn.microsoft.com/sql/. It’s not direct, but it gets you close. Over in the…