Posts by Brent Ozar

While in historic and beautiful Camden to hang out with friends, I went to Megunticook Falls and answered your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:05 Mike: Hi Brent. You’ve mentioned there are two types of DBAs: Production DBAs and Development DBAs. Are recruiters and hiring managers familiar with the term…

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…

The first day back after a long vacation is always rough, and today’s no exception. I took your questions from https://pollgab.com/room/brento in an effort to turn things around and get back in the groove:   Here’s what we covered: 00:00 Start 01:12 NotCloseEnoughToRetirementToStopLearning: If you got a new job production DBA where you had to…

Why yes, I’m wearing the same shirt as the video from “yesterday”. Why do you ask? Stop paying attention to that, and check out the top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:12 DBABA (database administrator by accident): I have a complex, nested view. everytime after a dacpac deployment this view runs…

I visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is a great place to visit around Halloween! There were tours, characters in costume, witch gear shops, and all kinds of spooky-themed happenings. I sat down outside of the Charter Street Cemetery to take your top-voted questions from…

After a long trip through Scandinavia, I’m back in the desert. You posted questions at https://pollgab.com/room/brento and I took the hot seat:   Here’s what we covered today: 00:00 Start 03:15 Marek: Hi Brent, what is the best solution to continuously synchronize Logins between two stand alone SQL Server instances or two Azure managed instances?…

I have a special guest star on today’s episode: Pinal Dave dropped by the house! We went through a few of the top-voted questions from https://pollgab.com/room/brento. 00:00 Start 00:15 What happened to you? Did you spend too much time in the sun? 00:48 AccidentalDBA: How do I explain to the 3rd party IT group that…

Despite its location, Hammerfest, Norway attracts countless tourists eager to see the festival celebrating one of the world’s favorite rappers. Did I get that right? I’m not sure I got that right. There’s also fierce competition for the title of northernmost town: nearby Honningsvåg Norway also wants that claim, but with a population of only…

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…

Come join me in my cabin aboard the Hurtigruten Nordlys, sailing up the coast of Norway, and we’ll cover your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered today: 00:00 Start 00:57 Accidental DBA: What are the best options you have seen for database deployment rollbacks with releases (if issues were encountered)? My understanding is…