The End of SQL Server 2019
Steve has a few thoughts after the end of mainstream support for SQL Server 2019.
2025-03-26
328 reads
Patching
How Do You Patch 100 Database Servers?
The challenges of managing lots of system are significant and there aren't easy solutions, but Steve has a few thoughts on what you can do.
2024-11-18
236 reads
2024-05-29
290 reads
The Case for Patching
Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and the current CU is 17. I took a few minutes to download […]
2022-08-20
149 reads
A New SQL Server Vulnerability
A new vulnerability for SQL Server is covered by a number of patches this week.
2022-06-18
734 reads
The Challenge of Edge Security
We will see databases deployed on the edge, and we will need strong security patches.
2021-12-20
290 reads
The Last SQL Server Service Pack
SQL Server 2016 SP3, the last service pack ever is out. Steve comments on how the world of software patches has changed.
2021-10-08
532 reads
Patching Challenges
Having a patching strategy for your systems is important, and Steve notes that you ought to be organized and allow for some flexibility when designing one.
2021-06-30
338 reads
2021-04-10
122 reads
SQL Server Database engine patching
This script can install Service pack, security patch and Cumulative update on SQL instance(Database Engine).
2020-05-26 (first published: 2020-05-19)
1,761 reads
Blogs
Optimize Azure Fabric Pipelines with This Key Spark Setting
By Daniel Janik
Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure...
SQL Server Post-Install Configurations
By Kevin3NF
The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory...
How Vastu Principles Can Inspire Smarter Database Administration: A Holistic Approach to Data Architecture
By Rohit Garg
In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Monitor SQL Server using Zabbix
Comments posted to this topic are about the item Monitor SQL Server using Zabbix
Archiving data older than 5 years
Hi We have databases with data stored for over 20 years, this is required...
Question of the Day
TCP Provider Errors in SQL Server
You're troubleshooting a connectivity issue between a client application and a remote SQL Server instance. The client receives a "provider: TCP Provider, error: 0 - No such host is known" message. You verify that SQL Server is running and reachable on the server. The SQL Server instance is configured with a named instance and uses dynamic ports. Which of the following steps is most likely to resolve the issue?
See possible answers