Migrate SQL Server Databases to Different Active Directory Domain
We want to leverage Distributed Availability Groups to migrate our databases to a different Active Directory domain. How do we go about it?
2026-09-25
Additional Articles
Database Animations: The Interview Question Everybody Gets Wrong
No no, I'm not just talking about the people answering the interview question. I'm talking about the people asking the question.
2026-09-23
What is cloud database vendor lock-in? The 3 types explained (and how to audit yours)
Cloud database vendor lock-in is one of the most expensive surprises in enterprise infrastructure — not because the dependency is hidden, but because most teams never quantify it before committing to a platform.
2026-09-21
Foreign Keys and Performance in a Microsoft Fabric Warehouse
I wanted to answer a simple question: Do relationships help, hurt, or have no effect when added to tables in a Fabric warehouse?
2026-09-18
SQL Server login failures: how to monitor, report, and alert on them
This guide walks through how to pull login failure data using sys.xp_readerrorlog, filter it by time and error type, parse it into readable columns, aggregate repeat offenders, and automatically email a summary report — turning a passive log file into an active security and troubleshooting tool.
2026-09-16
Database Animations: What’s a Residual Predicate and Why Is It Bad?
Normally when you're looking at an execution plan, and you see an index seek followed by a key lookup, that means it's running relatively quickly.
2026-09-14
9 things I wish SQL Server had (and why they’d matter)
Anyone who’s spent years writing T-SQL has a mental list of “why doesn’t SQL Server just do this already?” moments. Here are 9 of those from Louis Davidson’s perspective – a wish list of practical, coding-oriented feature requests drawn from real-world pain points.
2026-09-11
How Azure Arc allows a DB admin to become SQL Server sysadmin – the vulnerability explained
Azure Arc-enabled SQL Server is designed to bring on-premises and multi-cloud SQL Server instances under centralized Azure management, but a newly documented privilege escalation technique shows how that same management workflow can be turned against the server it’s meant to protect.
2026-09-09
JSON indexing in SQL Server 2025: how it works and current limitations
This guide has everything you need to know about JSON indexing in SQL Server 2025: what it is, how it works, and current limitations.
2026-09-07
How to avoid nested REPLACE functions with TRANSLATE in SQL Server
This guide covers how TRANSLATE() works, how it compares to REPLACE(), and where it falls short compared to other SQL dialects like PostgreSQL and Oracle.
2026-09-04
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers