In the first post of this series, we learned about a new type of system-versioned table that also works at the database level and introduces a mechanism that demonstrates whether your database has been tampered… System-versioned ledger tables: the next step
Choosing the right typeface for your presentation (or for that matter anything you create that contains words) is fraught. In a previous post I wrote about the difference between serif and sans-serif. I mentioned font… Accessibility in font choice
As long-time readers of this blog know, I’m a big fan of temporal tables, also known as system-versioned temporal tables. Until recently, temporal tables were synonymous with system-versioned tables, but all that changed a short… Introducing system-versioned ledger tables
Right off the top here, I must note that the term “dead man’s switch” is archaic, so for the rest of this post I’ll refer to it as “operator presence control,” or OPC. The concept… Why you need a Dead Man’s Switch
I have previously written about accessibility in video captions, presentation slides, and disabilities, and I thought I should expand on the latter topic as it relates to typefaces, or what we call “fonts.” To be… Let’s talk about typefaces
During routine maintenance on a customer’s production server, I discovered that they have one table consuming 40% of the storage in their database. That table contains just under 10 million rows, which isn’t that remarkable;… Think twice about storing JSON in your SQL Server database
I may be completely off base here, but I’ve noticed a correlation between folks who use Amazon Web Services and their understanding that once you scale up a service during a busy business period, you… Scaling down in the cloud
This coming Friday the 13th (August 2021) is the first ever Dativerse virtual conference, hosted by our DataGrillen friends William and Benjamin. According to their site: We try to elevate those that are usually underrepresented… Join me on 13 August 2021 for Dativerse
Although I don’t write about it much on this website, I am on the autism spectrum, and I have ADHD. I need to sit at the front of a room because it helps me see… Accessibility is not just about slides
This post is part of the series I kicked off here. You can read my post about captions here. Let’s talk about slides! Many of us are familiar with producing slide decks for talks and… Accessibility in your PowerPoint slide deck
Next week on Wednesday 28 July 2021, I will be presenting a brand-new session titled “How SQL Server stores that data type” for the free EightKB virtual conference. I’ve made it a 500-level talk, as… Join me at the EightKB virtual conference on 28 July 2021
My user group, the Calgary Data User Group, has been recording videos since April of this year, so at the time of this writing we have just two videos on our YouTube channel. As one… Accessibility after the fact: closed captions for videos
Today I want to write about the community that brought us all together. The community that got this very website on your radar. The community that got many of us spending lunch breaks, evenings and… On accessibility in our community
In early 2011 Jes Borland invited us to write about aggregations: I want to hear how you solved business problems with aggregate functions. I want to see your cool T-SQL tricks. How are aggregates used… T-SQL Tuesday Retrospective #015: Aggregations
It has been some time since I last wrote about Azure SQL Database. Although it has been more than three years since SQL Server 2017 was released, Microsoft have not been resting on their laurels.… A summary of new features in Azure SQL Database