February, 2008

Surface Area Configuration (SAC) tool will be removed in SQL 2008 release. This tool exposed two major functionalities. Surface Area Configuration for Services and Connections Surface Area Configuration for Features A. In SQL 2008, starting...

I am assuming most of you must be familiar with jargons Facets, conditions and polices by now, if you are hands-on over policy-based management framework. If you traverse to the facets node under Management->Policy Management in Object explorer...

Thanks for those who have attended this presentation. I have attached the demo policies and the demo script as promised. Note that the policy files only work for SQL Server 2008 CTP6 and above. Cheers, Hongfei

Making a superb coffee wending machine is great and we can write volumes on how to use it. Trust me, it wouldnt appeal if you dont quickly write about any feature of the machine that solves a day to day problem for a coffee drinker / Seller. This is exactly...

Hello Everybody! Its a pleasure to start blogging on this wonderful sunny morning at Seattle when the morning mist says good bye and the sun is happy to shine right above us. Everyone is smiling as the weather just turned from wet to pleasant. This is...

What is Policy-Based Management? How does it make SQL Server administration easier? What are the main components? What is the technology behind it? Join my webcast presentation (300 level) to learn this feature inside out with tons of demos. Don’t...

SQL Server 2008 SSMS introduces a new feature, Multiple Server Query Execution, in Query Editor. This feature intends to increase the productivity of running same query against multiple servers at once. Some of useage include: · Configure group of...