Latest 100 Posts

• 
  Keep Your SQL Server Running Smoothly During the HolidaysDecember 22, 2024
  Keep Your SQL Server Running Smoothly During the Holidays with Stedman Solutions’ Managed Services Contact us to find out how Stedman Solutions can help with your SQL Server environment. The holiday season is… Read More »Keep Your SQL Server Running Smoothly During the Holidays
• 
  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.… Read More »Common Waits Reported by Daily Monitoring This Month
• 
  Are All My Databases Encrypted?December 21, 2024
  TDE: Are All My Databases Encrypted? One of the most critical aspects of database management is ensuring that sensitive data is protected. In SQL Server, encryption provides an additional layer of security to… Read More »Are All My Databases Encrypted?
• 
  Stedman SQL Podcast Ep. 11 New Database Health FeaturesDecember 20, 2024
  Monitoring SQL Server Performance: Database Health Monitor’s New Features In the latest episode of the SQL Server Podcast, we explore exciting updates to Database Health Monitor, our free tool designed to help SQL… Read More »Stedman SQL Podcast Ep. 11 New Database Health Features
• 
  SQL Server Wait Type: LCK_M_RS_SDecember 19, 2024
  Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the… Read More »SQL Server Wait Type: LCK_M_RS_S
• 
  Left Outer Join with ExclusionDecember 18, 2024
  SQL Server Left Outer Join with Exclusion: Explained When working with SQL Server, there are many scenarios where you need to combine data from multiple tables. Often, a LEFT OUTER JOIN is used… Read More »Left Outer Join with Exclusion
• 
  Export Data from SQL Server to ExcelDecember 17, 2024
  Learn how to Export SQL to Excel. How to Export SQL to Excel Exporting data from SQL Server to Excel is a common task that DBAs, developers, and business users often need to… Read More »Export Data from SQL Server to Excel
• 
  Get your Join Types PosterDecember 16, 2024
  Download the Join Types poster today for FREE!Available for both SQL Server (TSQL) and MySQL. The poster includes detailed graphical representations of several join types: inner join, left outer join, right outer join,… Read More »Get your Join Types Poster
• 
  SQL Order of Joins PerformanceDecember 15, 2024
  Understaing SQL Order of Joins Performance When it comes to optimizing SQL queries, one of the critical aspects to consider is the order of joins in your query. While SQL Server’s optimizer is… Read More »SQL Order of Joins Performance
• 
  SQL Server Error 18456: Login FailedDecember 14, 2024
  Understanding and Resolving SQL Server Error 18456: Login Failed for User SQL Server Error 18456 is a common login error that can cause headaches for database administrators and developers alike. The error message… Read More »SQL Server Error 18456: Login Failed
• 
  10 Most Common Wait TypesDecember 13, 2024
  Understanding the Top 10 Most Common Wait Types in SQL Server When managing SQL Server Performance, understanding wait types is crucial for diagnosing and troubleshooting issues. Wait types provide insight into where SQL… Read More »10 Most Common Wait Types
• 
  New SQL Update from MicrosoftDecember 12, 2024
  Today Microsoft released a new update for SQL Server. SQL Server 2019 CU30 for 2019 (15.0.4415.2 – December 2024) CU29 + GDR (15.0.4410.1 – November 2024) 2024-12-12 Here are the latest updates for… Read More »New SQL Update from Microsoft
• 
  Database Health Monitor: Duplicate IndexesDecember 12, 2024
  Why Duplicate Indexes Are Bad in SQL Server Indexes are one of the most powerful tools in SQL Server for improving query performance. However, like most powerful tools, they must be used wisely.… Read More »Database Health Monitor: Duplicate Indexes
• 
  SQL Server DBCC Commands: DBCC WRITEPAGEDecember 11, 2024
  DBCC WRITEPAGE is an undocumented and unsuported DBCC command in Microsoft SQL Server that can be used to write a page of data from a database to a specified file on disk. It… Read More »SQL Server DBCC Commands: DBCC WRITEPAGE
