New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2022 CU19 for 2022 (16.0.4195.2 – May 2025) CU15 + GDR (16.0.4155.4 – November… Read More »New SQL Update from Microsoft
SteveStedman
Resolving High Virtual Log File (VLF) Count
This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding and Resolving High… Read More »Resolving High Virtual Log File (VLF) Count
Understanding Slow SQL Server Error Log
In the world of database management, ensuring efficient performance of SQL servers is pivotal. One common issue that database administrators face is a slow SQL… Read More »Understanding Slow SQL Server Error Log
SQL Server DBCC Commands: DBCC SQLPERF
DBCC SQLPERF is a database console command (DBCC) in Microsoft SQL Server that can be used to display statistical information about various performance-related aspects of… Read More »SQL Server DBCC Commands: DBCC SQLPERF
Tables With No Clustered Index
Why You Should Add a Clustered Index to Your SQL Server Tables In SQL Server, a clustered index is more than just a performance tweak—it’s… Read More »Tables With No Clustered Index
Looping Over SQL Server Certificates with Cursors
Managing security within SQL Server is a task that demands precision and careful attention, particularly when dealing with certificates. These digital certificates are crucial for… Read More »Looping Over SQL Server Certificates with Cursors
Securing SQL Server: CHECK_Expiration for SQL Server logins
The CHECK_EXPIRATION option is a security feature of SQL Server that allows you to enforce password expiration for SQL Server logins. When this option is… Read More »Securing SQL Server: CHECK_Expiration for SQL Server logins
GFS Backup Schedule
Understanding the GFS BACKUP Schedule and How It Can Work with SQL Server In today’s digital landscape, safeguarding data is more important than ever. As… Read More »GFS Backup Schedule
SQL Server Corruption: What Causes Corruption
Most of the time that I am contacted for help with a corruption repair it is a situation where the client does not have any… Read More »SQL Server Corruption: What Causes Corruption
Failing SQL Server Agent Jobs?
Understanding and Resolving Failed SQL Server Agent Jobs SQL Server Agent is a powerful tool for automating essential database tasks such as backups, index maintenance,… Read More »Failing SQL Server Agent Jobs?