Latest 100 Posts

• Blog – Latest
• Archive by Month
• Archive by Year

• 
  Login Auditing in SQL Server: SQL Server Audit vs. Extended EventsJune 12, 2026
  One of the most common questions I hear from clients is: “How can we track who is logging into our SQL Server environment?” Whether you’re dealing with compliance requirements, security reviews, troubleshooting, or… Read More »Login Auditing in SQL Server: SQL Server Audit vs. Extended Events
• 
  SQL Server Corruption: Corruption vs Drive FailureJune 11, 2026
  Database corruption in Microsoft SQL Server can present serious challenges, causing data loss, disruption of services, and potential impact on business operations. Understanding the causes, symptoms, and potential solutions for such corruption is… Read More »SQL Server Corruption: Corruption vs Drive Failure
• 
  How Check 239 Catches Failing Database Health Monitor Jobs in SQL ServerJune 10, 2026
  Catching Failing Database Health Monitor Jobs with Check 239 In any SQL Server environment, background monitoring processes play a crucial role in maintaining visibility into performance, stability, and long-term trends. When these processes… Read More »How Check 239 Catches Failing Database Health Monitor Jobs in SQL Server
• 
  Features in Database Health Monitor: Job History, Problem Indexes, and Backup ReportsJune 9, 2026
  Features in Database Health Monitor: Job History, Problem Indexes, and Backup Reports At Stedman Solutions, we are always working to make SQL Server management easier and more effective. Database Health Monitor continues to… Read More »Features in Database Health Monitor: Job History, Problem Indexes, and Backup Reports
• 
  SQL Server Wait Type: FT_MASTER_MERGEJune 8, 2026
  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: FT_MASTER_MERGE
• 
  SQL School: Are you ready for that next SQL Server InterviewJune 7, 2026
  SQL Server Interview Questions Course from Stedman’s SQL School Are you ready for your next SQL Server Interview? Aspiring SQL Server DBA or Developer? Our SQL Server Interview Questions course prepares you for… Read More »SQL School: Are you ready for that next SQL Server Interview
• 
  The Ultimate SQL Server Backup Strategy: Protecting Your Data from Disaster and CorruptionJune 6, 2026
  The Ultimate SQL Server Backup Strategy: Protecting Your Data from Disaster and Corruption A reliable SQL Server backup strategy is one of the most important parts of protecting your environment from downtime, corruption,… Read More »The Ultimate SQL Server Backup Strategy: Protecting Your Data from Disaster and Corruption
• 
  Why Is My SQL Server Slow? 8 Common Causes and SolutionsJune 5, 2026
  Are you constantly wondering, “Why my Vary phrasing with synonyms like ‘SQL Server performance issues’ or ‘slow SQL Server performance’ in some instances to maintain natural language flow.?” You’re not alone in facing… Read More »Why Is My SQL Server Slow? 8 Common Causes and Solutions
• 
  Securing SQL Server: Disable Ad-hoc Distributed QueriesJune 4, 2026
  Ad hoc distributed queries are a feature of SQL Server that allow you to execute a T-SQL statement against a linked server. A linked server is a server that has been defined in… Read More »Securing SQL Server: Disable Ad-hoc Distributed Queries
• 
  LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL Server: Key Differences ExplainedJune 2, 2026
  Diving into the world of SQL Server, understanding how to combine data from multiple tables is a critical skill. Among the various types of joins, LEFT OUTER JOIN and RIGHT OUTER JOIN stand… Read More »LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL Server: Key Differences Explained
• 
  Honoring those who have died while servingJune 1, 2026
  In observance of the US federal holiday Memorial day, and in memory of all who have died in service, Stedman Solutions, LLC will be closed for the last Monday in May. If you… Read More »Honoring those who have died while serving
• 
  Database Health: Monitoring Backups with Database Health MonitorMay 31, 2026
  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
• 
  What Could You Do With $10 Per Month?May 29, 2026
  What Could You Do With $10 Per Month? When you think about $10 per month, it does not sound like much. It is the cost of a couple of coffees, a fast-food lunch,… Read More »What Could You Do With $10 Per Month?
