SQL Agent Permissions

Problem

I was contacted by a user asking if it was possible for his team to be able to execute specific...

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

Database Configuration

It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...

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

On Being Disruptive

Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just...

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

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 for them. Licensing is given at the end of...