Stairway to SQL Server Replication: Level 3 - Transactional Replication – The Publisher

The Publisher is the database where all
replicated data originates. Each Publisher can have multiple publications
defined within it. Each publication contains a set of articles that all need to
reside in a single database. Each article corresponds to all or part of a single
database object. A single database object can map to an article in more than one
publication.

The SPU

We have GPUs for graphics, why not SPUs for SQL?

The Tech That is Gone

As we start a new year, Steve looks back at old technology that doesn't exist anymore.

Express.js or Next.js for your Backend Project

In this article, I will introduce two JavaScript frameworks that can be used to build backend projects.

Setting up for Team-based Database Development using Flyway Desktop

This article provides a simple demonstration of how a small team of developers might set up a Flyway Desktop project to manage, automate, and control database development.

Indexes: When Column Selectivity Is Not Always A Requirement

While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]

No Time for Testing

Testing software is important, but we always seem to find reasons not to. Steve Jones has a few thoughts about testing.

Should You Use SQL Server 2022’s STRING_SPLIT?

SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, that’s the only thing they improved – there’s still a critical performance problem with it.

The Importance of a Good Data Model in Power BI Desktop

A New Year, New Efforts

Happy New Year! You're going to be seeing a lot of summaries for 2022 and predictions for 2023 around this time of year. I'm not writing one of those. You'll also see people calling for new years resolutions and the like. I'm not going for that either. Nope, let's keep it simple. It is a […]