February 2008 - Posts

29 February 2008
Where is SAC tool?

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 CTP5 release, Read More...

5 Comments

 

29 February 2008
Some nodes in OE do not have "Policies" context menu - But I need them to author policies !

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 you Read More...

1 Comments

 

26 February 2008
Uploaded Demo Scripts for TechNet Webcast - Using the New Policy-Based Management Framework in SQL Server 2008

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 Read More...

1 Comments

Filed under: SQL Server Management Studio, DMF, Policy-based management, SQL Server 2008

 

Attachment(s):Scripts.zip

22 February 2008
The Wizard's Wand to Partitioning! Creating Staging Tables - adroitly simple

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 Read More...

1 Comments

Filed under: Switch Out, Staging Table, Manage Partition, Switch In

 

21 February 2008
The Wizard's Wand to Partitioning! Series Prelude

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 Read More...

5 Comments

Filed under: SQL Server 2008, Partitioning, Partitioning Wizard

 

18 February 2008
Webcast - SQL Server 2008 Policy-Based Management (formerly known as DMF)

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 miss Read More...

2 Comments

Filed under: SQL Server management, DMF, SQL Server 2008 Feature, Policy-based management

 

04 February 2008
Multiple Server Query Execution in SQL Server 2008

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 servers Read More...

7 Comments

Filed under: SQL Server, SQL Server Management Studio, Query Editor, NovCTP, Multiple Server Query Execution