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

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