Office Hours: Nine Minutes of SQL Server Answers

Post and upvote questions at pollgab.com/room/brento and pick what you'd like to see me discuss. Here's what we covered today:
00:00 Start
00:32 Jeremy: We have an older web app we're going to be rewriting to use microservices. We'll also be migrating it from on-prem to Azure. Our dev consultant is recommending we use Postgres rather than MS SQL Server to save money. What are your thoughts on moving from MS SQL to Postgres?
02:19 Peter: Have you ever deleted unused stats or think it might be worth deleting stats on a table to improve performance of a stats maintenance job? My pain point is an exceptionally long running stats update.
03:27 Jacob H: Hi Brent, how do you approach tuning when you are not able to run a query in production?
04:30 Kimberly Hathaway: Brent - battling sysadmins in my org. They want Veeam backups for all SQL svrs & not SQL backups. Claim is point in time DB recovery with Veeam. I say logs are not getting truncated so Veeam is not talking to SQL. Can you point me to a doc that will support this.
06:19 Cats_Everywhere : Hey Brent, I'm planning a new SQL Server build. I expect the Business people want this server to exist for 8-10 years. Are there any good arguments (business people would love) to persuade them to stick to a 5 year max? I picked 5 years due to Patching support from MS.
07:39 Ólafur: Any indexing tips for "SELECT DISTINCT F1, F2, F3"? Is this more / less important than indexing for the WHERE condition?
08:17 Bingo Boy: What are the pros / cons of setting up a SQL Server learning environment for log shipping / A.G. using containers vs virtual machines?

[@Iamyourboo2]

I'm deeply disappointed that we are no longer party people

[@johanbester4484]

Love his tone

[@mike4330]

no interest in MSSQL personally , but this is a really effective format for quickly handling things people get stumped on.

[@andreysamykin1143]

Thank you, Brent!

[@pchasco]

Moving to micro services also means multiple domain databases and/or replication to get data and services closer to the consumers of the data. That means thought and consideration to replication strategy. Migrating to a micro service architecture is mostly moot if the data is still stored in a monolithic database, and mostly just complicates development, versioning, and deployment.

[@silvanarix]

There is a Veeam backup option for truncating logs. I know, because I use it too.

[@nedgrady9301]

Infinite brents 🤯🤯

[@devendrasingh815]

Why Salesforce database doesn't allow create non clustered index ?

[@BrentOzarUnlimited]

They do, but only for smart users - like the kinds of people who pay attention on where to submit questions. Unfortunately, that's bad news for you. ;-)