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, the functionality of Surface Area Configuration for Services and Connections can now be performed using…

5

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 will see bunch of facets listed there. For eg. Let us pick Database Facet. This facet…

1

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 what this write up on the wizard is about. Creation of…

1

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 the exact feeling one will get when they see the…

5

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 the opportunity of live Q&A with the experts. Attendee Registration URL: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032360210&Culture=en-US   Cheers,…

3

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 or server farm ·         Generate report or document from multiple servers ·         Analyze result from multiple servers ·         or Run…

9

Ken Henderson – We Will Always Remember You

We are mourning the loss of Ken Henderson who passed away this Sunday evening. We don’t know any details at this time, but we will let the community know as we learn more. It was great being around Ken and feeling his passion and learning from him over the years. We will miss him. Bill…

29

SQL Server 2005 Best Practices Analyzer (January 2008) — Now Available!

It’s a new year and, with it, we come bearing gifts!  We have a pretty significant update to SQL Server 2005 Best Practices Analyzer.  It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools.  And all…

14

Performance Data Collector for SQL Server 2008 – Revealed

I’ve been getting many requests on what is this new Performance Data Collector  tool and how does it work. First off, Performance Data Collector is simply a component as one of the tools in Management Studio (SSMS) involved in performance troubleshooting. These tools include the new Data Collector, System Collection Sets, the Management Data Warehouse, and…

3