Changes to Service Packs and Cumulative Updates for SQL Server 2017

For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update...

DELETE data on SQL Server HEAP table – Did you know…

Before I complete my question let me provide context. I've received an alert saying that a specific database could not...

Enabling Database Containment for an Instance – #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .

 
Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...

How the gym made me a better database bloke…..

A blog post about how many reverse bicep curls or Romanian DeadLiftsI can do…? As Rob Farley (t | b | w)...

Introduction to SQL Server replication

This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster Recovery (DR), load balance your applications or any other...

Limiting resources available to containers

One question that I get asked regularly is, “can you limit the host resources to individual containers?”
This is a great...

Policy Based Management and Powershell

Introduction

Policy Based Management (PBM) can be used to inform DBAs when an incorrect setting is being used on a SQL...

SQL Sequence vs Identity Column

Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you...

The Alpha and the Omega. The BEGIN and the END.

The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do...