• 
  SQL Server Performance Tuning Course: Master Optimization and Cut Costs with Steve StedmanMay 28, 2026
  Database performance issues can drain resources and inflate costs for organizations relying on SQL Server. This course provides a focused path to mastering optimization techniques that address slow queries, inefficient designs, and scalability… Read More »SQL Server Performance Tuning Course: Master Optimization and Cut Costs with Steve Stedman
• 
  Exploring fn_dump_dblog: A Deep Dive into SQL Server Transaction Log AnalysisMay 27, 2026
  When it comes to managing and troubleshooting databases in SQL Server, the transaction log is a treasure trove of information. It holds the key to understanding database operations, recovering from failures, and ensuring… Read More »Exploring fn_dump_dblog: A Deep Dive into SQL Server Transaction Log Analysis
• 
  The Hidden SQL Server Performance Killer: Implicit ConversionsMay 26, 2026
  The Hidden SQL Server Performance Killer: Implicit Conversions When SQL Server Performance issues begin appearing, many companies assume the only solution is to add more hardware, increase cloud resources, or purchase additional SQL… Read More »The Hidden SQL Server Performance Killer: Implicit Conversions
• 
  SQL Server DBCC Commands: Shrinking NotesMay 25, 2026
  This chapter refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different conversation, however, shrink database does shrink the log file.… Read More »SQL Server DBCC Commands: Shrinking Notes
• 
  Mastering the T-SQL WAITFOR Command in SQL Server: A Guide to Timing ControlMay 24, 2026
  Delving into the intricacies of SQL Server, the T-SQL WAITFOR command emerges as a unique tool for managing the timing of script executions. Often overlooked, this command allows developers and database administrators to… Read More »Mastering the T-SQL WAITFOR Command in SQL Server: A Guide to Timing Control
• 
  Data Aggregation in SQL Server: Master SUM, COUNT, AVG, GROUP BY and MoreMay 23, 2026
  Data aggregation techniques is one of the most practical skills any SQL Server professional can develop, turning raw tables filled with thousands of rows into clear, actionable summaries. Whether you are calculating total… Read More »Data Aggregation in SQL Server: Master SUM, COUNT, AVG, GROUP BY and More
• 
  SQL Server Performance Consulting: Boost Database Efficiency with Expert SolutionsMay 22, 2026
  Is your SQL Server dragging down your business with sluggish performance and inefficiencies? Poor database performance can lead to frustrated users, delayed operations, and missed opportunities. At Stedman Solutions, we understand the critical… Read More »SQL Server Performance Consulting: Boost Database Efficiency with Expert Solutions
• 
  New SQL Update from MicrosoftMay 21, 2026
  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
• 
  NOLOCK vs READ UNCOMMITTED in SQL Server: Key Differences and Best PracticesMay 20, 2026
  When working with SQL Server, database administrators and developers often encounter scenarios where SQL Server Performance Tuning performance and data consistency must be carefully balanced. Two approaches frequently considered for optimizing query performance… Read More »NOLOCK vs READ UNCOMMITTED in SQL Server: Key Differences and Best Practices
• 
  SQL Server Corruption: What Can Get CorruptedMay 19, 2026
  One of the most satisfying parts of my job at Stedman Solutions is when we can help a customer repair a corrupt database that without our help would have put them out of… Read More »SQL Server Corruption: What Can Get Corrupted
• 
  SQL Server Patching Risks: Why It Matters and How Stedman Solutions HelpsMay 18, 2026
  When it comes to maintaining a robust SQL Server environment, patching is a critical yet often daunting task. The decision to apply updates can feel like navigating a minefield—while patches promise enhanced security… Read More »SQL Server Patching Risks: Why It Matters and How Stedman Solutions Helps
• 
  How to Identify and Resolve Blocking Queries in SQL Server with Database Health MonitorMay 17, 2026
  Navigating the complexities of database performance can be a daunting task, especially when blocking queries grind operations to a halt. In SQL Server, these bottlenecks can severely impact application responsiveness and user experience.… Read More »How to Identify and Resolve Blocking Queries in SQL Server with Database Health Monitor
• 
  SQL Server Wait Type:May 16, 2026
  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:
