MySQL and Backups As A Service

With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more...

Setting Up a Subscription

In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I...

SQL Server 2017 running on Windows Containers!

One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is – Why you want to run SQL Server on...

SQL Server 2017 running on Windows Containers!

One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is...

SQL Server Management Studio v17.0

Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...

Using DBCC Clonedatabase

I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw...

Continuous Integration

It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us...

DBA 101: Tuning lookups

Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a...

Dynamic Data Masking

By David Postlethwaite

Introduction

Dynamic data masking is a really useful new tool in SQL Server 2016. Keeping data safe is one...

Extended Events – I am dangerous (sometimes)

I did a dangerous thing, and I want to make sure that YOU DO NOT do the same. I was...