Archive

Archive for May, 2012

Know the cost of SQL Server 2012’s AlwaysOn Availability Groups

May 30, 2012 Leave a comment

SQL Server 2012 takes Database Mirroring to the next level. Many of us have used SQL Server 2008’s Database Mirroring as part of a disaster recovery (DR) solution. And it’s serves well in that capacity (unless you try and use synchronous mirroring on a high usage DB across to another data center – trust me, don’t do that!).

Some of the great improvements with the touted replacement to Database Mirroring:

  • Can have up to 4 replicas (not just one)
  • Can failover multiple databases as a unit (not just one)
  • Can read from the replicas

However, don’t just blindly go in for this model without counting the cost. There are some requirements for this new technology that impact your licensing cost, and possibly administration cost. Here they are:

1) The feature requires Windows failover clustering – this means you’ll need the Enterprise edition or higher of Windows Server. A Windows cluster requires a minimum of two servers, and since your replica must be on a separate cluster, you’re talking 4 servers, at least. NOTE that there is no requirement to install SQL Server as a clustered application.

2) The feature requires SQL Server Enterprise Edition. See this article for a comparison of the various editions: http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx

Now the question arises: Is Database Mirroring still available as an option in SQL Server 2012? The answer is yes. But beware that AlwaysOn is the replacement and Database Mirroring will likely disappear in the next release. This is explained in the AlwaysOn FAQ here: http://msdn.microsoft.com/en-us/sqlserver/gg508768#OtherEnhancements

My suggestion is to give careful thought to your DR design BEFORE you make firm decisions on your hardware and software editions. You don’t want to be painted into a corner with Standard edition if you could really benefit from features like this which requires Enterprise Edition, and of course on the flip side if Database Mirroring is sufficient for your needs, then you might be just fine with Standard Edition.

Reference for this post:

Introducing SQL Server 2012’s AlwaysOn Availability Groups SQL Server Magazine, January 2012

http://www.sqlmag.com/article/sqlserverdenali/sql-server-2012-configure-alwayson-141127

Microsoft Test Manager 2010 (MTM) Resources

May 24, 2012 Leave a comment
  1. Code Magazine article, taken from Chapter 3 of Software Testing with Visual Studio 2010, entitled Planning Your Testing
    http://www.code-magazine.com/Article.aspx?quickid=1103013
  2. Channel 9 videos:
    1. Introduction to Test Case Management in Visual Studio 2010 with Microsoft Test and Lab Manager
      http://channel9.msdn.com/blogs/kmcgrath/introduction-to-test-case-management-in-visual-studio-2010-with-microsoft-test-and-lab-manager
    2. Team Foundation Service Preview: Using Visual Studio, Microsoft Test Manager, and Eclipse
      http://channel9.msdn.com/posts/Team-Foundation-Service-Preview-Using-Visual-Studio-Microsoft-Test-Manager-and-Eclipse
    3. Software Testing with Microsoft Test Manager 11 and Lab Management
      http://channel9.msdn.com/Events/TechDays/TechDays-2012-Belgium/283

Accessing TFS Preview from Visual Studio 2010

May 24, 2012 Leave a comment

If you want to access your preview TFS account (TFS in the cloud) from Visual Studio 2010 you need to install KB2581206 (Visual Studio 2010 SP1 TFS Compatibility GDR).

Then you can configure access as usual. Screenshots explaining the process can be found on Gregg Boer’s blog post.

FIX: Pause icon shown when Sharing in Lync session

May 18, 2012 Leave a comment

In a Lync meeting I setup yesterday, a presenter was unable to Share his program or desktop successfully – all attendees see is a large white pause icon in the upper left of a black screen. Turns out this problem can occur if the sharer is running Windows XP and the Terminal Services Windows Service is not running. The fix was to change the service’s startup option from Disabled to Manual and start it.

Thanks to Navin for the solution (here).