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.

Enhance Your SQL Server 2016 Performance and Security with Cumulative Update 9 – HOLD
1 Oct 2019 · 6 min read

Enhance Your SQL Server 2016 Performance and Security with Cumulative Update 9 – HOLD

Microsoft has flagged an uninstall issue with SQL Server 2016 SP2 CU9. Find out why you should hold off and wait for the expedited CU10 release instead.

Read article →
SQL Server 2016 SP2 CU8: A Must-Have Update for Improved Performance and Security
1 Aug 2019 · 6 min read

SQL Server 2016 SP2 CU8: A Must-Have Update for Improved Performance and Security

SQL Server 2016 SP2 CU8 addresses 13 significant bugs including broken encrypted backup restores and Dynamic Data Masking failures. Here is what was fixed and why it matters.

Read article →
Stay Ahead of the Game with SQL Server 2014 SP3 CU4: The Latest Cumulative Update for Improved Performance and Security
30 Jul 2019 · 6 min read

Stay Ahead of the Game with SQL Server 2014 SP3 CU4: The Latest Cumulative Update for Improved Performance and Security

SQL Server 2014 SP3 CU4 addresses critical fixes including filtered index corruption, Extended Events crashes and SSISDB blocking. Here is what you need to know before patching.

Read article →
New Updates for SQL Server 2017 and SQL Server 2016 SP2: CU15 and CU7 for Improved Stability and Security
24 May 2019 · 6 min read

New Updates for SQL Server 2017 and SQL Server 2016 SP2: CU15 and CU7 for Improved Stability and Security

SQL Server 2017 CU15 and 2016 SP2 CU7 address over 30 documented bugs across Always On, backup, security, and replication. Here is what you need to know before deploying.

Read article →
SQL Server 2017 Analysis Services Security Update: Addressing Vulnerabilities to Ensure System Security
15 May 2019 · 5 min read

SQL Server 2017 Analysis Services Security Update: Addressing Vulnerabilities to Ensure System Security

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 →
New Updates Released for SQL Server 2014 SP3 and SP2: CU3 and CU17 for Improved Stability and Security
17 Apr 2019 · 6 min read

New Updates Released for SQL Server 2014 SP3 and SP2: CU3 and CU17 for Improved Stability and Security

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 →
Stay Up-to-Date with SQL Server 2017: Announcing Cumulative Update 14 with Notable Enhancements and Important Security Updates
26 Mar 2019 · 5 min read

Stay Up-to-Date with SQL Server 2017: Announcing Cumulative Update 14 with Notable Enhancements and Important Security Updates

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: The Update with Significant Changes and Important Security Updates
20 Mar 2019 · 5 min read

SQL Server 2016 SP2 CU6: The Update with Significant Changes and Important Security Updates

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 →
New Updates Released for SQL Server 2014 SP3 and SP2: CU2 and CU16
20 Feb 2019 · 6 min read

New Updates Released for SQL Server 2014 SP3 and SP2: CU2 and CU16

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 →
New Updates Released for SQL Server 2016 SP2 and SP1: CU5 and CU13
24 Jan 2019 · 6 min read

New Updates Released for SQL Server 2016 SP2 and SP1: CU5 and CU13

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 →
Why is the SQL Server So Slow?
20 Nov 2018 · 6 min read

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
20 Nov 2018 · 6 min read

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 →
← Previous Page 8 of 14 Next →

SQL Server insights, monthly.

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