Tag: 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.

24 May 2019 · 6 min read

New Updates for SQL Server 2017 and SQL Server 2016 SP2: CU15 and CU7 for Improved Stability and Security

SQL Server 2017 CU15 and 2016 SP2 CU7 address over 30 documented bugs across Always On, backup, security, and replication. Here is what you need to know before deploying.

Read article →
15 May 2018 · 6 min read

How to Fix Orphaned Users on an SQL Server

Orphaned users are one of the most common issues after SQL Server migrations and restores. Learn how to identify and fix them before they break production access.

Read article →
15 May 2018 · 6 min read

How to Find SQL Logins with NO Database Mappings

Orphaned SQL Server logins with no database mappings are a hidden security risk. Learn how to find and review them as part of your SQL Server security audit.

Read article →
15 May 2018 · 5 min read

SQL Server Fixed Server-Level Roles

SQL Server includes 9 fixed server-level roles that are commonly misused. Learn what each role does and how to apply them correctly to protect your instance.

Read article →

SQL Server insights, monthly.

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