- SQL Server Replication Course Info
SQL Server Replication Course from Stedman Solutions Are you responsible for managing SQL Server and looking to improve your knowledge of Replication? The SQL Server Replication Course from Stedman Solutions is the perfect… Read More »SQL Server Replication Course Info - Why the Join Type is ImportantWhy Learning the Different Join Types in SQL Server is Important When working with SQL Server, one of the most essential skills to master is the ability to use joins effectively. Joins allow… Read More »Why the Join Type is Important
- New SQL Update from MicrosoftToday Microsoft released a new update for SQL Server. SQL Server 2022 CU17 for 2022 (16.0.4175.1 – January 2025) CU15 + GDR (16.0.4155.4 – November 2024) 2025-01-16 Here are the latest updates for… Read More »New SQL Update from Microsoft
- Unlock the Full Potential of Your SQL Server with Stedman Solutions Managed ServicesUnlock the Full Potential of Your SQL Server with Stedman Solutions’ Managed Services In today’s fast-paced world, your SQL Server database is more crucial than ever. It’s the powerhouse behind your most critical… Read More »Unlock the Full Potential of Your SQL Server with Stedman Solutions Managed Services
- New Year’s Resolutions for SQL Server Success! 🎉Welcome back, SQL Server enthusiasts! Season 2 of the Stedman SQL Podcast is here, with your host Steve Stedman, and we’re starting the year with an episode packed with actionable insights to make… Read More »New Year’s Resolutions for SQL Server Success! 🎉
- NOLOCK vs READ UNCOMMITTED in SQL ServerUnderstanding NOLOCK vs READ UNCOMMITTED in SQL Server In the realm of SQL Server, managing data consistency and concurrency is a fundamental aspect of ensuring the integrity and performance of databases. Two commonly… Read More »NOLOCK vs READ UNCOMMITTED in SQL Server
- Unlock the Full Potential of Your SQL Server with Stedman Solutions Managed ServicesUnlock the Full Potential of Your SQL Server with Stedman Solutions’ Managed Services In today’s fast-paced world, your SQL Server database is more crucial than ever. It’s the powerhouse behind your most critical… Read More »Unlock the Full Potential of Your SQL Server with Stedman Solutions Managed Services
- Enhance Your SQL Skills for Free: Exclusive Offer for Stedman Solutions Managed Services CustomersEnhance Your SQL Skills for Free: Exclusive Offer for Stedman Solutions Managed Services Customers Contact us today to learn more about how we can help your business thrive. At Stedman Solutions, LLC, we’re… Read More »Enhance Your SQL Skills for Free: Exclusive Offer for Stedman Solutions Managed Services Customers
- The Power of Common Table ExpressionsCommon Table Expressions Hello to all SQL Server programmers and DBAs, I am Steve Stedman, over the years, I’ve come to recognize the value and power of SQL Server’s Common Table Expressions (CTEs).… Read More »The Power of Common Table Expressions
- SQL Server Performance Tuning ConsultantHow to Choose a SQL Server Performance Tuning Consultant If your SQL Server is experiencing slowdowns, sluggish performance, or frequent issues, it’s likely time to consider a SQL Server Performance Tuning consultant. Choosing… Read More »SQL Server Performance Tuning Consultant
- SQL Server Mentoring – Do you need some occasional help?Sometimes we all need a little help without a long term commitment. That why we created our SQL Server Mentoring service at Stedman Solutions. SQL Server Mentoring is a training / consulting option… Read More »SQL Server Mentoring – Do you need some occasional help?
- Advantages: SQL vs NoSQLWhy SQL Still Shines: Advantages of SQL Over NoSQL In the database world, there’s often a debate about whether to use SQL or NoSQL technologies. Both have their place, but it’s important to… Read More »Advantages: SQL vs NoSQL
- January 2025 Release – Version 1084 Release NotesJanuary 2025 Release – Database Health Monitor Version 1084 Release Notes Hello everyone! Steve Stedman here with exciting updates for the January 2025 release of Database Health Monitor (Version 1084). This release brings… Read More »January 2025 Release – Version 1084 Release Notes
- SQL Agent JobsWhat Are SQL Agent Jobs? If you’ve been managing a SQL Server environment for any amount of time, chances are you’ve come across SQL Server Agent Jobs. But what exactly are they, and… Read More »SQL Agent Jobs
- Daily Server Monitoring – SQL Versions for JanuaryOut 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 January
- SQL Server Wait Type: SLEEP_BUFFERPOOL_HELPLWWait 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: SLEEP_BUFFERPOOL_HELPLW
- Never Go It Alone: Our Managed Services Team is Your Lifeline for SQL Server ManagementManaging SQL Servers is a critical but often complex task. That’s why our Managed Services offer you the assurance and expertise of our team acting as your part-time or fractional DBA, for a… Read More »Never Go It Alone: Our Managed Services Team is Your Lifeline for SQL Server Management
- The Unmatched Value of Stedman Solutions Managed ServicesNavigating SQL Server Management: The Unmatched Value of Stedman Solutions’ Managed Services In the ever-evolving landscape of database management, businesses are continually seeking reliable, efficient, and cost-effective solutions to ensure their SQL Server… Read More »The Unmatched Value of Stedman Solutions Managed Services
- Free SQL Join Types DiagramSQL Join Types Diagram: Learn to Master Joins with Stedman Solutions When working with SQL Server, understanding join types is fundamental. Whether you’re a beginner or a seasoned professional, joins are essential to… Read More »Free SQL Join Types Diagram
- SQL Server Version Number ListSQL Server Version Number List: From SQL Server 7.0 to SQL Server 2022 When working with SQL Server, understanding the version number of the instance you’re using is essential for troubleshooting, compatibility, and… Read More »SQL Server Version Number List
- Why Choosing Stedman Solutions is a Cost-Effective Alternative to Hiring a Full-Time DBAIntroduction In the digital age, effectively managing your SQL Server has never been more critical. You might think that employing a full-time Database Administrator (DBA) is the only way to go, but have… Read More »Why Choosing Stedman Solutions is a Cost-Effective Alternative to Hiring a Full-Time DBA
- Finding and Resolving Blocking Queries in SQL ServerFor more information on Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at https://DatabaseHealth.com/download2. Finding and resolving blocking queries is an essential part of… Read More »Finding and Resolving Blocking Queries in SQL Server
- The Real Cost of SQL Server ManagementDownload “The Real Cost of SQL Server Management” White Paper Discover the true cost of managing SQL Server with our white paper, “The Real Cost of SQL Server Management: In-House Team vs. Stedman… Read More »The Real Cost of SQL Server Management
- Why my SQL Server is slow?Why My SQL Server is Slow If you’re asking yourself, “Why my SQL Server is slow?”, you’re not alone. A slow SQL Server can be a frustrating issue, especially when it disrupts critical… Read More »Why my SQL Server is slow?
- Securing SQL Server: Disable CLRCLR (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: Disable CLR
- SQL Server DBCC Commands: DBCC WRITEPAGEDBCC 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 Server Corruption: NOLOCK and CorruptionMicrosoft SQL Server’s database corruption can lead to severe operational complications, making crucial data inaccessible and potentially jeopardizing business continuity. Comprehending this problem requires a firm grasp of corruption indicators, its root causes,… Read More »SQL Server Corruption: NOLOCK and Corruption
- Stedman SQL Podcast Ep. 12 – JOIN TypesThis was our last episode of the year! Starting in January, we will be beginning our new Season 2 of the Stedman SQL Podcast. In this episode of the SQL Server Podcast, we… Read More »Stedman SQL Podcast Ep. 12 – JOIN Types
- Sample Database for NOLOCK in SQL ServerNOLOCK in SQL Server can be one of those bittersweet features that may sound great, but may not always do what you think it may be doing. Here’s a step-by-step demonstration to create… Read More »Sample Database for NOLOCK in SQL Server
- SQL Server CPU Overloaded?Is Your SQL Server CPU Overloaded? Use the CPU Schedulers Report in Database Health Monitor One of the most common performance concerns in SQL Server is determining whether the CPU is overloaded. It’s… Read More »SQL Server CPU Overloaded?
- Merry ChristmasMerry Christmas from the team at Stedman Solutions, LLC. Our offices will be closed to celebrate Christmas this year. If you need emergency help during this time, you can reach us through the… Read More »Merry Christmas
- The Christmas Query: A SQL Server Holiday StoryIt was Christmas Eve, and Santa was busy at the North Pole managing his massive toy database. Santa’s Workshop ran on a robust SQL Server setup, but tonight the server was struggling. The… Read More »The Christmas Query: A SQL Server Holiday Story
- Boost Your Database EfficiencySQL Server Performance Consulting: Boost Your Database Efficiency When your SQL Server isn’t performing at its best, the impact on your business can be significant—slower operations, frustrated users, and lost revenue. SQL Server… Read More »Boost Your Database Efficiency
- Large Differential BackupsLarge Differential BACKUPs: When to Consider More Frequent Full Backups In SQL Server, differential backups are a great way to capture the changes that have occurred since the last full backup. They can… Read More »Large Differential Backups
- Keep Your SQL Server Running Smoothly During the HolidaysKeep 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 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.… Read More »Common Waits Reported by Daily Monitoring This Month
- Are All My Databases Encrypted?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 FeaturesMonitoring 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_SWait 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 ExclusionSQL 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 ExcelLearn 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 PosterDownload 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 PerformanceUnderstaing 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 FailedUnderstanding 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 TypesUnderstanding 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 MicrosoftToday 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 IndexesWhy 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 WRITEPAGEDBCC 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 JOINUnderstanding 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 MeasuresThere 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 PerformanceWhy 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 DecemberOut 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 DownloadHello 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 TypeUnderstanding 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 NotesThe 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 TutorialMerge 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 CorruptedOver 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 CourseFor 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 CourseFor 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 CourseFor 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_CACHEWait 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!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 overGreetings, 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!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!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)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!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!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 TypeWRITE_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 ServerThe 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 CommandUnderstanding 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 CLRCLR (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 CourseAre 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 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.… Read More »Common Waits Reported by Daily Monitoring This Month
- The Everything SQL Server Class BundleHey 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 MonitorIf 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!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 CheckDBIf 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 RecommendationHey 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 CourseAre 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 MonitorThe 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 ServerMy 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 MicrosoftToday 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 ScriptHey 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 TuningAutomatic 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 MicrosoftToday 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 BundleWelcome 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 CXCONSUMERUnderstanding 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!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_UPWait 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 CourseAre 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 FREEPROCCACHEDBCC 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 NovemberOut 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 OfferHey 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 ServerHey 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!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 BundleHave 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 OfferWelcome, 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!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!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!
Getting Help from Steve and the Team
Contact us for your Free 30 minute consultation ORschedule your appointment now.