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.
SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description
Looking for a job or a candidate? Here are my links to SQL Server interview questions and answers, SQL Server related jobs and a DBA job description.
Least Privilege for Application Logins
Design least privilege for SQL Server application logins with roles, schema permissions, and stored procedures, then test real workflows.
SQLAuthority News – SQL SERVER Database Administrator Job Description
An updated SQL Server Database Administrator Job Description: support for the database environment, new technology, reliability and long-term planning.