• 
  Mastering SQL Server: Unleash the Power of Common Table Expressions (CTEs)May 15, 2026
  Welcome, SQL Server enthusiasts! If you’ve ever struggled with complex queries or sought a cleaner, more efficient way to manage your database operations, you’re in the right place. In this post, we’re diving… Read More »Mastering SQL Server: Unleash the Power of Common Table Expressions (CTEs)
• 
  Managed Service Stedman SQL Podcast Sn 3 Ep 8May 14, 2026
  Why SQL Server Managed Services Are the Smart Choice for Modern Businesses Managing SQL Server environments has become more complex than ever. Between performance tuning, backup management, security concerns, and around-the-clock monitoring, businesses… Read More »Managed Service Stedman SQL Podcast Sn 3 Ep 8
• 
  SQL Server Differential Backups: Why Size Matters and How to Optimize Your StrategyMay 14, 2026
  When managing SQL Server databases, differential backups are often hailed as a time and space-saving solution, capturing only the changes made since the last full backup. They promise efficiency, allowing database administrators to… Read More »SQL Server Differential Backups: Why Size Matters and How to Optimize Your Strategy
• 
  Securing SQL Server: Hide Instance Server SettingMay 13, 2026
  The Hide Instance option in SQL Server allows you to hide a specific instance of SQL Server from the list of available instances on the network. This can be useful for security purposes,… Read More »Securing SQL Server: Hide Instance Server Setting
• 
  Master SQL Server Performance Tuning and Take Control of Your Database PerformanceMay 11, 2026
  If you are responsible for maintaining, developing, or supporting SQL Server environments, Performance Tuning skills are no longer optional. Slow queries, blocking, deadlocks, TempDB contention, poor indexing strategies, and inefficient execution plans can… Read More »Master SQL Server Performance Tuning and Take Control of Your Database Performance
• 
  Exclusive SQL Performance Tuning TrainingMay 10, 2026
  I have used my over 30 years of SQL Server experience to personally curate my favorite performance tuning tips and tricks into this training. I am excited to contribute and share with the… Read More »Exclusive SQL Performance Tuning Training
• 
  Introducing the Rewards Program for Database Health MonitorMay 7, 2026
  Introducing the Rewards Program for Database Health Monitor At Stedman Solutions, we’ve always looked for ways to say thank you to everyone using Database Health Monitor. With the launch of the new Rewards… Read More »Introducing the Rewards Program for Database Health Monitor
• 
  Stedman Solutions Daily Monitoring ProductMay 1, 2026
  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… Read More »Stedman Solutions Daily Monitoring Product
• 
  April Promo Join Types PosterApril 25, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »April Promo Join Types Poster
• 
  Database Health: Monitoring Backups with Database Health MonitorApril 24, 2026
  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
• 
  My Join Types CourseApril 23, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »My Join Types Course
• 
  Join Types ShirtApril 21, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »Join Types Shirt
• 
  SQL Server DBCC Commands: DBCC CLONEDATABASEApril 20, 2026
  DBCC CLONEDATABASE is a DBCC command in Microsoft SQL Server that can be used to create a copy of a database on the same server. It is primarily used for testing and debugging… Read More »SQL Server DBCC Commands: DBCC CLONEDATABASE
• 
  Join Types on your wallApril 19, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »Join Types on your wall
• 
  SQL Server Database Integrity: Importance and Corruption Prevention TipsApril 18, 2026
  In the world of SQL Server management, ensuring database integrity is a cornerstone of reliable and efficient operations. Database integrity refers to the accuracy, consistency, and trustworthiness of data stored within your SQL… Read More »SQL Server Database Integrity: Importance and Corruption Prevention Tips
• 
  Don’t Miss Out With Join Types MonthApril 17, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »Don’t Miss Out With Join Types Month
• 
  Why SQL Server Managed Services Are Essential for Your Business SuccessApril 16, 2026
  In today’s fast-paced business landscape, data is the backbone of decision-making and operational efficiency. As a business leader or IT professional, you rely heavily on your SQL Server to store, manage, and retrieve… Read More »Why SQL Server Managed Services Are Essential for Your Business Success
