The following SQL logic will backup all databases excluding (‘master’, ‘model’, ‘msdb’, ‘tempdb’, ‘reportserver’, ‘reportservertempdb’), then it will produce 2 restore scripts. Restore Full Database Backups, and Restore Transaction Logs. The restore […]
The following logic can be placed into a Job by it’s self. Here’s what it does: 1. Creates a backup for all databases with an ONLINE state. 2. Creates a backup for […]
Here’s how to install .Net 3.5 on Server 2012. Admittedly it’s a real pain trying to get the good’ole .net 3.5 installed on Server 2012 through server manager. Here are some quick […]
If you are using SQL Server in an AWS environment then you’ll need to setup a system by which you can determine the memory or disk needs. The AWS charge model is […]
Here’s some quick SQL logic that will take the database offline, then online again. It’s helpful for maintenance reference.
Here’s some quick sql logic to perform a wild card search across all tables and columns. In this example I’m looking for any tables or views that contain a column with the […]
The following sql logic will simply change all database owners to ‘sa’. It’s a tried and true method. Will affect all databases excluding the system databases. Additionally; the final script will confirm […]
The following SQL logic takes a database offline, and then disables all subsequent logins of the database that have a name that is associated with the database name. In this case we […]
You can put this into a Maintenance Job by it’s self. It creates two temporary tables. One is a master list of all databases, types of objects, indexes, type of indexes etc. […]
The following logic checks for a particular user names that are possible SQL Job owners. Then returns a list to you of the found Jobs with said owners. Then it changes those […]
Here’s some quick SQL logic to return all the Job Owners.
Here’s a script which will help you extract information from the default trace. This should serve as a quick audit query, and not a long term audit solution. You can modify the […]
Here’s some SQL logic to help you query the RoboCopy output log file. Remember; you can query most things using an XML output so for this to work with the log file […]
Here’s some SQL logic that will track Robocopy Durations. I created this for an ETL process that basically takes a local database backup and copies it to another database server. I then […]