Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.
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 →Outsourcing SQL database management gives Australian businesses access to senior DBA expertise without the cost of permanent headcount. Here is what to expect.
Read article →Learn how to attach a SQL Server database using only the MDF file, without the original LDF log file, using two supported methods with key caveats explained.
Read article →Splitting a SQL Server database across multiple files and disks reduces I/O contention and improves throughput. Learn two practical methods using filegroups.
Read article →When SSMS cannot remove log shipping, you need to call the system stored procedures directly. Learn the correct order to clean up orphaned log shipping metadata safely.
Read article →Use SQL Server's plan cache DMVs to surface full table scans, missing indexes, and columns with no statistics without running a trace or waiting for an incident.
Read article →Identify exactly where your SQL Server is struggling using the Perfmon counters experienced DBAs rely on first for memory, disk, locking and CPU diagnostics.
Read article →Learn how to use SQL Server's missing index DMVs to identify index gaps that are quietly draining CPU and I/O from your production environment.
Read article →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 →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 →Learn how to grant read-only Activity Monitor access in SQL Server using VIEW SERVER STATE, without handing over sysadmin rights.
Read article →Relying on deprecated SQL Server features is one of the fastest ways to turn a planned migration into an emergency. Learn how to audit and address them before you upgrade.
Read article →Performance tips, security advisories, and industry analysis. No fluff, no spam.