Search Results for “office hours”

[Video] Office Hours: Great Questions, Part 1

Videos
0
Wow, y’all have been posting some great questions at https://pollgab.com/room/brento lately! Here’s what we covered today: 00:59 Gustav: Hi Brent We recently migrated to SQL MI General Purpose, and I noticed that the default blob storage per .mdf /.ndf file is 128Gb container with 500 IOPS! This is terribly slow! Would splitting the database into…
Read More

[Video] Office Hours: Speed Round Edition

Videos
0
I took a break from my Black Friday sale customer support emails to check in on the questions you posted at https://pollgab.com/room/brento and answer the highest-voted ones: 00:00 Start 00:15 Meshulam: What are the top use cases for running SQL Server in a container? Do many of your customers run SQL Server in a container?…
Read More

[Video] Office Hours: Black Friday Edition

Videos
0
My Black Friday sale is in its last days, so most of my time at the moment is spent keeping an eye on the site and answering customer questions. I’m happy to say it’s our best year so far, too! Y’all really like the new access-for-life options. I took a break from the online frenzy to…
Read More

Office Hours: Read This, Watch This Edition

SQL Server
1 Comment
This week, a lot of the questions you posted at https://pollgab.com/room/brento just need pointers to resources at other places. Welcome to the Read This, Watch This series of answers. Don’t Blame Anthony: Our developers prefer writing TSQL queries directly in their .NET code rather than writing sprocs and calling them. What are the pros /…
Read More

[Video] Office Hours: Sponsored By Black Friday Edition

Videos
2 Comments
Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk through ’em. Here’s what we covered today: 00:00 Start 00:22 CKI: Could please give me pointers how to answer the question “Do we need to create a new instance for the new application or can use the…
Read More

[Video] Office Hours: Surprise Edition

Videos
6 Comments
Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk through ’em. There’s a slight problem with this episode: I forgot to hit the Record Questions button in PollGab, so I can’t quickly/easily generate the list of questions we covered. If you asked a highly voted question…
Read More

[Video] Office Hours: Nine Minutes of Answers

Videos
3 Comments
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss during my live streams. This week, I took a break from working on my PASS Summit sessions in order to chat: Here’s what we covered: 00:00 Start 00:32 Jeremy: We have an older web app we’re going to be rewriting…
Read More

[Video] Office Hours Live: Ask Me Anything

Videos
4 Comments
Got a question for me? Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. Before heading to NYC for vacation, I recorded a live Office Hours on my Twitch channel. Here’s what we covered: 00:00 Start 04:40 neil: are there any ‘band aids’ a DBA can apply for a…
Read More

[Video] Office Hours Silent Edition

Videos
7 Comments
Okay, I, uh, forgot to unmute the microphone for this one: So here are the answers in text form instead. <sigh> Thank goodness it was a speed round! Mike: When Brent Ozar’s certification exams for SQL Server will be available? Looking forward to having exams like “Fundamentals of QT”, “Mastering Server Tuning” etc, so you…
Read More

[Video] Office Hours: Ask Me Anything at the Mediterranean Sea

Videos
0
On the last day of my Israel trip, I went through the highly upvoted questions from https://pollgab.com/room/brento and answered ’em, standing in front of the beach. Here’s what we covered: 00:00 Start 00:37 AllThePartyPeople: On our server, MAXDOP=1 (not my choice); we had a poor performing SP call (called as dynamic SQL; again not my choice);…
Read More

[Video] Office Hours: Six-Minute Speed Round

Videos
1 Comment
The morning after the Data TLV Summit in Tel Aviv, I stood out on the balcony and answered a few of your questions from https://pollgab.com/room/brento, rapid-fire style:   Here’s what we covered: 00:00 Intros 00:47 cyrpl: Hi Brent from PEI, Canada. A support person told me today that when creating a table, an ID column…
Read More

[Video] Office Hours in Tel Aviv, Israel

Videos
2 Comments
Before speaking at the Data TLV Summit, I sat by the Mediterranean Sea and discussed the top-voted questions you posted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:55 Manikandan GS: As postgres being one among the RDBMS lane, do you think postgres is having more features and flexibility compared to MS-SQL Server? 02:46 PaginationWoo!:…
Read More

[Video] Office Hours: Hotel Balcony Edition, Part 2

Videos
0
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. In today’s episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions: Here’s what we covered: 00:00 Introductions 00:59 Haydar: What tools do you like to use when troubleshooting azure sql db query…
Read More

[Video] Office Hours: Hotel Balcony Edition, Part 1

Videos
1 Comment
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. In today’s episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions: Here’s what we covered today: 00:00 Introductions 00:25 Kebros: Hi Brent.My manager wants me to summarize sql health into a number…
Read More
And it looks bad even in shades.

Office Hours, Short Text Answers Edition

Not all of the questions y’all post at https://pollgab.com/room/brento require long, thought-out answers. Some are just one-line specials, like these: F’legend: Hi Brent, in reply to a question talking about database restores for 1TB+ you also touched on scrubbing or synthetic data as a way to populate dev environments. Are there any resources/tools you would…
Read More

[Video] Office Hours: Ask Me Anything About SQL Server

Videos
0
Post your Microsoft data platform questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me answer. I sat down by the pool in Cabo with a cup of coffee to go through ’em: Here’s what we covered in this episode: 00:00 Introductions 00:43 MergeItLikeItsHot: Hi Brent, do you have any good resources to…
Read More