[Edited on 5 August 2021 with some pseudocode at the end.] This is not a post about SQL Server, but I need to write about… Read More »Using the Xero OAuth 2.0 API from a .NET Core console application
After last week’s post about using WITH (NOEXPAND) to query indexed views even on SQL Server Enterprise Edition, this week is a short but interesting… Read More »Using indexed views? What is an imprecise or non-deterministic convert?
Today after fighting with designing a view that let me create a clustered index on it (indexed views — also known as materialized views — are awesome… Read More »Using indexed views? Don’t forget this important tip.
In a previous post I wrote about storing password hashes in a database, which raises the question of how to convert an existing legacy password storage system… Read More »Convert legacy password storage without aggravating your users
There was an interesting conversation on Twitter recently, between Grant Fritchey (blog | twitter), Kenneth Fisher (blog | twitter), Anthony E. Nocentino (blog | twitter),… Read More »Containers and data: you gotta keep ’em separated
In October 2018, Microsoft announced a change to the source of their Docker containers. You should be using the new Microsoft Container Registry (MCR) as… Read More »SQL Server containers no longer being updated in the Docker registry
A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams feature from v18.0 onward. [Edit:… Read More »Database modelling in a post-SSMS world: dbForge Studio
I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK and POKE, all bring a… Read More »Infrastructure matters, even in the Cloud
A few months ago I ran into a problem after updating Visual Studio for Mac, where it would not start. The actual error message (which… Read More »Repair Visual Studio for Mac: Extension node not found in path
Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is no doubt biased. It might… Read More »A software architect replaces a relational database with a relational database
Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is no doubt biased. It might… Read More »Relational databases aren’t the problem