Slides and Demos for SQLSupper August meeting

Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols including a rather fun live demo.
The slides and demo...

Speaking at SQLSaturday Oslo

This weekend, I’ll hop on a plane and fly over to Norway for SQLSaturday Oslo.
I’ll be delivering a session I...

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