• 
  SQL School: ANTI LEFT JOINDecember 10, 2024
  Understanding the Anti Left Join in SQL Server An anti left join, also known as a left join with exclusion, is a query pattern used to retrieve rows from one table that do… Read More »SQL School: ANTI LEFT JOIN
• Securing SQL Server: Basic Security MeasuresDecember 9, 2024
  There are several ways that you can secure SQL Server, including: Enabling authentication and authorization: This helps ensure that only authorized users can access the SQL Server instance and the data it stores.… Read More »Securing SQL Server: Basic Security Measures
• 
  Database Health Monitor: Insight Into Database PerformanceDecember 8, 2024
  Why Database Health Monitor is Essential for DBAs As a database administrator, having a reliable, efficient monitoring tool is essential to ensure your database remains healthy, performs optimally, and avoids potential disasters. Over… Read More »Database Health Monitor: Insight Into Database Performance
• 
  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… Read More »Daily Server Monitoring – SQL Versions for December
• 
  Database Health Monitor – Free DownloadDecember 7, 2024
  Hello there! My name is Steve Stedman, and I want to tell you about an amazing product from Stedman Solutions, the Database Health Monitor. As a professional database administrator, I understand how vital… Read More »Database Health Monitor – Free Download
• 
  SOS_WORK_DISPATCHER Wait TypeDecember 5, 2024
  Understanding the SOS_WORK_DISPATCHER Wait Type in SQL Server. In SQL Server, the SOS_WORK_DISPATCHER wait type indicates a delay in dispatching a worker thread to process a specific workload. This wait typically arises when… Read More »SOS_WORK_DISPATCHER Wait Type
• 
  December 2024 Release – Version 1080 Release NotesDecember 4, 2024
  The December 2024 update for Database Health Monitor is here, and it’s packed with new features, usability enhancements, and bug fixes to make SQL Server monitoring even better. Whether you’re managing dozens of… Read More »December 2024 Release – Version 1080 Release Notes
• 
  Merge Replication TutorialDecember 4, 2024
  Merge Replication SQL Server Tutorial When it comes to synchronizing data across multiple databases in SQL Server, one of the most flexible methods is merge replication. It’s particularly useful in scenarios where changes… Read More »Merge Replication Tutorial
• 
  SQL Server Corruption: What Can Get CorruptedDecember 3, 2024
  Over the years I have documented many of the concepts around corruption repair. Want to find out more, check out the corruption category at by blog. In a Microsoft SQL Server database, several… Read More »SQL Server Corruption: What Can Get Corrupted
• 
  Cyber Monday – 60% off Cyber Monday Deal – Backup and Recovery CourseDecember 2, 2024
  For Cyber Monday, and we’re thrilled to present an offer that’s too good to pass up. Are you ready to supercharge your knowledge in backup and recovery? Now is the perfect time! Cyber… Read More »Cyber Monday – 60% off Cyber Monday Deal – Backup and Recovery Course
• 
  Cyber Monday – 80% off Cyber Monday Deal – Backup and Recovery CourseDecember 2, 2024
  For Cyber Monday, and we’re thrilled to present an offer that’s too good to pass up. Are you ready to supercharge your knowledge in backup and recovery? Now is the perfect time! Cyber… Read More »Cyber Monday – 80% off Cyber Monday Deal – Backup and Recovery Course
• 
  Cyber Monday – Cyber Monday Deal – Backup and Recovery CourseDecember 1, 2024
  For Cyber Monday, and we’re thrilled to present an offer that’s too good to pass up. Are you ready to supercharge your knowledge in backup and recovery? Now is the perfect time! Cyber… Read More »Cyber Monday – Cyber Monday Deal – Backup and Recovery Course
• 
  SQL Server Wait Type: SOS_PHYS_PAGE_CACHEDecember 1, 2024
  Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the… Read More »SQL Server Wait Type: SOS_PHYS_PAGE_CACHE
• 
  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!… Read More »Saturday Sale: 50% Off SQL Server Replication Course!
