2024-04-05
719 reads
Thomas Franz
Get the Most Current Row From a Detail Table
This article compares the performance of finding the most recent row in a child table for updates, looking at four possible solutions.
2023-07-10
3,739 reads
2023-04-19
644 reads
2020-01-23
919 reads
2019-10-28
547 reads
2019-08-26
1,163 reads
2019-06-17
829 reads
2019-02-11
870 reads
2019-01-04
988 reads
2018-10-12
952 reads
Blogs
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Forums
Why SQL Server Orphaned Users Cause Login Failures
SQL Server Orphaned Users often appear after restoring or migrating a database to another...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers