AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios

Author: Sanjay Mishra Contributors: Piyush Ranjan, Steven Schneider Reviewers: Ed Muth, Chuck Heinzelman, Silvano Coriani, Rama Ramani, Juergen Thomas, Cephas Lin, Lori Clark, Luis Carlos Vargas Herring Once you have created AlwaysOn Availability Groups in Windows Azure VM (tutorial) and created the Availability Group Listener (tutorial), it is important to know how the applications will… Read more

SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

SQLCAT.com consolidated index of Whitepapers

In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have consolidated all of the Whitepapers published over the last few years.   While all of the content actually exists on Technet and MSDN download sites, SQLCAT was a great resource to start looking.  Hopefully this will… Read more

Technical Reference Guides for Designing Mission-Critical Solutions using SQL Server are available

The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and architecture guidance for various mission-critical workloads deployed by users. These guidesreflect the knowledge gained by the CAT team while working with customers onmission-critical deployments, many of these deployments being the result ofdeep customer engagements by the CAT organization. Each guide provides not onlythe key… Read more

Moving the Transaction log file of the Mirror Database

  Author: Sanjay MishraReviewers: Prem Mehra, Mark Souza, Kun Cheng, Nicholas Dritsas, Thomas Kejser   Recently I worked with a customer who has deployed database mirroring for a very large database (~ 1 TB) between two data centers that are about 400 miles apart. I got an email from the customer that reads something like… Read more

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… Read more

New Best Practices Whitepaper published: "Database Mirroring and Log Shipping Working Together"

Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single mirror database, you can set up log shipping from a database mirroring pair to additional servers, to provide multiple… Read more

SQL Server 2005 Transactional Replication: Benefit of using SubscriptionStreams for low bandwidth, high latency environments

Author: Bren Newman Introduction When using Microsoft SQL Server 2005 Transactional Replication, the Log Reader Agent reads the log, constructs SQL statements for published articles and posts it to the Distribution database; the Distribution Agent reads the Distribution database, delivers and applies the “package” to the Subscriber. Often the Publisher, Distributor and Subscribers are on… Read more

How can SQL Server 2005 OnLine Piecemeal Restore improve availability?

Question 1:  How can SQL Server 2005 OnLine Piecemeal Restore improve availability? Question 2:  Can I recover a single object such as a table or specific partition(s) from a partitioned table? Answer:   The question is how to get the greatest flexibility, manageability, availability and recoverability for large databases.  Anytime you need to restore a… Read more