Since you can do a backup and a restore, you can do log shipping. If you're looking for a way to do this to MI with minimal downtime, that's generally...

No matter what, you'll have to do data cleansing, scripts or tools, that much is necessary. Generally, following data cleansing, I rebuild the indexes and then shrink the database, to...

I'm with Phil, probably your best bet is a trigger. Here are the docs. You want to look at the DML triggers and, probably, an AFTER trigger, meaning, after...

• This reply was modified 2 years, 7 months ago by Grant Fritchey. Reason: forgot url

The one I've been basing my own advice from is years old, by Brad McGehee. Frankly, I did a search, and I can't find it. That stinks, because lots of...

If you're going to run on AWS, I'd start by experimenting with AWS RDS. See how that works for you....

Ahhhh.... PLE.

I'm to the point where I actively dislike this metric. Not because it's problematic in and of itself. Instead, because of that doggone perpetual bit of "knowledge" that your...

I haven't done it, so there's that.

However, based on the documentation, yeah, it should be possible. That's not saying it is. But it really should be.

I'd suggest a few more,...

Every single test I've seen over the last, almost 20 years, suggests, with the exception of Columnstore indexes, REORGANIZE is a complete waste of processing power and time. Just don't...

Prepping non-production environments can be a lot work. Script the heck out of it. And yeah, there is a command you can use, SHRINK. I don't recommend it for...

With size based cleanup set to auto, it'll ignore the 7 day limit and clean up the data based on the size.

EDIT!

But, if it doesn't hit the size limit, then...

• This reply was modified 2 years, 7 months ago by Grant Fritchey.

#SQLHelp is pretty much what it says, "Hey, I could use some help on SQL Server." And that's all it's for. Yeah, sometimes people try to use it advertise a...

Are you sure about the "normal people" part? I mean, that group of speakers includes me, so...

Ha!

I believe this stuff, communication with humans, is just hard. We all struggle. Fact...

It sounds like you're describing Database DevOps. Basically, code goes into source control. You can run a linter through it there, or automatically later. Set up continuous integration to...

Nice one!

Welcome, again, to the team. Great to have you here.

I'm a fan of C#.