Here’s some quick SQL logic to create a DDL Trigger which is fired whenever a new database is created. This isn’t too terribly hard to setup, but doesn’t hurt to put a […]
Here’s some quick logic to change the recovery models of all databases (excluding system databases). This question comes up quite a bit and there are a number of ways to automate so […]
Here’s a quick query to find databases that haven’t been added to the AlwaysOn configuration. In other words they haven’t been added to the availability group.
Question: For AlwaysOn… Can you backup readable secondary replicas? Answer: Full Database Backups? NO Transaction Log Backups? YES Here’s what happens whenever you try to run Full Database Backups for readable secondaries […]
Here’s another quick way you can query the primary server. I’ve posted about this before sure; but that was using a precise result. If you wanted to see all servers involved you […]
If you arrived here then you’ve already seen that pesky “…cannot use the special principal ‘dbo’” error whenever you try to update, or edit permissions for the Sharepoint Config Database. OMG annoying […]