Search Results for “mirroring”

14. Database Mirroring: Learning Plan (5m)

Want to become an expert on mirroring? Here’s a task list to run in your lab. Need a free place to test mirroring out quickly to get your feet wet? Want to read more advanced articles on more mirroring topics? Curious if SQL Server Basic Availability Groups in Standard Edition make mirroring irrelevant? Get the…

You’ll need a membership to access this course. Check out my training classes.
Read More

02. Architecture Design: Tactics – Clustering, Always On, Mirroring, and More (29m)

Once we’ve defined our RPO and RTO goals, we need to pick the right SQL Server features to meet those goals. This module will teach you the pros and cons of clustering, mirroring, Always On Availability Groups, replication, log shipping, virtualization replication, and more.

You’ll need a membership to access this course. Check out my training classes.
Read More
Tara Kizer

Asynchronous Database Mirroring vs. Asynchronous Availability Groups

When Database Mirroring came out in SQL Server 2005 Service Pack 1, we quickly dropped Log Shipping as our Disaster Recovery solution. Log Shipping is a good feature, but I can failover with Asynchronous Database Mirroring faster than I can with Log Shipping. When Always On Availability Groups (AG) came out in SQL Server 2012,…
Read More

What Amazon RDS for SQL Server Users Need to Know about Multi-AZ Mirroring

Amazon Relational Database Service (RDS) now supports multi-availability-zone SQL Servers. This means you can have a primary database in one data center, and a secondary replica in another data center. Those Portland folks were always a little bit backwards anyway. When your primary server goes down, OR when the entire AZ goes down, you can fail…
Read More

Office Hours, Silent Film Edition

Videos
6 Comments
Hey, remember in yesterday’s video how I said I was having a really bad day? Well, here’s how bad it was – I recorded two videos in a row, and I forgot to turn my microphone on for the second video. <sigh> So here are the questions & answers: 00:25 Calvin H: Any tips or…
Read More

[Video] Office Hours at the Arctic Circle

Videos
0
Just after passing the Arctic Circle marker and celebrating with a glass of champagne, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:13 TheEveryDayDBA: Does it matter on what column you implement a table partition for a very large table? It has 28 billion rows, with no datetime column to…
Read More

How to Go Live on SQL Server 2022

SQL Server 2022
7 Comments
You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the migration. This is NOT a blog post about how to migrate – that’s the same as it’s been for a long time. Go build the new 2022 servers, and use log shipping or database mirroring to sync…
Read More

Office Hours Speed Round, Easy Text Answers Edition

Some of the questions y’all post at https://pollgab.com/room/brento have easy one-line answers. Let’s knock ’em out: George: Hi Brent, what recently has been the most challenging/surprising/new-to-you performance issue you have encountered? SQL Server 2019’s slowdowns. I spent days working on that. RoJo: Have you used Distributed AG as a way to upgrade major versions of…
Read More

[Video] Office Hours in the Valley of Fire State Park

Videos
0
I drove the Ferrari out through the Valley of Fire State Park and stopped out in the middle of nowhere to take the questions you’d upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:39 Saket Mittal: Hi Brent, I am working with a developer on a query, this query has lots of join ,…
Read More

Do You Have to License Your Standby SQL Server?

Licensing
26 Comments
Businesses who need high availability and disaster recovery usually want three servers: A primary SQL Server where all the writes & reads take place A high availability SQL Server sitting right next to the primary, in the same data center, keeping up with its writes, and A disaster recovery SQL Server sitting in another city…
Read More