There are a number of ways to manually check, or manually configure some kind of alert method for Database Mirroring. The following is some SQL logic that will automatically configure SQL Database […]
Ever find yourself needing to find the difference between two dates, but displaying in such a way that makes sense to most people? Here’s some quick sql logic to get you the […]
Here’s some very simplified sql logic that checks to see if a configuration is enabled, and subsequently changes those values if they are not enabled. Note: If you ever want to use […]
Here’s some sql logic you can throw into any Job. Create Database Mirror Alert Process. Job is designed to check all databases (excluding system level) to ensure they have been configured for […]
Here’s some sql logic that will show you the time between when a database was created (create_date), and when it was restored (restore_date).
Get the SQL Server Port Number with this Simple Query
Here’s some logic I wrote up which allows you to update a particular Job schedule across multiple servers. It’s designed to find the Job, Pull the Job ID and Schedule ID for […]
Here’s some quick SQL Logic to show you all the schedule ID’s across all your Jobs. This will help if you have multiple agent jobs across the enterprise that have the same […]
Here’s some sql logic you can put in a Job and run it nightly. Basically it will check to see which databases haven’t had a recent backup. In this case it’s any […]
Find databases that haven’t had a backup in over 1 day. ( 24 hours ). Here’s some quick sql logic that will help you get that info. This logic assumes the databases […]
Here’s some quick SQL Logic that will show you the age of your backups.