My team and I currently manage six SQL Server instances, each on its own server. Our main need is to monitor how the databases on our instances are evolving and keep an eye on disk space.Our sysadmin team manages the OS and monitors the VMs vitals, but we don’t have a hand on that monitoring and we want to see […]
Now that we have an artifact that we can deploy, lets push it onto our target environments. In this first article I will cover how we do it for DBs, SSIS, SSAS and why we do it. I’ll cover PowerBI in a later article as there is no task available for the On Premise version of PowerBI Report Server that we use and we had to rely on a custom script.
Having passed the 10-year experience mark working with Information Systems, I felt it was time to share some insight people might find useful.