The article covers four connected areas: over-privileged database users, msdb and SQL Server Agent exposure, privileged maintenance jobs, and trigger-based permission hijacking.
2026-08-10
Learn how the BIT_COUNT() function works and how it enabled operations where data is stored in bits.
2026-08-07
4,132 reads
In this tip, we’ll look at some best practices to help you get the most out of your models. We will also look the DAX formula language.
2026-08-07
This article goes into one of the new regular expression functions in SQL Server 2025: REGEXP_LIKE().
2026-08-05
5,018 reads
AI developer tools have matured fast. In 2026, most engineering workflows touch at least one AI coding agent, code reviewer, or research assistant — but the right combination depends heavily on your team size, codebase, and tolerance for setup overhead. This guide breaks down the tools actually worth using across three categories: research and architecture, day-to-day development, and code review, based on real, hands-on experience.
2026-08-05
This article looks at replacing a cursor with a window function to improve performance.
2026-08-03
6,495 reads
You've heard that page splits are bad, and they're an indication that your table design is making your storage work too hard. You've heard that the right answer to fix it is adjusting fill factor lower, or doing regular index maintenance.
2026-08-03
This article covers a few common errors when attaching database files to an instance, with some information on how to resolve the issues.
2026-07-31
1,215 reads
Although ‘Big Data’ (and more specifically, the analysis of it) offers several benefits, organizations often fail to derive the correct insights – the data that could help them make better business decisions. So, in this article, I’ll reveal exactly how organizations can take full advantage of these large datasets to make those better business decisions and improve operational effectiveness.
2026-07-31
From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.
2026-07-29
2,353 reads
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers