We’re Geekbuilt.® Developed by network and systems engineers who know what it takes to manage today’s dynamic IT environments, SolarWinds has a deep connection to the IT community. The result? IT management products that are effective, accessible, and easy to use.

author:

Database

How to Architect and Build Highly Observable Systems 2019

March 8, 2019

We’ve completely revised one of our most popular free ebooks, How to Architect and Build Highly Observable Systems. This book, originally written in 2015, has been downloaded by thousands of visitors and has generated extensive discussion. The updated 2019 edition incorporates many of the …


author:

Database

Using FORCE INDEX: When Your Query Optimizer Gets It Wrong

February 17, 2019

A Guest Post from Jordan Raine, Clio Jordan Raine is a staff software developer at Clio, the leading provider of legal practice management, client relationship management, and client intake software. Clio is dedicated to helping lawyers meet client needs and run efficient, profitable practices. …


author:

Database

PostgresConf Silicon Valley

October 30, 2018

Did you miss us at PostgresConf Silicon Valley in San Jose? Have no fear! Here’s a sneak peek video of Baron Schwartz delivering his talk on database indexing: How to Index Your Database Indexing is Simple, Approachable, and Useful Do you know what database indexes …


author:

Database

How NOT to Monitor Your Database

June 28, 2018

Do you have experience putting out backend database fires? What were some things you wished you had done differently? Proactive database monitoring is more cost efficient, manageable, and sanity-saving than reactive monitoring. We reviewed some of the most common mistakes – too many log …




author:

Database

New Stats Exposed in Go’s database/SQL Package

May 22, 2018

If you keep up with the Go development cycle, then you’ll know Go recently entered its feature-freeze for the Go 1.11 release. One of the changes for this upcoming release that caught my eye was to the database/sql package. Daniel Theophanes contributed a change …


author:

Database

How to Select the Right Queries to Optimize

April 18, 2018

Why is selecting the right queries to optimize so important? There are several reasons. Penny-Wise, Pound-Foolish  Look at the forest, not just the trees, and optimize globally, not locally. If you’re optimizing a query that never causes a user-visible problem, doesn’t impact other queries, …


author:

Database

Holt-Winters Forecasting Simplified

March 20, 2018

Holt-Winters forecasting is a way to model and predict the behavior of a sequence of values over time—a time series. Holt-Winters is one of the most popular forecasting techniques for time series. It’s decades old, but it’s still ubiquitous in many applications, including monitoring, …


author:

Database

Numeric Optimization in Golang With Nelder-Mead and Gonum

March 12, 2018

Numeric optimization is a set of techniques for fitting a function to a dataset by iteratively refining estimates. Numeric optimization is one way to do things like curve-fitting and parametric estimations. We use it in some time series forecasting techniques we implemented recently, where …