A quarterly permission review checks server and database roles, new grants, orphaned users, service accounts, and owner signoff.
SQLAuthority News – 600 Article and Over 3 Million Readers
Today is the 600th article on this blog, and over 3 Million readers have visited so far. Thank you. Send me your ideas, and see my favorite and best articles.
When to Upgrade: RTM, First CU or Later
Decide When to Upgrade SQL Server by weighing new features, early defects, support needs, and evidence from your own workload.
Three Scripts for a First Look at Any Server
A first look at any server needs three read-only T-SQL checks: configuration, databases and backups, and current activity.
SQLAuthority News – 3 Million Readers and Continuing Journey
SQLAuthority passed 3 Million readers. Thank you for your active participation. Here are my best and favorite articles if you want to keep reading.
Windows Settings That Affect SQL Server
Windows settings can influence SQL Server CPU speed, file growth, memory stability, and security scanning; learn what to inspect and validate.
Naming SQL Server Instances So People Understand Them
Naming SQL Server Instances well clarifies default and named installs, survives growth, and makes later server renames less painful.