Backup and Restore Strategies in SQL Server : A Brief Introduction

Establishment of a successful business requires the proper maintenance of the data. SQL Server is one the popular platform for...

Generating Frequency Table

This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...

Help Me, Help You, Deliver DevOps

I believe in DevOps.
Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.

I...

TDE: Looking inside your database and backups

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...

Testing Your SQL Server Backups the Easy Way with PowerShell & dbatools

In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from...

The parts of an object’s name

Any object within a database in SQL Server has what is called a four part name. Which rather implies four...

Webinar with Pure Storage Mar23 2pm Eastern

On Thursday, March 23rd, at 2pm Eastern, I will be hosting a webinar with Argenis Fernandez from Pure Storage where...

An Introduction to SQL Server 2016 Query Store

By David Postlethwaite

David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this...

Friday Reading 2017-03-17

As this is being posted I’m on my way up to Dublin Airport to catch my flight to Iceland ready...

New Article – Application Database Security Design (Part 1 – Authentication)

In conjunction with the webinar I gave last month for MSSQLTips, I’ve started an article series on application database security...