How to Configure TDE database with AlwaysOn using the Azure Key Vault in SQL Server 2016

One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to...

Speaking at SQL Saturday Denver (#673)

Wow, I can hardly contain my excitement.  I was selected to speak at SQL Saturday Denver on September 16, 2017.  I’ll...

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...

Information Measurement with SQL Server, Part 1: A Quick Review of the Hartley Function

By Steve Bolton
…………This long-delayed series of amateur self-tutorials has been in the works ever since I began writing my A...

Using Test-DbaOptimizeForAdHoc

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...

Friday Reading 2017-07-28

Hope you all had a good week. Been pretty chilled out here so I’ve been reading…
Announcing Azure Container Instances

Microsoft blog...

“Does that copy subscriptions too?” – Now it does! New PowerShell SSRS commands

On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the...

SQL Server on Linux Series: Moving TempDB

In the last blog post, we added additional drives to the SQL Server machine so that we can scale out...

Two Ways to Restore Database from MDF File in SQL Server

Introduction
In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large level. In such context SQL Server is the best...