PowerShell : Monitoring and Notification – Disk Space Alerts

“Microsoft Technet Guru – Gold Medal Winning Article- Nov, 2016”

Abstract
Monitoring disk space utilization of server(s) is the critical and important job for...

Replay your workload through the Query Store Replay script!

One of the great features of the Query Store is that it stores query execution plans and runtime performance on-disk...

Speaking at SQLSaturday Nashville!

Speaking at SQLSaturday Nashville!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 14th 2017! This...

Speaking at SQLSaturday Nashville!

Speaking at SQLSaturday Nashville!
I’m proud to announce that I will be speaking at SQL Saturday Nashville on January 14th 2017! This will be my first speaking event this year...

The Trails We Leave

Over the weekend I got an email from have i been pwned, a website that tracks data breaches and notifies...

What is – DML, DDL, DCL and TCL in TSQL?

In transact SQL , different type of activity performed ,like we can create database , manipulate date , update, delete even control access...

What is “SET STATISTICS TIME”?

When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...

What is “SET STATISTICS TIME”?

When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...

What is “SET STATISTICS TIME”?

When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...

Deploying a Windows Data Science Virtual Machine to Azure with PowerShell easily

This weekend (10 December 2016), I went to Slovenia for a SQL Saturday. As always, it was an amazing event...