• 
  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… Read More »Interview Course: Promo is almost over
• 
  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… Read More »Stedman Solutions Black Friday Exclusive!
• 
  One-Day Thanksgiving Sale: with 60% Off!November 28, 2024
  Grab the opportunity here before it is gone and don’t forget to use the coupon code BACK60. Happy Thanksgiving to our cherished community. As we all look forward to a festive Black Friday,… Read More »One-Day Thanksgiving Sale: with 60% Off!
• 
  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… Read More »Happy Thanksgiving (US)
• 
  Protect Your Business: Free Ransomware Awareness Course!November 28, 2024
  In our digital age, ransomware attacks are more prevalent than ever. From startups to multinational corporations, nobody is safe from the devastating impact of these malicious software attacks. Having witnessed firsthand the havoc… Read More »Protect Your Business: Free Ransomware Awareness Course!
• 
  Thanksgiving Bonanza: Backup & Recovery with 60% Off!November 28, 2024
  Happy Thanksgiving to our amazing community! As we pause to appreciate the good things in life, we have something special to help you secure one of the most important assets in your world—your… Read More »Thanksgiving Bonanza: Backup & Recovery with 60% Off!
• 
  IO_COMPLETION Wait Type and WRITE_COMPLETION Wait TypeNovember 27, 2024
  WRITE_COMPLETION Wait type can be an indicator that you may be having IO issues. In SQL Server, I/O performance is critical to overall system health and responsiveness. When performance problems arise, it’s often… Read More »IO_COMPLETION Wait Type and WRITE_COMPLETION Wait Type
• 
  The Risks of Patching vs. Not Patching SQL ServerNovember 26, 2024
  The Risks of Patching vs. Not Patching SQL Server: Why It Matters and How Stedman Solutions Can Help Patching SQL Server can feel like a double-edged sword. On one hand, it’s essential to… Read More »The Risks of Patching vs. Not Patching SQL Server
• 
  T-SQL WAITFOR CommandNovember 24, 2024
  Understanding the T-SQL WAITFOR Command in SQL Server Introduction to the WAITFOR Command The WAITFOR command in T-SQL is used to introduce a delay in the execution of SQL Server scripts or to… Read More »T-SQL WAITFOR Command
• 
  Securing SQL Server: Securing CLRNovember 23, 2024
  CLR (Common Language Runtime) is a feature of SQL Server that allows you to create and run managed code within the database engine. Enabling CLR on SQL Server allows you to create stored… Read More »Securing SQL Server: Securing CLR
• 
  Unlock Peak Performance with Our SQL Server Performance Tuning CourseNovember 22, 2024
  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… Read More »Unlock Peak Performance with Our SQL Server Performance Tuning Course
• 
  Common Waits Reported by Daily Monitoring This MonthNovember 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.… Read More »Common Waits Reported by Daily Monitoring This Month
• 
  The Everything SQL Server Class BundleNovember 21, 2024
  Hey there, SQL enthusiasts and fellow learners! Grab your spot and capitalize on our special pricing. I’m genuinely excited to share something I’ve been working on: the Everything SQL Server Bundle. Whether you’re… Read More »The Everything SQL Server Class Bundle
• 
  Check out this bundle: Database Health Monitor + Blocking Query MonitorNovember 20, 2024
  If you, like me, are always on the lookout for the best tools for database management, then you’re in for a treat! I’ve recently released this bundle that’s honestly too good not to… Read More »Check out this bundle: Database Health Monitor + Blocking Query Monitor
• 
  Week 3 Class Discount Wrap-Up: Your Last Chance to Save!November 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,… Read More »Week 3 Class Discount Wrap-Up: Your Last Chance to Save!
• 
  SQL Server Corruption: How Often Should I Run CheckDBNovember 18, 2024
  If you are reading this article becuase you are trying to repair your corruptin database, please reach out ot us at Stedman Solutions we can take a quick look and help determine your… Read More »SQL Server Corruption: How Often Should I Run CheckDB
