Tag: automation

Automating Password Rotation for Oracle Databases

Password rotation is not the most exciting task in the world, and that’s exactly why it’s a perfect candidate for automation. Automating routine tasks like this are good for everyone – DBAs can work on something that’s more exciting, companies…

Read More >

Ansible and AWS Automation

Overview The goal was to create and manage a MySQL RDS instance and learn how to control AWS resources by using Ansible. With Ansible interacting with AWS it’s best to determine how hard or easy it is to build and…

Read More >

Cloning Oracle Grid Infrastructure Using Ansible

Sometimes your organization may decide to move to new hardware, to new data center and you, as an Oracle DBA, would need to be involved in preparation and configuration of new servers at new location. It is very often that…

Read More >

Simple Steps to Perform opatch Maintenance with Ansible

Like the Universe, IT growth seems to be infinite, we always have more environments, more servers, more users, more disk usage, more databases to manage and it won’t stop. In fact, we are pretty sure that this expansion is going…

Read More >

Automate SQL Server Version and Database Compatibility Report Using PowerShell

Sandeep Arora, SQL Server Database Consultant, provides a script for automating SQL Server Version and Database Compatibility Report by using PowerShell.

Read More >

Capturing SQL Server IO Latencies for a Period of Time with PowerShell

Today’s blog post is a demonstration of the PowerShell approach to Paul Randal’s recent blog post, Capturing IO Latencies for a Period of Time. Since wait statistics were properly implemented in SQL Server, it turned into a powerful resource to diagnose and troubleshoot…

Read More >

Loose Coupling and Discovery of Services With Consul — Part 2

Creating a Consul Client Docker Image In my previous post, I demonstrated how to create a cluster of Consul servers using a pre-built Docker image. I was able to do this because our use case was simple: run Consul. In…

Read More >

Loose Coupling and Discovery of Services With Consul — Part 1

Today I would like to demonstrate the use of Consul to help achieve loose coupling and discovery of services, two important principles of service-oriented architecture (SOA) present in modern, elastic infrastructures. If you have ever designed an architecture to be…

Read More >

Making it Easier to Graph Your Infrastructure’s Performance Data

Today I would like to share a story with you about the development of a Puppet module for Grafana and its release on the Puppet Forge. But first, I’d like to provide some context so you can understand where Grafana…

Read More >