Availability Groups are generally considered to be the modern, safe, approach to high availability. At the very least, they get a lot more love & attention from Microsoft than any...

Yeah, what jeff said.

Ooh, yeah, PowerBI. Another vote for exploring that space as a possible solution. In fact, it might work for you and not require a lot of data movement. Maybe.

Happy to help!

Nope. It's almost two years old. It was a wildly successful release with very few bugs or issues. What it did have (nothing is perfect) has largely been addressed by...

The key to deadlocks is usually, but not always, that you have multiple different queries, not the same query, that are accessing the various tables in different orders. Meaning, one...

This might not be real simple. Microsoft lists a bunch of ways you can do it though. Probably the easiest is using the SQL Server Import/Export Wizard in Excel....

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...