Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.
KB5001989 patches a critical remote code execution vulnerability in SQL Server 2017 Analysis Services. Learn why immediate patching is essential to protect your environment.
Read article →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 →SQL Server 2017 Cumulative Update 14 delivers over 30 bug fixes covering query execution, backup reliability, and security vulnerabilities, plus new CLR support in memory-optimised tables.
Read article →SQL Server 2016 SP2 CU6 delivers over 50 bug fixes, a critical security patch, and key improvements to Always On Availability Groups and backup reliability.
Read article →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 →Microsoft has released SQL Server 2016 SP2 CU5 and SP1 CU13, addressing over 70 bug fixes across replication, Always On, backup, and security. Here is what production DBAs should know.
Read article →When SQL Server slows down, wait statistics reveal exactly where the problem is hiding. Learn how to query DMVs to diagnose performance issues quickly.
Read article →SQL Server deployments have technical traps that catch non-specialists off guard. Here are 10 things every project manager must get right before go-live.
Read article →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 →Monitor legacy SQL Server 2000 instances with this stored procedure that collects key diagnostic data and outputs it as CSV for automated daily email reporting.
Read article →Performance tips, security advisories, and industry analysis. No fluff, no spam.