[Video] Office Hours: The Long OneYou posted a lot of great questions at https://pollgab.com/room/brento and I spent almost an hour covering these: Here’s […] 27 mars 2024 dans Sites anglophones étiqueté Videos par brentozar.com
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 […] 26 mars 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
[Video] Office Hours in Snowy Telluride, ColoradoOn a beautiful sunny afternoon in the mountains, I went through your top-voted questions from https://pollgab.com/room/brento. Audio is […] 21 mars 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Does Your GROUP BY Order Matter?Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT […] 20 mars 2024 dans Sites anglophones étiqueté Execution plans par brentozar.com
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 […] 19 mars 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
[Video] Office Hours: Speed RoundNot all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 […] 14 mars 2024 dans Sites anglophones étiqueté Videos par brentozar.com
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 […] 12 mars 2024 dans Sites anglophones étiqueté t-sql par brentozar.com
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 […] 7 mars 2024 dans Sites anglophones étiqueté Execution plans par brentozar.com
Finding Sister Locations to Help Each Other: Answers & DiscussionThis week’s query exercise asked you to find two kinds of locations in the Stack Overflow database: Locations […] 6 mars 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
[Video] Office Hours From the FutureTo answer today’s questions from https://pollgab.com/room/brento, I strapped on my Apple Vision Pro and recorded my persona as […] 5 mars 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Read This Before Your Users Install SSMS 20SQL Server Management Studio 20 Preview 1 is out, and the new connection dialog has a big change: […] 4 mars 2024 dans Sites anglophones étiqueté Production Database Administration par brentozar.com
Updated First Responder Kit and Consultant Toolkit for February 2024New this month: better sp_BlitzIndex performance on databases with tens of thousands of objects, sp_DatabaseRestore can run test […] 1 mars 2024 dans Sites anglophones étiqueté First Responder Kit Updates par brentozar.com
Query Exercise: Finding Sister Locations to Help Each OtherFor this week’s query exercise, let’s start with a brief query to get a quick preview of what […] 29 février 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Find Recent Superstars: Answers & DiscussionYour query exercise for this week was to write a query to find users created in the last […] 28 février 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Join Me in Orange County for Tuning Databases in One ...You’ve got production databases in SQL Server or Azure SQL DB, and you want to make ’em faster. […] 27 février 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
Sessions You Should Attend at SQLBits Online 2024SQLBits 2024 is next month, and the session agenda is out, including the Microsoft-led sessions. If you’re going […] 26 février 2024 dans Sites anglophones étiqueté SQLBits par brentozar.com
[Video] Office Hours: Hot Tub EditionToday’s Office Hours comes from a very different office! I climbed into the hot tub to review your […] 23 février 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Query Exercise: Find Recent SuperstarsFor this week’s Query Exercise, we’re working with the Stack Overflow database, and our business users have asked […] 22 février 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Finding Long Values Faster: Answers & DiscussionIn last week’s Query Exercise, our developers had a query that wasn’t going as fast as they’d like: […] 21 février 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
#TSQL2sday Roundup: The Most Recent Issues You Closed.For this month’s TSQLTuesday, I asked y’all to describe the most recent issues you closed. If you ask […] 20 février 2024 dans Sites anglophones étiqueté development par brentozar.com
[Video] Office Hours: Ask Me Anything About Microsoft DatabasesPost your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the […] 16 février 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Query Exercise: Finding Long Values FasterOur developers have come to us with a problem query that isn’t as fast as they’d like. Using […] 15 février 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Improving Cardinality Estimation: Answers & DiscussionYour challenge for last week was to take this Stack Overflow database query to show the top-ranking users […] 14 février 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
The Last Ticket/Issue I Closed #TSQL2sdayFor this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that […] 13 février 2024 dans Sites anglophones étiqueté t-sql par brentozar.com
SQL ConstantCare® Population Report: Winter 2023The short story: SQL Server 2019 continues its utter domination of the Microsoft data platform landscape this quarter. […] 12 février 2024 dans Sites anglophones étiqueté SQL Server par brentozar.com
[Video] Office Hours: Lumberjack EditionOn a chilly January day, I went through your top-voted questions from https://pollgab.com/room/brento. Yes, it actually gets cold […] 9 février 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Query Exercise: Improving Cardinality EstimationYour challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows […] 8 février 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Database Changes to Find Tagged Questions Faster: Answers and DiscussionIn the last Query Exercise discussion, we hit a performance wall when we were trying to quickly find […] 7 février 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
#TSQL2sday Invitation: Describe the Most Recent Issue You Closed.T-SQL Tuesday is a monthly blogothon where we get together and write about a different topic. I’m hosting […] 6 février 2024 dans Sites anglophones étiqueté Professional Development par brentozar.com
Office Hours: PowerBI & Fabric Q&A with Eugene MeidingerToday’s Office Hours has a different topic. Eugene Meidinger dropped by to answer your business intelligence questions. Follow […] 1 février 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Who’s Hiring in the Microsoft Data Platform Community? February 2024 ...Is your company hiring for a database position as of February 2024? Do you wanna work with the […] 1 février 2024 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
Finding Tagged Questions Faster: Answers & DiscussionYour query exercise was to take this Stack Overflow query to find the top-voted questions for any given […] 31 janvier 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Free Video Training: Estimation and Statistics by Dave BallantyneIt’s hard to find good 400-500 level SQL Server training at any price, let alone free. Dave Ballantyne’s […] 30 janvier 2024 dans Sites anglophones étiqueté statistics / Videos par brentozar.com
What PowerBI Questions Do You Have for Eugene Meidinger?Eugene Meidinger, aka SQLGene.com, makes Power BI concepts easy and accessible. He’s got a free introduction to Power […] 26 janvier 2024 dans Sites anglophones étiqueté Data Science par brentozar.com
Query Exercise: Find Tagged Questions Faster.For this week’s Query Exercise, we’re going to start with an existing query that has performance problems from […] 25 janvier 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Finding the Best Time for Maintenance: Answers & DiscussionYour Query Exercise was to find the best time to do database maintenance by querying the Users table, […] 24 janvier 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Save 5% on SQLBits Registration with BRENT5.Going to the SQLBits conference in March? Whether you’re registering in-person or attending virtually, save 5% on your […] 23 janvier 2024 dans Sites anglophones étiqueté SQLBits par brentozar.com
[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