Search Results for “first responder kit”

Your Teammates Need the Fundamentals.

Conferences and Classes
0
You’ve been reading my site for a while, watching videos, keeping up with the best SQL Server techniques. However, you’ve got a lot of other folks on your team who don’t have as much free time as you, or they’re just getting started on their SQL Server performance tuning journey. Forward this post to them,…
Read More

Announcing Fundamentals Week, May 6-10

Conferences and Classes
3 Comments
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watching recordings or stepping through demos yourself, but…you just can’t block out the time, and you…
Read More

[Video] Office Hours: Speed Round

Videos
1 Comment
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded answers. Let’s conquer 22 questions in 15 minutes! Here’s what we discussed: 00:00 Start 01:05 JoseDBA: We just started monitoring our AlwaysOn with Datadog. Any recommendations of what to monitor that is valuable and not filling ourselves with meaningless alerts? Thanks! 01:43 Boutaga: Hey…
Read More

[Video] Office Hours: Ask Me Anything About Microsoft Databases

Videos
0
Post your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the stream. If you’d like to be alerted when I live stream these, follow me on Twitch. Here’s what we discussed today: 00:00 Start 00:38 Steve E: Hi Brent, Have you ever come across any environment using Application…
Read More

[Video] Office Hours: Lumberjack Edition

Videos
0
On a chilly January day, I went through your top-voted questions from https://pollgab.com/room/brento. Yes, it actually gets cold in Vegas! It’s sub-freezing overnight before the sun comes out each day. Here’s what we covered: 00:00 Start 02:53 MyTeaGotCold: Is BCP dead for both exporting and importing? When exporting, people seem to prefer not using SQL.…
Read More

[Video] Office Hours: Ask Me Anything About the Microsoft Data Platform

Videos
0
Forgive the hoarse voice – I’m recovering from something COVID-ish. I went through your top-voted questions from https://pollgab.com/room/brento and did my best: Here’s what we covered: 00:00 Start 03:03 DBANoob: We have EF code that creates randomly generated temp table names every time it runs, while the rest of the logic remains the same, giving…
Read More

[Video] Office Hours: 21 Good Questions

Videos
2 Comments
This one is a 3-part episode: I take 21 questions from https://pollgab.com/room/brento and then later, work on First Responder Kit pull requests. Here’s what we covered: 00:00 Start 01:08 MooneyFlyer: Hey Brent, apart from installing and playing around with it, what is the best way to get started with Postgres for someone familiar with SQL…
Read More

[Video] Office Hours: Live on Black Friday Edition

Videos
3 Comments
On Black Friday, I took a break from answering support emails to hit your top-voted questions from https://pollgab.com/room/brento.   Here’s what we covered: 00:00 Start 00:41 MatthewsSQLServer: How AlwaysON AG failovers cause can be analyzed, is it DB/Cluster/Infrastructure/AD issue. Can you please suggest any videos or blogs that can help? 02:19 NotADeveloper: We have a…
Read More

One-Hour Session Booked

Great! Here’s what happens next. I’ve emailed you a calendar invite with the online meeting details, like the Zoom login. You can send that to anyone on your team who you’d like to attend. If you want me to look at the database during the call, you’ll need someone ready to share their screen. I…
Read More

[Video] Office Hours: All About Miles Edition

Videos
6 Comments
Today’s webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:03 Miles: Hi Brent, I am aware of “sp_statement” completed and sp_batch_completed events in trace and extended events. But, what is the use of rpc_completed event? How this event will be helpful…
Read More

[Video] Office Hours While the Pool Refills

Videos
6 Comments
I step away from the backyard long enough to take y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 02:23 Stockburn: Hi Brent, we are using distributed always on AGs, with a node in AWS for DR. We are thinking of using this to quickly migrate the work load to the…
Read More
Office Hours Podcast

[Video] Office Hours: Azure & SQL Server Q&A

Videos
0
Y’all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams.   Here’s what we covered today: 00:00 Start 01:56 Manoj: Where do you see artificial intelligence having the most impact on DBA’s? 03:25 It’s ‘a me: Hi Brent, is it still “best practice” to have databases split into…
Read More

How to Configure Ola Hallengren’s Database Maintenance Scripts for Backups

Someone told you that you should be using Ola Hallengren’s Maintenance Scripts. You’ve downloaded his Maintenance Solution.sql, you ran it in the master database, and … now you’re not sure what’s supposed to happen next. In this post, we’ll cover how to configure backups. First, configure the Agent jobs. When MaintenanceSolution.sql ran, it created a…
Read More

[Video] Office Hours: Live Q&A

Videos
2 Comments
This one’s broken up into two parts because I took a bio break mid-stream: 00:00 Start 03:04 Clippy: Hey Brent, you are the best!!! Can you share us more about your roots? What’s the origin of your family name and where does it comes from? 04:15 I_ALSO_WANT_A_FERRARI: Hi Brent, first of all thank you for…
Read More

[Video] Office Hours Speed Round: 21 Answers in 15 Minutes

Videos
2 Comments
HONK HONK! It’s time for a fast round of answers to concise questions y’all posted and upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:19 TheyBlameMe: Hi Brent. What is your view on using Dacpac diffs vs “old style” manual update scripts for deploying DB schema changes in dev-test-prod? 00:52 Alex: Hi boss, I…
Read More