• 
  Mastering the DBA and Developer Interview: My Personal RecommendationNovember 17, 2024
  Hey folks! If you’re anything like me, preparing for a big interview, especially in the SQL Server domain, can be nerve-wracking. That’s why I want to share this incredible course I recently discovered:… Read More »Mastering the DBA and Developer Interview: My Personal Recommendation
• 
  Unlock Peak Performance with Our SQL Server Performance Tuning CourseNovember 16, 2024
  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… Read More »Unlock Peak Performance with Our SQL Server Performance Tuning Course
• 
  Database Health: Free Download – Database Health MonitorNovember 16, 2024
  The Database Health Monitor for SQL Server is available for download on our website, and the best part is that it’s a free trial ! The free download provides access to all the… Read More »Database Health: Free Download – Database Health Monitor
• 
  Starting Out with SQL ServerNovember 15, 2024
  My Recommendations for Beginners If you’re anything like me when I first dipped my toes into the world of databases, SQL Server can feel a tad overwhelming. But fear not! I’ve found this… Read More »Starting Out with SQL Server
• 
  New SQL Update from MicrosoftNovember 14, 2024
  Today Microsoft released a new update for SQL Server. SQL Server 2022 CU16 for 2022 (16.0.4165.4 – November 2024) CU15 + GDR (16.0.4155.4 – November 2024) 2024-11-14 Here are the latest updates for… Read More »New SQL Update from Microsoft
• 
  Limited Time Offer: Dive into SQL Server Blocking with Our Exclusive ScriptNovember 14, 2024
  Hey there, fellow SQL DBA and Developers I’ve been immersed in the world of database administration for over 33 years now, and if there’s one thing I’ve learned, it’s that understanding SQL Server… Read More »Limited Time Offer: Dive into SQL Server Blocking with Our Exclusive Script
• 
  Automatic SQL Server TuningNovember 13, 2024
  Automatic SQL Tuning: The Pros and Cons Automatic SQL tuning aims to simplify the optimization of SQL queries by automating the process. It can save time and improve performance, but it’s important to… Read More »Automatic SQL Server Tuning
• 
  New SQL Update from MicrosoftNovember 12, 2024
  Today Microsoft released a new update for SQL Server. SQL Server 2016 CU17 + GDR for SP2 (13.0.5893.48 – June 2022) CU17 for 2016 SP2 (13.0.5888.11 – March 2021) CU15 + GDR for… Read More »New SQL Update from Microsoft
• 
  The Everything SQL Server Class BundleNovember 12, 2024
  Welcome to all SQL enthusiasts! We’re ecstatic to introduce our comprehensive offering – The Everything SQL Server Bundle. Whether you’re just starting out or a seasoned professional, this bundle promises to elevate your… Read More »The Everything SQL Server Class Bundle
• 
  CXPACKET and CXCONSUMERNovember 11, 2024
  Understanding the CXPACKET and CXCONSUMER Wait Types in SQL Server In SQL Server, two of the most commonly encountered wait types are CXPACKET and CXCONSUMER. These wait types are closely tied to parallel… Read More »CXPACKET and CXCONSUMER
• 
  November Week 2 Discounts 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… Read More »November Week 2 Discounts Offers Expire Soon!
• 
  SQL Server Wait Type: PAGEIOLATCH_UPNovember 10, 2024
  Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the… Read More »SQL Server Wait Type: PAGEIOLATCH_UP
• 
  Unlock Peak Performance with Our SQL Server Performance Tuning CourseNovember 9, 2024
  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… Read More »Unlock Peak Performance with Our SQL Server Performance Tuning Course
• 
  SQL Server DBCC Commands: DBCC FREEPROCCACHENovember 8, 2024
  DBCC FREEPROCCACHE is a DBCC command in Microsoft SQL Server that can be used to clear the procedure cache, which is a region of memory that stores the execution plans for stored procedures,… Read More »SQL Server DBCC Commands: DBCC FREEPROCCACHE
