SQL ROUND Function vs. Bankers Rounding with T-SQL
Learn about rounding values using T-SQL and how the ROUND function works compared to creating a user-defined function for bankers rounding.
2024-09-06
Additional Articles
I Must Be an Idiot: Automatic Tuning Never Works for Me.
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a smoke break rather than showing up for work.
2024-09-04
How to Slice Data by Fiscal Month using DAX for Power BI Reports
In this article, learn how to set the current fiscal month identity in a calendar table using DAX for Power BI when dealing with fiscal periods.
2024-09-02
Is it still worth it to sponsor PASS Summit?
Conference planning is underway. Several folks have asked me whether I think the PASS conference is still worth exhibiting. I thought an article would be best to break down my thoughts. I’m in an interesting position, being a marketing leader who also specializes in SQL Server and doesn’t work for Microsoft. I’ve worked directly for several companies in the ecosystem, so I know how difficult reaching the DBA market has been post-pandemic.
2024-08-30
Microsoft Fabric: Using Lakehouse data in Real Time Dashboards
Real-Time dashboards are a great feature in Real Time Intelligence experience to monitor our data. However, by default ...
2024-08-30
Is your DevOps strategy missing a vital link?
Database DevOps practices can help you ship features faster, but how do you safely enable this, and ensure those updates will successfully deploy? Redgate Test Data Manager was developed to resolve bottlenecks and challenges, helping organizations ship deployments they can trust by enabling developers and testers to self-serve test data that walks and talks like production with sensitive customer data taken care of. Read more on the blog.
2024-08-28
Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
Learn about object-level, column-level, and row-level security in Microsoft Fabric Warehouse and how this can be implemented to limit access to data.
2024-08-28
Days of the Week, Bitwise Edition
I recently had to help support synchronization and distribution of workloads between multiple servers.
2024-08-26
SQL Local Variables and Performance Issues
In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.
2024-08-23
Auditing SQL Server – Part 3 – SQL Server Configuration Audit
This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm.
2024-08-21
Blogs
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Why I stopped using MCP for AI coding stuff
By HeyMo0sh
Something has shifted quietly in 2026. The developers I know/respect—the ones actually shipping, not...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers