SQL Server Performance: A Developer's Guide to Faster Queries
The query patterns that quietly cripple SQL Server performance - non-SARGable predicates, parameter sniffing and more - and how developers and DBAs fix them together.
Read article →
Update all DB growth parameters to defined increments
Default SQL Server auto-growth settings cause VLF fragmentation and autogrowth wait events. This script analyses every database and generates the correct ALTER DATABASE statements automatically.
Read article →
Microsoft’s Postponement of Patches: Investigating Incorrect Results Bugs in SQL Server 2019 and 2016
Microsoft patched two silent incorrect results bugs in SQL Server 2019 CU9 and 2016 SP2 CU16, affecting CONCAT queries and in-memory tables with columnstore indexes.
Read article →
Critical Security Issue in Extended Events Fixed in Latest SQL Server Updates
Microsoft has confirmed a critical remote code execution vulnerability in SQL Server's Extended Events feature. Find out if your instance is exposed and how to fix it.
Read article →
Boost Your SQL Server Performance with the Latest Cumulative Updates: SQL Server 2017 CU18 and SQL Server 2016 SP2 CU11
SQL Server 2017 CU18 and SQL Server 2016 SP2 CU11 fix critical production issues including deadlocks, memory leaks, and replication failures. Here is what changed and why it matters.
Read article →
Why is the SQL Server So Slow?
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 →
10 Things Every Project Manager Must Know When Deploying a SQL Server
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 →
How to Configure SQL Server Auditing
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 →
The Benefits of Outsourcing SQL Database Management
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 →
How to Attach Only a Database MDF
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 →
How to Split a Database Across Multiple Files / Disks
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 →
How to Manually Remove Log Shipping
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 →