Search Results for “log shipping”

Back Up Transaction Logs Every Minute. Yes, Really.

Last Updated February 9, 2017

Right now, your transaction log backups are set up to run every 15 minutes, every hour, or maybe every few hours. It’s time for a reality check. Figure out what internal customer owns the data inside the database, and walk into their office. Ask them how much data they’re comfortable losing. You’re probably going to…

PASS Summit 2011 Day 2 Keynote Liveblog #sqlpass

Last Updated February 12, 2017

Brent Ozar

#SQLPass

Time for another keynote liveblog. Let’s get started. It’s #SQLKilt day! Bill Griaziano is kicking things off in a kilt: Bill Graziano Supporting #SQLKilt Day 8:19am – Bill introducing Tim Radney and Jack Corbett as outstanding volunteers. 8:22 – Lori Edwards is the 2011 PASSion award for her outstanding work making this such a great…

[Video] Office Hours at Jökulsárlón Glacial Lagoon

Last Updated September 4, 2023

Brent Ozar

Videos

Post your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. In this episode, I’m at Jökulsárlón Glacial Lagoon, a wonder of nature, watching the icebergs pile up, stuck in the lagoon due to the incoming high tides. Here’s what we covered: 00:00 Start 01:15…

[Video] Office Hours: All About Miles Edition

Last Updated August 10, 2023

Brent Ozar

Videos

Today’s webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:03 Miles: Hi Brent, I am aware of “sp_statement” completed and sp_batch_completed events in trace and extended events. But, what is the use of rpc_completed event? How this event will be helpful…

[Video] Office Hours While the Pool Refills

Last Updated August 3, 2023

Brent Ozar

Videos

I step away from the backyard long enough to take y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 02:23 Stockburn: Hi Brent, we are using distributed always on AGs, with a node in AWS for DR. We are thinking of using this to quickly migrate the work load to the…

The SQL Server Advice You Don’t Wanna Hear

Last Updated May 25, 2023

Brent Ozar

SQL ConstantCare

One of the big principles of our SQL ConstantCare® monitoring product – which happens to be free this month – is that we only wanna tell you things you’re actually gonna take action on. Anytime we email you advice, there a few “Mute” links that you can click on to never hear this advice. You…

Happy 21st Anniversary, BrentOzar.com. What’s Coming Next?

Last Updated June 1, 2023

Brent Ozar

Company News

It’s pretty cool to look at a blog post and see, “Last updated: 21 years ago.” It’s pretty fun to see old pictures of me in the media library, too. When I first started blogging over two decades ago, it wasn’t a business. I just did it because I enjoyed writing, sharing, and being part…

How to Go Live on SQL Server 2022

Last Updated April 25, 2023

Brent Ozar

SQL Server 2022

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…

[Video] Office Hours Speed Round: 21 Answers in 15 Minutes

Last Updated April 18, 2023

Brent Ozar

Videos

HONK HONK! It’s time for a fast round of answers to concise questions y’all posted and upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:19 TheyBlameMe: Hi Brent. What is your view on using Dacpac diffs vs “old style” manual update scripts for deploying DB schema changes in dev-test-prod? 00:52 Alex: Hi boss, I…

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

Last Updated January 14, 2023

Brent Ozar

Videos

Y’all just never run out of interesting questions at https://pollgab.com/room/brento! I’m impressed, got another great round today. Here’s what we covered: 00:00 Start 00:25 Chrisbell: Recently we’ve been facing thread starvation issues. How can we troubleshoot it when even sp_whoisactive ( even with DAC ) is unresponsive and takes forever to return a result set…

The SQL Server Posts You Read the Most in 2022

Last Updated December 26, 2022

Brent Ozar

Company News

Here’s what I wrote in 2022 that gathered the most views: #10: Who’s Hiring in the Database Community? February 2022 Edition – I saw the success of Hacker News’ “Who’s Hiring” monthly posts, and I blatantly stole the idea for the Microsoft data platform community. It works out well, very popular, very popular. #9: PSPO:…

[Video] Office Hours: Black Friday Edition

