- SQL Server Performance Tuning CourseBoost 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…
- Recovering from a ransomware attack
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… - Recovering from accidental data deletes
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… - In-House Team vs. Stedman Solutions
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… - Best Tool for Monitoring SQL Server Performance
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 by bottlenecks, slowdowns, or even crashes. Enter Database Health Monitor: a tool… - Backup and recovery for SQL Server
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… - Stedman Solutions Monitoring and Managed Services
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… - Daily Server Monitoring – SQL Versions for September
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… - Backup and recovery relating to disk failure
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… - Press Release: Stedman Solutions Launches New Partner Program
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… - The Importance of SQL Server Backup and Recovery: Learn from Experts
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… - A Sneak Peek at the Backup and Recovery Course
“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… - Happy Labor Day
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… - September Promotion on my backup and recovery course.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…
- Introducing SQL Server Mentoring: Your Shortcut to Expert Guidance
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… - Database Health Monitor Overview
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… - August special – SQL Server Mentoring (and more)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…
- Common Waits Reported by Daily Monitoring This MonthEach 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…
- SQL Server Mentoring – We’ve got your back.
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… - Expertise at Its Best: Unleashing the Power of our Experienced DBAs and Programmers
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… - Master Your SQL Projects with Stedman Solutions SQL Server Mentoring
Whether you’re diving into an exciting new SQL project or struggling with ongoing ones, there’s one resource that can provide the support you need to drive your project to successful completion—Stedman Solutions’ SQL Server Mentoring. We are here to offer unmatched expertise and insights, helping you navigate the challenging landscape of SQL Server with ease…. - SQL Server Corruption Class – Learn How to Prepare and React
SQL Server Corruption Class – Learn How to Prepare and React Watch this video by Steve Stedman to find out more. For additional informative videos, visit my YouTube channel at https://www.youtube.com/@SteveStedman. There, you’ll find a wide range of content covering various topics, all designed to provide valuable insights and help you stay informed. Course Link… - Stedman Solutions, LLC Presents: The August Special on SQL Server MentoringWe are excited to announce our August special promotion tailor-made for those looking to hone their SQL skills and ensure their SQL servers operate at peak efficiency. Here’s the deal: When you sign up for our 4 or 8-hour SQL Server Mentoring program, you won’t just benefit from our comprehensive guidance and expertise. As a…
- TSQL Output Clause Class
Using the TSQL Output Clause The SQL Server Output Clause is a powerful feature for retrieving data from INSERT, UPDATE, or DELETE statements. This class will show you how to leverage the Output Clause for auditing, tracking changes, and creating an undo mechanism. An often overlooked feature, it can significantly enhance your ability to write… - Exclusive SQL Performance Tuning TrainingSteve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and tricks to get more performance out of your SQL Server. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. What…
- Daily Server Monitoring – SQL Versions for AugustOut 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…
- Join Types Poster
I have been getting a lot of good feedback on twitter lately about the JOIN Types poster. Hi, Steve Stedman here, and I want to share with you a poster that I have created that provides a visual representation of the different join types in SQL Server. The poster is available at https://stedman.us/largePoster, and it… - Need some help? We provide mentoring
Do you aspire to refine your SQL Server abilities and elevate your professional standing? Your search ends here! Stedman Solutions’ SQL Server Mentoring offers an ideal solution for IT specialists keen on advancing their skillset. Our mentoring program is characterized by its personalized, interactive nature, ensuring you receive tailored guidance and support to maximize your… - Is your DBA on Vacation
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… - Overview of Classes at Stedman SQL School
Welcome to Stedman’s SQL School! In this video, we provide an in-depth overview of all the classes we offer to help you master SQL Server. Whether you are a beginner or an experienced professional, our courses cover a wide range of topics tailored to enhance your SQL skills and knowledge. Watch this video by Steve… - August Promotion Mentoring includes Free Daily Monitoring
For the month of August we are running a promotion. When you purchase a 4 or 8 hour mentoring block with Stedman Solutions, you will receive 6 months of our Daily Monitoring product for free. The monitoring is over a $600 value. As an IT professional working on SQL projects, you may occasionally find yourself… - Exclusive SQL Performance Tuning TrainingSteve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and tricks to get more performance out of your SQL Server. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. What…
- Shrinking Databases
Understanding SHRINKDB in SQL Server: Pros, Cons, and Best Practices Introduction When managing SQL Server databases, one of the tasks that often comes up is the need to reclaim space. This is where the SHRINKDATABASE (SHRINKDB) command comes into play. However, while shrinking a database can seem like a quick fix for storage issues, it’s… - Free Ransomware Awareness ClassFree Ransomware Awareness Class – Essential Protection for Your Business | Stedman Solutions Watch this video by Steve Stedman to find out more. For additional informative videos, visit my YouTube channel at https://www.youtube.com/@SteveStedman. There, you’ll find a wide range of content covering various topics, all designed to provide valuable insights and help you stay informed….
- Statistics and Blocking Query Monitoring
Thank you for considering Database Health Monitor as your go-to tool for monitoring and optimizing your databases. In addition to the benefits I mentioned in my previous article, I’d like to discuss how our tool can help you with two specific challenges: wait statistics and blocking queries. Wait Statistics Wait statistics are critical for understanding… - Data Aggregation with SQL Server
Aggregating Data in Your SQL Server Are you ready to take your SQL skills to the next level? Our Aggregating Data in Your SQL Server course offers a comprehensive guide to mastering aggregation, grouping, and windowing functions in SQL Server queries. In This Course This detailed course covers everything from basic aggregation to advanced windowing… - SQL Server Join Types Class by Steve Stedman
Master SQL Server Join Types with Steve Stedman! Join SQL Server expert Steve Stedman as he dives into the essential topic of SQL Server join types. Whether you’re a beginner or looking to sharpen your skills, this short video covers the fundamentals of INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, and CROSS JOIN…. - Common Waits Reported by Daily Monitoring This MonthEach 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 CXPACKET ASYNC_NETWORK_IO CXSYNC_PORT LCK_M_SCH_S LCK_M_IX LCK_M_IS RESOURCE_SEMAPHORE_QUERY_COMPILE Our daily monitoring product scans…
- Mastering SQL Server Replication
Mastering SQL Server Replication: A Comprehensive Class by Stedman Solutions Are you ready to take your SQL Server skills to the next level? Join us in this detailed video where we dive into our comprehensive SQL Server Replication class. Whether you’re a database administrator, data architect, or IT professional, this class is designed to provide… - Discover Stedman SolutionsDiscover Stedman Solutions: Your Go-To for SQL Server Management In today’s data-driven world, managing your SQL Server environment efficiently and securely is crucial for any business. If you’ve never heard of Stedman Solutions, LLC before, this blog post will introduce you to what we do and explain why we are the best choice for your…
- DBA on Vacation
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… - SQL DBA and Developer Interview Prep Course
SQL DBA and Developer Interview Prep Course Get Ready for Your Next Interview Whether you’re about to hire a DBA or Database Developer, or preparing to interview for one of those roles, our course is designed to guide you through the interview process from both perspectives. Sign up now! Why This Course? SQL Server remains… - Whats your next project? Can the Stedman Solutions team help?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…
- Backup and Recovery CourseWelcome to our Backup and Recovery Course! In today’s digital age, data is the lifeline of any business. Ensuring its safety and availability is paramount. Our comprehensive Backup and Recovery Course is designed to equip you with the essential skills and knowledge to safeguard your data effectively. What You’ll Learn: Understanding the importance of data…
- WITH NOLOCK Hint
NOLOCK Hint in SQL Queries: Myths, Misconceptions, and Best Practices In the world of SQL Server, the NOLOCK hint often generates spirited debates among database professionals. This hint is frequently used but equally misunderstood. In this blog post, we’ll explore what the NOLOCK hint does, dispel some common myths and misconceptions, and provide best practices… - Daily Server Monitoring – SQL Versions for JulyOut 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…
- Staff Augmentation – we can help with your DBA needs.
As the founder and owner of Stedman Solutions, LLC, I understand the challenges you face when your DBA or developer plans a vacation or when you find yourself in need of temporary assistance. That’s why our team at Stedman Solutions is here to help. When your valued staff members take time off, we can step… - Exploring Automatic Tuning Options in SQL Server
Exploring Automatic Tuning Options in SQL Server Automatic tuning in SQL Server is a powerful feature designed to help database administrators (DBAs) maintain optimal performance without the need for constant manual intervention. By leveraging built-in intelligence, SQL Server can automatically identify and resolve performance issues, making it an invaluable tool for both experienced and novice… - Closed in observance of Independence day
Stedman Solutions will be closed on the 4th of July to celebrate Independence Day. We wish everyone a safe and happy holiday. 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. July… - Sample SQL Databases in SQL Server
Sample SQL Databases in SQL Server SQL Server is a robust relational database management system that offers a variety of features for data management, analysis, and reporting. One of the great resources for learning and testing SQL Server capabilities is the set of sample databases provided by Microsoft. These databases are rich with sample data… - Happy Canada Day to my Canadian Customers and Friends
As we all know, July 1st holds a special place in the hearts of Canadians. It’s a day that stands as a testament to the founding of a nation. It’s Canada Day! This day is not just about the warm summer sun, barbeques, and dazzling fireworks. It’s about celebrating the shared values, culture, and historical… - July is Database Health Monitor Month
July is here and that means it’s time for us to pivot our collective gaze to the pulse of our digital lifeblood – our databases! As the founder of Database Health and Stedman Solutions, I am excited to declare this month as Database Health Monitor Month! This is our annual opportunity to appreciate the often-unseen… - SQL Server Compatibility Levels
Understanding SQL Server Compatibility Levels In the world of SQL Server, compatibility levels play a crucial role in ensuring that your database applications run smoothly even after upgrading to a newer version of SQL Server. By understanding and managing these compatibility levels, you can avoid potential issues and leverage new features while maintaining stability and… - Enterprise vs Standard
Enterprise SQL Server vs. Standard SQL Server: Making the Right Choice for Your Business Choosing the right SQL Server edition is a critical decision for any business, affecting performance, scalability, and cost. Microsoft offers several editions of SQL Server, but the most commonly compared are the Enterprise and Standard editions. In this blog post, we… - Free Join Types PosterI have been getting a lot of good feedback on twitter lately about the JOIN Types poster.Download the Join Types poster today for FREE!Available for both SQL Server (TSQL) and MySQL. Some of the join types covered are: Inner Join: Returns records that have matching values in both tables. Left (Outer) Join: Returns all records…
- Microsoft Certified Master for SQL Server Program
Reflecting on the Microsoft Certified Master for SQL Server Program In the SQL Server community, the Microsoft Certified Master (MCM) for SQL Server program was a notable certification that ran from 2008 until its retirement in 2013. While not as widely pursued or recognized as some other certifications, the MCM program was aimed at seasoned… - Our Managed Services package
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. Our managed services for SQL Server often include the following features: Database Administration: The service provider… - Common Waits Reported by Daily Monitoring This MonthEach 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 CXPACKET ASYNC_NETWORK_IO LCK_M_SCH_S LCK_M_S LCK_M_IX LCK_M_IS LCK_M_U Our daily monitoring product scans…
- Staff Augmention – We can help!As the founder and owner of Stedman Solutions, LLC, I understand the challenges you face when your DBA or developer plans a vacation or when you find yourself in need of temporary assistance. That’s why our team at Stedman Solutions is here to help. When your valued staff members take time off, we can step…
- Understanding Worktables in SQL Server
In the realm of SQL Server, efficient query processing and resource management are crucial for maintaining performance and reliability. One of the often-overlooked components that play a vital role in query execution is the worktable. In this blog post, we’ll delve into what worktables are, how they function, and why they are important for SQL… - July 6th – Rockin’ the Code World
I’m thrilled to announce that I’ll be joining Rockin’ the Code World with dotNetDave for a special session on July 6th! A couple of years ago, I had the pleasure of being on the show with Dave, and I’m excited to be back for another episode. This time, we’re diving into an important, though less… - Understanding RPO and RTO with SQL Server
Understanding RPO and RTO with SQL Server In the realm of SQL Server management, two crucial concepts that every DBA and IT manager must understand are Recovery Point Objective (RPO) and Recovery Time Objective (RTO). These metrics are pivotal in planning for disaster recovery and ensuring business continuity. Let’s dive into what RPO and RTO… - Why Your SQL Server Needs Expert Managed Services
Managing a SQL Server environment can be a daunting task, especially for businesses without a dedicated DBA team. SQL Server issues can lead to significant downtime, data corruption, and performance bottlenecks that can impact your bottom line. At Stedman Solutions, we specialize in SQL Server managed services, ensuring your systems run smoothly, securely, and efficiently…. - Daily Server Monitoring – SQL Versions for JuneOut 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…
- TSQL Output Clause Course
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… - 10 Reasons to Consider Stedman Solutions SQL Server Managed Services
10 Reasons to Consider Stedman Solutions SQL Server Managed Services As the demands on your SQL Server environment increase, it’s crucial to ensure its performance, security, and reliability. Stedman Solutions offers specialized SQL Server managed services designed to keep your databases running smoothly and efficiently. Here are ten compelling reasons to consider Stedman Solutions for…
Contact Info
Stedman Solutions, LLC.PO Box 3175
Ferndale WA 98248
Phone: (360)610-7833