Windows Management Using Ansible Tower (Part 3) - MS SQL Basic HealthChecks and Add User

This video shows the possibilities of using Ansible Tower to manage Microsoft SQL Server (Day 2 Operations)

All the relevant playbooks can be found at the following link,

The actual flow of the video is as follows:

1) The Windows engineer will make use of Ansible Tower to perform basic health checks on MS SQL,
i) Check that all required services are running as well as those which are not running
ii) Check the MS SQL version and make sure that it is what we expect it to be
iii) Check the system time to ensure that it is synced and has not drifted
iv) Check disk utilization to make sure that we have sufficient disk space for the DB to operate
2) Note that we can always send out a report if we detect anomalies in the health check results
3) The Windows engineer proceeds to add a new user with 'db_datareader' role for the 'Test_Database' DB
4) The Windows engineer makes use of the Microsoft SQL Server Management Studio to confirm the successful creation of the new user. User mapping checks out as well.
5) Note that there is a simple sample playbook for MS-SQL management. It provides the basic patterns that we can use in a playbook to query table and insert new entry. The link to the playbook is as follows,