2026-07-20
628 reads
2026-07-20
628 reads
When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens.
2026-07-10
2,546 reads
2026-06-22
481 reads
2026-06-10
748 reads
2026-06-03
275 reads
A dangerous privilege-escalation path exists in SQL Server when cross-database ownership chaining, system database defaults, and overly permissive permissions are combined.
2026-04-24
Every few years, someone asks a familiar question: do we really still need to disable the sa account in SQL Server? After all, it’s 2026. SQL Server has better encryption, better auditing, better defaults, and more security features than ever before. Surely this old guidance belongs in the past?
2026-03-20
This article presents a way to check and validate input before using it in your dynamic SQL queries to prevent SQL Injection problems.
2026-03-02
4,472 reads
Windows is changing its security, which will affect SQL Server.
2026-02-14
510 reads
This article is a follow-up to SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data, in which we saw some vulnerabilities that affected pretty much all DBaaS offerings available in the cloud. Now, we’ll look at another vulnerability that once again affects every major cloud vendor.
2026-01-30
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Comments posted to this topic are about the item SQL Server Certificates
Comments posted to this topic are about the item Connect an Azure Function to...
Comments posted to this topic are about the item The SQL Server 2016 Plan
Which of these is not true for certificates used for SQL Server connections?
See possible answers