April 2018 » GarryBargsley.com

TDE Disabled – Oh! Not Really

Posted onApril 17, 2018April 16, 2018Leave a comment

Issue Recently, I was forwarded a request from our Product Support team to prepare the database for a third party application to be sent to the vendor for troubleshooting. This particular database has TDE enabled, so I figured that is easy, let me knock that out. So I proceeded to restore the database to one Read More …

dbachecks – Automate checks using SQL Agent

Posted onApril 12, 2018April 11, 2018Leave a comment

It is that time again to rave about dbachecks! This week I put in to action automated checks that run via SQL Agent for different scenarios. Issue In my environment I have 300+ servers from development to production. I do not just want to run all checks on all servers as that would take forever and Read More …