• 
  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… Read More »Daily Server Monitoring – SQL Versions for November
• 
  Aggregation: A Special Course OfferNovember 7, 2024
  Hey everyone! I’m thrilled to share something special. For those looking to truly master SQL Server’s aggregation and window functions, I’ve stumbled upon an amazing course that’s being offered at an insane discount.… Read More »Aggregation: A Special Course Offer
• 
  Discovering the Magic of CTEs in SQL ServerNovember 6, 2024
  Hey there, SQL developers and DBA’s I’ve always been captivated by Common Table Expressions (CTEs) in SQL Server. There’s something about streamlining complex queries and making them more readable that I find incredibly… Read More »Discovering the Magic of CTEs in SQL Server
• 
  Week 1 Class Discounts: Almost Gone!November 5, 2024
  Posted on: 11/5/2023 at SteveStedman.com Hey folks! Time’s flying and there are only a few days left to grab the special discounts on my SQL Server classes for November. If you’ve been contemplating,… Read More »Week 1 Class Discounts: Almost Gone!
• 
  Introducing the Everything SQL Server BundleNovember 4, 2024
  Have you seen the Stedman SQL School – The Everything SQL Server Bundle. Curated with both budding enthusiasts and seasoned professionals in mind, this comprehensive package is set to revolutionize your SQL Server… Read More »Introducing the Everything SQL Server Bundle
• 
  Mastering the TSQL Output Clause: Exclusive OfferNovember 3, 2024
  Welcome, today I am thrilled to present a unique opportunity to deep dive into one of SQL Server’s most underappreciated features: the TSQL Output Clause. For a limited time, and for just $2… Read More »Mastering the TSQL Output Clause: Exclusive Offer
• 
  Grab My Favorite SQL Joins Course at a Special Discount!November 2, 2024
  Hey dear readers! I’ve always raved about the SQL Joins mastery class. It’s one of those resources I genuinely love. The regular price stands at $29.99 USD which, to be honest, is already… Read More »Grab My Favorite SQL Joins Course at a Special Discount!
• 
  November’s the Time for Crazy SQL Deals!November 1, 2024
  Hey there! Guess what? It’s that time of the year again – good ol’ November, when I go a bit crazy and slash the prices on my SQL Server courses. If you’ve been… Read More »November’s the Time for Crazy SQL Deals!
• 
  New SQL Update from MicrosoftOctober 31, 2024
  Today Microsoft released a new update for SQL Server. SQL Server 2019 CU29 for 2019 (15.0.4405.4 – October 2024) CU28 + GDR (15.0.4395.2 – October 2024) 2024-10-31 Here are the latest updates for… Read More »New SQL Update from Microsoft
• 
  SQL Server Corruption: Stories About Causes of CorruptionOctober 31, 2024
  The integrity of a Microsoft SQL Server database can be severely undermined by corruption, leading to data inaccessibility and potential operational disasters. Steve Stedman’s comprehensive approach to identifying and rectifying such corruption is… Read More »SQL Server Corruption: Stories About Causes of Corruption
• 
  SQL CountersOctober 30, 2024
  SQL Counters: Understanding sys.dm_os_performance_counters in SQL Server Monitoring SQL Server Performance is crucial for ensuring optimal operation. One essential tool for this is the Dynamic Management View (DMV) sys.dm_os_performance_counters. This DMV provides real-time… Read More »SQL Counters
• 
  The Five Most Popular Features of Database Health MonitorOctober 29, 2024
  The Five Most Popular Features of Database Health Monitor Deadlock Analysis: Automatically captures and analyzes deadlocks, providing clear insights to resolve these conflicts and prevent them from recurring. Wait Stats Monitoring: Quickly identifies… Read More »The Five Most Popular Features of Database Health Monitor
• 
  SQL With IF StatementOctober 28, 2024
  The other day I was asked how to use SQL with an IF Statement, so here is my blog post to cover that question. Using the IF Statement in T-SQL for SQL Server… Read More »SQL With IF Statement
