Blog

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

12 Apr 2026 · 7 min read

Boost SQL Server Performance with AI-Assisted Query Optimisation Tools

AI-assisted query optimisation tools are helping SQL Server DBAs diagnose performance bottlenecks faster and implement fixes in a fraction of the time. Here is what that means in practice.

Read article →
9 Apr 2026 · 6 min read

Proactive Security for SQL Server: Mitigating CVEs and Protecting Your Data

One unpatched SQL Server vulnerability can expose your entire data estate. Learn how CVE patching, access controls, and regular audits work together to protect your databases.

Read article →
6 Apr 2026 · 6 min read

Leverage SQL Server 2022's New Functions for Enhanced Data Analysis and Performance

SQL Server 2022 introduces DATE_BUCKET, DATETRUNC and bit manipulation functions that replace complex workarounds and improve query performance. Here is what DBAs need to know.

Read article →
3 Apr 2026 · 6 min read

Why Your SQL Server Needs to Stay Current: A DBA Services Guide to CUs and Patches

Falling behind on SQL Server cumulative updates exposes your environment to known vulnerabilities and documented bugs. Here is what you need to know about staying current.

Read article →
31 Mar 2026 · 7 min read

Will AI replace your DBA?

AI is changing database administration, but it is not replacing your DBA. Here is an honest look at what AI can handle in SQL Server and where human expertise remains irreplaceable.

Read article →
16 Mar 2026 · 5 min read

The Hidden Costs of Not Having a DBA

Failed backups, costly downtime and security vulnerabilities add up fast without a DBA. Find out what SQL Server neglect is really costing your business.

Read article →
9 Mar 2026 · 6 min read

SQL Server Migration Assessment: A Complete Guide

A SQL Server migration assessment tells you what will break, what's compatible and what infrastructure you need. Here's how DBA Services runs them properly.

Read article →
2 Mar 2026 · 5 min read

SQL Server 2025 upgrade guide: what every business needs to know

SQL Server 2025 brings native AI, vector data support, and real performance gains. Here is what Australian businesses need to know before planning their upgrade.

Read article →
3 Oct 2025 · 6 min read

How to Backup SQL Database (and Why Most Backups are Doomed to Fail)

Most organisations have backups running but still cannot restore when it matters. Learn the correct way to back up SQL Server and avoid the mistakes that create a false sense of security.

Read article →
16 Sep 2025 · 6 min read

Query Plan Confusion? When It’s Time to Call a SQL Server Consultant

Slow queries cost real money. Learn how to read SQL Server execution plans, tackle common performance issues, and recognise when a specialist can help.

Read article →
5 Sep 2025 · 6 min read

How to Check Your SQL Server Version and Edition

Six reliable methods to find your exact SQL Server version and build number, from a quick T-SQL query to SSMS server properties and the Windows control panel.

Read article →
Page 1 of 11 Next →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.