Why not just take standard SQL Server backups and in the event of a total outage, reinstall SQL Server somewhere and run a restore? Moving it all to Access is...

So, git is a third party tool. We're kind of stuck here. No matter what, something has to interpolate from your database to a git repository. Maybe take a look...

I generally gather two sets of metrics. I like to get the wait statistics because they tell me where the overall bottlenecks are. I also like to get query performance...

You are going to want to rebuild columnstore indexes on some sort of basis. This does two things. It helps to condense the columns down so that the compression works...

Hey Jeff!
Do you lend out the launcher to family & friends? If so, you've given it to the wrong person. If not, dude, go check on it, because I...

Ah, yeah, if the Query Store is read only, it sure won't be collecting data. I'm still going to test what happens when the database itself is read only. I...

The database is Read Only?

Hmmm. I haven't tested that. I'll get on it. Thanks for the blog post idea.

Now, what are all the Query Store settings?...