[Video] Office Hours: Hong Kong HarborI recently went to Shanghai & Hong Kong, and stopped to take your questions from https://pollgab.com/room/brento while sitting […] 18 avril 2024 dans Sites anglophones étiqueté Videos par brentozar.com
How to Have a Conversation About Software LicensingAs a consultant, I sometimes see SQL Servers with high CPU core counts relative to their workload. For […] 17 avril 2024 dans Sites anglophones étiqueté Licensing par brentozar.com
Announcing Offline Access to Your BrentOzar.com CoursesSo you’ve got an iPhone or iPad or Vision Pro, and you bought one of my training classes […] 16 avril 2024 dans Sites anglophones étiqueté Company News par brentozar.com
[Video] Office Hours: Career & Data Q&AA few career and security questions found their way into the queue at https://pollgab.com/room/brento for this episode: Here’s […] 11 avril 2024 dans Sites anglophones étiqueté Videos par 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. […] 10 avril 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
Using ChatGPT for T-SQL Code ReviewsFor this month’s T-SQL Tuesday, Pinal Dave asked us if AI has helped us with our SQL Server […] 9 avril 2024 dans Sites anglophones étiqueté t-sql par brentozar.com
[Video] Office Hours: Just Three QuestionsSometimes y’all post questions at https://pollgab.com/room/brento that require extended answers. Today, I’m hitting just 3 questions: Here’s what […] 4 avril 2024 dans Sites anglophones étiqueté Videos par brentozar.com
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 […] 3 avril 2024 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
Announcing Fundamentals Week, May 6-10You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […] 2 avril 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
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 – […] 1 avril 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
[Video] Office Hours: 25 Answers in 10 MinutesIt’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 […] 28 mars 2024 dans Sites anglophones étiqueté Videos par brentozar.com
[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