Here’s some logic which may help you tackle some of those Database STIG requirements for SQL Server. I created this for a particular SQL Database Server which hadn’t yet been hardened according […]
Here’s some quick SQL logic to change all the database owners to ‘sa’.
This is alittle write-up I did on determining the average memory, and io for each database instance. This is a global solution, and can be deployed across any SQL Server 2012 environment. Presently […]
Often times whenever you are performing a database migration you need to determine which data files are actually being used, and which are not. You can always run a query against the […]