I wrote a stream-of-consciousness post a few months ago about what I do in my day job at Microsoft, working in the Database Docs team. Basically we spend most of our day in an obscure… The hell of Git line endings and the (not so) simple fix
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 is this: when you’re setting up a machine, you don’t… Choco upgrade, y’all
This post is brought to you — indirectly — from a boss I loved working for, on a project which almost killed me, at a company which I had to walk away from to restore… Read the error message
[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 something that I’ve been struggling with for a number of… 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 side-road into deterministic values, and why it is important to… 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 in the right context!), I kept running into the same… 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 to use hashes (or even no passwords!) without annoying the… Convert legacy password storage without aggravating your users
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. |￣￣￣￣￣￣￣|| CONTAINERS || ARE NOT | | VIRTUAL || MACHINES ||… What is a container anyway?
There was an interesting conversation on Twitter recently, between Grant Fritchey (blog | twitter), Kenneth Fisher (blog | twitter), Anthony E. Nocentino (blog | twitter), Vicky Harp (twitter), and me about containers and SQL Server.… 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 the source for official Docker container images for Microsoft products.… SQL Server containers no longer being updated in the Docker registry
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 2 March 2019. My session is called An overview of… Speaking at SQLBits in March 2019
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: Microsoft reversed this decision with SSMS 18.1, and the designer… 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 smile to my lips every time I read or say… 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 I retrieved from a log file) said: Extension node not… 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 go into technical detail. Parts of it may be wrong.… A software architect replaces a relational database with a relational database