SQL Server Consolidation

Many companies are now looking to consolidate their SQL Server instances. The old strategy of one instance per server can be wasteful of resources. Often large chunks of physical resources sit idle and a lot of money is spent on electricity to power all those machines. If you can consolidate even some of your instancesContinue reading “SQL Server Consolidation”

What to know before you choose a SQL Server Disaster Recovery and/or High Availability solution

Why disaster recovery planning matters: ·         Do you know what your plans are to recover from various data losses? Have you ever tested those plans? Can they be implemented within your Service Level Agreements (SLA)? Are you confident your plans cover the most likely and/or most painful types of data losses? ·         Who gets toContinue reading “What to know before you choose a SQL Server Disaster Recovery and/or High Availability solution”

SQL Server 2005/2008 Now Supports Guest Clustering in a Virtual Machine!

Technorati Tags: SQL Server,virtualization Guest clustering in a Virtual Machine for SQL Server has been a hotly requested feature for quite some time, and as of today it is officially supported! See the below links from Bob Ward for the exact details. Basically the guest OS has to be Windows 2008 or higher, SQL ServerContinue reading “SQL Server 2005/2008 Now Supports Guest Clustering in a Virtual Machine!”

Introduction to Policy Based Management

Thanks to Lara Rubbelke for teaching me about PBM! See the attached PBM.zip for a full slide deck and demos of the “on change” functionality.    Install •       Get updated policies from the feature pack item “Microsoft SQL Server 2008 Policies” •       In Management Studio expand your instance then Management.Policy Management.Policies.Import Policy •       Import from C:Program FilesMicrosoftContinue reading “Introduction to Policy Based Management”

Previous blogs on SQLCommunity.com

Connect.Microsoft.com By Cindy Gross on Monday, March 09, 2009 12:15:56 AM Want to provide feedback on any Microsoft product? Want access to the latest CTPs (sometimes known as betas)?   Create an account on http://connect.microsoft.com/ and you can file bugs or wishes and vote on what other people have submitted. You can also find CTPsContinue reading “Previous blogs on SQLCommunity.com”

%d bloggers like this: