May 2007 - Posts

NEW KB Article - Description of disaster recovery options for Microsoft SQL Server

This is a new KB article published only few days ago

You might find this articel also interesting:

Description of the waittype and lastwaittype columns in the master.dbo.sysprocesses table in SQL Server 2000 and SQL Server 2005


I promise to keep you updated with the news. You can also visit to get updates.



Itay Braun

Microsoft has released Microsoft Core XML Services (MSXML) 6.0 Service Pack 1

Microsoft has released Microsoft Core XML Services (MSXML) 6.0 Service Pack 1 (SP1). MSXML 6.0 SP1 is released as an optional update on the Microsoft Windows Update Web site. MSXML 6.0 SP1 improves reliability, security, and conformance with the XML 1.0 specification. MSXML 6.0 SP1 also improves compatibility with the System.Xml namespace in the Microsoft .NET Framework 2.0.

MoreInformation Section

Overview of MSXML 6.0 SP1

  • MSXML 6.0 SP1 updates the existing version of MSXML 6.0, of MSXML 4.0, and of MSXML 3.0.
  • MSXML 6.0 SP1 updates the version of the MSXML6.dll file to 6.10.1129.0.
  • You do not have to install the release version of MSXML 6.0 to install MSXML 6.0 SP1.
  • You can install MSXML 6.0 SP1 side-by-side together with MSXML 4.0 and together with MSXML 3.0.
  • MSXML 6.0 SP1 is installed as a component of Microsoft SQL Server 2005 Service Pack 2 (SP2) or as a component of Windows Vista.

    If you do not have SQL Server 2005 SP2 installed or if you do not have Windows Vista installed, you can download MSXML 6.0 SP1 from the Microsoft Download Center. To do this, visit the following Microsoft Web site:

Max Worker Threads Configuration in SQL Server 2005


In 2005 the default value for this setting has changed from 255 (SQL2k) to 0 (dynamic in SQL2k5).  According to various sources, the following table shows the automatically configured number of Max Worker Threads for SQL Servers (2005) with different numbers of CPUs when the SQL Server database engine is left to dynamically set this value:




Auto Configured Max Worker Threads (32 bit Server)

Auto Configured Max Worker Threads (64 bit Server)

<= 4 CPUs



8 CPUs



16 CPUs



32 CPUs





The formula to determine the max worker processes is as follows:


For x86 systems where total number of logical processors <=4


                # max worker threads = 256




                # max worker threads = 256 + ((# Procs – 4) * 8)



For x64 systems where total number of logical processors  <= 4


                # max worker threads = 512




                # max worker threads = 512 + ((# Procs – 4) * 16)


On an 8 processor x86 machine (could be 4-proc HT or 4-proc dual core machine, therefore shows 8 logical procs), max worker threads will be configured to 288 (256 + (4 * 8))


 You can find out how many threads have been configured by looking at the max_workers_count column in the sys.dm_os_sys_info DMV.



SQL and indeed Windows has NO method of identifying the difference between physical and logical processors – i.e. multi-core and hyper-threaded processors appear to windows (and therefore) SQL as processors.  As such 4 x Dual core would appear as 8 logical processors – and max worker threads would be sized on this basis regardless  of whether these are 8 x physical, 4 x dual core or 4 x HT.



New Microsoft Certified Architect: Database


Program overview

( )  

The Database Architect program, the newest Technology Architect program under the Microsoft Certified Architect (MCA) umbrella, provides training and certification in Microsoft SQL Server to help you become a trusted database architect. The program ensures success in three ways.

Top tier training and certification

The instructors are renowned leaders in their specific subject areas. Most of the instructors are Microsoft subject matter experts and members of the product development team as well as top Microsoft product architects, support professionals, and members of the Microsoft IT department.

Certification requires extensive industry experience, successful completion of intensive written exams, lab-based simulations, and an evaluation by a peer-based Review Board.

Learn about the Review Board

A community of trusted architects

The program provides highly trained and skilled product architects who have strong ties to the Microsoft development team and the Microsoft IT department. These ties provide direct input into current and future products, as well as definitive and authoritative answers to questions in a timely manner.

The Microsoft development team trusts the community, based on its partnership in building the program and certification, and regards this community as its foremost field-based resource.

Skills to successfully address complex customer requirements

The curriculum ensures that architects have a broad and solid understanding of how to address the most complex scenarios and customer requirements.

The certification process ensures that graduates have extensive real-life experience and are equipped with not just the utmost technical skills but also the soft skills required to be successful in an enterprise or otherwise complex deployment.

Sharing rigorous prerequisites and Board reviews with the other MSA programs, the Database Architect program differs from the Infrastructure and Solutions Architect programs in the following ways:

External participation is limited to Microsoft Gold Certified Partners only (systems integrators). It is not open to general customers.

