Mastering Common Table Expressions (CTEs) in SQL Server Common Table Expressions (CTEs) are a powerful feature in SQL Server that can make your queries more readable, more expressive, and often more efficient. Today, we’ll demystify this tool and invite you …
Mastering Common Table Expressions (CTEs) in SQL Server Read more »
Enhancing SQL Server Health with Daily Monitoring and Proactive Alerting As SQL Server professionals, we understand the critical nature of maintaining the health and performance of your database systems. It’s not just about avoiding downtime; it’s about ensuring your data …
Enhancing SQL Server Health with Monitoring and Proactive Alerting Read more »
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 on SQL Server allows you to create stored procedures, triggers, and functions using languages such …
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, however, shrink database does shrink the log file. Not shrinking your database is one of …
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 blog. There are several common causes of database corruption in SQL Server, including: * Hardware …
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. When a client application requests data from the database, the request is placed in a …
SQL Server Wait Type: PREEMPTIVE_HADR_LEASE_MECHANISM Read more »
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 your SQL Server environment. The holiday season is here, and with it comes the well-deserved …
Keep Your SQL Server Running Smoothly During the Holidays Read more »
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 is no private client information to expose here. For this month, here are the details. …
Common Waits Reported by Daily Monitoring This Month Read more »
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 aggregation is a vital tool for anyone seeking to extract the most valuable insights from …
SQL School: Elevate Your SQL Skills with Data Aggregation Read more »