• 
  LEFT OUTER JOIN and RIGHT OUTER JOINOctober 26, 2024
  Understanding the Difference Between LEFT OUTER JOIN and RIGHT OUTER JOIN in SQL Server When working with SQL Server, one of the fundamental concepts is joining tables to retrieve data. LEFT OUTER JOIN… Read More »LEFT OUTER JOIN and RIGHT OUTER JOIN
• 
  November Promotion at Stedman SQL SchoolOctober 25, 2024
  Just 6 days from now our November promotion at Stedman SQL School begins. For the entire month of November, we will be offering some of the biggest discounts on our SQL courses ever.… Read More »November Promotion at Stedman SQL School
• 
  October 2024 Release – Version 1074 Release NotesOctober 24, 2024
  The latest October 2024 release (Version 1074) of Database Health Monitor brings exciting new features, enhancements, and important bug fixes to improve your SQL Server monitoring and diagnostic experience. Here’s a detailed breakdown… Read More »October 2024 Release – Version 1074 Release Notes
• 
  Dangers of Removing IndexesOctober 24, 2024
  In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having… Read More »Dangers of Removing Indexes
• 
  Database Health Monitor with CoachingOctober 24, 2024
  With years of development into Database Health Monitor, there are many features there for many difference scenarios from performance to security, to overall server health. With this month being Database Health Montior month… Read More »Database Health Monitor with Coaching
• 
  Database Integrity in SQL Server: What It Is and Why It MattersOctober 24, 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… Read More »Database Integrity in SQL Server: What It Is and Why It Matters
• 
  Last Call: Just One Week Left for a Phenomenal Deal from Stedman Solutions!October 23, 2024
  Today, I’m back to spotlight a deal that’s genuinely too good to ignore, especially if you’re in the realm of SQL Server management. We’re down to the final week of October, and Stedman… Read More »Last Call: Just One Week Left for a Phenomenal Deal from Stedman Solutions!
• 
  fn_dump_dblog in SQL ServerOctober 22, 2024
  Understanding fn_dump_dblog in SQL Server In SQL Server, the transaction log plays a vital role in ensuring database integrity and providing the ability to restore data in the event of a failure. To… Read More »fn_dump_dblog in SQL Server
• 
  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.… Read More »Common Waits Reported by Daily Monitoring This Month
• 
  SQL Server Wait Type: SOS_SYNC_TASK_ENQUEUE_EVENTOctober 20, 2024
  Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the… Read More »SQL Server Wait Type: SOS_SYNC_TASK_ENQUEUE_EVENT
• 
  Securing SQL Server: Scan for Startup ProcsOctober 19, 2024
  The Scan For Startup Procs feature in SQL Server allows you to specify a list of stored procedures that will be automatically executed whenever the database engine starts. This can be useful in… Read More »Securing SQL Server: Scan for Startup Procs
• 
  Unlocking Database Performance: Unleash the Power with SQL Performance TuningOctober 18, 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… Read More »Unlocking Database Performance: Unleash the Power with SQL Performance Tuning
• 
  SQL Server DBCC Commands: Overview of Undocumented CommandsOctober 18, 2024
  SQL Servers DBCC commands are a set of T-SQL commands that are used for various maintenance and diagnostic tasks. Some of these commands are documented and can be accessed through the SQL Server… Read More »SQL Server DBCC Commands: Overview of Undocumented Commands
• 
  Difference Between Log Shipping and Replication in SQL Server?October 17, 2024
  What is the Difference Between Log Shipping and Replication in SQL Server? When it comes to SQL Server, ensuring data availability, Disaster Recovery, and data distribution are critical tasks for any database administrator.… Read More »Difference Between Log Shipping and Replication in SQL Server?
• 
  Stedman SQL Server Podcast Episode 5October 16, 2024
  Mark your calendars! Next Wednesday, October 23, 2024, at 10:30 AM PST, we’re diving into Topic #2 of our IT Manager’s Whitepaper. This session will focus on just how critical SQL Server performance… Read More »Stedman SQL Server Podcast Episode 5
