Practical Reporting Queries with CROSS APPLY (Part 3)
This article continues the series on APPLY, showcasing how some practical reports can be implemented using this operator.
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?
Evaluating a DBA (or AI)
Steve has a few thoughts on hiring and the way in which you might want to evaluate a DBA candidate.
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Learn about a Type 4 Slowly Changing Dimension in this article by Dinesh Asanka.
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.
An Azure Outage
Recently the Azure service had an outage and Steve Jones has a few comments on this and why it might not be worse than your own company's IT group.
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
See how SQL Server 2025 uses Optional Parameter Plan Optimization to create separate plans for selective and unfiltered searches, how to verify the dispatcher and variants, and when dynamic SQL or recompilation is still the better choice.
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.
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Lumajang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Panglima Besar Sudirman No.27, Tompokersan, Kec. Lumajang, Kabupaten Lumajang, Jawa Timur 67311
Alamat Telp BCA KCP Banjar Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Letjen Suwarto No.1A B-C, Hegarsari, Kec. Pataruman, Kota Banjar, Jawa Barat 46322
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers