Stedman Solutions Blog

Welcome to the Stedman Solutions Blog: Your Go-To Resource for SQL Server Insights

If you’re a SQL Server enthusiast, an IT professional tasked with managing databases, or a business owner who relies on SQL Server for mission-critical applications, you’ve come to the right place. The Stedman Solutions Blog is designed to share practical, real-world knowledge and tips to help you get the most out of your SQL Server environment.

At Stedman Solutions, LLC, we’ve been working with SQL Server since 1990, focusing on performance tuning, troubleshooting, and long-term database health. This blog is an extension of that expertise, crafted to serve as a resource hub for the SQL Server community.

What You’ll Find on Our Blog

1. SQL Server Tips and Tutorials

From fundamental concepts to advanced topics like performance tuning and query optimization, we aim to demystify SQL Server with tutorials and examples. Whether you’re just getting started or are looking for expert insights, you’ll find articles tailored to your level of expertise.

2. Case Studies and Real-World Scenarios

Discover how our team has solved challenging SQL Server issues, including database corruption repair, performance bottlenecks, and high-availability configuration. These real-world stories illustrate the value of specialized SQL Server knowledge.

3. Best Practices for SQL Server Management

Learn strategies for keeping your SQL Server environment secure, reliable, and high-performing. From regular maintenance routines to disaster recovery planning, we’ll share actionable advice to protect your data.

4. Updates on SQL Server Tools and Features

Stay current with the latest developments in the SQL Server ecosystem. We’ll provide insights on new features, updates, and tools that can enhance your database operations.

5. Behind-the-Scenes Look at Stedman Solutions

We’re passionate about SQL Server, and our blog offers a glimpse into our projects, team culture, and the tools we use every day—like our Database Health Monitor, a free tool for monitoring and improving SQL Server performance.

Why Follow the Stedman Solutions Blog?

Our blog is more than just another technical resource. It’s a place where we share knowledge gained from decades of experience and hundreds of successful client engagements. By following our blog, you’ll gain insights that can:

Help you solve SQL Server challenges faster.
Prevent costly downtime and data loss.
Enhance your skills with practical guidance.

Let’s Get Started!

We invite you to explore our latest posts and subscribe to stay updated. Whether you’re interested in proactive SQL Server management, advanced tuning techniques, or simply looking to keep your environment running smoothly, the Stedman Solutions Blog is here to help.

For more in-depth support or to learn about our Managed Services, contact us today. Let’s take the stress out of SQL Server management together!

Explore our blog today at Stedman Solutions Blog. Let’s build better databases, one post at a time!

