Sign up to our blog and get e-mail notifications for new entries
SQL Server knowledge. Shared.
Read our latest blog entries
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
A new chapter begins
In 2012 when I originally founded Born SQL, I never imagined I would find myself a five-time recipient of the Microsoft Data Platform MVP award, let alone be offered a job to work for Microsoft alongside amazing people including William Assaf and Kendra Little. It is a bittersweet moment for me to hang up my consulting
-> Continue reading A new chapter begins
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
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
And that’s a wrap
It’s the final week of 2021, a year that was both twice as long and half the length of 2020. If you can, please make sure you are vaccinated and boosted. It doesn’t prevent infection, but it does make the experience less awful. If you’re a recent recipient of COVID-19, please do your level best
-> Continue reading And that’s a wrap
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
You can’t run SQL Server on Apple Silicon, and it sucks
Prior to 2017, the only way to get SQL Server running on a Mac was through a virtual machine running some version of Windows that supported some version of SQL Server. Then SQL Server 2017 — and later SQL Server 2019 — were made available as Docker images, thanks to the newly-introduced Linux support in
-> Continue reading You can’t run SQL Server on Apple Silicon, and it sucks
Your next step in the cloud
Over the last nine months I’ve presented (virtually) eleven times on a variety of topics relating to SQL Server and the Microsoft Data Platform. Long-time readers will know I have some experience as a high school teacher and college lecturer, and I’ve co-authored three technical books on SQL Server. My most popular session at the
-> Continue reading Your next step in the cloud
Be careful with table updates
The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those of us who need to audit changes to a database. This is even more important now as SQL Server 2022 approaches, with its new system-versioned ledger tables which record everything.
-> Continue reading Be careful with table updates
Calgary Data User Group: Big Data Clusters with Bob Pusateri
This is one of those shameless plugs I’m allowed to do from time to time to promote my user group here in Calgary. Tonight, starting 5pm Mountain time, Bob Pusateri (blog | Twitter) will be presenting an hour-long session about Big Data Clusters, a very interesting feature that was introduced with SQL Server 2019. From
-> Continue reading Calgary Data User Group: Big Data Clusters with Bob Pusateri