Taking #PowerPivot to the Next Level

Power Pivot is an amazing, flexible and powerful business intelligence tool (among other things) and there is no doubt about...

The Log Chain

I ran across a question recently from someone that received a similar message to the one showed in this image:

In...

Exploring the Microsoft Azure HDInsight Query Console (No Scripting Required)

As I noted in my previous post, I am not a fan of scripting. In that post we set up...

SQLSaturday & The Speaker Wait List

When a new SQLSaturday event is launched an email is sent to all the speakers who have opted in to...

Assigned reading: FREEPROCCACHE

I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one...

Automatic Roll Forward Transaction Log Backups

Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore...

Query cost and Query Execution time - Difference

This post is my 100th post 🙂 Was inactive in blogging for few years in between. Now back in full flow....

Outlier Detection with SQL Server, part 7: Cook’s Distance

By Steve Bolton[
…………I originally intended to save Cook’s and Mahalanobis Distances to close out this series not only because the...

Compressing Outcomes

Find yourself struggling to determine the outcome of attempted compression settings in your database? This should help!
Related Posts:

Failed to Create the Audit File December 31, 2017

Disk Space and...

Compressing Outcomes

You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a...