SQL Server 2016 has reduced the NoSQL JSON “advantage” over SQL Server

 Microsoft has finally implement support for JSON data in SQL Server 2016 and in Azure SQL Database. In a previous...

Database Backup History – Back to Basics

In this article I explore the basic of querying backup history data as a foundation to reporting on essentials such as storage and job management.
Related Posts:

The Mystery of Missing...

Database Backup History – Back to Basics

Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...

Report Portal in SSRS 2016

SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...

SQL Server and Hyper-threading

This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...

Last Restore of a Database – Back to Basics

In this article I explore the basics around how to determine when a database was last restored.
Related Posts:

Changing Default Logs Directory - Back to Basics January 4, 2018

SQL...

Last Restore of a Database – Back to Basics

Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...

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

New whitepaper with ScaleArc

I’m pleased to announce a new collaborative whitepaper with ScaleArc entitled “Improving uptime and performance of legacy apps on Microsoft...

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