Common Waits Reported by Daily Monitoring This MonthDecember 21, 2024
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. PREEMPTIVE_OS_PIPEOPS ASYNC_NETWORK_IO SP_SERVER_DIAGNOSTICS_SLEEP MEMORY_ALLOCATION_EXT CXPACKET CXSYNC_PORT LCK_M_SCH_S PREEMPTIVE_OS_GETPROCADDRESS CXCONSUMER RESOURCE_SEMAPHORE_QUERY_COMPILE Our daily monitoring product scans… Read More »Common Waits Reported by Daily Monitoring This Month
Database ForensicsDecember 20, 2024
Understanding Database Forensics: What It Is and Why It Matters In today’s data-driven world, databases are critical to the operation of businesses and organizations. They store sensitive, mission-critical information, including financial data, customer records, and intellectual property. However, with the increasing complexity of database systems and the growing sophistication of cyber threats, protecting that data… Read More »Database Forensics
Podcast Episode 11 – Database Health Monitor- New FeaturesDecember 18, 2024
Stedman SQL Podcast Episode 11 – New Features Steve Stedman hosts the Stedman SQL podcast, featuring George and Mitchell, developers of the Database Health Monitor. They discuss new features in DHM, including the VLF visualization report, schema search, SQL CPU schedulers, deprecated features, historic file size over time, and average page life expectancy charts. Mitchell… Read More »Podcast Episode 11 – Database Health Monitor- New Features
Real Cost of SQL Server ManagementDecember 17, 2024
Download “The Real Cost of SQL Server Management” White Paper Discover the true cost of managing SQL Server with our white paper, “The Real Cost of SQL Server Management: In-House Team vs. Stedman Solutions.” This comprehensive guide dives deep into the financial implications of maintaining an in-house team compared to outsourcing to specialists like Stedman… Read More »Real Cost of SQL Server Management
Max Degree of ParallelismDecember 15, 2024
Understanding the SQL Server MAX Degree of Parallelism Setting The Max Degree of Parallelism (MAXDOP) setting in SQL Server plays a crucial role in determining how SQL Server handles parallel query execution. It controls the maximum number of processors that can be used for executing a single query. Over the years, SQL Server’s handling of… Read More »Max Degree of Parallelism
What are SQL Agent JobsDecember 13, 2024
What Are SQL Agent Jobs? If you’ve been managing a SQL Server environment for any amount of time, chances are you’ve come across SQL Server Agent Jobs. But what exactly are they, and why are they so critical to efficient database management? In this blog post, I’ll break down what SQL Agent Jobs are, how… Read More »What are SQL Agent Jobs
Podcast Episode 10 – RPO and RTODecember 11, 2024
Stedman SQL Podcast Episode 10 – RPO and RTO Steve Stedman and Shannon Lindsay discuss the transition of their podcast from live streaming to pre-recorded episodes, available on YouTube, Spotify, and their website. They announce the upcoming release of a new database health monitor with features like VLF visualization reports and SQL schema search. The… Read More »Podcast Episode 10 – RPO and RTO
SQL Server Performance Tuning ConsultantDecember 10, 2024
How to Choose a SQL Server Performance Tuning Consultant If your SQL Server is experiencing slowdowns, sluggish performance, or frequent issues, it’s likely time to consider a SQL Server Performance Tuning consultant. Choosing the right consultant can make a significant impact in bringing your SQL Server back to optimal performance. But with so many options… Read More »SQL Server Performance Tuning Consultant
Introduction to Parameter Sniffing in SQL ServerDecember 8, 2024
What is parameter sniffing in SQL Server? Understanding Parameter Sniffing in SQL Server: What It Is and How to Handle It One of the more nuanced aspects of SQL Server performance tuning is understanding and addressing parameter sniffing. This is a common scenario that arises when SQL Server generates and stores a query execution plan… Read More »Introduction to Parameter Sniffing in SQL Server
Checking Database Corruption in SQL ServerDecember 7, 2024
In this blog post we will cover how to check for database corruption on SQL Server. Database corruption can be a nightmare for any SQL Server administrator. Without proactive monitoring and regular checks, corruption can silently creep in, leaving you with incomplete or inaccessible data when you need it most. This article will guide you… Read More »Checking Database Corruption in SQL Server
Daily Server Monitoring – SQL Versions for DecemberDecember 7, 2024
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… Read More »Daily Server Monitoring – SQL Versions for December
HTDELETE Wait Type in SQL ServerDecember 6, 2024
Understanding the HTDELETE Wait Type in SQL Server In SQL Server, understanding wait types can provide critical insights into performance bottlenecks, enabling DBAs to optimize their environment effectively. One such wait type that occasionally appears in SQL Server environments is HTDELETE. Though not one of the most common wait types, understanding HTDELETE can help when… Read More »HTDELETE Wait Type in SQL Server
Podcast Episode 9 – SQL Server CorruptionDecember 4, 2024
Our SQL Server Corruption episode. Stedman SQL Podcast Episode 9 – Corruption Steve Stedman and Derrick Bovenkamp discuss SQL Server database corruption, its causes, symptoms, and prevention strategies. SQL Server Corruption often results from IO issues, such as firmware problems with iSCSI or antivirus software misconfigurations. Symptoms include failed queries and check DB errors. They… Read More »Podcast Episode 9 – SQL Server Corruption
UPDLOCK hint – DangersDecember 4, 2024
In this conversation, the focus is on how the UPDLOCK (update lock) can cause serious performance issues, specifically excessive wait times and blocking in SQL Server. At Stedman Solutions, while working with a Managed Services client, we encountered a situation where SELECT statements were incorrectly using the UPDLOCK hint. Normally, update locks are intended for… Read More »UPDLOCK hint – Dangers
Cyber Monday – 60% off until 8pm pacific time.December 2, 2024
Cyber Monday Deal #3: 60% Off From 11:00 AM to 8:00 PM Pacific Time, you can still save big with a 60% discount on our Backup and Recovery course. Get it for only $15.98! Enroll Now with a 60% savings: https://stedman.us/60BACK Coupon Code: 60BACK We understand that these discounts may seem too good to be… Read More »Cyber Monday – 60% off until 8pm pacific time.
Cyber Monday – 80% off 8am to 11am pacific timeDecember 2, 2024
Cyber Monday Deal #2: 80% Off Between 8:00 AM and 11:00 AM Pacific Time, enjoy an incredible 80% discount on our Backup and Recovery course. Get it for just $7.99! Enroll Now with 80% savings: https://stedman.us/80BACK Coupon Code: 80BACK Cyber Monday Deal #3: 60% Off From 11:00 AM to 8:00 PM Pacific Time, you can… Read More »Cyber Monday – 80% off 8am to 11am pacific time
Cyber Monday – 90% off 7:00am to 8:00am pacific timeDecember 2, 2024
Cyber Monday Deal #1: 90% Off From 7:00 AM to 8:00 AM Pacific Time, get a whopping 90% off our Backup and Recovery course. Enroll for just $3.99 instead of $39.99! This is the lowest markdown we’ve ever offered. Enroll Now at a 90% savings: https://stedman.us/90BACK Coupon Code: 90BACK Cyber Monday Deal #2: 80% Off… Read More »Cyber Monday – 90% off 7:00am to 8:00am pacific time
Saturday Sale: 50% Off SQL Server Replication Course!November 30, 2024
Celebrate Small Business Saturday with 50% Off Our SQL Server Replication Course! Small Business Saturday is here, and to celebrate, we’re offering 50% off our SQL Server Replication course—but only for one day! Whether you’re managing databases in a small business or a larger enterprise, SQL Server replication is a crucial skill that can help… Read More »Saturday Sale: 50% Off SQL Server Replication Course!
Stedman Solutions Black Friday Exclusive!November 29, 2024
Discover the Secrets Behind SQL Server Blocks with Stedman Solutions Our Black Friday sale is here, and we at Stedman Solutions have a ONE DAY SALE that you simply can’t miss! Black Friday Exclusive: 25% Off! Enroll in our Track Blocking Queries course and get: 2 hours of personalized coaching with Steve Stedman, the SQL… Read More »Stedman Solutions Black Friday Exclusive!
DBA and Developer Interview Course: Promo is almost overNovember 29, 2024
Greetings, The journey towards mastering SQL Server can be intricate, demanding impeccable preparation, especially when anticipating significant interviews. Thus, I present a meticulously curated course: “DBA and Developer Interview Questions”. Course In-Depth For Aspiring DBAs and Developers: Aiming for a role in the SQL Server domain? This course caters to your every need, featuring comprehensive… Read More »DBA and Developer Interview Course: Promo is almost over
Happy Thanksgiving (US)November 28, 2024
In observance of the US federal holiday Thanksgiving, Stedman Solutions, LLC will be closed for the Fourth Thursday in November. If you need emergency help during this time, you can reach us through the contact us form, or for existing customers just contact one of us by our cell phone or text. -Steve Stedman
One-Day Thanksgiving SaleNovember 28, 2024
One-Day Thanksgiving Sale: Secure Your SQL Server & Job with 60% Off! Happy Thanksgiving to our cherished community. As we all look forward to a festive Black Friday, we’re serving up an early treat that’s valid for today only. This isn’t just another course sale; it’s an investment in crisis-proofing your professional future. Why This… Read More »One-Day Thanksgiving Sale
Why my SQL Server is slow?November 26, 2024
Understanding Why My SQL Server Is Slow If you’re wondering, “Why my SQL Server is slow?”, you’re not alone. SQL Server performance issues can disrupt critical business operations, delay projects, and frustrate users. A slow SQL Server often points to underlying issues that can be diagnosed and resolved with the right approach. In this blog… Read More »Why my SQL Server is slow?
WRITELOG Wait Type in SQL ServerNovember 24, 2024
Understanding the WRITELOG Wait Type in SQL Server What is the WRITELOG Wait Type? The WRITELOG wait type in SQL Server occurs when a task is waiting for the log buffer to be written to disk. SQL Server relies on a transaction log to guarantee data integrity, ensuring that all database modifications are recorded in… Read More »WRITELOG Wait Type in SQL Server
Podcast Episode 8 – Business ContinuityNovember 22, 2024
Watch / Listen Now – The Business Continuity episode Steve Stedman discusses the availability of the Stedman Solutions SQL podcast on YouTube and Spotify, and announces November class promotions with discounts up to 60% off. He emphasizes the importance of business continuity planning, especially in light of recent storms in the Pacific Northwest. Stedman outlines… Read More »Podcast Episode 8 – Business Continuity
Unlock Peak Performance with Our SQL Server Performance Tuning CourseNovember 22, 2024
Hey there, Are you ready to supercharge your SQL Server’s performance? If so, you’re in luck! We’re thrilled to announce an exclusive limited-time offer on our comprehensive SQL Server Performance Tuning course, designed to equip database professionals with the skills and knowledge needed to optimize SQL Server performance effectively. 50% OFF – Enroll Now for… Read More »Unlock Peak Performance with Our SQL Server Performance Tuning Course
Common Waits Reported by Daily Monitoring November 2024November 21, 2024
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. PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP MEMORY_ALLOCATION_EXT CXSYNC_PORT CXPACKET ASYNC_NETWORK_IO LCK_M_SCH_S LCK_M_S PREEMPTIVE_OS_GETPROCADDRESS CXCONSUMER Our daily monitoring product… Read More »Common Waits Reported by Daily Monitoring November 2024
The Perfect Bundle: Database Health Monitor + Blocking Query MonitorNovember 20, 2024
In our commitment to offer top-tier tools for database professionals, we’re thrilled to spotlight a bundle that’s a match made in tech heaven! Dive deep into the synergy of the Database Health Monitor and the Blocking Query Monitor, and discover how they not only complement each other but provide the ultimate solution to your SQL… Read More »The Perfect Bundle: Database Health Monitor + Blocking Query Monitor
Week 3 Class Discount Wrap-UpNovember 19, 2024
Another exciting week of promotions is coming to a close, and we want to make sure you don’t miss out on the fantastic discounts we’ve offered. These exclusive deals are about to expire, so grab them while you still can! In just a couple of days, these discounts will be replaced by exciting Thanksgiving, Black… Read More »Week 3 Class Discount Wrap-Up
Mastering the DBA and Developer Interview: Essential Prep CourseNovember 17, 2024
Whether you’re a recruiter searching for the perfect Database Administrator or an aspiring SQL Developer gearing up for that critical interview, navigating the intricate nuances of the SQL Server domain can be challenging. Our comprehensive “DBA and Developer Interview Questions” course is tailored just for you! https://stedman.us/INTERVIEW25 Unlock Your Potential with Expert-Designed Content For Candidates:… Read More »Mastering the DBA and Developer Interview: Essential Prep Course
Podcast Episode 7 – Brandie Kayser joins us!November 15, 2024
Join us this week as we discuss IT budgeting on the podast. Stedman SQL Server Podcast Ep. 7 Steve Stedman hosts the seventh episode of his podcast, discussing the importance of IT budgeting with Brandie Kayser from ROC-IT. Brandie emphasizes the need for regular IT assessments and budgeting to avoid unexpected expenses. She highlights the… Read More »Podcast Episode 7 – Brandie Kayser joins us!
An Introduction to SQL Server: A Guide for BeginnersNovember 15, 2024
Navigating the intricate world of databases can be daunting, especially if you’re new to SQL Server. Recognizing this challenge, we have designed a beginner-friendly course titled “Getting Started with SQL Server.” This course is tailored specifically for individuals who are unfamiliar with SQL Server, offering them a smooth transition into understanding its functionalities and tools.… Read More »An Introduction to SQL Server: A Guide for Beginners
Limited Time Offer: Dive into Our Exclusive Track Blocking Queries Course and ScriptNovember 14, 2024
In the rapidly evolving world of digital technology, a keen understanding of SQL Server blockages is non-negotiable. To help professionals like you harness the full potential of SQL Server, we’ve curated an exceptional course, complemented with our state-of-the-art track blocking queries script. Why is this offer different? Exclusivity: Beyond traditional coursework, you will have privileged… Read More »Limited Time Offer: Dive into Our Exclusive Track Blocking Queries Course and Script
SQL Server Long Running QueriesNovember 13, 2024
How to Monitor SQL Server Long Running Queries Monitoring long running queries in SQL Server is crucial for maintaining a well-performing database. When left unchecked, long running queries can slow down the server, increase resource consumption, and create bottlenecks that affect other processes. In this blog post, we’ll explore how to monitor SQL Server long… Read More »SQL Server Long Running Queries
Podcast Episode 6 – October Database Health Monitor New FeaturesNovember 11, 2024
Stedman SQL Podcast Episode 6 In episode six of the Stedman SQL podcast, Shannon Lindsay hosts George and Mitch to discuss new features in the database health monitor. They introduce a Quick Scan check for unscheduled SQL Server Agent jobs, which is particularly useful in cloud environments like RDS and Azure. Two major additions in… Read More »Podcast Episode 6 – October Database Health Monitor New Features
Nov Week 2 Class Discounts Roundup: Limited-Time Offers Expire Soon!November 10, 2024
Greetings, fellow learners and SQL enthusiasts! Time is of the essence, as we approach the end of another fantastic week of classes here at [Your Institution Name]. We’ve been delighted to see your enthusiasm for acquiring new skills and knowledge in the world of SQL Server. As we gear up for the upcoming week, it’s… Read More »Nov Week 2 Class Discounts Roundup: Limited-Time Offers Expire Soon!
Peak Performance with Our SQL Server Performance Tuning CourseNovember 9, 2024
Hey there, Are you ready to supercharge your SQL Server’s performance? If so, you’re in luck! We’re thrilled to announce an exclusive limited-time offer on our comprehensive SQL Server Performance Tuning course, designed to equip database professionals with the skills and knowledge needed to optimize SQL Server performance effectively. 50% OFF – Enroll Now for… Read More »Peak Performance with Our SQL Server Performance Tuning Course
Daily Server Monitoring – SQL Versions for NovemberNovember 7, 2024
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… Read More »Daily Server Monitoring – SQL Versions for November
Unlock Advanced SQL Techniques with Our Special Offer!November 7, 2024
Attention SQL enthusiasts and professionals! Our highly anticipated course on aggregation and window functions in SQL is now available at a promotional price. For a limited time, dive into the intricacies of SQL Server querying for just $3! This offer stands until November 15th. Coupon code AGG3
40% Off: Enhance Your SQL Skills with Common Table ExpressionsNovember 6, 2024
Common Table Expressions (CTEs) are an integral feature in SQL Server, enabling developers to produce more organized, readable, and maintainable code. Recognizing their importance, we’ve invested over 9 years into curating a course that encompasses every facet of CTEs. Drawing from experiences presenting at esteemed conferences, authoring a specialized book, and hosting myriad online sessions,… Read More »40% Off: Enhance Your SQL Skills with Common Table Expressions
Last Chance: Exclusive Week 1 Class Discounts!November 5, 2024
Hurry, there’s only a limited window of opportunity to snag these incredible deals on our SQL Server classes for November. In a few days, these offers will be history, making way for fresh promotions. 1. SQL Joins Type Class at a Whopping 40% Off Regularly priced at $29.99 USD, our best-selling JOINS Type class is… Read More »Last Chance: Exclusive Week 1 Class Discounts!
The Everything SQL Server Class BundleNovember 4, 2024
Hello SQL enthusiasts! Today, we are thrilled to bring to the spotlight our class offering – The Everything SQL Server Bundle. Specially curated for both the budding enthusiasts and the seasoned pros, this comprehensive package is here to revolutionize your SQL Server learning journey. Inside the Bundle From gearing up for those key interviews to… Read More »The Everything SQL Server Class Bundle
Unlock the Power of TSQL Output Clause: Only $2 for Limited Time!November 3, 2024
Enhance your SQL Server toolkit with an in-depth understanding of the TSQL Output Clause. For a mere $2, using the coupon code OUTPUT2, this course will guide you through the intricacies of one of SQL Server’s most underutilized features. Why is the SQL Server output clause so transformative? Immediate Feedback on Operations: Ever wanted instant… Read More »Unlock the Power of TSQL Output Clause: Only $2 for Limited Time!
Exclusive Offer: SQL Joins Course at 40% OffNovember 2, 2024
Our SQL Joins class is among the top favorites of our esteemed learners. At its regular pricing of $29.99 USD, many consider it an incredible value. Now, with our special offer, it gets even better. Use the coupon code JOINSNOV to avail a 40% discount and enroll in the course for just $17.99 USD. Course… Read More »Exclusive Offer: SQL Joins Course at 40% Off
SQL Server Class Specials this November at Stedman SolutionsNovember 1, 2024
November has always been a special month at Stedman Solutions, synonymous with outstanding offers on our SQL Server courses. As we transition into the festive season, we are thrilled to announce an entire month of unparalleled discounts and promotions. At Stedman Solutions, we’ve always believed in delivering unparalleled value. This November, we continue this tradition… Read More »SQL Server Class Specials this November at Stedman Solutions
Patching SQL ServerOctober 30, 2024
The Risks of Patching vs. Not Patching SQL Server Patching SQL Server is essential for security, performance, and compatibility. However, it can introduce risks like downtime or compatibility issues. Let’s look at both sides. Risks of Not Patching Security Vulnerabilities: Unpatched servers are prone to breaches and Ransomware. Data Corruption: Bugs can lead to data… Read More »Patching SQL Server
Podcast Episode 5 – PerformanceOctober 28, 2024
Stedman SQL Podcast Ep. 5 – Performance In episode five of the Stedman Solutions SQL Server podcast, Steve Stedman and Shannon Lindsay discuss common performance issues in SQL Server. They highlight the importance of indexing, emphasizing the need for proper index creation and avoiding multiple identical or single-column indexes. They address the impact of functions… Read More »Podcast Episode 5 – Performance
Final Days to Seize October Special at Stedman Solutions!October 28, 2024
For the month of October you will receive a free year of our SQL Server Daily Monitoring with the purchase of a SQL Server Assessment. Time is running out! There are only a few days left in October, which means you have a limited opportunity to benefit from our exclusive offer at Stedman Solutions. Purchase… Read More »Final Days to Seize October Special at Stedman Solutions!
Cost of Unplanned DowntimeOctober 26, 2024
How to Calculate the True Cost of Unplanned Downtime: Every Business is Different Unplanned downtime can wreak havoc on any organization, but the true cost is often far greater than what meets the eye. Whether it’s caused by hardware failure, data Corruption, or system crashes, the financial impact varies widely from business to business. However,… Read More »Cost of Unplanned Downtime
TSQL Output Clause CourseOctober 24, 2024
The output clause is one of the wow factor query items, where when people see you use it the just go WOW, I did not know you could do that. I can remember working with a client and showing that to them and getting that same reaction of WOW. Have you seen our SQL short… Read More »TSQL Output Clause Course
Unleash the Power with SQL Performance TuningOctober 23, 2024
Hey there, Steve Stedman here, and I couldn’t be more excited to share some insights on a service that has been making waves in the world of database management. Today, I want to shine a spotlight on Stedman Solutions’ exceptional SQL Performance Tuning service, which has helped countless businesses optimize their database performance and streamline… Read More »Unleash the Power with SQL Performance Tuning
Your Performance Tuning ToolkitOctober 23, 2024
How Database Health Monitor Can Be Your Performance Tuning Toolkit For more informationon Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at http://DatabaseHealth.com/download2. As a SQL Server DBA or developer, keeping your databases running smoothly is a top priority. One of the most challenging aspects of… Read More »Your Performance Tuning Toolkit
Common Waits Reported by Daily Monitoring This MonthOctober 21, 2024
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. PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP MEMORY_ALLOCATION_EXT CXSYNC_PORT CXPACKET LCK_M_SCH_S CXCONSUMER LCK_M_S RESOURCE_SEMAPHORE_QUERY_COMPILE LCK_M_IS Our daily monitoring product… Read More »Common Waits Reported by Daily Monitoring This Month
What Are the 3 Types of Replication in SQL Server?October 20, 2024
Replication in SQL Server is a powerful feature that allows you to copy and distribute data and database objects from one database to another and keep them synchronized. This is especially useful for scenarios like load balancing, high availability, or geographically distributed databases. Understanding the types of replication available in SQL Server is crucial for… Read More »What Are the 3 Types of Replication in SQL Server?
SQL Join Types PosterOctober 18, 2024
Download the Join Types poster today for FREE!Available for both SQL Server (TSQL) and MySQL. Check out the poster, it is a versatile, print-on-demand resource which you can customize according to your preference of size. This tool has been tailored to serve as a useful reference for both SQL Server developers and database administrators, simplifying… Read More »SQL Join Types Poster
Empower Your Projects with our Skilled TeamOctober 17, 2024
Empower Your Projects with our Skilled DBAs and Programmers: A Comprehensive Solution With a technical team of 5 people with well over 100 years of combined experience we are available to help with your next project. Our team of highly experienced Database Administrators (DBAs) and programmers is uniquely qualified to support and elevate your projects.… Read More »Empower Your Projects with our Skilled Team
Automatic SQL Server Tuning: The Pros and ConsOctober 16, 2024
Automatic SQL server tuning can seem like a dream come true for many database administrators and developers. The idea of software handling the intricate and time-consuming task of optimizing SQL queries automatically, freeing up time for other priorities, is appealing. But like any tool, Automatic SQL Tuning has its benefits and drawbacks. In this post,… Read More »Automatic SQL Server Tuning: The Pros and Cons
Podcast Episode 4 – ReplicationOctober 14, 2024
Replication on SQL Server – podcast episode by Steve Stedman. October 9, 2024 Steve Stedman discusses SQL Server replication, highlighting its use in synchronizing data between servers. He covers snapshot, transactional, and merge replication, explaining their functionalities and limitations. Snapshot replication provides a one-time copy of data, but can be inefficient during updates. Transactional replication… Read More »Podcast Episode 4 – Replication
Unlock the Full Potential of Your SQL ServerOctober 14, 2024
Unlock the Full Potential of Your SQL Server with Stedman Solutions’ Managed Services In today’s fast-paced world, your SQL Server database is more crucial than ever. It’s the powerhouse behind your most critical operations. That’s where Stedman Solutions, LLC, steps in. We offer flexible, fully managed services tailored to the unique demands of your SQL… Read More »Unlock the Full Potential of Your SQL Server
LCK_M_RIn_S_LOW_PRIORITY Wait Type in SQL ServerOctober 13, 2024
Understanding the LCK_M_RIn_S_LOW_PRIORITY Wait Type in SQL Server In SQL Server, understanding wait types is crucial for diagnosing performance issues and improving database efficiency. One of the less commonly encountered wait types that can impact performance is LCK_M_RIn_S_LOW_PRIORITY. Let’s dive into what it means, the context in which it occurs, and how to mitigate this… Read More »LCK_M_RIn_S_LOW_PRIORITY Wait Type in SQL Server
WRITE_COMPLETION Wait TypeOctober 11, 2024
Understanding the WRITE_COMPLETION Wait Type in SQL Server and Its Performance Impacts When it comes to SQL Server Performance tuning, understanding wait types is essential. One such wait type that often flies under the radar but can signal important I/O issues is WRITE_COMPLETION. This wait type can point to problems with your disk subsystem, particularly… Read More »WRITE_COMPLETION Wait Type
Understanding and Avoiding SQL Server LCK_M_U and LCK_M_X Wait TypesOctober 9, 2024
In SQL Server, Performance Tuning often involves examining Wait Statistics to understand what’s causing delays in query execution. Two common wait types that can significantly impact performance are LCK_M_U (Update Lock) and LCK_M_X (Exclusive Lock). These wait types occur when queries are blocked due to locking conflicts in the database. If you don’t manage locking… Read More »Understanding and Avoiding SQL Server LCK_M_U and LCK_M_X Wait Types
Podcast Episode 3 – Stedman SQL Server PodcastOctober 7, 2024
October, 2 2024 Steve Stedman emphasizes the critical importance of SQL Server data in business operations, highlighting the severe consequences of data loss. He recounts a ransomware attack on a regional hospital that resulted in the complete loss of patient data and backups, underscoring the need for robust backup and business continuity plans. Stedman stresses… Read More »Podcast Episode 3 – Stedman SQL Server Podcast
Podcast Episode 1October 7, 2024
September 18, 2024 Steve Stedman announced the transition of their live stream to a weekly podcast called the Stedman SQL Podcast. Shannon will assist with editing and streaming. The team is planning six months of content, including SQL Server training and new features for the Database Health Monitor (DHM). George and Mitchell, developers of DHM,… Read More »Podcast Episode 1
Daily Server Monitoring – SQL Versions for OctoberOctober 7, 2024
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… Read More »Daily Server Monitoring – SQL Versions for October
Top 10 Techniques to Turbocharge Your SQL Server PerformanceOctober 7, 2024
For the month of October you will receive a free year of our SQL Server Daily Monitoring with the purchase of a SQL Server Assessment. Top 10 Techniques to Turbocharge Your SQL Server Performance Understanding how to optimize your SQL Server performance is crucial for ensuring your applications and data-driven processes run smoothly. In this… Read More »Top 10 Techniques to Turbocharge Your SQL Server Performance
Daily Monitoring ProductOctober 5, 2024
A great way to keep tabs on the overall health of your SQL Server. Pricing: $129.99 per month per SQL Server instance when paid month to month. Payment on a recurring payment by credit card plan required. We provide monitoring tools that alert us when there is an issue so that we can recommend fixes… Read More »Daily Monitoring Product
The Power of an SQL Server Health AssessmentOctober 3, 2024
Optimizing Efficiency and Security: The Power of an SQL Server Health Assessment In today’s fast-paced technology landscape, businesses depend on efficient and secure data management to stay competitive. An SQL Server health assessment plays a crucial role in ensuring that your systems are running optimally, safeguarded from vulnerabilities, and prepared for future growth. In this… Read More »The Power of an SQL Server Health Assessment
Full year of Daily SQL Monitoring FREE with purchaseOctober 2, 2024
October Special at Stedman Solutions: Receive a Year of Free SQL Server Monitoring! For a limited time this October, Stedman Solutions is excited to announce an unbeatable offer. When you purchase a SQL Server Assessment, we’ll provide a full year of our renowned SQL Server Daily Monitoring service at no additional cost. We can help!https://stedman.us/performance… Read More »Full year of Daily SQL Monitoring FREE with purchase
Podcast Episode 2October 1, 2024
Steve Stedman and Craig Buchner discuss the benefits of SQL Server managed services, emphasizing stability, optimization, security, and business continuity. They highlight that managed services act as a cost-effective alternative to hiring full-time DBAs, offering comprehensive support for SQL servers. Key points include the ability to handle corruption repairs, performance optimization, and cloud migrations. Stedman… Read More »Podcast Episode 2
Common Reasons you may need to restore from backupsSeptember 30, 2024
Our Backup and Restore Course is designed to give you a comprehensive understanding of SQL Server backup strategies, restoration processes, and best practices. Whether you’re a beginner or an experienced DBA, this course covers everything from simple database backups to advanced techniques like transaction log backups, point-in-time recovery, and disaster recovery planning. Learn how to… Read More »Common Reasons you may need to restore from backups
Datacenter failure, can you get your backups?September 29, 2024
Our Backup and Restore Course is designed to give you a comprehensive understanding of SQL Server backup strategies, restoration processes, and best practices. Whether you’re a beginner or an experienced DBA, this course covers everything from simple database backups to advanced techniques like transaction log backups, point-in-time recovery, and disaster recovery planning. Learn how to… Read More »Datacenter failure, can you get your backups?
What is a SubQuerySeptember 28, 2024
What is a SQL Query Subquery? A subquery (also known as an inner select or nested query) is a query nested inside another SQL query. It allows you to build more complex queries by embedding one SELECT statement within another. Subqueries can help solve problems that require multiple steps or aggregations, and they enable you… Read More »What is a SubQuery
Are you ready to restore those backups?September 26, 2024
In our data-driven world, having a reliable backup for your SQL Server data is just half the battle; knowing how to effectively recover that data is equally vital. Stedman’s SQL Server Backup and Recovery Course is designed to equip you with not just the skills to back up your data, but more importantly, to recover… Read More »Are you ready to restore those backups?
Database Health Monitor Chart ColorsSeptember 25, 2024
The Meaning Behind the Colors in Database Health Monitor Charts One of the key aspects of effective database monitoring is quick, visual insight into what’s happening with your SQL Server. The Database Health Monitor tool has always aimed to make database management easier and more intuitive, and a big part of that is in how… Read More »Database Health Monitor Chart Colors
Database IntegritySeptember 23, 2024
Database Integrity in SQL Server: What It Is and Why It Matters Maintaining database integrity is one of the most critical aspects of managing any SQL Server environment. Simply put, database integrity ensures that the data stored in your SQL Server remains accurate, consistent, and reliable. However, when database integrity is compromised, it can lead… Read More »Database Integrity
Common Waits Reported by Daily Monitoring This MonthSeptember 21, 2024
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. PREEMPTIVE_OS_PIPEOPS MEMORY_ALLOCATION_EXT SP_SERVER_DIAGNOSTICS_SLEEP CXSYNC_PORT CXPACKET ASYNC_NETWORK_IO LCK_M_SCH_S LCK_M_IX LCK_M_S LCK_M_IS Our daily monitoring product scans… Read More »Common Waits Reported by Daily Monitoring This Month
Ransomware attack and your backup and recovery planSeptember 21, 2024
Recovering from a ransomware attack is a critical aspect of backup and recovery for SQL Server. Ransomware is a type of malicious software that encrypts files and demands payment in exchange for the decryption key. Ransomware attacks can cause significant damage to your organization’s data, and recovering from these attacks can be challenging. To recover… Read More »Ransomware attack and your backup and recovery plan
Backup and Restore Course OverviewSeptember 20, 2024
In today’s digital age, robust data backup and recovery systems are more crucial than ever. One minor glitch, hardware failure, or cyber-attack could spell disaster, especially for businesses that rely heavily on data. If you’re looking to secure your SQL Server data, Stedman’s SQL Server Backup and Recovery Course is an excellent investment in your… Read More »Backup and Restore Course Overview
Why Your SQL Server Backups Are More Crucial Than You Think: Lessons from the FrontlinesSeptember 18, 2024
Hello everyone, today, I want to talk about something near and dear to my heart: SQL Server backups. Trust me when I say that having a reliable backup is the guardian angel you never knew you needed until disaster strikes. Here’s why. The Reality of Emergency SQL Server Responses At Stedman Solutions, a portion of… Read More »Why Your SQL Server Backups Are More Crucial Than You Think: Lessons from the Frontlines
SQL Server Performance Tuning CourseSeptember 17, 2024
Boost Your SQL Server Performance with Expert Guidance! In this video, Steve Stedman from Stedman Solutions introduces his comprehensive SQL Server Performance Tuning course. Learn essential techniques to optimize your SQL Server, enhance query performance, and ensure efficient database management. Perfect for DBAs and IT professionals, this course covers everything from indexing strategies to performance… Read More »SQL Server Performance Tuning Course
Recovering from a ransomware attackSeptember 15, 2024
Recovering from a ransomware attack is a crucial aspect of backup and recovery for SQL Server, and it deserves a closer look. Ransomware attacks have become increasingly common and are a growing concern for many organizations. These attacks can cause significant damage to data, result in system downtime, and even disrupt business operations. Preventing ramsomware… Read More »Recovering from a ransomware attack
Recovering from accidental data deletesSeptember 15, 2024
Recovering from accidental data deletes is another crucial aspect of backup and recovery for SQL Server. Accidental data deletes can happen due to human error, software bugs, or other unforeseen events. When data is deleted, it can be challenging to recover, especially if there are no backups available. To recover from accidental data deletes, the… Read More »Recovering from accidental data deletes
In-House Team vs. Stedman SolutionsSeptember 14, 2024
The Real Cost of SQL Server Management: In-House Team vs. Stedman Solutions When managing your SQL Server environment, you’re faced with a critical decision: Should you build an in-house team, or should you outsource to specialists like Stedman Solutions? Let’s dive into the financial implications of both options to determine where your investment will provide… Read More »In-House Team vs. Stedman Solutions
Best Tool for Monitoring SQL Server PerformanceSeptember 12, 2024
Our best tool for monitoring SQL Server performance is Database Health Monitor. Why Database Health Monitor is the Best Tool for Monitoring SQL Server Performance In the world of SQL Server management, performance monitoring isn’t just a best practice—it’s a necessity. The right tools can be the difference between a smooth-running system and one plagued… Read More »Best Tool for Monitoring SQL Server Performance
Backup and recovery for SQL ServerSeptember 10, 2024
As a database professional, you know how critical it is to have a solid backup and recovery plan in place for your SQL Server environment. Whether you’re dealing with accidental data deletes, ransomware attacks, disk failures, or complete datacenter outages, having a well-planned backup and recovery strategy is essential to ensure that your organization can… Read More »Backup and recovery for SQL Server
Stedman Solutions Monitoring and Managed ServicesSeptember 9, 2024
Enhance Your SQL Server Environment with Stedman Solutions’ Monitoring and Managed Services When it comes to managing your SQL Server environment, performance and reliability are critical. A slow or unreliable database can cause everything from frustrated users to significant business disruptions. That’s why at Stedman Solutions, we go beyond standard managed services by integrating our… Read More »Stedman Solutions Monitoring and Managed Services
Daily Server Monitoring – SQL Versions for SeptemberSeptember 7, 2024
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… Read More »Daily Server Monitoring – SQL Versions for September
Backup and recovery relating to disk failureSeptember 5, 2024
Recovering from disk failure is a critical aspect of backup and recovery for SQL Server. A disk failure can occur due to a variety of reasons such as hardware failure, power outages, or natural disasters. When a disk failure occurs, it can result in data loss, system downtime, and even business disruption. To mitigate the… Read More »Backup and recovery relating to disk failure
Press Release: Stedman Solutions Launches New Partner ProgramSeptember 3, 2024
FOR IMMEDIATE RELEASE Download as a PDF. Contact Information: Craig Buchner512-968-2353partners@stedmansolutions.com Stedman Solutions Launches New Partner Program Enables MSPs, consulting firms, and system integrators to add SQL Server management and emergency SQL help to their service line card Ferndale, WA, September 3, 2024 – Stedman Solutions, a SQL Server MSP, has announced a new Partner… Read More »Press Release: Stedman Solutions Launches New Partner Program
The Importance of SQL Server Backup and Recovery: Learn from ExpertsSeptember 3, 2024
In the wise words of Benjamin Franklin, “If You Fail to Plan, You Are Planning to Fail.” This timeless adage holds particular relevance when it comes to safeguarding your SQL Server databases. A failure to adequately prepare for data loss scenarios—be it due to hardware malfunctions, data corruption, or increasingly prevalent ransomware attacks—can have devastating… Read More »The Importance of SQL Server Backup and Recovery: Learn from Experts
A Sneak Peek at the Backup and Recovery CourseSeptember 2, 2024
“Oh yes of course I have SQL Server backups” Take another look. Do they fit your needs? About 40% of new customers we meet do not have adequate backups for their business! That’s 1 in 3 companies! Insufficiently meeting the business needs, the consequences of inadequate database backups can be perilous. Failing to align backups… Read More »A Sneak Peek at the Backup and Recovery Course
Happy Labor DaySeptember 2, 2024
In observance of the US federal holiday Labor Day, Stedman Solutions, LLC will be closed for the first Monday in September. As the founder of Stedman Solutions, LLC, I would like to take this opportunity to thank all of the Team members for everything they do every day. If you need emergency help during this… Read More »Happy Labor Day
September Promotion on my backup and recovery course.September 1, 2024
Hey there! Steve Stedman here, and I’m thrilled to announce a special sale on my Backup and Recovery Course for SQL Server! As a database professional, you understand the critical importance of having a solid backup and recovery plan. It’s the difference between a minor hiccup and a major catastrophe that could disrupt your entire… Read More »September Promotion on my backup and recovery course.
Introducing SQL Server Mentoring: Your Shortcut to Expert GuidanceAugust 30, 2024
Hey there, Steve Stedman here, ready to share some exciting news with you. At Stedman Solutions, we understand that sometimes all you need is a little assistance without committing to a long-term arrangement. That’s why we’ve developed our SQL Server Mentoring service to cater specifically to your needs. SQL Server Mentoring is the perfect blend… Read More »Introducing SQL Server Mentoring: Your Shortcut to Expert Guidance
Database Health Monitor OverviewAugust 27, 2024
Database Health Monitor Database Health Monitor is a comprehensive tool designed to help SQL Server administrators keep their databases running smoothly. Developed to provide deep insights into the health and performance of SQL Server environments, it’s particularly valuable for those who want to prevent problems before they occur. Key Features of Database Health Monitor: Performance… Read More »Database Health Monitor Overview
August special – SQL Server Mentoring (and more)August 25, 2024
At Stedman Solutions, we strive to offer flexible consulting services to our clients, ranging from fixed-price projects to ongoing hourly work. Each approach caters to different needs, but today I want to shed light on one of our unique services that has proven particularly beneficial for our clients – our mentoring packages. Here’s how our… Read More »August special – SQL Server Mentoring (and more)
Common Waits Reported by Daily Monitoring This MonthAugust 21, 2024
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. PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP CXPACKET CXSYNC_PORT ASYNC_NETWORK_IO MEMORY_ALLOCATION_EXT LCK_M_IX LCK_M_SCH_S LCK_M_IS PREEMPTIVE_OS_GETPROCADDRESS Our daily monitoring product scans… Read More »Common Waits Reported by Daily Monitoring This Month
SQL Server Mentoring – We’ve got your back.August 20, 2024
Hey there, it’s Steve Stedman from Stedman Solutions. I’m reaching out today because I understand that, at times, we could all use a guiding hand without necessarily tying ourselves down to a lengthy commitment. And that’s exactly why we’ve introduced our SQL Server Mentoring service. Think of SQL Server Mentoring as a pocket-sized consultant, ready… Read More »SQL Server Mentoring – We’ve got your back.
Expertise at Its Best: Unleashing the Power of our Experienced DBAs and ProgrammersAugust 17, 2024
With a technical team of 5 people with well over 100 years of combined experience we are available to help with your next project. Our team of highly experienced Database Administrators (DBAs) and programmers is uniquely qualified to support and elevate your projects. They bring an array of expertise to the table, each with their… Read More »Expertise at Its Best: Unleashing the Power of our Experienced DBAs and Programmers