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

Stock Market Chart in Power BI

U.S. stock markets have taken a beating this past week fueled by China markets. Take a look at how China and...

Setting Up an HDInsight Cluster (No Scripts Required)

Let me start by saying, I am not a fan of scripting. It definitely has its place and a lot...

Targeted Plan Cache Removal

A lot of times you’ll hear how people are experiencing sudden, intermittent, poor performance on a query, bad parameter sniffing...

The tail of the log

The tail of the log
A little while back I was feeling overwhelmed by the number of blog posts ideas that...

Above All, Good Judgment

What is permissible is not always honorable. – Marcus Tullius Cicero
Rules. Best practices. Guidelines. Design patterns. Policies. All are good and...