Simple Talk

If your T-SQL is buried under layers of nested REPLACE() calls just to swap out a few characters, there’s a simpler way. SQL Server’s TRANSLATE() function — introduced in 2017 but still rarely used — lets you replace multiple characters in a single string with one function call instead of stacking several REPLACE() functions inside each other.

Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently launching a set of official

PASS Data Community Summit is celebrating a milestone most communities never reach: 25+ years of data professionals showing up for each other. From a single Microsoft-seeded user group in 1999, to the global, multi-platform conferences everyone knows today – here’s how it all unfolded.

This story was originally posted on the

SQL Server DBAs routinely rely on automation: SQL Server Agent jobs, maintenance plans, refresh processes, restore scripts, replication cleanup, CDC operations, cross-database modules, and temporary objects. These workflows are often trusted because they’re normal – and that’s precisely why they deserve more attention.

The goal of ...

PostgreSQL replication is one of the most powerful tools available for keeping your database resilient, redundant, and performant, but it’s only effective when it’s stable. Replication lag, network bottlenecks, and long-running transactions can each quietly erode the reliability your applications depend on.

This guide breaks down how replic...