Author: Steve Stedman

SQL Server is a powerful relational database management system that serves as the backbone for countless applications and data-driven solutions. Whether you’re a developer, database administrator, or student learning the ropes, having access to well-structured example databases can significantly enhance your understanding and proficiency. These sample databases provide a practical way to experiment with queries, test performance optimizations, and explore the intricacies of SQL Server’s features without the risk of impacting live data. In this post, we’ll dive into some …

Example Databases for SQL Server Read more →

The Importance of Managed Services for SQL Server: How Stedman Solutions Can Help In today’s data-driven world, businesses rely heavily on robust database systems to store, manage, and analyze critical information. SQL Server, one of the most widely used relational database management systems, plays a pivotal role in ensuring data integrity and accessibility for organizations of all sizes. However, maintaining and optimizing SQL Server environments can be a complex and resource-intensive task, often requiring specialized expertise and constant monitoring. This …

Importance of Managed Services for SQL Server Read more →

Hey there. If you have been putting off sharpening your database skills because of cost or timing, let me give you the nudge you need: November is here, and with it comes the annual tradition at Stedmans SQL School where I open the vault and make premium SQL Server training more accessible than ever. This is not a marketing gimmick. It is a deliberate month-long event designed to remove barriers for anyone serious about mastering SQL Server. For the next …

November Promotion Month at Stedmans SQL School Read more →

NOLOCK Hint in SQL Queries: Myths, Misconceptions, and Best Practices If you’ve ever worked with SQL Server, you’ve likely come across the WITH NOLOCK hint in queries. This powerful yet often misunderstood feature can appear to be a game-changer when dealing with large datasets or high-concurrency environments. However, its use comes with significant trade-offs that can impact data integrity and query reliability. In this post, we’ll dive into what WITH NOLOCK really does, when it’s appropriate to use it, and …

Understanding SQL Server WITH NOLOCK Read more →

Why Stedman Solutions Should Be Your Go-To for SQL Server Needs Welcome to a deep dive into the world of innovative problem-solving and strategic excellence with Stedman Solutions. If you’ve ever wondered what sets a company apart in delivering consistent, impactful results, you’re in the right place. Stedman Solutions isn’t just a name; it’s a promise of tailored strategies, cutting-edge technology, and unwavering commitment to client success. In this post, we’ll explore the core reasons why Stedman Solutions stands as …

You Can Count On Stedman Solutions Read more →

Understanding Merge Replication in SQL Server Merge replication is a powerful feature in SQL Server that allows data to be synchronized between multiple databases, even when they are not continuously connected. This type of replication is particularly useful in scenarios where users or applications need to work with data offline and later sync changes with a central database. Whether you’re managing a distributed sales force, supporting remote offices, or enabling mobile applications, merge replication provides a flexible solution to ensure …

Understanding Merge Replication on SQL Server Read more →

Discover Database Health Monitor: Your Ultimate SQL Server Monitoring Tool If you’re managing a database, whether for a small business or a large enterprise, ensuring its optimal performance and reliability is critical. Database Health Monitor is a specialized tool or system designed to keep a close watch on the performance, security, and overall well-being of your database. It acts as a vigilant guardian, continuously tracking key metrics like query performance, storage usage, and system uptime to prevent potential issues before …

Database Health Monitor What It Is Read more →

Can Inserting into a Table with a SELECT from the Same Table Cause Deadlocking? Yes, inserting into a table using a SELECT statement from the same table in SQL Server can cause deadlocking if run in multiple sessions concurrently. This is due to resource contention between reading and writing operations on the same table. Below is a detailed explanation. Why Deadlocking Can Occur Locking Behavior The SELECT statement typically acquires shared locks (S) on the rows or pages it reads …

INSERT INTO SELECT Deadlock Read more →

In my recent YouTube video, I share a practical tip for SQL Server Management Studio (SSMS) users to make their coding workflow more efficient. As someone who mentors developers, I’ve seen how small optimizations can make a big difference, and this trick for commenting and uncommenting code is one I’m excited to teach. It’s a simple technique that saves valuable time, especially when managing large scripts or working in fast-paced database development environments. In the video, I walk through a …

Speed Up Your SQL Workflow: Commenting Code in SSMS Read more →

At Stedman Solutions, we are always working to make SQL Server management easier and more effective. In Database Health Monitor, we have several reports and enhancements that help you better understand what’s happening across your SQL Servers. One of the highlights is the Job History Chart. Viewing job history in SQL Server Management Studio often felt like sifting through fragmented data without much context. With the redesigned job history report, you now get a clear 24-hour view of all jobs …

Job History, Problem Indexes and Backup Reports Read more →