Backing Up and Restoring Your On-Premise Databases To and From the Cloud

I’ve been meaning to start a series of posts on “Dipping your toes into the cloud” for a while now,...

Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped. There is insufficient system memory in resource pool ‘internal’ to run this query.

Today my colleague had issue that SQL server...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Let’s talk SQL Server Waits: Topic 2 – CXPacket

With our effort to talk about SQL Waits we come across another common wait called CXPacket. Last week we reviewed...

Multi-server scripts with SSMS using SQLCMD mode

SSMS is the most common tool used by SQL Developers or DBA’s but unfortunately there are some features that are...

See SQL Run

Note: I am perfectly aware of my ability as an artist so let the ribbing begin

Speaking at SQLBits in March 2019

I have been selected to speak for a second time at SQLBits, which is being hosted in Manchester UK this...

Understanding and working with NULL in SQL Server

Graphic representation of the difference between 0 and NULL
Image taken from 9gag.comAccording to database theory, a good RDBMS must implement...

Understanding and working with NULL in SQL Server

Graphic representation of the difference between 0 and NULLImage taken from 9gag.com

According to database theory, a good RDBMS must implement a marker to indicate "Missing or inapplicable information".SQL Server...

Webinar next week on Database DevOps

Next week is my webinar on why the database is the heart of DevOps. You can still register today to...

Authentication considerations for your applications when migrating to Azure SQL Managed Instances

This blog post is related to my previous blog post on Azure SQL Managed Instances:
Azure SQL Managed Instance – full blown...