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


I’m up bright and early in Malibu, so let’s talk through your highly upvoted questions from https://pollgab.com/room/brento.

  • 00:00 Introduction
  • 01:04 JD: Have you ever encountered a very weird case during query / performance tuning that you just couldn’t get the query across the finish line, specifically just because SQL Server didn’t want to behave nicely? 🙂 What did you end up doing to overcome it?
  • 03:15 Accidental DBA: Hi Brent, do you have any recommended DMV queries you like to run for the scenario when SQL server is on fire and sp_blitzfirst is very slow in returning results?
  • 04:34 Ashok Sharma: Hi Brent, I am moving all my databases from on-premises to Azure VM (not managed instance). What is the best method to migrate SSISDB and reports DB to Azure? Which backup / restore work? I am on SQL 2016 SE
  • 05:55 Zatrikion: Hi Brent, Is parameter sniffing the same on SQL in the cloud (azure) and on an physical SQL server? Or do they “work” differently?
  • 07:08 Dmitriy: When migrating from stand-alone SQL Server to Azure SQL DB, what’s the most efficient solution to replace cross-database queries?
  • 08:10 Accidental DBA: Hi Brent, do you have any guidelines for determining how much RAM the SQL Server should have? DB is 7 terabytes.
  • 09:39 Null Pointer Exception: Thanks for everything you do for the community! Random question… any ideas/theory on why SQL Server doesn’t support temp tables in views? Would make it so much easier to give the optimize views for performance.
  • 10:53 Jiri: Working with for smaller companies I mostly see apps where SQL Server is in fact an application server. Means all business logic is in the database objects and the app is just a GUI. What do you mean about such architecture and what approach it requires concerning SQL Server?
  • 13:10 Kapil Swamy: What is the best way to identify potential botllneck in performing troubleshooting
  • 14:13 Little Bobby Tables: Yo Brent, issue I have with log shipping. I rebuild indexes on my largest tables monthly. (Standard Edition) This creates very large .trn backups ~8GB. Backups every 10min. T-log restore fails on these 30% of the time; requiring Full backup restore. Ever seen this issue?
  • 15:57 Pat: Hi Brent, Accidental DBA here. The main alert I get in my monitoring solution is Baseline OS paging. Range today, for ex, is 2 to 12,671. Also disk queue length at times, today 1 to 6. Googling to see if they’re important yields “it depends” . How can I tell if these are “bad”?
  • 18:18 Mike: Favorite subject “Transactional Replication” What entry or setting points the publisher to the distributor in the master database?
  • 18:53 George: Hi Brent, I need to implement a logging process for one of our accounting solutions and the processes in it. Can you suggest a good lightweight tool or methodology that can handle this and scale well ?
  • 19:27 Magnus: Hi Brent, I work at an MSP as an infrastructure DBA. We don’t do any performance tuning, and almost no t-sql code writing. I’ve only worked as a DBA in this environment(4 years). When is it time to leave, and when will I regret not leaving? Also,I Just signed up for your courses!
  • 24:08 Wrap-up
Previous Post
[Video] Office Hours at Silver Strand State Beach: Ask Me Anything About SQL Server
Next Post
Free Webcast Coming Up: How to Size Storage for SQL

5 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.