• 
  Fighting back against RansomwareApril 15, 2026
  In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them back, and I have seen others who have… Read More »Fighting back against Ransomware
• 
  Stedman SQL Podcast Sn 3 Ep 6 Database Health Monitor Recap and UpdatesApril 15, 2026
  If you’ve been around SQL Server long enough, you know one thing for sure—monitoring tools either make your life dramatically easier… or they become just another noisy dashboard you ignore. In the latest… Read More »Stedman SQL Podcast Sn 3 Ep 6 Database Health Monitor Recap and Updates
• 
  Demystifying SQL Server Join Types: A Guide to MasteryApril 14, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »Demystifying SQL Server Join Types: A Guide to Mastery
• 
  SQL Server Corruption: When Did It HappenApril 13, 2026
  Navigating the landscape of Microsoft SQL Server, one may occasionally encounter the formidable issue of database corruption, which can jeopardize vital data and disrupt business processes. Drawing upon one’s experience in diagnosing and… Read More »SQL Server Corruption: When Did It Happen
• 
  SQL Server Wait Type: PREEMPTIVE_OS_CLOSEHANDLEApril 12, 2026
  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: PREEMPTIVE_OS_CLOSEHANDLE
• 
  Join Types Shower CurtainApril 11, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »Join Types Shower Curtain
• 
  Our Free Joins PosterApril 10, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »Our Free Joins Poster
• 
  Securing SQL Server: Patching your SQL ServerApril 9, 2026
  Keeping your SQL Server up-to-date with the latest patches and updates is an important part of maintaining the security and stability of your system. Here are a few reasons why it is important… Read More »Securing SQL Server: Patching your SQL Server
• 
  Master SQL Server Aggregation: Boost Your Data Query SkillsApril 7, 2026
  Mastering SQL Aggregation: Elevate Your Querying Skills If you’ve ever found yourself struggling to make sense of large datasets in SQL Server, you’re not alone. Whether you’re a beginner or an experienced DBA,… Read More »Master SQL Server Aggregation: Boost Your Data Query Skills
• 
  Mastering Anti Left Join in SQL Server: A Comprehensive GuideApril 5, 2026
  SQL Server is a powerful tool for managing and querying data, but mastering its intricacies can be a game-changer for developers and database administrators. One such advanced concept is the anti left join,… Read More »Mastering Anti Left Join in SQL Server: A Comprehensive Guide
• 
  How to Prepare for SQL Server Database Corruption: Essential Tips and StrategiesApril 4, 2026
  Are You Prepared for SQL Server Corruption? Hello, I’m Steve Stedman, and I’m here to talk about one of the most critical aspects of SQL Server management: preparing for database corruption. Over the… Read More »How to Prepare for SQL Server Database Corruption: Essential Tips and Strategies
• 
  Free Ransomware Course for SQL Server DBAs: Protect Your Databases NowApril 3, 2026
  Protect Your SQL Server: Free Ransomware Course for DBAs In the digital age, data is the lifeblood of any organization, and as a SQL Server DBA, you are the guardian of this invaluable… Read More »Free Ransomware Course for SQL Server DBAs: Protect Your Databases Now
• 
  April is Join Types MonthApril 2, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »April is Join Types Month
• 
  More that Just SocksApril 2, 2026
  Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in… Read More »More that Just Socks
• 
  The MSQL_DQ Wait Type: A Sweet CollaborationApril 1, 2026
  In a groundbreaking (and delicious) revelation, SQL Server has introduced a new wait type that bridges the gap between tech innovation and sweet treats. Enter the MSQL_DQ wait type, a unique collaboration between… Read More »The MSQL_DQ Wait Type: A Sweet Collaboration
• 
  Celebrating World Backup Day with Stedman’s SQL SchoolMarch 31, 2026
  Celebrating World Backup Day with Stedman’s SQL School: Unlock the Secrets of Efficient Backup and Recovery As we mark World Backup Day on March 31st, it’s a timely reminder of the critical importance… Read More »Celebrating World Backup Day with Stedman’s SQL School
• 
  Database Health: Free Download – Database Health MonitorMarch 30, 2026
  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
