Steve Stedman

Database corruption in Microsoft SQL Server can present serious challenges, causing data loss, disruption of services, and potential impact on business operations. Understanding the causes, symptoms, and potential solutions for such corruption is essential for any database administrator looking to maintain the integrity and reliability of their SQL Server environment.. It is impossible to completely prevent corruption from happening. There …

SQL Server Corruption: Can I Prevent Corruption Read more »

Have you seen our Managed Services offering? Managed Services for SQL Servers has become one of the largest parts of our business, and we have even expanded the managed services team now to 4 people supporting clients SQL Servers. A short video where I describe the managed services offering that we have at Stedman Solutions to support SQL Servers. We …

Have you seen our Managed Services offering? Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU21 for 2019 (15.0.4316.3 – June 2023) CU18 + GDR (15.0.4280.7 – February 2023) 2023-06-15 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU5 …

New SQL Update from Microsoft Read more »

There are 2 perspectives here to the DBA on vacation, typically in an organization with only a single DBA so there is no cross coverage when someone goes on vacation. The view as the DBA: I have done everything that I can to prepare the systems for vacation, but still I end up getting called for some regular maintenance job …

DBA on Vacation Read more »

Hello SQL Server enthusiasts, Throughout my SQL Server journey, I’ve come to appreciate the critical role that data aggregation plays in extracting meaningful insights from data. With this in mind, I have created a course on Teachable called “Aggregating Data in Your SQL Queries.” https://stedman.us/aggregation I’m eager to share some of the compelling benefits that this course offers and explain …

SQL School: Master the Art of Data Aggregation with SQL Server Read more »

The CHECK_POLICY option is a security feature in SQL Server that is used to enforce password policy settings for SQL authenticated logins. When CHECK_POLICY is set to ON, SQL Server will check the password for a login against the password policy defined in the operating system. This can help ensure that passwords used for SQL authenticated logins are strong and …

Securing SQL Server: CHECK_POLICY for SQL Server logins Read more »

Foreign keys are a fundamental aspect of relational databases, as they enforce referential integrity between related tables. However, foreign key relationships can also cause performance issues, particularly if the foreign key is untrusted. An untrusted foreign key occurs when SQL Server is unable to verify the relationship between two tables, potentially leading to performance issues and data inconsistencies. The Database …

Database Health: Untrusted Foreign Keys Read more »

Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …

Daily Server Monitoring – SQL Versions for June Read more »