[Video] Office Hours: Ask Me Anything About SQL Server and Azure
In between client calls, I stop to review y’all’s top-voted questions from https://pollgab.com/room/brento.
Here’s what we covered today:
- 00:00 Start
- 02:44 mailbox: Do DBA’s still need to be the only ones with permission and responsibility to roll-out code changes in production? Are there are shops in which this is a developer task that doesn’t involve the DBA?
- 04:54 MyTeaGotCold: Is there ever a good use case for SSIS? After two days of using it, I burn with righteous fury and beg my colleagues to let me torch it.
- 05:55 mailbox: Is it still good advice to disable hyperthreading on the Hosts dedicated only to your SQL Server VMs? What about when your Host Cluster houses all company vms(not just sql server) — still a good idea to disable hyperthreading on the host? Does this advice apply to Azure Cloud?
- 06:58 Sanjay: What are your thoughts on using cross database queries to selectively opt into a newer compat level? DB1 = 120, Compat Level, DB2 (Empty shell DB) = 150 Compat Level
- 07:53 Ross: What are your thoughts on the Windows Service account for SQL Server having sysadmin permissions?
- 08:11 Ravonna Renslayer: What is your opinion of native compiled stored procedures? Do you see them used much?
- 09:04 GeneralDogsBody: HI, we have an audit table with 408m records, the clustered index is a guid, and it is causing us performance issues on inserts. We want to change the clustered index to a new column that is an identity. Is there a preferred method to do this?
- 10:06 SQL_bob: What are the use cases for using SQL Server with Data files sitting on a smb fileshare? Do you have any experience with this configuration?
- 11:09 VoteBrentForPresident: Hola Vato! When getting the “Aggressive Under-Indexing” from BlitzIndex how can I dig deeper to find out what indexes I need? I’ve gone through the module “Tuning Indexes to Avoid Blocking module” but not really found the tools for solving that, please guide me sensei.
- 12:10 Piotr: Any tips for dealing with high VLF count when using SQL AG?
- 13:21 Kang: What is your opinion of Azure Synapse? Will the success of Fabric kill it off?
- 14:05 Asking For a Friend: Are cloud databases overrated? Have a teeny database in a SQLMI, was asked to move to Azure DB, but still $hundreds/mo. Could move to on prem VM, (yes sunk costs), but direct cost of the DB there would be $0/mo + perform better. Just don’t see a good cost/benefit for cloud SQL.
- 15:14 MyTeaGotCold: Do you ever foresee In-Memory OLTP becoming the norm? I’m considering having my next SQL Server use it exclusively.
- 15:43 Nathan Brown: Is there a good way to know if a given SQL operator is a blocking operator or not?
- 16:32 Heimdall: Do you like / ever use the live query statistics in SSMS?
- 17:44 Maciej: Have you ever rejected an offer for consultancy because of ethical reasons? If yes, could you tell us why?
2 Comments. Leave new
hyper-threading and SSIS were absolutely cringy even only to read.
Part of what I like about Office Hours is that it reminds you of the kinds of problems people are struggling with today. It’s easy to think that because YOU know something really well, that EVERYONE must know it really well.
I have a bunch of chef friends, and I sometimes ask them questions that make them laugh. “Uh, how do I sharpen a knife?” My favorite friends are the ones who don’t make me feel stupid, even though my question is pretty basic, heh.