Index maintenance freebies

I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log...

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

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

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

See SQL Run

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

Azure Advisor

Azure offers a lot of value-added services included with the price of what you pay . One of the things really,...

Azure Kubernetes Service Error – LoadBalancer type service external IP stays pending

Last week I was working on my Azure Kubernetes Service cluster when I ran into a rather odd issue. I’d...

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! ]]

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