CLR (Common Language Runtime) is a feature of SQL Server that allows you to create and run managed code within the database engine. Enabling CLR… Read More »Securing SQL Server: Securing CLR

This chapter refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different conversation,… Read More »SQL Server DBCC Commands: Shrinking Notes

Merry Christmas from the team at Stedman Solutions, LLC. Our offices will be closed to celebrate Christmas this year.

Over the years I have documented many of the concepts around corruption repair. Want to find out more, check out the corruption category at by… Read More »SQL Server Corruption: What Causes Corruption

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database.… Read More »SQL Server Wait Type: PREEMPTIVE_HADR_LEASE_MECHANISM

Keep Your SQL Server Running Smoothly During the Holidays with Stedman Solutions’ Managed Services Contact us to find out how Stedman Solutions can help with… Read More »Keep Your SQL Server Running Smoothly During the Holidays

Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there… Read More »Common Waits Reported by Daily Monitoring This Month

I’m Steve Stedman, a firm believer in the value and power of effective data management. Having interacted with SQL Server extensively, I’ve recognized that data… Read More »SQL School: Elevate Your SQL Skills with Data Aggregation

Monitoring long-running queries is an essential part of database performance monitoring, as it can help identify queries that are causing performance issues and take corrective… Read More »Database Health: Monitoring Long-running Queries

The SA (System Administrator) account is a predefined account in SQL Server that has full control over the database server. By default, the SA account… Read More »Securing SQL Server: Renaming and Disabling the SA Account