Author: Steve Stedman

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 →

For more information on Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at https://DatabaseHealth.com/download2. Welcome to our deep dive into DB Assistant, a critical component of the Database HealthMonitor suite. As organizations increasingly rely on robust database systems to manage vast amounts of data, ensuring optimal performance and reliability becomes paramount. DB Assistant is designed to be your proactive partner in this journey, offering real-time insights and automated solutions to keep …

DB Assistant – Part of Database Health Monitor Read more →

Database Health Monitor streamlines SQL Server Agent job management by offering a clear, visual way to track job successes and failures in real time. Its intuitive dashboards help you quickly spot trends, identify recurring issues, and troubleshoot problems, ensuring your SQL Server jobs run smoothly across single or enterprise environments. Want to see how it works? Watch our video to explore Database Health Monitor‘s powerful features, from real-time monitoring to trend analysis, and learn how to optimize your SQL Server …

SQL Server Agent Job Management Read more →

Optimizing Your SQL Server with Database Health Monitor‘s DBAssistant Feature Managing a SQL Server environment can feel like juggling a dozen flaming torches while riding a unicycle. With so many moving parts—performance, security, maintenance, and more—it’s easy for issues to slip through the cracks. That’s where Database Health Monitor’s DBAssistant feature comes in, acting like a seasoned DBA whispering expert advice in your ear. This powerful tool analyzes a wide range of SQL Server metrics and configurations, offering actionable recommendations …

Database Health Monitor’s DBAssistant Feature Read more →

Learn SQL JOINS In The Shower Ever found yourself daydreaming about database queries while shampooing your hair? If not, you’re about to start. Learning SQL JOINS doesn’t have to be confined to a desk or a dimly lit computer screen. In fact, some of the best learning happens when you’re relaxed, and what better place to unwind than in the shower? This blog post will break down the concept of SQL JOINS—those powerful tools for combining data from multiple tables—into …

SQL JOINS Shower Curtain Read more →

Transactional Replication in SQL Server Transactional replication in SQL Server is a powerful mechanism for maintaining data consistency across multiple databases, often used in scenarios where real-time data synchronization is crucial. It works by replicating changes made to the publisher database to one or more subscriber databases, ensuring that data remains up-to-date with minimal latency. This method is particularly valuable for businesses that require distributed database environments, such as retail chains managing inventory across multiple locations or financial institutions ensuring …

Using Transactional Replication in SQL Server Read more →

Copy-Only Backups for One-Off Situations Written by Steve Stedman of Stedman Solutions, LLC In the world of data management, backups are a critical safety net, ensuring that valuable information is never lost to unexpected failures or mishaps. However, not all backup strategies are created equal, and sometimes a full system backup or incremental approach isn’t the right fit for the task at hand. Enter copy-only backups—a specialized solution designed for one-off situations where you need a quick, isolated snapshot of …

Copy-Only Backups for One-Off Situations Read more →