• 
  Managed Services: an alternative to hiring a DBAOctober 15, 2024
  The SQL Server Managed Services offered by Stedman Solutions, LLC is an alternative to hiring a full time DBA, or to help your existing DBA that may be overloaded. Watch this video by… Read More »Managed Services: an alternative to hiring a DBA
• 
  How Functions in the JOIN ON Clause Can Slow Down Your SQL QueriesOctober 14, 2024
  When writing SQL queries, it’s easy to focus on getting the right results without thinking too much about performance. One common mistake that can lead to significant slowdowns is using functions in the… Read More »How Functions in the JOIN ON Clause Can Slow Down Your SQL Queries
• 
  Database Health: Monitoring Backups with Database Health MonitorOctober 14, 2024
  Monitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or corruption. The Database Health Monitor for SQL Server… Read More »Database Health: Monitoring Backups with Database Health Monitor
• 
  SQL Server Corruption: Corruption vs Drive FailureOctober 13, 2024
  Over the years I have documented many of the concepts around corruption repair. Want to find out more, check out the corruption category at by blog. Transcribed from a presentation on Database Corruption… Read More »SQL Server Corruption: Corruption vs Drive Failure
• 
  Why Every Business Needs Stedman Solutions’ SQL Server Health AssessmentOctober 12, 2024
  In the dynamic world of databases, ensuring optimal performance and robustness is crucial. Yet, many businesses often sideline database assessments, unaware of the untapped potential they can unlock. At Stedman Solutions, we emphasize… Read More »Why Every Business Needs Stedman Solutions’ SQL Server Health Assessment
• 
  SQL Server Wait Types that Cause More BlockingOctober 11, 2024
  Understanding SQL Server Wait Types that Cause More Blocking In SQL Server, wait types can tell you a lot about what’s slowing down your system, but some wait types can actually contribute to… Read More »SQL Server Wait Types that Cause More Blocking
• 
  Exclusive SQL Performance Tuning TrainingOctober 10, 2024
  With over 30 years of hands-on SQL Server experience, I have personally curated my favorite performance tuning tips and techniques into this exclusive training series. Having worked with SQL Server since its early… Read More »Exclusive SQL Performance Tuning Training
• 
  Best Tool for Monitoring SQL Server PerformanceOctober 9, 2024
  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… Read More »Best Tool for Monitoring SQL Server Performance
• 
  New SQL Update from MicrosoftOctober 8, 2024
  Today Microsoft released a new update for SQL Server. SQL Server 2016 CU17 + GDR for SP2 (13.0.5893.48 – June 2022) CU17 for 2016 SP2 (13.0.5888.11 – March 2021) CU15 + GDR for… Read More »New SQL Update from Microsoft
• 
  Unbeatable October Offer: Free Year of SQL Server Daily Monitoring with Every SQL Server Assessment!October 8, 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. The month of October is about more than… Read More »Unbeatable October Offer: Free Year of SQL Server Daily Monitoring with Every SQL Server Assessment!
• 
  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… Read More »Daily Server Monitoring – SQL Versions for October
• 
  Are Your SQL Server Backups Really Enough?October 7, 2024
  Are Your SQL Server Backups Really Enough? Plan Now, Before Disaster Strikes! Imagine this: a Ransomware attack hits your company, or worse, a flood destroys your server room. Are you confident that your… Read More »Are Your SQL Server Backups Really Enough?
• 
  Protect Your SQL ServerOctober 6, 2024
  Protect Your SQL Server: Free Ransomware Course for DBAs As a DBA, you’re entrusted with one of the most critical aspects of any organization: its data. In today’s threat landscape, ransomware is one… Read More »Protect Your SQL Server
• Stedman Solutions LLC: Your Partner in SQL Server Resilience & PreparednessOctober 5, 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. In our data-centric world, SQL Server plays a… Read More »Stedman Solutions LLC: Your Partner in SQL Server Resilience & Preparedness

Getting Help from Steve and the Team