The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.
2026-07-29
1,907 reads
From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.
2026-07-29
1,907 reads
This article examines three recurring database-layer failures documented in the EDPB’s 2026 enforcement findings: the complexity of executing erasure across relational schemas, the backup paradox that can silently undo compliant deletions, and the audit log contradiction that traps organizations between two competing obligations.
2026-07-14 (first published: 2026-07-13)
Keeping track of all the security related logs can be hard. Using your security team to shoulder some of the load can help. Learn how in this article.
2024-12-16
3,983 reads
In this article, we look at how to audit and monitor the use of SQL Server extended stored procedures in your database instance.
2024-10-28
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.
2024-09-18
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
This is the second part of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. It covered some items to check at the hardware level and configuration items, but this section gets into more detailed hardware auditing details.
2024-08-07
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column in the Stack Overflow database.
2024-06-03
2024-02-21
422 reads
An audit finding relating to production data, containing customer identifiable data, in a UAT environment, prompted this simple script, which completely scrambles data in such a way that the original value can not be reconstituted.
2023-05-24 (first published: 2023-05-19)
927 reads
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
No two SQL Server environments are alike. A fix that resolves a performance issue...
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Hello experts, An application team has asked us to modify a SQL Agent job....
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...