There's your problem

The denial-of-service attack is coming from inside the house

A short post this week. While I was helping some friends recently, we experienced a curious thing where as soon as an application was started up, it was immediately followed by a denial-of-service attack that played out in the most mundane way you can imagine. The application itself is an API that is replacing the
-> Continue reading The denial-of-service attack is coming from inside the house

Microsoft Office logo

Checking accessibility in your day-to-day work

Last year I wrote a series of posts about accessibility as it relates to presentations, and one aspect which I didn’t cover is within the documents themselves. We create slides with wonderful typeface choices, clear text, minimal animations, good colour choices, and so on, but what happens when we need to share those documents with
-> Continue reading Checking accessibility in your day-to-day work

Calgary Data User Group

Database Projects 101 in Azure Data Studio (Calgary Data User Group)

On Wednesday February 23rd, 2022, the Calgary Data User Group will be hosting our first user group session of the year, featuring Warwick Rudd. The topic is an introduction to Database Projects in Azure Data Studio, the cross-platform tool for connecting to SQL Server and Azure SQL Database. Here is the abstract: Database Projects are
-> Continue reading Database Projects 101 in Azure Data Studio (Calgary Data User Group)

a coffee filtering process

Don’t optimize for ad hoc workloads as a best practice

(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held belief systems that don’t take new information into account, and how confirmation bias is not a good motivator for recommending best practices. Let’s talk about the
-> Continue reading Don’t optimize for ad hoc workloads as a best practice

DataGrillen logo

Join me in Germany in June

I have been selected to speak at the DataGrillen conference later this year. I will be presenting my session How Does SQL Server Store That Data Type?, which I debuted during last year’s EightKB online conference. This is the abstract for the talk, which will be presented on Thursday June 2nd, 2022, from 1:15 pm – 2:15 pm in
-> Continue reading Join me in Germany in June

Output from SELECT @@VERSION;

SQL Server 2019 on Apple Silicon redux: it actually works

Last month I wrote a blog post suggesting that it was not possible to get SQL Server 2019 running on Apple Silicon. I hedged my statement by saying you could get Azure SQL Database Edge running in a Docker container instead, but at the time I could not get SQL Server itself to work at
-> Continue reading SQL Server 2019 on Apple Silicon redux: it actually works

Rest In Peace PASS

One year later: my look back on the PASS organization

My good friend and talented singer Rob Volk reminded me recently that I had promised to write about my involvement with PASS at the end of its life, and I remember saying out of respect that I’d wait a year before doing so. Time flies. To recap, the few remaining assets of the PASS organization including
-> Continue reading One year later: my look back on the PASS organization

hands holding injection for vaccination

On the nature of constant change

Recently my spouse and I travelled to South Africa (yes, I know there’s a pandemic on) to deal with a gloomy family matter that required in-person interaction. Being an adult means dealing with things that other people can’t do or don’t want to do. Literally hours after we arrived, hot on the tail of South
-> Continue reading On the nature of constant change