Whenever I move to a new place and set up a new home studio, I give you a walkthrough so you can get a rough idea of how I work. I just finished setting up my new San Diego home base, and here's a tour of what it looks like both as an attendee, and behind the scenes:
At a conference in Belgium this week, Steve Jones posted a video:
https://twitter.com/way0utwest/status/1447556893753368579
When you buy my Live Class Season Pass, you can attend all of my live online training classes for a year straight, plus watch the recordings. It's an excellent deal: go to your manager just once, get approval just once, and then spend the entire year learning how to master SQL Server. You don't have to…
Good evening, party people! I finally have my new San Diego home base all set up and unpacked, so I took a champagne break to review your top-rated questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=ESHC8NZKf5E
This month & next, I'm going to teach you the fundamentals of SQL Server database performance tuning, live, for free.
The first class is my How to Think Like the Engine class. It's already free online in both video and blog post formats, but this fall I'm updating and expanding it to a 3-hour version. You could totally start watching the recorded version now, but...I know how it is. Some folks prefer watching live because they can ask questions as I go along:
Just got the keys to the new home base in San Diego, and the furniture isn't even in yet. I went through your top-voted questions from https://pollgab.com/room/brento before my smoke alarm battery started chirping:
https://www.youtube.com/watch?v=o7CYItqFiXY
On a very chilly morning, I went through your highly-upvoted questions from here and talked through 'em:
https://www.youtube.com/watch?v=lpklTAJdrBE
I stopped at a waterfall in Iceland to answer your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=tWguvLfHaNA
Every year, I run a Data Professional Salary Survey here. Thousands of y’all have answered – here are the past results in Excel – and it helps everybody get a better idea of how overpaid they are. (Did I word that right?)
Here are the questions I’m planning to ask this year:
I drove up the volcano Hekla in central Iceland - also known as the Gateway to Hell - and parked the Defender here:
While my travel companions hiked up higher (and took that photo), I set up the tripod and camera, then went through your highly-upvoted questions from https://pollgab.com/room/brento.
The beach at Vestrahorn mountain looks different every time we've visited: high tide, low tide, sun, clouds. Always a fun side trip when we're out in the southeast of Iceland. I took a break to answer the questions you upvoted here.
https://www.youtube.com/watch?v=TE2y8nKioG8
When you execute a query, the database server has to figure out things like:
Which table to process first
Which index to use on that table
Whether to seek on that index or scan it
Which table to process next
How to join the data between those two tables
When to sort the data
You work at a charity or non-profit, helping them make a difference with data.
Maybe you write reports to help fundraisers do a better job of raising money to find a cure for a disease. Or maybe you're a developer at a non-government organization whose mission is to speak for those who can't speak for themselves. Or maybe you're a sysadmin who's been stuck managing vital databases, but your non-profit is already stretched to the limit and can't afford training.
I took a break from playing with glacier leftovers at Diamond Beach to answer the questions you upvoted at https://pollgab.com/room/brento/.
https://www.youtube.com/watch?v=K4l522V4h08
I've slowed the First Responder Kit update frequency down to once every 2 months. I know from firsthand experience working with clients that folks just can't patch quickly enough, hahaha. Folks who want to be on the bleeding edge updates can always use the dev branch in Github, too, getting every new fix the moment it's merged.
You posted and upvoted SQL Server questions at https://pollgab.com/room/brento, and I went out for a walk on the Seltjarnarnes peninsula to the lighthouse to answer 'em.
https://youtu.be/IB2EH2irD6s
You posted and upvoted questions at https://pollgab.com/room/brento to pick what you'd like to see covered in a Q&A session:
https://www.youtube.com/watch?v=gRwLZERyORk
I hang out by Hallgrímskirkja, the modern church in Reykjavik, and take your highly-voted questions from https://pollgab.com/room/brento. Here's what we covered:
https://www.youtube.com/watch?v=slku6V9mWnw
Before Fjöruborðið opens for lunch, I answer a few of your questions from https://pollgab.com/room/brento including:
00:00 Introductions
00:29 Peter: What is your opinion about the SQL generated by Entity Framework?
02:00 Peter: When would you switch from EF to stored procedures?
02:45 Always Learning DBA: What are free resources to help me transition into an architect or data scientist role?
04:43 How is the auditing and monitoring different for Azure SQL DB?
06:33 Recap
I sit on the porch and discuss your highly voted questions from https://pollgab.com/room/brento.
https://youtu.be/YJ92WDOwOMo
