Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.
2024-02-03 (first published: 2024-01-03)
4,905 reads
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
8,878 reads
Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
2023-11-20 (first published: 2023-11-15)
13,240 reads
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,723 reads
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,740 reads
Here's why you should NEVER use the FORMAT() function in SQL Server.
2022-08-05
21,315 reads
Introduction to Query history and server reports i...
2022-03-14
9,645 reads
It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In this article, Edward Pollack demonstrates how to collect extended event data.
2021-11-03
SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom about one counter, SQL Compilations/sec, can sometimes be misleading.
2021-08-20
SQL Server provides information for troubleshooting performance. Ed Pollack demonstrates collecting SQL Server performance monitor data.
2021-08-11
By Steve Jones
Rodney Kidd took some great shots of the keynote and published an album here:...
By Brian Kelley
here is the compiled video of the Red Teaming course Microsoft put together.
Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...
Comments posted to this topic are about the item Fabric Mirroring
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item How Important Are Real Time...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers