Database Backups – Back to Basics

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

R and SQL Server 2016

Yesterday, I delivered another session for Singapore SQL PASS Chapter. The session titled "R and SQL Server 2016" was giving...

KPIs in SSRS 2016

Key performance indicators, or KPIs, are at-a-glance metrics for simple insight into the business. These are each designed to provide...

Power BI Custom Visuals Class (Module 30 – Linear Gauge)

In this module you will learn how to use the Linear Gauge Power BI Custom Visual.  The Linear Gauge would...

Automating DBCC Page

Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will...

Data gateway confusion

Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...

Run Book, Run!!!

How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains...

sp_helptext vs object_definition()

I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...

SQL Agent Permissions

Problem

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

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