• 
  Embrace Efficiency and Growth: The Integrated Power of Managed ServicesMarch 29, 2026
  Embrace Efficiency and Growth: The Power of Managed Services In today’s fast-evolving business landscape, organizations are constantly seeking ways to optimize their operations, scale efficiently, and ensure the robust management of their critical… Read More »Embrace Efficiency and Growth: The Integrated Power of Managed Services
• 
  SQL Server Backup Strategy: Are Your Backups Enough to Prevent Disaster?March 28, 2026
  Are Your SQL Server Backups Really Enough? Plan Now, Before Disaster Strikes! Picture this: your SQL Server environment is running smoothly until a sudden cyberattack encrypts your data, or a hardware failure wipes… Read More »SQL Server Backup Strategy: Are Your Backups Enough to Prevent Disaster?
• 
  Stedman SQL Podcast Sn 3 Ep 5 The 7 Deadly Sins of Index and Statistics MaintenanceMarch 27, 2026
  When it comes to SQL Server performance, index and statistics maintenance is one of those areas where “good intentions” can quietly turn into serious problems. In a recent discussion, I sat down with… Read More »Stedman SQL Podcast Sn 3 Ep 5 The 7 Deadly Sins of Index and Statistics Maintenance
• 
  Finding Long Running Queries in SQL ServerMarch 27, 2026
  You usually don’t notice a slow query right away. What you do notice is everything else starting to lag. Dashboards take longer to load, jobs start overlapping, and suddenly users are asking what… Read More »Finding Long Running Queries in SQL Server
• 
  How to Use IF Statements in T-SQL for SQL Server: A Complete GuideMarch 26, 2026
  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 »How to Use IF Statements in T-SQL for SQL Server: A Complete Guide
• 
  Sleep Better With Managed Services From Stedman Solutions, LLC.March 25, 2026
  Finding Peace of Mind with SQL Server Managed Services As the owner or manager of a business that relies on SQL Server for critical data management and operations, the thought of your SQL… Read More »Sleep Better With Managed Services From Stedman Solutions, LLC.
• 
  SQL Server Wait Types Causing Blocking: Key Insights & SolutionsMarch 24, 2026
  When managing SQL Server Performance, understanding the root causes of blocking is crucial for maintaining a smooth and efficient system. Blocking happens when one process locks a resource, forcing others to wait, and… Read More »SQL Server Wait Types Causing Blocking: Key Insights & Solutions
• 
  SQL Server Managed Services: A Cost-Effective Alternative to Hiring a Full-Time DBAMarch 23, 2026
  Navigating the complexities of database management can be a daunting task for many businesses, especially when the need for a skilled Database Administrator (DBA) arises. Hiring a full-time DBA can be a significant… Read More »SQL Server Managed Services: A Cost-Effective Alternative to Hiring a Full-Time DBA
• 
  SQL Server Corruption: How Often Should I Run CheckDBMarch 22, 2026
  Most of the time that I am contacted for help with a corruption repair it is a situation where the client does not have any good backups, and that makes the corruption repair… Read More »SQL Server Corruption: How Often Should I Run CheckDB
• 
  SQL Server DBCC Commands: DBCC WRITEPAGEMarch 21, 2026
  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
• 
  The Challenges of Relying Solely on an In-House DBAMarch 20, 2026
  The Challenges of Relying Solely on an In-House DBA: Insights from Stedman Solutions In the fast-paced world of IT, the database is the backbone of any organization, storing critical data that drives decision-making… Read More »The Challenges of Relying Solely on an In-House DBA
• 
  Securing SQL Server: Transparent Data EncryptionMarch 19, 2026
  Transparent Data Encryption (TDE) is a feature of Microsoft SQL Server that enables the encryption of a databases data and log files, as well as the encryption of backups, to protect sensitive data… Read More »Securing SQL Server: Transparent Data Encryption
• 
  Why Consider Cloud Backups for SQL ServerMarch 18, 2026
  Cloud Backup and Recovery Strategies for SQL ServerIn today’s hybrid world, many SQL Server environments still run primarily on-premises, but the cloud offers powerful options for enhancing backup reliability, offsite protection, and Disaster… Read More »Why Consider Cloud Backups for SQL Server
