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”
Author Archives: Cindy Gross | She-Her | Befriending Dragons
SQL Server 2005 Clustering Tips/References
I have copied this over from an older blog. I have cleaned it up a bit to clarify a few areas and added some links. SQL Server 2005 Clustering Tips/References This information will supplement the clustering information I wrote in chapter 10 of SQL Server 2005 Practical Troubleshooting: The Database Engine — Handy cluster related infoContinue reading “SQL Server 2005 Clustering Tips/References”
Share this:
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”
Share this:
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!”
Share this:
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”
Share this:
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”
Share this:
How to configure DTC for SQL Server in a Windows 2008 cluster
How to configure DTC for SQL Server in a Windows 2008 cluster [This post was revised 11 May 2009 with new mapping information, fixed formatting issues 23 March 2010] With Windows 2008 you now have the option to use multiple DTCs. There is a lot of confusion over whether to do that for SQL ServerContinue reading “How to configure DTC for SQL Server in a Windows 2008 cluster”
