Choco upgrade, y’all
Chocolatey is a package manager for Windows, like the built-in package managers on Linux, and third-party ones on macOS like Homebrew and MacPorts. The idea… Read More »Choco upgrade, y’all
Home »
Development
Read the error message
This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a… Read More »Read the error message
Using the Xero OAuth 2.0 API from a .NET Core console application
[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
Using indexed views? What is an imprecise or non-deterministic convert?
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?
Using indexed views? Don’t forget this important tip.
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.
Convert legacy password storage without aggravating your users
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
What is a container anyway?
Recently there was a thread on Twitter which established that a lot of IT people didn’t know the difference between virtual machines and containers. |￣￣￣￣￣￣￣||… Read More »What is a container anyway?
Containers and data: you gotta keep ’em separated
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
SQL Server containers no longer being updated in the Docker registry
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
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 year from 27 February to… Read More »Speaking at SQLBits in March 2019
Database modelling in a post-SSMS world: dbForge Studio
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
Infrastructure matters, even in the Cloud
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
Repair Visual Studio for Mac: Extension node not found in path
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
A software architect replaces a relational database with a relational database
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
Relational databases aren’t the problem
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