[Video] Office Hours: The Question is Not the Problem EditionI answer your top-voted Azure SQL DB and SQL Server questions from https://pollgab.com/room/brento and lose my temper about […] 19 janvier 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Query Exercise: Find the Best Time for MaintenanceIf we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own […] 18 janvier 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Find Posts with the Wrong CommentCount: Answers & DiscussionYour Query Exercise was to find denormalization accuracy problems: checking the accuracy of a reporting column, Posts.CommentCount. There […] 17 janvier 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
We’re Starting to Automate Testing for the First Responder Kit.Brent says: It’s really funny how the world works. I wrote what you see below in December 2023 […] 16 janvier 2024 dans Sites anglophones étiqueté First Responder Kit par brentozar.com
[Video] Office Hours: Ask Me Anything About the Microsoft Data ...Forgive the hoarse voice – I’m recovering from something COVID-ish. I went through your top-voted questions from https://pollgab.com/room/brento […] 12 janvier 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Query Exercise: Find Posts with the Wrong CommentCountFor 2024, I’m trying something new: weekly homework challenges! For this week’s query challenge, we’re going to do […] 11 janvier 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Find Foreign Key Problems: Answers & DiscussionYour Query Exercise was to find foreign key problems: data that might stop us from successfully implementing foreign […] 10 janvier 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Announcing the 2024 Data Professional Salary Survey Results.This is the 8th year now that we’ve been running our annual Data Professional Salary Survey, and I […] 9 janvier 2024 dans Sites anglophones étiqueté Salary par brentozar.com
Query Exercise: Find Foreign Key ProblemsFor 2024, I’m trying something new: weekly homework challenges! For this week, let’s say we’ve decided to implement […] 4 janvier 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
[Video] Office Hours: Oddball Questions EditionThe last Office Hours of 2023 featured some oddball questions from https://pollgab.com/room/brento. Not bad, just … odd. Here’s […] 3 janvier 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Who’s Hiring in the Microsoft Data Platform Community? January 2024 ...Is your company hiring for a database position as of January 2024? Do you wanna work with the […] 2 janvier 2024 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
[Video] Office Hours: Holiday Speed Round EditionMost of the https://pollgab.com/room/brento questions from this episode had really short and sweet answers. Let’s take a break […] 29 décembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Updated First Responder Kit and Consultant Toolkit for December 2023New this month: more work on letting sp_Blitz run with limited permissions, nicer Markdown output, sp_BlitzLock compatibility with […] 28 décembre 2023 dans Sites anglophones étiqueté First Responder Kit Updates par brentozar.com
[Video] Working on First Responder Kit Pull RequestsFor this month’s First Responder Kit releases, I worked through most of the pull requests live on my […] 27 décembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
The Annual Data Professional Salary Survey Closes This Week!Take the Data Professional Salary Survey now. The 2020s have been tough: a pandemic, a recession, layoffs, and […] 26 décembre 2023 dans Sites anglophones étiqueté Salary par brentozar.com
[Video] Office Hours: 21 Good QuestionsThis one is a 3-part episode: I take 21 questions from https://pollgab.com/room/brento and then later, work on First […] 21 décembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
[Video] Office Hours: Wrong Side of the Bed EditionI woke up on the wrong side of the bed after a nap. How does that even happen?!? […] 20 décembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts“Documentation! Hey, look at that.” Lemme start this off by saying this is probably irrelevant to you. (It’s […] 19 décembre 2023 dans Sites anglophones étiqueté Amazon Web Services (AWS) par brentozar.com
[Video] Office Hours: Sunshine EditionYou know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what […] 14 décembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
[Video] Office Hours: Really Good Questions EditionY’all were on fire in this one! You posted great questions at https://pollgab.com/room/brento and I worked through ’em: […] 13 décembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
What Would You Ask Your Predecessor? Get Answers with ChatGPT.So many times in my career, I’ve come across a questionable query, table design, or server configuration decision, […] 12 décembre 2023 dans Sites anglophones étiqueté Humor par brentozar.com
How Has Inflation Affected Your Salary? Let’s Find Out Together.The 2020s have been tough: a pandemic, a recession, layoffs, and inflation. Inflation makes things particularly tricky because […] 6 décembre 2023 dans Sites anglophones étiqueté Salary par brentozar.com
Who’s Hiring in the Microsoft Data Platform Community? December 2023 ...Is your company hiring for a database position as of December 2023? Do you wanna work with the […] 5 décembre 2023 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
ChatDBA: ChatGPT 4 Answers 5 Office Hours QuestionsEvery now and then, someone asks a question on PollGab about why I don’t use ChatGPT to answer […] 1 décembre 2023 dans Sites anglophones étiqueté Production Database Administration par brentozar.com
[Video] Office Hours: Live on Black Friday EditionOn Black Friday, I took a break from answering support emails to hit your top-voted questions from https://pollgab.com/room/brento. […] 29 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
[Video] Office Hours: Black Friday Promo EditionIn this episode, a lot of the questions triggered mentions of our Black Friday Sale, on now! Here’s […] 28 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
BrentOzar.com Cyber Monday Week SaleEvery November, we run a huge sale here on my training courses, apps, and online services. Now’s your […] 27 novembre 2023 dans Sites anglophones étiqueté Company News par brentozar.com
It’s Black Friday! Time to save big on SQL Server ...My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […] 24 novembre 2023 dans Sites anglophones étiqueté Company News par brentozar.com
[Video] Office Hours: Brent’s Cursed Technology EditionI first answered these while standing at a harbor in Maine, but upon arriving home, I realized my […] 23 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
[Video] Office Hours in Camden HarborOn an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions […] 22 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Why Haven’t You Disabled SA? Wrong Answers Only.On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong […] 21 novembre 2023 dans Sites anglophones étiqueté Humor par brentozar.com
[Video] Office Hours at Megunticook Falls in Camden, MaineWhile in historic and beautiful Camden to hang out with friends, I went to Megunticook Falls and answered […] 16 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Office Hours, Silent Film EditionHey, remember in yesterday’s video how I said I was having a really bad day? Well, here’s how […] 15 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
The Black Friday Sale is Here: Save Big on Training ...My Annual Black Friday Sale is On! I’m running a giant Black Friday sale on my training courses! […] 14 novembre 2023 dans Sites anglophones étiqueté Company News par brentozar.com
The Real Problem with SQL Server’s Licensing CostsAt least once a month, a client has The Postgres Conversation™ with me. It happens at the end […] 13 novembre 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com
Office Hours: “Read This” EditionSometimes when people post questions at https://pollgab.com/room/brento, the answer is just a link, nothing more, nothing less. It […] 10 novembre 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com
[Video] Office Hours: Having a Bad Day EditionThe first day back after a long vacation is always rough, and today’s no exception. I took your […] 9 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
[Video] Office Hours: Yes, I’m In the Same ShirtWhy yes, I’m wearing the same shirt as the video from “yesterday”. Why do you ask? Stop paying […] 8 novembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Free Webcast: How to Think Like the Engine, LiveYou’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it […] 7 novembre 2023 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
Who’s Hiring in the Microsoft Data Platform Community? November 2023 ...Is your company hiring for a database position as of November 2023? Do you wanna work with the […] 6 novembre 2023 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
The Black Friday Sale is Live!You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the […] 1 novembre 2023 dans Sites anglophones étiqueté Company News par brentozar.com
[Video] Halloween Office Hours in Salem, MAI visited friends in Salem, Massachusetts, home of the 1692 witch trials, and it turns out Salem is […] 30 octobre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Announcing Buy-Now-Pay-Later, Just in Time for the Black Friday Sale!It’s almost time for my annual Black Friday sale, and some of you are staring longingly at the […] 26 octobre 2023 dans Sites anglophones étiqueté Company News par brentozar.com
Announcing My 2023 Black Friday Sale!You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the […] 25 octobre 2023 dans Sites anglophones étiqueté Company News par brentozar.com
Announcing Live Online Mastering Classes!In the last 2 years since I last taught my Mastering classes, the SQL Server performance tuning game […] 24 octobre 2023 dans Sites anglophones étiqueté Company News par brentozar.com
Updated First Responder Kit and Consultant Toolkit for October 2023The last couple of releases have focused on running sp_Blitz with limited permissions, like not being able to […] 20 octobre 2023 dans Sites anglophones étiqueté First Responder Kit Updates par brentozar.com
[Video] Office Hours: Back in the Vegas Home StudioAfter a long trip through Scandinavia, I’m back in the desert. You posted questions at https://pollgab.com/room/brento and I […] 19 octobre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
SQL ConstantCare® Population Report: Fall 2023The short story for this quarter: SQL Server 2019 is on fire, dominating the market. For the long […] 18 octobre 2023 dans Sites anglophones étiqueté SQL Server Population Report par brentozar.com
Who’s Hiring in the Microsoft Data Platform Community? October 2023 ...Is your company hiring for a database position as of October 2023? Do you wanna work with the […] 17 octobre 2023 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
Fundamentals Week is Coming. Every Day, the Price Goes Up.You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […] 16 octobre 2023 dans Sites anglophones étiqueté Company News / Conferences and Classes par brentozar.com