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…...

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,...

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...

An Intelligent Approach to Business Intelligence: Part Two

In part one of “An Intelligent Approach to Business Intelligence” we shared some insight into the challenges of capturing, understanding and leveraging data. Now, let’s take a look at a business intelligence approach that uses the latest reliable infrastructure...

An Intelligent Approach to Business Intelligence: Part One

There’s a lot of information about analytics and business intelligence. In fact, you could argue that there is too much information. Business executives and IT professionals scour the internet to research “how to do it” and find everything from relevant blogs to...

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...