• 
  Stedman SQL Podcast Sn 3 Ep 4 SQL Server UpgradesMarch 17, 2026
  When it comes to SQL Server upgrades, one of the most common questions I hear from clients is: Should we do an in-place upgrade, or build a new server and migrate? It’s a… Read More »Stedman SQL Podcast Sn 3 Ep 4 SQL Server Upgrades
• 
  Art of Data Aggregation with SQL ServerMarch 16, 2026
  Over the course of my SQL Server journey, I’ve grown to appreciate just how vital data Aggregation is for gaining insights from your data. That’s why I’ve developed a course on Teachable called… Read More »Art of Data Aggregation with SQL Server
• 
  Cut Costs Without Compromising QualityMarch 15, 2026
  Cut Costs Without Compromising Quality: Outsource Server Maintenance with Managed Services and Watch Your Savings Grow Welcome back, fellow data enthusiasts! Today, we’re diving into a topic that’s not only crucial for your… Read More »Cut Costs Without Compromising Quality
• 
  Understanding TempDB Spills in SQL Server Execution PlansMarch 13, 2026
  In SQL Server, a spill to TempDB occurs when an operator in a query execution plan requires more working memory than was granted by the server. When this happens, SQL Server writes intermediate… Read More »Understanding TempDB Spills in SQL Server Execution Plans
• 
  New SQL Update from MicrosoftMarch 12, 2026
  Today Microsoft released a new update for SQL Server. SQL Server 2022 CU24 for 2022 (16.0.4245.2 – March 2026) CU23 + GDR (16.0.4240.4 – March 2026) 2026-03-12 Here are the latest updates for… Read More »New SQL Update from Microsoft
• 
  Dangers of Removing IndexesMarch 11, 2026
  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
• 
  New SQL Update from MicrosoftMarch 10, 2026
  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
• 
  Master SQL Joins with Our Free T-SQL Join Types Poster DownloadMarch 9, 2026
  Have you ever found yourself scratching your head, trying to remember the difference between a LEFT OUTER JOIN and a RIGHT OUTER JOIN? Or maybe you’re unsure when to use a CROSS APPLY… Read More »Master SQL Joins with Our Free T-SQL Join Types Poster Download
• 
  Scale Your BusinessMarch 8, 2026
  Scale Your Business worry-free! Join Managed Services at Stedman Solutions and Reclaim Your Time. In the dynamic landscape of today’s economy, scaling a business is a commendable yet formidable task. As enterprises strive… Read More »Scale Your Business
• 
  SQL Server Backup and Recovery: Is Your Strategy Ready for Disaster?March 7, 2026
  Is Your SQL Server Backup and Recovery Strategy Really Up to the Task? Disaster can strike at any moment—a Ransomware attack, a hardware failure, or even a flood in your server room. When… Read More »SQL Server Backup and Recovery: Is Your Strategy Ready for Disaster?
• 
  SQL Server Wait Type: PREEMPTIVE_OS_GETCOMPRESSEDFILESMarch 6, 2026
  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: PREEMPTIVE_OS_GETCOMPRESSEDFILES
• 
  SQL Server Performance Assessment with Stedman SolutionsMarch 5, 2026
  Mastering SQL Server Performance: An Insightful Journey with Stedman Solutions Welcome to the Stedman Solutions blog! I’m Steve Stedman, and today I’m thrilled to share with you the essentials of our Comprehensive Database… Read More »SQL Server Performance Assessment with Stedman Solutions
• 
  TSQL Output Clause CourseMarch 2, 2026
  Have you seen our SQL short course on the TSQL Output Clause? The SQL Server output clause is a great way to get data back from an insert, update or delete statement, and… Read More »TSQL Output Clause Course
• 
  March is Peace of Mind MonthMarch 1, 2026
  Stedman Solutions introduces, Peace of Mind Month, granting you satisfaction and reassurance for your SQL Server through Managed Services. The month of March is “Peace of Mind Month” for us at Stedman Solutions.… Read More »March is Peace of Mind Month
