Database

Changing Default Database File Locations in SQL Server

12/06/13 When you create a database in SQL Server and do not specify a file location for your data and log files, SQL Server will rely on the default locations as defined in the se…

How to write Go packages coders will love

12/03/13 This post was featured in our July 2015 anthology of most popular SolarWinds Database Performance Monitor (DPM) blog posts of all time. One of the patterns I’ve found in t…

5 Things You Didn’t Know About SQL Agent

11/27/13 Microsoft SQL Server comes with a boatload of additional components. One component is the SQL Agent. The purpose of the SQL Agent is to serve as a job scheduler. Many expe…

What Happens if I Shrink a Database in Windows Azure?

11/20/13 At some point in your career as a data professional, you are going to fill up an entire drive with data. It is not a question of “if,” but a matter of “when” this will hap…

Providing Exceptional Customer Service to Exceptional Customers

11/05/13 What is “exceptional” customer service? It’s difficult to define, but you know when you have received it. It is an experience in which a service representative helped chan…

Big-O Notation Made Simple

10/23/13 If you’re a programmer or computer scientist, you’re probably familiar with Big-O notation. It’s part of your foundational understanding of how complex a problem and/or al…

Improve SQL Server Performance by Looking at Plan Cache (Part 3)

10/03/13 You can use the information in the SQL Server plan cache to research performance issues and investigate opportunities for performance improvement. In this three-part artic…

Improve SQL Server Performance by Looking at Plan Cache (Part 2)

10/03/13 In this second part of a three-part article series, we’ll look at how to examine the plan cache to quickly identify plans that need tuning, including: Plans that have miss…

Improve SQL Server Performance by Looking at Plan Cache (Part 1)

10/03/13 The plan cache holds a great deal of information about the overall health of your database instance. You can use the plan cache to investigate current performance issues a…

100% Reproducible Builds in Go

09/10/13 This post was featured in our July 2015 anthology of most popular SolarWinds Database Performance Monitor (DPM) blog posts of all time. One of the nice things about Go is …

Godaemon, a Library to Daemonize Go Apps

08/27/13 At SolarWinds® Database Performance Monitor we have a specific need to daemonize one of our Go applications, which must safely run detached from terminals, with a working …

A tutorial on how to use Go’s database/sql package

07/22/13 We found ourselves wishing for a tutorial to complement the database/sql documentation in Go, so we wrote one and shared it on Github. Please send pull requests to contrib…