[Video] Office Hours: Career & Data Q&A
A few career and security questions found their way into the queue at https://pollgab.com/room/brento for this episode: Here’s […]
brentozar.com
Your Teammates Need the Fundamentals.
You’ve been reading my site for a while, watching videos, keeping up with the best SQL Server techniques. […]
Using ChatGPT for T-SQL Code Reviews
For this month’s T-SQL Tuesday, Pinal Dave asked us if AI has helped us with our SQL Server […]
[Video] Office Hours: Just Three Questions
Sometimes y’all post questions at https://pollgab.com/room/brento that require extended answers. Today, I’m hitting just 3 questions: Here’s what […]
Who’s Hiring in the Microsoft Data Platform Community? April 2024 ...
Is your company hiring for a database position as of April 2024? Do you wanna work with the […]
Announcing Fundamentals Week, May 6-10
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Tomorrow’s the Big Day: Free Live Webcasts!
No fooling here. Tomorrow, I’m teaching my very favorite class live online, for free, two different ways – […]
[Video] Office Hours: 25 Answers in 10 Minutes
It’s time for a speed round, a rapid-fire tour of your top-voted questions from https://pollgab.com/room/brento: Here’s what we […]
[Video] Office Hours: The Long One
You posted a lot of great questions at https://pollgab.com/room/brento and I spent almost an hour covering these: Here’s […]
Join Me for Free Live SQL Server Training Next Week.
Next week, I’m teaching my very favorite class live online, for free, two different ways – one with […]
[Video] Office Hours in Snowy Telluride, Colorado
On a beautiful sunny afternoon in the mountains, I went through your top-voted questions from https://pollgab.com/room/brento. Audio is […]
Does Your GROUP BY Order Matter?
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT […]
Free Live Webcasts: Slide & Demo Versions of How to ...
You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it […]
[Video] Office Hours: Speed Round
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 […]
Option Recompile is a Magic Turbo Button That Actually Works.
I didn’t say that – Guy Glantser did. Guy Glantser is an Israeli SQL Server guru with a […]
What Happens When Multiple Queries Compile at Once?
An interesting question came in on PollGab. DBAmusing asked: If a query takes 5-7s to calculate the execution […]
Finding Sister Locations to Help Each Other: Answers & Discussion
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database: Locations […]
[Video] Office Hours From the Future
To answer today’s questions from https://pollgab.com/room/brento, I strapped on my Apple Vision Pro and recorded my persona as […]
Read This Before Your Users Install SSMS 20
SQL Server Management Studio 20 Preview 1 is out, and the new connection dialog has a big change: […]
Updated First Responder Kit and Consultant Toolkit for February 2024
New this month: better sp_BlitzIndex performance on databases with tens of thousands of objects, sp_DatabaseRestore can run test […]
Query Exercise: Finding Sister Locations to Help Each Other
For this week’s query exercise, let’s start with a brief query to get a quick preview of what […]
Find Recent Superstars: Answers & Discussion
Your query exercise for this week was to write a query to find users created in the last […]