Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

April 2010 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

April 2010 - Posts

SQL Server in Virtual platform - keep a close watch on physical server's configuration

Server consolidation & virtualization is a hot topic and also it is one of the biggest concerns for many DBAs is scalability/performance when it comes to virtualization.

At this point,performance for virtual machines can be close to, if not the same as, many physical server configurations....read more


Mind the gap, the latest version number for SQL Server 2008 R2 is....

Since the news about SQL Server 2008 R2 RTM is publicised I have downloaded and installed the Evaluation edition and R2 Express edition.

You can also download SQL Server 2008 R2 RTM - Management Studio Express (with pre-registration)

The Microsoft® SQL Server® 2008 R2 RTM - Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded applications, lightweight Web applications, and local data stores. Designed for easy deployment and rapid prototyping, this download includes support for Sysprep, Microsoft's System Preparation Utility for Microsoft Windows operating system deployment. 

Microsoft SQL Server 2008 R2 Management Studio Express (SSMSE) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server Express. This edition combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators of all skill levels.

To read what is new in SQL Server® 2008 R2 click here.

Also worth to refer the System Requirements

  • Supported Operating Systems: Windows 7; Windows Server 2003; Windows Server 2008; Windows Server 2008 R2; Windows Vista; Windows XP
  • 32-bit systems
    • Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended.)
  • 64-bit systems
    • 1.4 GHz or faster processor
  • Minimum of 512 MB of RAM (2 GB or more is recommended.)
  • 2.2 GB of available hard disk space

Here is the copy of the detailed Systems Requirements for your review. 

Finally the version number of SQL Server 2008 R2 you will see is "10.50.1600".

Also don't forget to get SQL Server 2008 R2 Books Online and SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)


Come play in the SQL Server 2008 R2 Hosted Trial virtual lab!

In continuation to SQL_Server_2008_R2 release date announcement you can access a complete, integrated Microsoft SQL Server 2008 R2, SharePoint 2010, and Office 2010 environment… right from your desktop.

 SQL Server 2008 R2 Hosted Trial

Our Hosted Trial makes it easy for you to experience new features without any need for configuration or additional work. Register now to try out up to seven labs:

  • SQL Server 2008 R2 – Multi Server Management
  • SQL Server 2008 R2 – PowerPivot
  • SQL Server 2008 R2 – Reporting Services
  • SQL Server 2008 R2 – Master Data Servicess
  • SQL Server 2008 R2 – StreamInsight
  • SQL Server Integration Services - Introduction
  • SQL Server Integration Services – Intermediate to Advanced

Hosted Trial Brought to You By: 

        Microsoft SQL Server 2008 R2    
Register Now!


SQL Server Management Data Warehouse - quick tour on setting health monitoring policies

Profiler, Perfmon, DMVs & scripts are legendary tools for a DBA to monitor the SQL arena.


In line with these tools SQL Server 2008 throws a powerful stream with policy based management (PBM) framework & management data warehouse (MDW) methods, which is a relational database that contains the data that is collected from a server that is a data collection target. This data is used to generate the reports for the System Data collection sets, and can also be used to create custom reports. ... more from here.


Congratulations 2010 Microsoft MVP, woo hoo 5th time now

Well, its April 01st again and a big day for me 2 important events to note (daughter's birthday and MVP renewal notification).

After a long travel from London to Hyderabad after speaking at UK AIC 2010 conference, I was able to make it by half day here for my daughter's birthday, phew. Then next one awaiting official confirmation about MVP renewal (April - Mar cycle), woo hooo here is one....

Dear Satya Jayanty,

Congratulations! We are pleased to present you with the 2010 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in SQL Server technical communities during the past year.

Here is a FAQ note about how to become MVP, to nominate yourself or someone else, please visit this page. and

Where can I find contact information for Microsoft MVPs?
While you can find a list of the current MVPs who wanted to be included on our awardees page, we do not list MVP contact information for all MVPs for privacy and security reasons.