Orchestrator Datacenter Detection

Orchestrator is datacenter-aware, meaning that it takes nodes location into consideration when performing a topology change. Let’s explore the options to make Orchestrator automatically detect this configuration. Using MySQL server One option is to use the monitored database server to…

Read More >

SQL Server 2017 Automatic Tuning

Introduction Every new version of SQL Server ships with exciting new features. One of the simplest but important features is Automatic Tuning. Before covering this new feature, let’s analyze the old ways so we can understand what is really automated…

Read More >

Linux File System for SQL Server DBAs

With Microsoft releasing SQL Server on Linux and a lot of SQL Server DBAs coming from a predominantly Windows background, this post is going to arm the DBA with the fundamental knowledge of the Linux file system. If you come…

Read More >

Datascape Podcast Episode 29 – A Tour of Microsoft Azure Cognitive Services

On today’s show, we welcome back Warner Chaves. Warner is here to fill us in on Microsoft Azure Cognitive Services (as well as related updates from Microsoft Build). In our discussion, we will be covering everything you need to know…

Read More >

HAProxy MySQL Lag Awareness via systemd

In one of the projects I have been working on, one requirement was the ability to stop traffic from reaching a MySQL host which has been lagging behind its master for longer than a specific amount of time and then…

Read More >

Cassandra CQL Cheatsheet

Every now and then I find myself looking for a couple of commands I do often. In some other software/technologies we sometimes find a thing called a “cheatsheet” that displays the more used (and some more obscure commands) of that…

Read More >

Setting up Docker on Oracle Linux

Over the last couple of years, I have been hearing about Docker at different conferences. It’s a container technology that seems to have gained a lot of popularity. In recent months, I have started exploring how Docker can be used…

Read More >

Neo4j Cluster using Vagrant, Ansible and Virtualbox

Recently, I was faced with the need to create and configure a Neo4j cluster. In order to be able to easily experiment with different settings and configurations, I decided I needed to create a local to Neo4j cluster using Vagrant,…

Read More >

Azure Total Cost of Ownership Calculator

Microsoft has released a new Azure Total Cost Ownership (TCO) Calculator. This calculator allows you to quickly enter in your current on-premises workload and review the expected savings or costs of moving to Azure. Workloads You simply enter in your…

Read More >

Log Buffer #547: A Carnival of the Vanities for DBAs

This Log Buffer edition covers Oracle, SQL Server and MySQL.

Read More >
Page 1 of 32012345...10...Last Page »