Enrollment fee is US$25,000. This fee covers the certification process and training program, but does not guarantee successful completion of the program.

Learn about the tuition and cancellation policy

Learn about the certification process

The program requires participation in intensive training led by experts on the various database technologies and dependencies. It is held in Redmond, Washington.

Review the curriculum and see a sample schedule



Monthly conference calls that consist of program updates, product updates, feedback discussions, and educational presentations.

Welcome kits, including leather jackets.

An apprentice program that assists in developing future Database Architects.

Automatic inclusion in Microsoft Office Technology Adoption Program (TAP) communications and resources.

Technical training from top subject matter experts within and outside of Microsoft.

Free Database Architect continuing education courses. These courses are usually delivered two times per year and focus on various technologies.

Continued interaction and contact with SQL Server subject matter experts, other Database Architects, and the Microsoft SQL Server product group for assistance in architecture and deployment needs.

KATMAI - Vision for next release of SQL Server announced at Microsoft’s first Business Intelligence Conference

Just released today (May 9th) at Microsoft’s first Business Intelligence Conference.

Microsoft SQL Server “Katmai” Builds on Proven Success of SQL Server 2005, Empowering Customers to Manage the Data Explosion

Vision for next release of SQL Server announced at Microsoft’s first Business Intelligence Conference.


SEATTLE — May 9, 2007 — Today at the first Microsoft Business Intelligence (BI) Conference, Microsoft Corp. presented its vision for the next version of its flagship data management and analysis platform. SQL Server™ code-named “Katmai,” the next release of Microsoft® SQL Server, will help companies access and manage rapidly increasing volumes of data for mission-critical applications, increase their ability to better understand the organization with business insight, and reduce difficulties associated with managing complex systems. SQL Server “Katmai” builds on the success of SQL Server 2005 as a proven platform that is crucial to the completion of business projects, delivering increased functionality to a comprehensive range of applications from the desktop to the data center.

“We developed SQL Server with the goal of providing a data management and analysis platform for all companies regardless of size or budget,” said Ted Kummert, corporate vice president of the Data and Storage Platform Division at Microsoft. “With the release of ‘Katmai,’ we’ll take the next step on our data platform vision by delivering a comprehensive and integrated business intelligence solution. Expanding the usability of data across businesses will give customers more value for their IT investments.”

Kummert will go into further details about Microsoft’s vision of SQL Server “Katmai” during his keynote address at the conference on May 10. Kummert will show how SQL Server “Katmai” is part of Microsoft’s vision for pervasive BI, illustrating the company’s unified commitment to offer a complete and integrated BI solution that customers can rely on to meet all critical BI needs.

Scheduled to be available in 2008, SQL Server “Katmai” will deliver on Microsoft’s overall data platform vision to meet the needs of the coming data explosion and the next generation of data-driven applications.

Data Platform to Power Business Insights Regardless of Size or Budget


SQL Server “Katmai” is designed to do the following:

·         Provide a scalable and reliable platform with advanced security technology for even the most demanding applications

·         Reduce the time and cost of managing data infrastructure with innovative policy-based management

Redefining Pervasive Insight


SQL Server “Katmai” brings powerful BI capabilities and valuable data even closer to every user:

·         Empowers users to easily consume information due to increased integration with front-end tools in the 2007 Microsoft Office system, including Office Excel® 2007, Excel Services, Office SharePoint® Server and Office PerformancePoint Server 2007

·         Provides reports of any size or complexity internally within organizations and externally to partners and suppliers

·         Aligns corporate decision-making by collaborating on key analysis and reports within Microsoft Office SharePoint Server

·         Integrates all relevant data within the enterprise into a scalable and comprehensive data warehouse platform

Dynamic Development for Data Management Solutions

SQL Server “Katmai” offers these features for developers:

·         Provides an integrated development environment with Microsoft Visual Studio® and .NET Framework that will accelerate development of new applications with a higher level of data abstraction

·         Enables developers to synchronize data from virtually any device to the central data store


Beyond Relational Data

SQL Server “Katmai” enables users to do the following:

·         Manage any type of data including relational data, documents, geographic information and XML

·         Work with a consistent set of services and tools


SQL Server “Katmai” is scheduled to be delivered in 2008.

More information is available at .



Itay Braun


The public CTP for DataDude SR1 is now available!

The public CTP release for our first service release is now available.


This release enables:

·          3/4 part name resolution through a new feature called database references

·          Files are now part of the project definition and can be fully parameterized to match you deployment needs (this replaces the need for the storage deployment script)

·          SQLCMD variable support; this adds a project property page for editing variables that you can then use inside your scripts. Variables are stored inside the project file and can be mapped to MSBuild properties.


Besides that we fixed parser, interpreter bugs and the performance bugs for which we released an hotfix earlier this year.


This release does require Visual Studio 2005 SP1.


You can download the SR1 CTP from this location:



Itay Braun



This Blog