Last Updated November 25, 2022

Brent Ozar

Videos

My Black Friday sale is in its last days, so most of my time at the moment is spent keeping an eye on the site and answering customer questions. I’m happy to say it’s our best year so far, too! Y’all really like the new access-for-life options. I took a break from the online frenzy to…

[Video] Office Hours: Nine Minutes of Answers

Last Updated October 22, 2022

Brent Ozar

Videos

Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss during my live streams. This week, I took a break from working on my PASS Summit sessions in order to chat: Here’s what we covered: 00:00 Start 00:32 Jeremy: We have an older web app we’re going to be rewriting…

[Video] Office Hours Live: Ask Me Anything

Last Updated October 3, 2022

Brent Ozar

Videos

Got a question for me? Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. Before heading to NYC for vacation, I recorded a live Office Hours on my Twitch channel. Here’s what we covered: 00:00 Start 04:40 neil: are there any ‘band aids’ a DBA can apply for a…

Office Hours, Short Text Answers Edition

Last Updated September 5, 2022

Brent Ozar

Production Database Administration

Not all of the questions y’all post at https://pollgab.com/room/brento require long, thought-out answers. Some are just one-line specials, like these: F’legend: Hi Brent, in reply to a question talking about database restores for 1TB+ you also touched on scrubbing or synthetic data as a way to populate dev environments. Are there any resources/tools you would…

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

Last Updated August 12, 2022

Brent Ozar

Videos

Post your Microsoft data platform questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me answer. I sat down by the pool in Cabo with a cup of coffee to go through ’em: Here’s what we covered in this episode: 00:00 Introductions 00:43 MergeItLikeItsHot: Hi Brent, do you have any good resources to…

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

Last Updated July 9, 2022

Brent Ozar

Videos

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 ,…

Office Hours Speed Round: Text Edition

Last Updated July 13, 2022

Brent Ozar

Production Database Administration

Not all of the questions you post at https://pollgab.com/room/brento are hard. Some of ’em can be answered in one line: Q: accidentalDBA: Hi Brent, My friend is moving from two physical servers (production + failover) to VMs on the same host and SAN. His manager wants to keep log shipping as a DR solution. I…

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

Last Updated June 21, 2022

Brent Ozar

Videos

You posted questions at https://pollgab.com/room/brento, upvoted the ones you’d like to see me cover, and I did the needful: Here’s what we covered: 00:00 Introductions 01:19 chandwich: Hi Brent. I’ve been unsuccessful in my attempt to convince my employer I need formal SQL training. I help manage hundreds of customers’ SQL Servers and Applications, but…

[Video] Office Hours: Vail Fireside Chat

Last Updated June 9, 2022

Brent Ozar

Videos

You posted and upvoted questions at https://pollgab.com/room/brento, and I sat down by the fire on a chilly evening in Vail, Colorado to answer ’em. I was driving cross-country, heading back from a road trip to see my mom. Here’s what we covered: 00:00 Introductions 00:46 Ms. Cosmos: What are the top traits for the perfect…

Search Results for “log shipping”

Back Up Transaction Logs Every Minute. Yes, Really.

PASS Summit 2011 Day 2 Keynote Liveblog #sqlpass

[Video] Office Hours at Jökulsárlón Glacial Lagoon

[Video] Office Hours: All About Miles Edition

[Video] Office Hours While the Pool Refills

The SQL Server Advice You Don’t Wanna Hear

Happy 21st Anniversary, BrentOzar.com. What’s Coming Next?

How to Go Live on SQL Server 2022

[Video] Office Hours Speed Round: 21 Answers in 15 Minutes

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

The SQL Server Posts You Read the Most in 2022

[Video] Office Hours: Black Friday Edition

[Video] Office Hours: Nine Minutes of Answers

[Video] Office Hours Live: Ask Me Anything

Office Hours, Short Text Answers Edition

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

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

Office Hours Speed Round: Text Edition

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

[Video] Office Hours: Vail Fireside Chat

Hi! I’m Brent Ozar.

Save your cart?