Database

Latest Posts in Database

How Do MySQL Indexes Work? An In-Depth Tutorial on Creating Clustered and Secondary Indexes and The Effect on Database Performance

MySQL is the most used database in the world. And as it continues to grow in popularity as an open-source database system for developers, understanding how these indexes work is…

Comprehensive Guide on Partitioning and Sharding in Azure Database for PostgreSQL

One of the biggest mistakes I’ve had to repeatedly help companies fix has been poor partitioning design. I’ve seen many database architectures designed in an attempt to make queries faster.…

Why You Need to Automate DevOps

When I began my career in IT more than two decades ago, most organizations had multiple silos of application development teams. Each team would be responsible for a single application…

What is a Data Warehouse? Benefits and Tips

A data warehouse (DW) is a centralized repository of data integrated from multiple systems.. This data is often cleansed and standardized before being loaded. Designed to support analytical workloads, a…

Comparing PostgreSQL and MySQL Databases: Differences Explained

Over the past two to three years, I’ve seen customers make a move towards both MySQL and PostgreSQL. There is no software licensing with either of these database systems, which…

How DBAs are Using SolarWinds DPM and Marginalia to reduce MTTR

Database performance is critical to business revenue. Slow and non-responsive databases can result in hundreds of thousands or millions of dollars in lost revenue from poor customer experience and downtime.…

Getting Started With Azure Database for PostgreSQL

Open-source software (OSS) relational database management systems (RDBMSes) are becoming incredibly popular in the cloud computing world. In this article, I’ll discuss one of the most popular OSS relational databases,…

Comparing DBA, DBRE, and SRE Roles

As I navigate further into my career, I’m finding the scope of my role has shifted over the years. I thought I’d take some time to help relay the differences…

Importance of Data Warehouse Automation

The enterprise data warehouse (EDW) provides access to business data stored in a denormalized structure called a star schema, which makes it easy to analyze, visualize, and forecast essential business…

New Features and Enhancements in SQL Server 2022

In the era of technology defined by cloud computing, features evolve at the blinding speed of continuous deployment. When large software development organizations like Microsoft deliver semi-annual releases of products,…

Tweets

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Are you ready to increase user productivity? Collaborate on service tickets with users by connecting Microsoft Team… t.co/ouVXAdyGmg

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Unlock the full potential of your IT stack with Hybrid Cloud Observability: Sign up for our free demo:… t.co/SLNIGxpJog

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

Get the latest insights about SolarWinds Observability, including the addition of Real User Monitoring (RUM) and Sy… t.co/5cO5VcmcyD