In my first post on Redgate SQL Provision, I ran some basic tests against the AdventureWorksDW2017 database to demonstrate how SQL Provision works. The headline was that I saved 47 …
I managed to get some time with Redgate at SQLBits XVIII and was interested in seeing a demo of SQL Provision. I’ve watched Redgate promoting Compliant Database DevOps heavily over the past 6 months and was intrigued to see their latest product in action. It didn’t disappoint!
I’m a huge advocate of naming conventions. SSIS is no exception.
Constantly have issues attaching public databases on my VMs resulting in the above error. Multiple reasons for it, mainly file system permissions.
Three different approaches depending on the database being moved. Whilst this not required, it’s a good idea to perform these actions one database at time in case of encountering issues.
Interesting stuff learned today about how to navigate the Master Data Services schema.