x64 Windows – Upgrade from 32bit SQL Server to 64bit SQL Server

Many people are now upgrading from 32bit to 64bit SQL Servers. Most of you have a match between your operating system and your SQL Server platform. For example, most of you install a 32bit SQL Server on 32bit Windows, and if you have the x64 platform of Windows, you usually install the x64 SQL Server….


Windows 7 upgrades half price for a few days only!

You can pre-order Windows 7 starting Friday, June 26, 2009 at midnight eastern time and get at least half off. The offer is good until supplies run out or July 11, 2009, whichever comes first. The release date for Windows 7 is October 22, 2009 – if you pre-order you get a great OS at…


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 instances…


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 info…


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 to…


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 Server…


SQL Server 2008 SP1 is now available

SQL Server 2008 SP1 (build 2531) is now available. Downloads SQL Server 2008 Service Pack 1 Microsoft® SQL Server® 2008 Express Edition Service Pack 1 Microsoft SQL Server 2008 Feature Pack, April 2009 Microsoft SQL Server 2008 Upgrade Advisor, April 2009 Microsoft SQL Server 2008 Reporting Services Report Builder 2.0, April 2009 Microsoft SQL Server…


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 Files\Microsoft…


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 CTPs…


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…