Blog

Spikes, Slopes, and SQL

Spikes, Slopes, and SQL

You have data you’re tracking every day. Maybe a lot of data. And maybe you’re tracking it a lot of different ways. You even create graphs of the data over time, so that you can spot trends and anomalies. And then one day you realize that you have too many graphs…...

Read Blog Post »
15 Could Get You 45

15 Could Get You 45

Today, more than ever there are so many ways to “spend your time.” Both professionally and personally, you can do just about anything at any hour of the day. Technology allows us to purchase a gift from the comfort of our couch, order movie tickets, plan a vacation,...

Read Blog Post »
The Flaws of Predictive Analytics

The Flaws of Predictive Analytics

As I write this post, I’m listening to a streaming internet radio station that picks songs for me based on my past listening sessions and preferences. I generally enjoy this. The more songs I tell the station I like, the better it gets at finding other songs that I...

Read Blog Post »
Index Health and Data Loads in SQL Server

Index Health and Data Loads in SQL Server

Most databases have maintenance plans running that monitor the health of the database, including indexes, and perform maintenance tasks as needed. But, what happens when data loads are sufficient enough to fragment the indexes and degrade performance during the data...

Read Blog Post »