Author: SteveStedman

February: The Month of Performance at Stedman Solutions! February is here, and at Stedman Solutions, LLC, we’re declaring it Performance Month! As a seasoned expert in SQL Server since 1990, I’m excited to share exclusive opportunities this month to turbocharge your SQL Server’s performance. Here are three pivotal ways you can participate in Performance Month with Stedman Solutions: 1. Free …

February: The Month of Performance at Stedman Solutions! Read more »

As the founder and owner of Stedman Solutions, LLC, I know how important it is to address the challenges you face when it comes to your DBA or developer’s absence or the overwhelming workload on your in-house resources. That’s why our team at Stedman Solutions is here to provide you with reliable solutions. Find out more about our SQL Server …

Staff Augmentation – We can help Read more »

Iterating Over SQL Server Certificates with Cursors Welcome to another SQL Server educational post! Today, we’re going to explore how to use cursors to iterate over all certificates in the sys.certificates system view. Cursors can be handy when you need to process each row in a result set individually. A T-SQL (Transact-SQL) cursor is a database object used in SQL …

Iterating Over SQL Server Certificates with Cursors Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding and Mitigating Slow SQL Server Error Log Access Are you experiencing sluggishness when accessing your SQL Server error log? As a database professional and the owner of Stedman Solutions, LLC, I’ve encountered this issue multiple times and understand …

Understanding Slow SQL Server Error Log Access Read more »

Top 10 SQL Server Wait Types for Performance Tuning Understanding these wait types is key to identifying performance bottlenecks in SQL Server: CXPACKET: Indicates parallelism-related waits. High values suggest inefficiencies in query parallelization. LCK_M_XX: Lock waits (e.g., LCK_M_S, LCK_M_U) signal queries waiting for resource locks, pointing to potential blocking or deadlocking. PAGEIOLATCH_XX: Wait times due to disk I/O operations, indicating …

Top 10 SQL Server Wait Types for Performance Tuning Read more »

Hello there! My name is Steve Stedman, and I want to tell you about my amazing product, the Database Health Monitor. As a professional database administrator, I understand how vital it is to have a reliable and efficient monitoring tool that can provide insights into the performance and health of a database. That’s why I created the Database Health Monitor, …

Database Health Monitor Read more »

Hello there! My name is Steve Stedman, and I want to tell you about my amazing product, the Database Health Monitor. As a professional database administrator, I understand how vital it is to have a reliable and efficient monitoring tool that can provide insights into the performance and health of a database. That’s why I created the Database Health Monitor, …

Database Health Monitor Read more »

Navigating SQL Server Management: The Unmatched Value of Stedman Solutions’ Managed Services In the ever-evolving landscape of database management, businesses are continually seeking reliable, efficient, and cost-effective solutions to ensure their SQL Server environments are running at peak performance. As the owner of Stedman Solutions, LLC, I’ve seen the challenges and costs that organizations face when trying to manage and …

The Unmatched Value of Stedman Solutions Managed Services Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Impact of SQL Server AutoClose Setting on Performance The SQL Server AutoClose database setting, when enabled, can significantly impact the performance of your database. Below are key reasons why: 1. Resource Overhead When the AutoClose setting is …

SQL Server AutoClose Impact on Performance Read more »