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 […]