[Video] Office Hours: Github Copilot in Azure Data Studio
I start today's Office Hours by playing with the very underwhelming Github Copilot in ADS, then take your questions from https://pollgab.com/room/brento.
https://youtu.be/vOkE8bfdOMU
Indexing and Statistics
Designing, evaluating, maintaining, and troubleshooting indexes and statistics.
568 associated posts270 primary posts
[Video] Office Hours: Almost Back in San Francisco
It's back to lighter fog-friendly clothes as the ship pulls into San Francisco and I answer your questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=ZT5hr9JZz7k
[Video] Office Hours at Sea: SQL Server Q&A
En route from San Francisco to Juneau aboard the Ruby Princess, I stopped to hit a few of your questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=o4P50_U-zUA
[Video] Office Hours: Azure & SQL Server Q&A
Y'all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams.
https://www.youtube.com/watch?v=TpNXUCPzfj4
[Video] Office Hours: Professional Development & Training Questions
A lot of today's questions from https://pollgab.com/room/brento have a common theme, but it's just a coincidence:
https://www.youtube.com/watch?v=x2Tm_BHXT68
Production DBA
Office Hours Speed Round, Easy Text Answers Edition
Some of the questions y'all post at https://pollgab.com/room/brento have easy one-line answers. Let's knock 'em out:
George: Hi Brent, what recently has been the most challenging/surprising/new-to-you performance issue you have encountered?
[Video] Office Hours: Ask Me Anything About Azure SQL DB & MSSQL
Post your questions at https://pollgab.com/room/brento and upvote the ones you'd like to see me answer.
https://youtu.be/V5illj_KOJg
[Video] Office Hours: Ask Me Anything at Sea
It was a dark and stormy morning, on the last day of my Panama Canal cruise. Before I perished, I sat down to answer your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/lAMRoB1LyWE
Production DBA
Office Hours: Questions That Didn’t Make the Cut
Sometimes, y'all post questions at https://pollgab.com/room/brento and they don't get a lot of upvotes, and reading through 'em, I bet it's because other people don't quite understand what you're asking. I think there might actually be a good question at the heart of it, but ... I'm just not sure what it is, and it needs to be rephrased.
Production DBA
Office Hours: Short Text Answers Edition
Not all of the questions y'all post at https://pollgab.com/room/brento require long-winded responses.
Brandon: Do you seen a rise in json queries to address impedance mismatch between data/objects? I struggled with EF to produce a query that was neither simple nor complicated against a properly designed db (according to 2 experts). Dropped EF; used json query in stored proc; it was magic.
[Video] Office Hours Brought to You by Quest Software
Today's episode of Office Hours is brought to you by Quest Software. I went through your top-voted questions from PollGab.com/room/brento, and, uh, kinda looked like I was sponsored by Fendi while doing it, hahaha:
https://youtu.be/2NssGp4tays
[Video] Office Hours: Quiet Sunday Edition
While waiting for the dry cleaner to open, I went live to stream a quiet session going through a bunch of y'all's questions from https://pollgab.com/room/brento.
https://youtu.be/1rYG0laQpOU
[Video] Office Hours: 22 Good Questions and a Stinker
Lots of good questions on today's broadcast! If you'd like to submit one, go to https://pollgab.com/room/brento and upvote the ones you'd like to see me cover.
https://youtu.be/phAwmrItoCY
[Video] Office Hours: Ten Minutes of SQL Server Answers
ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let's answer your questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=zdxnqlw3EGY
[Video] Office Hours: Bad Hair Edition
I am waaaay overdue for a haircut, but instead of being a responsible adult, I stopped to take your questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=e2ZQisZJp5M
[Video] Office Hours: Holiday Speed Round
Beep beep! Here's a speed round of Office Hours where I rip through a dozen questions in under ten minutes. Want to see your own questions answered? Post 'em and upvote the ones you like at https://pollgab.com/room/brento.
https://youtu.be/qt2mmS0RY5I
Should You Use SQL Server 2022’s GREATEST and LEAST?
If you've been following along with this week's posts on DATETRUNC and STRING_SPLIT, you're probably going to think the answer is no, but bear with me. It's Christmas week, right? The news can't all be bad.
GREATEST and LEAST are kinda like MAX and MIN, but instead of taking multiple rows as input, they take multiple columns. For example:
[crayon-6a6f49e85c98b471992896/]
Produces 3 and 1. This actually has really useful real-world implications.
T-SQL & Development
Should You Use SQL Server 2022’s STRING_SPLIT?
SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, that's the only thing they improved - there's still a critical performance problem with it. Let's take the Stack Overflow database, Users table, put in an index on Location, and then test a…
[Video] Office Hours: Great Questions, Part 2
Every time I think, "There can't be any more SQL Server questions left," y'all post more great ones at https://pollgab.com/room/brento!
https://www.youtube.com/watch?v=ZcF2sG5J4sk
[Video] Office Hours: Great Questions, Part 1
Wow, y'all have been posting some great questions at https://pollgab.com/room/brento lately!
https://youtu.be/eIjMqm0b02s
