Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Architecting Database Dev and Test Environments: Best Practices and Anti-Patterns for SQL Server

Many organizations use out-of-date architecture patterns for developing relational databases which are a pain to manage, slow developers down, and limit testing and innovation. It’s time to modernize these environments and improve standards for database development. In the years I worked as a consultant specializing in SQL Server administration and tuning, I frequently fielded questions from customers about how to best manage databases in development and test environments.

Grafana - How to read Graphite Metrics

Before getting started on how to read Graphite metrics, let us first dive into understanding what Grafana is all about. In a nutshell, Grafana is an open source analytics and monitoring solution, developed and supported by Grafana Labs. It allows you to query, display graphs and set alerts on your time-series metrics no matter where the data is stored.

Cloud and On-Premises Database Monitoring Best Practices

SolarWinds product experts present a visual overview of cloud and on-premises database monitoring best practices using SolarWinds Database Performance Analyzer (DPA) and Database Performance Monitor (DPM). They will cover high-level monitoring in DPA by looking at correlation tabs, such as resources, virtualization, and blocking, and will demonstrate how to create example alerts that can look at this data.

Using the SQL Change Automation PowerShell cmdlets with Jenkins

In this video you’ll get an overview of how Redgate’s SQL Change Automation PowerShell module can plug into Jenkins using pipeline-as-code to build and deploy your SQL Server Databases. For more information, feel free to email in, leave a comment below or visit the Redgate website!

Securing SQL Server with DoD STIGs

Making sure your SQL Servers are secured against malicious users is difficult. How can you know that you’ve done enough? How do you know you’re protected from the things that actually worry you? The United States Defense Information Systems Agency (DISA) publishes a set of guidelines for organizations securing different pieces of software that connect to the US Department of Defense’s networks (DoD).

8 Crucial Database Performance Metrics

What are the most important database performance metrics, and how do you monitor them? This is a question many IT professionals would like the answer to. We can collect and use a wide range of database metrics to analyze database and server resource consumption, not to mention overall usage. You are probably wondering why this is essential for business, so let’s explore this next.