When approaching an automation problem the first questions you must answer is whether you should even invest the time to write a script. There are scenarios where it just isn’t worth your time. Depending on the tools available to you even the task of scripting out every database object could be accomplished easier and faster…
Continue Reading »
My co-worker and fellow DBA, Leigh Freijo has a blog entry about a Powershell script he created to re-integrate QA/Development database changes using Red Gate SQL Backup and Red Gate SQL Compare snapshot files. The script providers a wrapper around Red Gate’s command line tools. This is a good demonstration of the strength of any scripting language…
Continue Reading »
Co-worker and fellow DBA,, John O’Shea developed a Powershell script to create Red Gate SQL Compare snapshot files. Check out John’s blog post here.
Continue Reading »