Search Results for &#8220;disaster recovery&#8221;

SQL ConstantCare® Quick Start “10TB of data on a Commodore 64, interesting” 1. Set up the SQL ConstantCare® app. Don’t install this on the SQL Server itself – just install it on your own workstation or a jump box works fine too. The box doesn’t need to be up 24/7 – data collection happens once…

[Video] Office Hours 2018/1/10 (With Transcriptions)

Last Updated January 18, 2018

This week Brent, and Richie discuss validating backups using the backup set table, how to figure out if you’re a Mid-Level or Senior DBA, rollbacks, compatibility modes while upgrading SQL Server versions, MAXDOP settings, and Brent’s car purchasing tip. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our…

[Video] Office Hours 2017/12/13 (With Transcriptions)

Last Updated December 16, 2017

Videos

This week Tara, Erik, and Richie discuss virtualization, replication & mirroring, switching SQL service logins to an AD account, temporal tables, tempdb issues, migrating from SQL 2015, and Richie’s outdoor adventures in “Breath of the Wild.” Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen…

[Video] Office Hours 2017/11/15 (With Transcriptions)

Last Updated November 20, 2017

This week Brent, Erik, Richie, and Tara discuss Docker, writing to different servers in different locations, SAN Replication, reducing the size of a database, patching Availability Groups, getting rid of failover cluster instances, long-term backup storage options, VLF numbers, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe…

[Video] Office Hours 2017/11/08 (With Transcriptions)

Last Updated November 11, 2017

Videos

This week, Richie and Tara discuss Richie’s current projects, Availability Groups, offloading reads and backups, applying service packs, whether production should ship agent jobs to production recovery server, security checks and scans in SQL Server, CPU performance issues upgrading to SQL Server 2016 and 2017, database backups and restores, whether there’s currently a DBA shortage,…

How to Do a SQL Server Architecture Review

Last Updated October 12, 2017

Architecture, Processes and Practices

We’ve talked about how to do a free SQL Server health check, and then how to drill deeper with performance check. After these two, management usually steps back and asks, “Wait a minute – how’d we get into this mess? And long term, strategically, what should we do next?” And usually, we’re in a hot…

[Video] Office Hours 2017/10/4 (With Transcriptions)

Last Updated October 7, 2017

This week, Brent, Tara, and Richie discuss what they think about having no more service packs for SQL Server 2017 and newer versions, shrinking log files, how many servers can one DBA manage, log backups, mirroring vs Availability Groups vs log shipping, and their next company retreat location. Here’s the video on YouTube: You can…

What is the biggest mistake you made in production?

Last Updated August 1, 2017

Tara Kizer

SQL Server

This has been blogged before by several people. One thing I’ve learned from Brent is to not let the fact that the topic has been blogged before stop you from blogging about it. With that out of the way… When you have sysadmin access, you are bound to make a big mistake in production at…

[Video] Office Hours 2017/07/12 (With Transcriptions)

Last Updated July 17, 2017

This week, Brent, Richie, Erik, and Tara discuss partitioning tables, native backups vs 3rd party agent backups, page life expectancy, query tuning, deadlocks, drawbacks of RCSI, triggers, replication, Always On Availability Groups, and forest fires. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on…

[Video] Office Hours 2017/07/05 (With Transcriptions)

Last Updated July 11, 2017

This week, Brent and Tara discuss separating data and logs on separate drives, statistics time, scalar UDFs, licensing, encryption, gathering SQL error logs and agent job history, replication, upcoming training courses from Brent Ozar Unlimited, and what DBA topics they struggle with the most. Here’s the video on YouTube: You can register to attend next week’s Office…

[Video] Office Hours 2017/06/28 (With Transcriptions)

Last Updated July 2, 2017

This week, Erik, Tara, and Richie discuss performance and load testing tools, sysadmin update SQL server restart, defragmenting column store indexes, Amazon Redshift, installing Microsoft updates, Always On Availability Groups, Redgate SQL Clone, as well as their thoughts on the current DBA job market. Here’s the video on YouTube: You can register to attend next week’s Office…

Introducing sp_AllNightLog: Log Shipping at Scale, Open Source

Last Updated June 30, 2017

Backup and Recovery, First Responder Kit, kCura Relativity

In our Faux PaaS project, we need a backup plan – or rather, a restore plan. On each SQL Server instance, clients can create as many databases as they want, anytime they want, with no human intervention. We need those databases covered by disaster recovery as quickly as practical. SQL Server’s newer disaster recovery options – Always On Availability Groups and…

Fundamentals of Database Administration

Last Updated November 15, 2020

Erik Darling

You’re a systems administrator or developer who’s been stuck in charge of the SQL Server. You have a couple of production SQL Servers, no high availability or disaster recovery, and around 100GB of data or less on each server. You’ve never been to a “real” SQL Server training class, and you’ve been Googling your way…

[Video] Office Hours 2017/06/21 (With Transcriptions)

Last Updated June 25, 2017

This week, Brent, Erik, Tara, and Richie discuss cross-database transactions in AGs, agent job owners, column store indexes, linked servers, migrating SQL Server databases to AWS cloud, synchronous readable secondary, rebuilding indexes, backups using SANs, licensing, Always On Availability Groups on CDC, Azure Cosmo DB, compression, and encryption. Here’s the video on YouTube: You can…

sp_AllNightLog

Last Updated December 13, 2022

You manage a SQL Server instance with hundreds or thousands of mission-critical databases. You want to back them all up as quickly as possible, and one maintenance plan job isn’t going to cut it. The basic concept: backing up and restoring databases You also want to protect those databases by restoring them as quickly as…

[Video] Office Hours 2017/05/31 (With Transcriptions)

Last Updated June 3, 2017

This week, Brent and Richie discuss sp_Blitz Backups, change history tracking, exams and certifications, using Azure for DR-only, which version of SQL server to use for a new DB, adding additional data files, load balancing, trace flag 2371, dealing with reporting services, and much more. Here’s the video on YouTube: You can register to attend next week’s…

[Video] Office Hours 2017/05/03 (With Transcriptions)

Last Updated May 7, 2017

This week, Brent, Tara, and Richie discuss choosing batch sizes, SQL 2017 on Linux, how much memory to leave on the OS for the SQL server, parameter sniffing, allocation unit size of SQL Server, triggers, X-Files, aliens and much more! Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…

Confession: I recommended that a 5GB database get split up.

Last Updated April 5, 2017

Licensing, Microsoft Azure, SQL Server

Listen, I can explain. Really. Photo by Toa Heftiba We had a client with a 5GB database, and they wanted it to be highly available. The data powered their web site, and that site needed to be up and running in short order even if they lost the server – or an entire data center –…

We’re Changing Our Online Training – Here’s Why.

Last Updated March 25, 2017