April 2007 - Posts

Cumulative update package (build 3161) for SQL Server 2005 Service Pack 2 is now available

Just published (April 17th): http://support.microsoft.com/kb/935356

The cumulative update package (build 3161) for SQL Server 2005 SP2 contains the SQL Server 2005 hotfixes that were not included in SQL Server 2005 SP2.

Note This cumulative update package is also known as build 3161.

Important notes about the cumulative update package

SQL Server 2005 hotfixes are now multilanguage. There is only one cumulative update package for all languages.
One cumulative update package includes all the component packages. The cumulative update package is designed to update only those components that are installed on the system.
You must enable the SQL Server Management Object (SMO) extended stored procedures and the SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you install the cumulative update package. For more information about the SMO and DMO XPs option, see SQL Server 2005 Books Online.

Note SQL Server 2005 Books Online notes that the default setting of these stored procedures is 0 (off). However, this value is incorrect. By default, the setting is 1 (on).



Itay Braun

Two SQL Server Events for Microsoft Premier Customers! Microsoft TVP - Reading - U.K.

If you are a Microsoft Premier customer involved with SQL Server, there are two great events scheduled that you can't miss:


SQL Server 2005 Developer Productivity Day

Thursday 19th April


The event is designed for Database Developers who are experienced in using SQL Server 2000 and have had some experience with SQL Server 2005. The day would also provide attendees NOT experienced with SQL Server an insight into the new Developer related features and enhancements.


The SQL Server 2005 Developer Productivity Operations day provides participants with information that will enable them to:


· Create more secure, more robust applications at a lower cost

· Take advantage of existing skills across a variety of development languages

· Build new classes of connected applications across any platform or device


The following is an outline of the subjects to be covered on the day.


· Transact-SQL Enhancements

· Reliable Messaging with the SQL Server 2005 Service Broker

· Web Services and XML Support

· Visual Studio Integration and Hosted Common Language Runtime

· Visual Studio Team System For Database Professionals

· Multiple Active Result sets

· SQL Management Objects

· Security Enhancements


SQL Server 2005 Operations and Performance Day

Friday 25th May


This SQL Server 2005 Operations Day is designed for experienced SQL Server Database Administrators. The day would also provide attendees NOT experienced with SQL Server an insight into operational related features and enhancements with SQL Server 2005.


The SQL Server 2005 Operations and Performance day provides participants with information that will enable them to:


· Make an Informed decision regarding choice of 32 bit / 64 bit hardware / software

· Use new SQL Server 2005 Features to troubleshoot performance issues

· Implementing and Managing CLR Functionality and Security within SQL Server 2005

· Learn about the SQL Server Management Pack For MOM


The following is an outline of the subjects to be covered on the day. It is not intended as an exhaustive list of all the topics to be discussed.


· Troubleshooting performance with DMV’s

· Profiler / Database Tuning Advisor

· 32 bit versus 64 bit

· Using MOM to Manage SQL Server

· Introduction to CLR for SQL Administrators


To register to those events, you will need to contact your assigned TAM.

Both events will take place in Microsoft - Thames Valley Park - Reading.

We are looking forward to see you all!


Beatrice Nicolini

SQL Server 2005 Performance Troubleshooting - combining Profiler and Performance Monitor

(Copied from the original blog:  http://blogs.technet.com/beatrice ) 

One of the cool things that comes with SQL Server 2005, is that you have the possibility to correlate together the results of a SQL Server Profiler Trace together with a System Monitor (or Performance Monitor - however you want to call it!)  counter data.


How can you do this? Well, things are easier than you would think: just collect your data in SQL Profiler and in System Monitor how you usually do. Just make sure to collect the data for the same period of time (how can you correlate them otherwise?)


Then, open your trace in SQL Server Profiler and, always from SQL server Profiler, open the counter data you've retrieved with System Monitor (File - Import Performance Data).


Here is a preview of the result you'll get:

Beatrice Nicolini

Custom Administrative Reports – Part II

The "Performance Dashboard" is a good example of custom administrative reports – reports you can use from the Management Studio to administer the SQL Server. Of course you can use other custom reports in the Management Studio. For ex. Simon Sabin wrote the SQL 2005 Management Studio version of the good old Enterprise Manager Task Pad (http://sqlblogcasts.com/blogs/simons/archive/2007/03/28/Update-to-the-taskpad-custom-report.aspx )



If you haven’t downloaded the Performance Dashboard you can find it in this link : http://www.microsoft.com/downloads/details.aspx?familyid=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en



I would like to contribute two reports:

Server Properties – server and database properties. When one of the properties is not Microsoft’s best practice it turns red.


Maintenance Plan history – the history of the full backup, index rebuilding, consistency checks and database shrink. When you use the Enterprise Manager history / Management Studio you can only see the history of databases which are part of the maintenance plan. But what if the database doesn’t have a maintenance plan at all and its indexes never rebuilt? You won’t see that database in the history!!

In my reports you will.   


The reports I wrote could be used on SQL Server 2000 / 2005.


How to use it?

Save the attached RDL files on your machine. You should create a folder for the reports. For ex.

"C:\Program Files\Microsoft SQL Server\90\Tools\CustomReports".

Right click on an SQL Server node in the Object Browser (the node can be SQL Server 2000 as well), click on Reports, Custom Reports, and browse to the location of the RDL file called ServerProperties (it has a link to the other report).

This is it, the Management Studio can run the report, and you don’t need Reporting Services server for that.


It is just a first version so please let me know if you found any bugs.

I hope others will share their reports / queries with us.




Itay Braun

Premier Field Engineer - SQL Server

Microsoft Services - UK

E-Mail: itayb@microsoft.com

Mobile: +44-796-928-9996

Veni         Vidi         Fixit


CTP2 of Microsoft Office PerformancePoint Server 2007 is now available!

CTP2 of Microsoft Office PerformancePoint Server 2007 is now available!

We are proud to announce the ENU (English) release of Microsoft Office PerformancePoint Server 2007 CTP2 software! This is now available to Internal Microsoft Users and TAP customers – and shortly will be announced externally through the Marketing Team and the MSConnect email notification. Note that CTP2  will also be available in localized languages German and Japanese in about 4 weeks time – look for a separate announcement on this.

MSConnect and Download
You can download the files within the "Download" section of Microsoft Connect (https://connect.microsoft.com/default.aspx). Prior to getting access to the download page you must take the mandatory survey (if you haven’t already) and agree to the Licensing terms. We encourage all CTP members to actively use the newsgroups and feedback section for assistance and to provide feedback/submit bugs regarding the CTP2 software release. Additional product information about Office PerformancePoint Server 2007 can be found at www.microsoft.com/performancepoint.


Itay Braun



This Blog