[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
For the longest time PASS was known as the Professional Association for SQL Server, and made all of its money from a single event each year, the PASS Summit. If you’ve ever attended a SQLSaturday, you’re… Finally, PASS is a proper association now
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available in Azure SQL Database, UTF-8 is exciting if you have a legacy database and application that needs to support Unicode strings… Fun and profit with UTF-8
Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little beefier. There were ten virtual machines on the SuperMicro server, nine which were allocated 127 GB of thin-provisioned storage, and one… Managing virtual machine drives on ESXi
After being selected to present my full day pre-conference session at the Summit, I am very pleased to announce that I will also be presenting my Database Administration Through the Ages talk that originated at… I am speaking at the PASS Virtual Summit 2020
At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data Studio, and was asked by Chris Wood to share all… These are the extensions I have installed on Azure Data Studio
An important change to the MAXDOP documentation was made last week, with a good write up by Pedro Lopes (Twitter), a Program Manager on the SQL Server team at Microsoft. First though, some background on… MAXDOP: not quite what you think
A short post this week, to let you know that I’ll be presenting a brand new session to the Edmonton PASS user group (EDMPASS) next Thursday. It will be an online session, and you can… Speaking at the Edmonton PASS user group on 16 July 2020
It’s Canada Day here, the commemoration of the country’s confederation in 1867. Given events over the last few months such as the worldwide pandemic, followed by a number of politically-motivated movements for change across the… Canada Day 2020
One of my hobbies is trying to break technology so that you don’t have to. I don’t consider myself a professional or hobbyist hacker, though if the shoe fits… Last year when Windows Server 2019… Unsupported but working versions of SQL Server on Windows Server 2019
This week we’re looking at how the database engine stores GUIDs (globally unique identifiers), specifically known as UNIQUEIDENTIFIER in SQL Server. If you would like to read about storage of other data types, here are… How SQL Server stores data types: UNIQUEIDENTIFIER
In this post we are looking at how SQL Server stores floating point values (FLOAT and REAL). If you’d like to read the previous posts in this series of how SQL Server stores data types,… How SQL Server stores data types: floating points
On Twitter, Michael Dyrynda writes: ⚠️ Never ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever… How should I store currency values in SQL Server?
In this post we look at how SQL Server stores currency values using the MONEY and SMALLMONEY data types. If you’d like to read the previous posts in this series of how SQL Server stores… How SQL Server stores data types: money
As longtime readers know, I am also a software developer (we can’t call them engineers in Canada for legal reasons). I took over a complex codebase last year in a field I’m unfamiliar with, and… An insidious form of SQL injection