May 31, 2012 | Database Mirroring, DavidP |
By David Postlethwaite I was at a meeting the other week when someone mentioned that you could specify two SQL Servers in a .NET connection string. I hadn’t heard of this before and did some investigation and found out a bit more. In your SQL connection string...
Apr 13, 2010 | Database Mirroring, Snapshots, SQL Server 2005, SQL Server 2008, TSQL Tuesday |
Aaron Nelson (Blog|@SQLvariant) is hosting this months #TSQL2sDay with the theme of reporting. My post looks at some of things I have done in the past to offload reporting to another server to reduce the overhead of running reports against production OLTP databases.A...
Mar 11, 2010 | Database Mirroring, Performance, Snapshots, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication |
This post is the second post in my series about Database mirroring. For part one is titled Configuring Database Mirroring in SQL Server. I believe that high availability is the primary reason people mirror their important production databases. Depending on your...
Mar 7, 2010 | Database Mirroring, SQL Server 2005, SQL Server 2008, SQLServerPedia Syndication |
I plan on writing a series of posts on database mirroring, this is the first. Database Mirroring is a new feature of SQL Server 2005 and I have been configuring and testing it lately so I thought I would write a short post to document what I have learned. This post...
