Tag: database security

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

17 Feb 2023 · 6 min read

“SQL Server 2022: Rapid-Fire Updates Enhance Performance and Security”

Microsoft released SQL Server 2022 CU1 and a GDR within two days of each other, addressing critical backup corruption risks, security vulnerabilities, and memory management issues.

Read article →
1 Aug 2019 · 6 min read

SQL Server 2016 SP2 CU8: A Must-Have Update for Improved Performance and Security

SQL Server 2016 SP2 CU8 addresses 13 significant bugs including broken encrypted backup restores and Dynamic Data Masking failures. Here is what was fixed and why it matters.

Read article →
30 Jul 2019 · 6 min read

Stay Ahead of the Game with SQL Server 2014 SP3 CU4: The Latest Cumulative Update for Improved Performance and Security

SQL Server 2014 SP3 CU4 addresses critical fixes including filtered index corruption, Extended Events crashes and SSISDB blocking. Here is what you need to know before patching.

Read article →
17 Apr 2019 · 6 min read

New Updates Released for SQL Server 2014 SP3 and SP2: CU3 and CU17 for Improved Stability and Security

Microsoft released SQL Server 2014 SP3 CU3 and SP2 CU17 in August 2021 with targeted fixes for performance, backup reliability and security. Here is what you need to know before deploying.

Read article →
20 Feb 2019 · 6 min read

New Updates Released for SQL Server 2014 SP3 and SP2: CU2 and CU16

Microsoft released SQL Server 2014 SP3 CU2 and SP2 CU16 with targeted fixes for performance, backup reliability, and availability. Here is what production DBAs need to know.

Read article →
11 Jul 2018 · 6 min read

How to Configure SQL Server Auditing

Step-by-step guide to configuring SQL Server Auditing at both the server and database level, with T-SQL scripts you can adapt for your environment.

Read article →
15 May 2018 · 6 min read

SQL Server 2012 Encryption Key Hierarchy

SQL Server uses a layered key hierarchy to protect data at rest. Learn how each level works, why it matters for recovery, and how it supports compliance requirements.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.