Product has been added to your cart.

Search Results for “log shipping”

Home
Search Results

[Video] Office Hours: Cabo Home Studio Edition

Last Updated February 24, 2022

Got questions about SQL Server? Post them at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. This episode was the first live one I shot in my home studio in Cabo: Here’s what we covered: 00:00 Introductions 02:19 Nullpointer: What are your thoughts on temporal tables, I don’t hear you talk much…

[Video] Office Hours: SQL Server Q&A in Cabo at Sunrise

Last Updated December 15, 2021

Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Here’s what we covered: 00:00 Introductions 01:04 Jr Wannabe DBA: Hi Brent, a colleague wants to upgrade from Standard to Enterprise purely for performance gains on several regular servers (up to 8 CPU, 128GB of RAM, SQL 2016 or 2019).…

Don’t Use SQL Server to Send Emails.

Last Updated December 12, 2021

Production Database Administration

I would like to unsubscribe from this idea. I’m not talking about Agent alerts when jobs fail. That’s fine when you can’t get the business to spring for a monitoring system. I’m talking about using SQL Server to send emails to confirm a customer’s order, alert that a product is low on stock, or other…

Office Hours - ask me anything.

[Video] Office Hours Speed Round: 17 Answers in 11 Minutes

Last Updated November 18, 2021

Not all of your questions need detailed answers. In this speed round, I race through 18 answers in 11 minutes: Here’s what we covered: 00:11 UnfortunatelyPostgresIsCheaper: I know you’ve answered that, as far as u know, there isn’t a ‘Brent Ozar’ of Postgres, but as you spend a lot of time with it u must know…

[Video] Office Hours in Malibu: Ask Me Anything About SQL Server

Last Updated October 19, 2021

I’m up bright and early in Malibu, so let’s talk through your highly upvoted questions from https://pollgab.com/room/brento. 00:00 Introduction 01:04 JD: Have you ever encountered a very weird case during query / performance tuning that you just couldn’t get the query across the finish line, specifically just because SQL Server didn’t want to behave nicely?…

[Video] Office Hours: Ask Me Anything About SQL Server at Vestrahorn

Last Updated September 17, 2021

The beach at Vestrahorn mountain looks different every time we’ve visited: high tide, low tide, sun, clouds. Always a fun side trip when we’re out in the southeast of Iceland. I took a break to answer the questions you upvoted here. Questions we covered: 00:00 Introductions 00:38 Scott M: When do you recommend sp_BlitzWho vs…

[Video] Office Hours at the Eldfell Volcano Crater

Last Updated August 30, 2021

You posted and upvoted questions at https://pollgab.com/room/brento, and I ascended – well, drove into – the Eldfell Volcano in the Westman Islands to answer ’em: Questions we covered in the video: 00:00 Introductions 01:55 Do you notice big improvements for physical servers over virtual servers? 05:14 Why aren’t my SQL Servers using all of the…

Store Files in a File System, Not a Relational Database.

Last Updated July 1, 2021

Since the dawn of time, database vendors have called out to developers, “Store everything inside the database. You know you want to. Here, we’ll make it easy for you by adding data types like binary and features like filestream.” Ah, but this siren song leads you to your eventual doom. Users wanna store historical versions…

How to Patch SQL Server

Last Updated June 4, 2021

Production Database Administration

Microsoft releases SQL Server Cumulative Updates about every 60 days. This is a part of your job that you’re going to be doing a lot, so let’s get good at it! Here’s the strategy I like to use. Pick what patch you’re going to apply. Generally speaking, you should be on the most recent Cumulative…

Do You Have to License Your Standby SQL Server?

Last Updated May 27, 2021

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…

Brent Ozar

Free Webcast: Architecture Design for SQL Server High Availability & Disaster Recovery

Last Updated May 26, 2021

You’re building a new SQL Server, and you need to protect it. You want to learn when it’s right to use clustering, AlwaysOn Availability Groups, virtualization, or storage replication. You don’t have an unlimited budget, either, so you need to learn how SQL Server licensing impacts these choices. Or maybe you’re not doing it yet…

Yep, still the same smile.

What Does a Database Administrator Actually Do?

Last Updated December 15, 2021

Production Database Administration

A DBA makes sure the databases are backed up, well-configured, patched, secure, and fast. I explain my job to acquaintances by saying, “You know how some web sites are really slow, and their checkout times out, or it loses your data? It’s my responsibility to make sure those problems don’t happen. I’m not the only…

SQL Server Upgrades and Migrations

Last Updated August 23, 2021

Brent Ozar Unlimited Team

Your Microsoft SQL Server had a good run. But it’s getting creaky and old, and you’ve decided it’s time to make a change. You’re trying to decide which version of SQL Server to use, and which cloud options make the most sense. “Hey, I see the problem already!” I can help. I’ve built and rebuild…

Office Hours

Frequently Asked Questions from Office Hours

Last Updated December 17, 2020

Production Database Administration

In my Twitch & YouTube live streams, some questions seem to come up every week. I’m not expecting this post to stop ’em by any means – most folks on the live stream don’t seem to read the blog regularly – but I thought I’d share ’em here. Q: Why is the same query sometimes…

SQL ConstantCare

What SQL ConstantCare® Has Been Finding In Your Servers Lately

Last Updated July 28, 2020

SQL ConstantCare

SQL ConstantCare® analyzed over 3,000 of your SQL Servers this month. Here are the things we check for and the number of servers where we found this problem this month: Backup Back Up Your TDE Certificate – 137 servers affected Take a Full Backup – 370 servers affected Take a Log Backup – 353 servers affected…

SQL ConstantCare

What SQL ConstantCare® Looks For

Last Updated July 27, 2020

“This server’s plan cache smells terrible.” SQL ConstantCare® analyzes your data looking for health and performance issues that cause user pain. Here are the things we check for and the number of servers where we found this problem this month: Backup Back Up Your TDE Certificate – 137 servers affected CRITICAL: Take a Full Backup…

Can I Offload DBCC CHECKDB To Another Server?

Last Updated May 13, 2020

CHECKDB and Corruption

You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m not talking about doing corruption checking on both the primary and other servers – that’s wonderful, and if you’re doing that, you should hug yourself. You’re doing…

DBA Training Plan 21: Building a New SQL Server

Last Updated September 18, 2019

DBA Training Plan, High Availability

I have a secret setup checklist. Oh sure, our free First Responder Kit has a SQL Server setup checklist that walks you through a few things you need to do before you install, plus a few things to do immediately afterwards. That’s good. It’s actually pretty darned good. But it’s not the secret checklist. Gather round and cover your…

My new hardware

DBA Training Plan 20: Planning Your Next Server

Last Updated September 9, 2019

Architecture, DBA Training Plan

When the business decides it’s time to give up fixing the old server because it’s not fast enough or reliable enough, stop. The worst thing you can do is jump directly to the hardware vendor’s site, check a few boxes, and order a new shiny server that ends up with exactly the same problems as…

I would like to scale out my Porsche collection.

DBA Training Plan 16: Is It Time to Scale Out?

Last Updated August 27, 2019

Architecture, DBA Training Plan

In our last episode, we found out what your server was waiting on. In the closing remarks, I mentioned that you should find out which queries are causing the problem, and focus your mitigation efforts there. You might have circled back to the episode where we covered sp_BlitzCache, used a @SortOrder parameter that lines up…