Product has been added to your cart.

Search Results for “disaster recovery”

What to Do When DBCC CHECKDB Reports Corruption

Brent Ozar
Backup and Recovery, CHECKDB and Corruption, Processes and Practices, SQL Server
35 Comments
The instant you encounter corruption in a production SQL Server database, stop. Read this entire article first to understand the big picture, and then come back here to take action. First, understand that you shouldn’t start by trying to repair the corruption. You may be facing a storage subsystem problem where your storage is corrupting…
Read More

[Video] Office Hours 2016/04/20 – Now With Transcriptions

Brent Ozar
SQL Server, Videos
2 Comments
This week, Brent, Erik, Jessica, Richie, and Tara discuss database modeling tools, how to learn about database corruption, the new cardinality estimator, and the only question that will be on our certification exams. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. What ERD Tool…
Read More

What Is a Staging Environment and How Do You Build One?

Brent Ozar
Architecture, SQL Server
4 Comments
If you’re a full time production database administrator, you need a staging environment. This is where you test infrastructure tasks like failing over mirroring, doing a disaster recovery role swap, cluster quorum changes, log shipping configuration, and patching. You need to test this stuff repeatedly so that when you’re under pressure in the production environment, you…
Read More

What’s Covered in the Senior DBA Class of 2016?

Brent Ozar
SQL Server
13 Comments
You’re a SQL Server DBA who is ready to advance to the next level in your career but aren’t sure how to fully master your environment and drive the right architectural changes. That’s about to change in one week of learning and adventure with me, Brent Ozar. Join me to learn how size, architect, maintain, and troubleshoot…
Read More

Why RPO and RTO Are Actually Performance Metrics Too

Brent Ozar
Architecture, Backup and Recovery, CHECKDB and Corruption, SQL Server
7 Comments
Most companies come to us saying, “The SQL Server isn’t fast enough. Help us make it go faster.” They’re kinda surprised when one of the first things we fill out together is a variation of our High Availability and Disaster Recovery Planning Worksheet: Download the full PDF in our First Responder Kit They say things like, “Wait,…
Read More

Fake moustaches, barbecue, and SQL Server.

Brent Ozar
SQL Server
8 Comments
Must be Dell DBA Days: https://www.youtube.com/watch?v=Gn43sOLrcVs Join us live as we performance tune – and break – SQL Servers: Thursday Morning: Finding Your Slow SQL Server’s Bottlenecks in Record Time with Wait Stats Thursday Afternoon: How to Prove Hardware is the Problem Friday Morning: SQL Server High Availability, Disaster Recovery, and Licensing Explained Friday Afternoon:…
Read More

Replication Won’t Refresh Your Dev and Pre-Production Environments

Kendra Little
Development, Replication
19 Comments
It’s almost like the real thing, except it’s totally different. At first glance, SQL Server’s transactional replication seems like it’s useful for moving data around in all sorts of situations: it works in Standard Edition, it’s not synchronous, and you can have multiple subscribers. Why People Want Replication to Test and Pre-Production Environments Setting up…
Read More

How to Configure Always On AG Backups with Ola Hallengren’s Scripts

Brent Ozar
Always On Availability Groups, Backup and Recovery, Ola Hallengren's Database Maintenance Scripts
90 Comments
With SQL Server AlwaysOn Availability Groups, you can offload backups to a replica rather than running them on the primary. Here’s how to do it: 1. Install Ola Hallengren’s utility scripts on all of the replicas. During the install, it creates a laundry list of SQL Agent jobs, but doesn’t set up schedules for any of them.…
Read More

How to Set Up Standard Edition Always On Availability Groups in SQL Server 2016

Brent Ozar
Always On Availability Groups, SQL Server
191 Comments
SQL Server 2016 adds Availability Groups in Standard Edition. While the licensing details can obviously change right up to release date, here’s what was announced at the Ignite conference: Limited to two nodes only (a primary and a secondary) Like mirroring, you can’t read from the secondary, nor take backups of it But like database…
Read More
Pocket Square

SQL Server Consultants

Brent Ozar
Now Hiring: SQL Server Consultants tl;dr – we’re looking for SQL Server database administrators who want to make the jump into consulting from home. About Us We’re a boutique consulting firm that specializes in high performance, highly available database servers. We listen to a company’s pain points, find the root cause, and show them how to get…
Read More

Are You Getting the Benefits of Virtualization?

Brent Ozar
Licensing, SQL Server, Virtualization
11 Comments
Here’s some of the reasons companies usually virtualize their SQL Servers: Cost savings on hardware Cost savings on Windows OS licensing Cost savings on SQL Server licensing Protect against the failure of a single hardware element Leverage extended features for Disaster Recovery Automatic load balancing across multiple hosts Easier hardware replacement/migration When we perform a SQL Critical…
Read More

How to Configure Ola Hallengren’s IndexOptimize Maintenance Script

Brent Ozar
Index Maintenance, Ola Hallengren's Database Maintenance Scripts
128 Comments
If you’re a production database administrator responsible for backups, corruption checking, and index maintenance on SQL Server, try Ola Hallengren’s free database maintenance scripts. They’re better than yours (trust me), and they give you more flexibility than built-in maintenance plans. However, the index maintenance defaults aren’t good for everyone. Here’s how they ship: Transact-SQL CREATE PROCEDURE…
Read More

How Would You Change Always On Availability Groups?

Brent Ozar
Always On Availability Groups, SQL Server
93 Comments
SQL Server 2012 introduced AlwaysOn Availability Groups, a way to achieve high availability, disaster recovery, and scale-out reads. SQL 2014 brought some improvements around higher uptime and more scale-out, and all signs point to continued improvements in the next version of SQL Server, too. (I love it when Microsoft brings out features like this and…
Read More

Oracle HA & DR Basics [With Video]

Jeremiah Peschka
Oracle
0
Oracle has different availability and recovery options from SQL Server. Being aware of what these options are and how you can use them will go a long way toward keeping your Oracle boxes just as safe as your SQL Server boxes. Here’s my 17-minute video explaining it, or you can keep reading and get your…
Read More
Brent Ozar

Hi! I’m Brent Ozar.

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.

Want to advertise here and reach my savvy readers?