Thoughts About Stack Overflow’s Annual Developer SurveyEvery year, Stack Overflow runs a developer survey about technology, work, community, and more. This year’s results include […] 26 juillet 2024 dans Sites anglophones étiqueté SQL Server par brentozar.com
[Video] Office Hours in a Mexican Hot TubWhile taking a dip in Cabo, I went through your top-voted questions from https://pollgab.com/room/brento. https://www.youtube.com/watch?v=OaHImrIMM6YVideo can’t be loaded […] 25 juillet 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Query Exercise Answer: Fixing a Slow Computed ColumnIn last week’s Query Exercise, we added a user-defined function to the Users table to check whether their […] 24 juillet 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Announcing New Membership Tiers: Free & MentoringI give away a lot of stuff in various places on the internet: videos, scripts, the new free tier […] 23 juillet 2024 dans Sites anglophones étiqueté Company News par brentozar.com
Today’s a Good Day to Talk to Your Manager About ...Last night, two major IT disasters struck: Microsoft Azure’s Central region went down for about 4 hours. The […] 19 juillet 2024 dans Sites anglophones étiqueté Backup and Recovery / Cloud Computing par brentozar.com
[Video] Office Hours in My BackyardOn a pleasantly mild morning, I sat down on the patio and took your top-voted questions from https://pollgab.com/room/brento. […] 18 juillet 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Query Exercise: Fix This Computed Column.Take any size of the Stack Overflow database and check out the WebsiteUrl column of the Users table: […] 17 juillet 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Updated, Larger Stack Overflow Demo DatabaseStack Overflow publishes a data dump with all user-contributed content, and it’s a fun set of data to […] 16 juillet 2024 dans Sites anglophones étiqueté stack overflow par brentozar.com
[Video] Office Hours in BulgariaI went through your top-voted questions from https://pollgab.com/room/brento while in front of the National Gallery for Foreign Art […] 11 juillet 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Announcing Free SQL Server Monitoring.You already use sp_Blitz and the rest of the free, open source First Responder Kit to give your […] 10 juillet 2024 dans Sites anglophones étiqueté SQL ConstantCare par brentozar.com
Use “We” Not “You”. #tsql2sdayFor T-SQL Tuesday this month, Louis Davidson suggested we give our past self some advice. I’d tell myself, […] 9 juillet 2024 dans Sites anglophones étiqueté Consulting Lines par brentozar.com
[Video] Office Hours in Sofia, BulgariaI was honored to speak at the Present to Succeed conference in Sofia, Bulgaria, run by a former […] 4 juillet 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Save $350 on the PASS Summit if You Register Now.Next Tuesday, pricing on the 3-day tickets for the PASS Data Community Summit goes up to $2,095. But […] 3 juillet 2024 dans Sites anglophones étiqueté #SQLPass par brentozar.com
Does Bit Column Order Matter in Tables?At the PGConf.dev, where Postgres developers get together and strategize the work they wanna do for the next […] 2 juillet 2024 dans Sites anglophones étiqueté development par brentozar.com
Updated First Responder Kit and Consultant Toolkit for July 2024The next release would normally be August, but I’m doing a release a little early in order to […] 1 juillet 2024 dans Sites anglophones étiqueté First Responder Kit Updates par brentozar.com
[Video] Office Hours: I Don’t Have All the AnswersWhen I went through the top-voted questions at https://pollgab.com/room/brento, I didn’t have all the answers today: Here’s what […] 27 juin 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Join Me in Seattle for Watch Brent Tune a Query ...The PASS Data Community Summit session lineup for Nov 4-8 in Seattle was just announced, and I’ve been […] 26 juin 2024 dans Sites anglophones étiqueté #SQLPass par brentozar.com
The SQL Language is Just a Hurdle You Gotta Overcome.I’m not talking just about Microsoft SQL Server specifically here, nor T-SQL. Let’s zoom out a little and […] 25 juin 2024 dans Sites anglophones étiqueté t-sql par brentozar.com
[Video] Office Hours: Database Answers from a Hotel RoomI went through your top-voted questions from https://pollgab.com/room/brento before heading out to PGConf.dev in Vancouver. Here’s what we […] 20 juin 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Query Exercise Answer: Beating ChatGPT at Finding Good Question TimesFor this week’s Query Exercise, I asked you to write a better query than ChatGPT wrote. Your goal […] 19 juin 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Join Me in San Diego for SQL Saturday!I’m coming to San Diego on Sept 13-14 for SQL Saturday San Diego! I’m teaching a one-day pre-conference […] 18 juin 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
[Video] Creepy Office Hours in VancouverWhile in a hotel room in Vancouver for PGconf.dev, I strapped on my Apple Vision Pro headset to […] 13 juin 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Query Exercise: Beat ChatGPT at Finding Good Question TimesWhat are the best days of the week and times of the day to post a question at […] 12 juin 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
There’s a 6-Month Statute of Limitations on “The Last Person.”“The last person must have set it up that way.” “The last person wrote that code.” “The last […] 11 juin 2024 dans Sites anglophones étiqueté Processes and Practices par brentozar.com
[Video] Office Hours in a Hotel RoomWhile in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we […] 6 juin 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Two Tweaks for Faster Backups with Ola Hallengren’s ScriptsOla Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a […] 5 juin 2024 dans Sites anglophones étiqueté Backup and Recovery par brentozar.com
Who’s Hiring in the Microsoft Data Platform Community? June 2024 ...Is your company hiring for a database position as of June 2024? Do you wanna work with the […] 4 juin 2024 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
[Video] Office Hours: 16 QuestionsLike Sixteen Candles, but different: I go through your top-voted questions from https://pollgab.com/room/brento. Strangely, my video and audio […] 31 mai 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Coming in Entity Framework 9: Better Query ParameterizationHallelujah. With current versions of Entity Framework, when developers add a mix of parameters and specific values to […] 30 mai 2024 dans Sites anglophones étiqueté development par brentozar.com
This Is It! The Last 3 Days of My Anniversary ...Every year in May, I look back at when I first registered BrentOzar.com way back in May 2001. […] 29 mai 2024 dans Sites anglophones étiqueté Company News par brentozar.com
Updated First Responder Kit and Consultant Toolkit for May 2024If you’ve hard-coded installer file names, there’s a big change in this release. There are now just 2 […] 28 mai 2024 dans Sites anglophones étiqueté First Responder Kit Updates par brentozar.com
Okay, About That SmartPostgres.com Thing.In some of the Query Exercises posts here, you might have noticed links over to similar query exercises […] 23 mai 2024 dans Sites anglophones étiqueté Professional Development par brentozar.com
[Video] Office Hours: I Feel Like an Amateur EditionI started with audio problems, then had video problems halfway in. It’s amusing because we also discuss feeling […] 22 mai 2024 dans Sites anglophones étiqueté Videos par brentozar.com
The Future of DBAs: History RhymesEitan Blumin recently wrote a post about the future of the DBA career in which he talked about […] 21 mai 2024 dans Sites anglophones étiqueté Professional Development par brentozar.com
[Video] Office Hours: Answers for Your Database QuestionsY’all post questions and upvote the best ones at https://pollgab.com/room/brento, and I discuss ’em in my home office […] 16 mai 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Getting Data Out of an Audit Table: Answers & DiscussionIn last week’s post, I gave you a trigger that populated a history table with all changes to […] 15 mai 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Why Generative AI Scares the Hell Out of DBAsI was chatting with a client’s DBA about this thought-provoking blog post about data governance in the age […] 14 mai 2024 dans Sites anglophones étiqueté Production Database Administration par brentozar.com
I’m Getting Antsy for SQL Server vNext.Historically, Microsoft publicly announces the next version of SQL Server about a year before it ships. For example: […] 9 mai 2024 dans Sites anglophones étiqueté SQL Server 2025 par brentozar.com
Who’s Changing the Table? Answers and DiscussionYour challenge for this week was to find out who keeps mangling the contents of the AboutMe column […] 8 mai 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
SQL ConstantCare® Population Report: Spring 2024The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha. The long […] 7 mai 2024 dans Sites anglophones étiqueté SQL Server Population Report par brentozar.com
[Video] Office Hours: Ask Me Anything About Azure and Microsoft ...Back at home in the office, time to settle in with a nice caffeine-free Diet Coke and go […] 6 mai 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Who’s Hiring in the Microsoft Data Platform Community? May 2024 ...Is your company hiring for a database position as of May 2024? Do you wanna work with the […] 3 mai 2024 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
Query Exercise: Who’s Changing the Table?For this week’s Query Exercise, your challenge is to find out who keeps messing up the rows in […] 2 mai 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
It’s Time For Our Annual Anniversary Sale!I first registered BrentOzar.com way back in May 2001. Over the years, some things in databases have changed […] 1 mai 2024 dans Sites anglophones étiqueté Company News par brentozar.com
Join Me at the PASS Data Community Summit in November!On November 4 in Seattle, I’m presenting a new pre-conference workshop! Tuning T-SQL for SQL Server 2019 and […] 30 avril 2024 dans Sites anglophones étiqueté #SQLPass par brentozar.com
[Video] Database Answers in Hong KongAs my time in Hong Kong came to an end, I sat inside on a foggy morning and […] 25 avril 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Troubleshooting Mysterious Blocking Caused By sp_getapplockI’m kinda weird. I get excited when I’m troubleshooting a SQL Server problem, and I keep hitting walls. […] 24 avril 2024 dans Sites anglophones étiqueté Locking, Blocking, and Isolation Levels par brentozar.com
It’s almost time for Fundamentals Week! Have you signed up ...The Monday after next, I’ll be getting together with dozens of smart people who are a lot like […] 23 avril 2024 dans Sites anglophones étiqueté Conferences and Classes par brentozar.com
[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