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

WWH of SSIS Zero to Hero in SSIS series (How to Use SSIS ?) TIP #112

Hello Friends,
Welcome, back to Zero to Hero in SSIS series(Post #110). In last post #111 ,We gone through the WW...

Pick the Right Database in Azure

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...