In this episode, a lot of the questions triggered mentions of our Black Friday Sale, on now!
Here’s what we covered:
- 00:00 Start
- 01:41 Pete: 1 NUMA, 2 NUMA, 3 NUMA, 4 NUMA, or More? 176 cores, 1.5 TB RAM, currently all in a single NUMA configuration. I’m just a jr DBA so researching if breaking this monster in to multiple NUMAs is the right / best way to go.
- 03:38 Margaret Norkett: Using SQL 2019 all databases are set to compat 150. Query performance that was once good is now bad and none of the usual things to fix it seem to work. I noticed a setting “Query Optimizer Fixes” on the database which has default of 0 (off). Changing to “on” helps – WHY?
- 06:10 mailbox: Do you have a favorite storage vendor? if so, what makes them your favorite?
- 07:25 Tara: With the popularity of Chat-GPT, do you think AI will make canned reports obsolete?
- 09:02 WhereIsMyEspresso: Hi Brent, if the collation of the user DB differs from the system DBs, would you consider changing the collation of the system DBs for performance improvements?
- 10:03 Montro1981: Hi Brent, a “friend” of mine mentioned that “Working with agile-ish dev teams and a good SQL design is basically counter to agile philosophy”, what is your take on this?
- 11:19 Ouroboros: Who has the best SQL AG training?
- 12:38 Huyang: Should production DBA’s and consultants support end of life versions of SQL Server?
- 14:04 Victor Timely: Do you see TSQL sequences used much? What are the top use cases?
- 15:29 Sylvie: What is your opinion of the TSQL deprecation “More than two-part column name”? Does it seem harsh for Microsoft to deprecate this usage?
- 17:10 Mr. Roarke: What is your opinion of the various SQL query tuner products? Will this negate the need for DBA’s or is this just fantasy?
- 18:14 Steve Trevor: What is your opinion of Azure Database Migration service?
- 19:27 Black Friday Sale reminder
- 20:30 Thinking back to Amazon Dash Buttons
- 21:58 Ezra: What are the scenarios you have seen where only system DB backups need to be restored?
- 22:51 Renaldo: What’s the best way to synchronize stored proc changes across AG replicas?
- 23:50 Janis: Do you see many customers running SQL Server in containers?
- 24:28 Slonik: What is your opinion of Babelfish for Aurora PostgreSQL?
- 24:48 Black Friday Promos reminder
- 25:15 Slonik: Why does SQL Server cache query plans and PostgreSQL does not? Which methodology is better?
- 26:10 Remus: What is your opinion of OnTap cloud volumes for SQL VM cloud storage compared to native cloud storage offerings?
- 26:22 mailbox: what are the main pain-points to supporting Clusterless AG’s for use as readable secondaries? and as a Disaster Recovery Node?
- 27:12 depthcharge: We’re having to shrink some files to balance a staging DB, but nibbling chunks on a nightly basis is taking a while. Is comprehensive index rebuilds + DBCC SHRINKFILE with TRUNCATEONLY a useful tactic here?
- 28:44 Ariel Ferdman: What solution should I use for DR Distributed AG or single AG distributed on two sites?
- 29:50 Diego: Hi Brent. There is a huge sp in prod that is executed in 200 different sessions/threads from JAVA and always result in a deadlock. I was thinking in using query hint UPDLOCK how good is it?
- 31:06 sureman: Hi Brent, tell us your opinion of paying for any advertising or marketing campaigns to bring in more consulting business? Any value in it?
- 32:42 Steve Trevor: What are your pros / cons for using Azure backup vs native SQL backup when backing up Azure SQL VM multi TB?
- 33:05 ZappyDBCC: Hi Brent, do you sometimes use physical read for performance tuning ? and if so, can you give some examples of its use ? Thanks
- 33:26 Black Friday Promo