• 
  Master SQL Server with Stedman’s SQL School: Comprehensive Courses for All LevelsFebruary 24, 2026
  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… Read More »Master SQL Server with Stedman’s SQL School: Comprehensive Courses for All Levels
• 
  Database Health: Untrusted Foreign KeysFebruary 23, 2026
  Foreign keys are a fundamental aspect of relational databases, as they enforce referential integrity between related tables. However, foreign key relationships can also cause performance issues, particularly if the foreign key is untrusted.… Read More »Database Health: Untrusted Foreign Keys
• 
  Several Common TSQL Error MessagesFebruary 22, 2026
  Written by Steve Stedman, founder and owner of Stedman Solutions, LLC. Welcome to our deep dive into the world of TSQL error messages. If you’ve ever found yourself scratching your head over cryptic… Read More »Several Common TSQL Error Messages
• 
  TSQL Removing Leading Zeros in SQL ServerFebruary 21, 2026
  When working with data in SQL Server, you might encounter situations where numeric values are stored as strings with leading zeros. These leading zeros can cause issues when performing calculations, comparisons, or displaying… Read More »TSQL Removing Leading Zeros in SQL Server
• 
  SQL Server Corruption: Stories About Causes of CorruptionFebruary 20, 2026
  Database corruption in Microsoft SQL Server can present serious challenges, causing data loss, disruption of services, and potential impact on business operations. Understanding the causes, symptoms, and potential solutions for such corruption is… Read More »SQL Server Corruption: Stories About Causes of Corruption
• 
  Database Health Monitor Rewards Program: Turning Monitoring Into Ongoing SQL Server EducationFebruary 19, 2026
  If you’ve been following along with the Stedman SQL Podcast (Season 3, Episode 3), you heard Mitchell Glasscock and I introduce something we’re really excited about—the Database Health Monitor Rewards Program. This is… Read More »Database Health Monitor Rewards Program: Turning Monitoring Into Ongoing SQL Server Education
• Exclusive SQL Performance Tuning TrainingFebruary 19, 2026
  Steve 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… Read More »Exclusive SQL Performance Tuning Training
• 
  Securing SQL Server: Transparent Data EncryptionFebruary 18, 2026
  Transparent Data Encryption (TDE) is a feature of Microsoft SQL Server that enables the encryption of a databases data and log files, as well as the encryption of backups, to protect sensitive data… Read More »Securing SQL Server: Transparent Data Encryption
• 
  Discover The Benefits of Stedman SolutionsFebruary 16, 2026
  Discover Stedman Solutions: Your Go-To for SQL Server Management Welcome to a world of innovation and efficiency with Stedman Solutions, where cutting-edge technology meets unparalleled service. If you’ve been searching for a way… Read More »Discover The Benefits of Stedman Solutions
• 
  SQL Server DBCC Commands: DBCC CLONEDATABASEFebruary 14, 2026
  DBCC CLONEDATABASE is a DBCC command in Microsoft SQL Server that can be used to create a copy of a database on the same server. It is primarily used for testing and debugging… Read More »SQL Server DBCC Commands: DBCC CLONEDATABASE
• 
  SET DEADLOCK_PRIORITYFebruary 12, 2026
  SET DEADLOCK_PRIORITY HIGH;BEGIN TRANSACTION;— Your critical transaction code hereUPDATE Orders SET Status = ‘Processed’ WHERE OrderID = 12345;COMMIT TRANSACTION; Or set a lower priority for less critical operations: The priority you set remains… Read More »SET DEADLOCK_PRIORITY
• 
  New SQL Update from MicrosoftFebruary 12, 2026
  Today Microsoft released a new update for SQL Server. SQL Server 2025 CU2 for 2025 (17.0.4015.4- February 2026) 2026-02-12 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download… Read More »New SQL Update from Microsoft
• 
  SQL Server Max Memory Setting: How to Configure for Optimal PerformanceFebruary 12, 2026
  When it comes to optimizing SQL Server performance, one of the most critical yet often overlooked configurations is the max server memory setting. This parameter directly influences how much memory SQL Server can… Read More »SQL Server Max Memory Setting: How to Configure for Optimal Performance

Getting Help from Steve and the Team