You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today.

Why Database Engineers Should Own the Application Repository


As a database professional its my responsibility to make sure data is well formed, performant and available to the end user. So many of us only stop there thinking they only should work with their database technology. Let’s explore why this mentality needs to change.

Kent Howerter

Kent Howerter



Getting Started with Grafana Dashboards


Today we are going to look at how to create a simple attractive dashboard that will wow the end users and give your career a little boost of fun. Then we will top it off with design theory on layout and how to pop the details you are delivering with color. Welcome to Grafana.

Kent Howerter

Kent Howerter


The SARGable Query


Knowing how to correctly write high performance queries will help the speed of your database and make your applications preform well under pressure. Today we are going to help define what SARGable and non-SARGable queries.

Kent Howerter

Kent Howerter


SQL Server 2019 Availability Groups with Kubernetes


Microsoft first introduced SQL Server on Linux with their 2017 version and has only scraped the surface of many new features to come. Today we are looking at SQL Server 2019 HA Always on Availability Groups (AG) within a Kubernetes cluster. This article will assume you have some experience with Kubernetes containers and configuration.

Kent Howerter

Kent Howerter


True DevOps Includes Database Deployment


Having your database in source control and included into your automated deployment is considered a true CI/CD configuration. Getting to this point can be challenging but well worth the dedication and perseverance. We are going to walk through some of the key items you need to consider before taking the steps.

Kent Howerter

Kent Howerter


How to Choose the Right Database


I had a developer ask me a question the other day that made me take a few steps back. They asked me how would I know if the database I want to use is the right one? Now this question is like producing a new report for the business. It will raise a bunch of other questions with deeper analysis and eventually, the answer comes to the forefront. Let’s look at a few current options.

Kent Howerter

Kent Howerter


Postgres Versioning with Hidden Fields


Versioning in Postgres you say? Multi Version Concurrency Control (MVCC) controls what information can be seen by storing both the past image and the latest image with hidden fields in the table itself. We are going to take a look at these hidden fields and expose the information in them.

Kent Howerter

Kent Howerter


Get Your Feet Wet with Kitematic by Docker


Kitematic is an easy way to start using Docker without the scary command line. Just point, click and connect. Yes, it’s that easy. We are going to dive in and show you what you need all the way down to connecting to SQL Server 2017 Docker image. (Just for the record, I still like command line, but this is a quick option).

Kent Howerter

Kent Howerter


The Rise of Postgres in the Modern World


Postgres has been around for over three decades now and gaining traction in the modern world of database storage. We are going to dig a little deeper and find out why this has become a viable option for the enterprise and look at some of the differences between SQL Server and PostgreSQL while pointing out some neat features.

Kent Howerter

Kent Howerter


What is this thing we call DevOps?


DevOps didn't gain much traction in the tech community until about three years ago and has several different meanings. Today we are going to take a look at DevOps.

Kent Howerter

Kent Howerter


Cloud Deployment Models


So you want to move to the cloud and need to select the correct model that meets your needs. We are going to go over the three different models to choose from and their advantages.

Kent Howerter

Kent Howerter


SQL Server 2017 Installation


Microsoft SQL Server 2017 has many new features. Some of the features are the ability to install on Linux and Linux based Docker containers, SSIS Scale Out Master and Scale-Out Worker, resumable online index rebuilds and Machine Learning Service language supporting R/ Python. In this article, we are going to show you how to install a 2017 basic database engine.

Kent Howerter

Kent Howerter


Cosmos DB Advantages


I once used a screwdriver as a hammer. Did it work? Yes, but wasn’t my best option. Choosing the right tool for a job helps your end product and makes the development process accelerate with clean and readable code. Knowing what each database can do and what the pros and cons are will help drive your decision.

Kent Howerter

Kent Howerter