Hmmm. Weird.

I'd suggest putting Extended Events to work. You can look for Object: Altered events. I'm pretty sure that's where it would come up. Just filter by the database(s) in...

Statistics maintenance is a huge topic. Suffice to say, more updates are better (usually, but not always). Detailed scans for updates are better (usually, but not always). The only way...

You're going to have to think through the relationships between all these things a bit more and then create tables based on those relationships. For example, I don't see a...

yeah, it's down to whether or not the app name is included in the connection. If it's not there, it's probably not possible to tell where any given query is...

If your number one wait statistic is anything except IO_LATCH*, don't mess with memory optimized tables. OK, maybe, MAYBE, for some table variables, they do pretty cool things there. However,...

Hey Tom!

So, for Managed Instance, and for Azure SQL Database, while Microsoft is handling things like consistency checks and backups, you are responsible for what goes on inside the database....

Oh, I won't be surprised if they change the licensing model. But I'm positive that development on the product is going to continue. Each release puts another 10 years, minimum,...

I'd go one farther. Set up database security so that you have groups. Grant security to the groups. Add/remove logins or groups of logins with the groups. It makes security...

This one is all about opinion, so, take with a grain of salt the size of a house.

You're being a little bit paranoid. SQL Server is one of the most...

Agreement with what everyone else added.

Heh... I agree with Grant on logical execution being left to right and data flow being right to left and both being top to bottom (except on super-umbra-red...

Thank you Grant, actually if you have the power you can just delete that, I didn't redact parts of the screenshot I should have. Reporting it was the...

I'm a little confused. You keep talking about servers and server specs. However, you also said you were using Azure SQL Database. That doesn't involve servers. So... which is it?

OK. This is a fun one.

Execution plans are logically executed from left to right, and roughly, top to bottom. You can validate I'm right about this by looking at the...

Yep. Without the rest of the error message, I can't even hazard a guess. Jeff is probably right (says Grant all the time).