Clean up was pretty severe. I dropped a bunch of repos, including one empty one. Don't ask. But yeah, I really let that slip.

And when my mother-in-law passed, we went...

Suggestions? Not as such. Meta data is really going to be the only thing you can do, so it's a good place to focus.

With Azure MI, yeah, you can restore using T-SQL. Microsoft documentation on it is pretty thorough. You will have to figure out how you want to secure your Azure...

I suspect the answer is no, but you know, the best person to ask would be Steve. Pretty sure he has open DMs here on the platform. Send him a...

Generally speaking, it all goes through one person, Steve Jones. I don't think he has a team checking things out like that.

SQL Server is not going to be able to validate duplicate documents. It just doesn't work like that. Maybe with SQL Server 2025 and the new AI functionality, but even...

Just what you say. Capture query metrics with Trace (and you have no idea how painful that was for me to type, #TeamXE) to see which ones are using CPU....

Multiple posts on the same topic just confuses things. Let's keep the discussion on this, over here at the link. Thanks!

It is possible we're losing value, on average. We are starting to age out of this position and more junior people are taking it on. Plus, lots of younger people...

Oh, it's not that bad. They'll let you look. Just get...

Ooh, I so feel this.

One I see all the time, and I'm sure you do too, is when traveling internationally, depending on your flights, blah, blah, blah, you end up...

Generally, it'll cause CHECKDB to fail. However, I've seen it where it takes the server offline. This is because the rollback that has to occur, also needs some disk space,...

Migrating between data platforms is a massive undertaking. It's not just data types, although that's a big part of it. You also have to take into account connection mechanisms within...

Just know that moving data OUT of Azure costs money.

Couple of things. It's now maintaining an index in addition to simply dumping data into a heap. Also, depending on how your data is ordered on retrieval, you may be...