SQL Server Blog Posts from Stedman Solutions
SQL Server Blog Posts
Welcome to the hub for all things SQL Server! Here, you’ll find the latest blog posts covering tips, tricks, and insights into SQL Server management, performance tuning, query optimization, and much more. Whether you’re a seasoned database administrator or just starting your journey with SQL Server, our blog is packed with valuable content to help you tackle real-world challenges and improve your skills.
At Stedman Solutions, we’re passionate about SQL Server and dedicated to sharing knowledge gained from over three decades of experience. Our blog posts cover a range of topics, including resolving database corruption, enhancing query performance, understanding T-SQL techniques, and leveraging tools like Database Health Monitor. Each article is written with a practical focus, offering solutions and advice you can apply directly to your SQL Server environment.
Take a moment to explore the latest posts below. Whether you’re here to solve a specific problem, learn about a new feature, or stay updated on best practices, you’re in the right place. If you find a topic that resonates with your current challenges, be sure to dive in—and feel free to contact us if you need personalized assistance or want to learn more about our SQL Server services.
Latest SQL Server Blog Posts
- Podcast Episode 11 – Database Health Monitor- New FeaturesStedman SQL Podcast Episode 11 – New Features Steve Stedman hosts the Stedman SQL podcast, featuring George and Mitchell, developers of the Database Health Monitor. They discuss new features in DHM, including the VLF visualization report, schema search, SQL CPU schedulers, deprecated features, historic file size over time, and average page life expectancy charts. Mitchell… Read More »Podcast Episode 11 – Database Health Monitor- New Features
- Real Cost of SQL Server Management
Download “The Real Cost of SQL Server Management” White Paper Discover the true cost of managing SQL Server with our white paper, “The Real Cost of SQL Server Management: In-House Team vs. Stedman Solutions.” This comprehensive guide dives deep into the financial implications of maintaining an in-house team compared to outsourcing to specialists like Stedman… Read More »Real Cost of SQL Server Management - Max Degree of ParallelismUnderstanding the SQL Server MAX Degree of Parallelism Setting The Max Degree of Parallelism (MAXDOP) setting in SQL Server plays a crucial role in determining how SQL Server handles parallel query execution. It controls the maximum number of processors that can be used for executing a single query. Over the years, SQL Server’s handling of… Read More »Max Degree of Parallelism
- What are SQL Agent 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 why are they so critical to efficient database management? In this blog post, I’ll break down what SQL Agent Jobs are, how… Read More »What are SQL Agent Jobs
- Podcast Episode 10 – RPO and RTOStedman SQL Podcast Episode 10 – RPO and RTO Steve Stedman and Shannon Lindsay discuss the transition of their podcast from live streaming to pre-recorded episodes, available on YouTube, Spotify, and their website. They announce the upcoming release of a new database health monitor with features like VLF visualization reports and SQL schema search. The… Read More »Podcast Episode 10 – RPO and RTO
- SQL Server Performance Tuning 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 the right consultant can make a significant impact in bringing your SQL Server back to optimal performance. But with so many options… Read More »SQL Server Performance Tuning Consultant
- Introduction to Parameter Sniffing in SQL ServerWhat is parameter sniffing in SQL Server? Understanding Parameter Sniffing in SQL Server: What It Is and How to Handle It One of the more nuanced aspects of SQL Server performance tuning is understanding and addressing parameter sniffing. This is a common scenario that arises when SQL Server generates and stores a query execution plan… Read More »Introduction to Parameter Sniffing in SQL Server
- Checking Database Corruption in SQL ServerIn this blog post we will cover how to check for database corruption on SQL Server. Database corruption can be a nightmare for any SQL Server administrator. Without proactive monitoring and regular checks, corruption can silently creep in, leaving you with incomplete or inaccessible data when you need it most. This article will guide you… Read More »Checking Database Corruption in SQL Server
- Daily Server Monitoring – SQL Versions for 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 client information to expose here. What is this service? With this service we detect and alert you of any issues that arise… Read More »Daily Server Monitoring – SQL Versions for December
- HTDELETE Wait Type in SQL ServerUnderstanding the HTDELETE Wait Type in SQL Server In SQL Server, understanding wait types can provide critical insights into performance bottlenecks, enabling DBAs to optimize their environment effectively. One such wait type that occasionally appears in SQL Server environments is HTDELETE. Though not one of the most common wait types, understanding HTDELETE can help when… Read More »HTDELETE Wait Type in SQL Server
- Podcast Episode 9 – SQL Server CorruptionOur SQL Server Corruption episode. Stedman SQL Podcast Episode 9 – Corruption Steve Stedman and Derrick Bovenkamp discuss SQL Server database corruption, its causes, symptoms, and prevention strategies. SQL Server Corruption often results from IO issues, such as firmware problems with iSCSI or antivirus software misconfigurations. Symptoms include failed queries and check DB errors. They… Read More »Podcast Episode 9 – SQL Server Corruption
- UPDLOCK hint – DangersIn this conversation, the focus is on how the UPDLOCK (update lock) can cause serious performance issues, specifically excessive wait times and blocking in SQL Server. At Stedman Solutions, while working with a Managed Services client, we encountered a situation where SELECT statements were incorrectly using the UPDLOCK hint. Normally, update locks are intended for… Read More »UPDLOCK hint – Dangers
- Cyber Monday – 60% off until 8pm pacific time.Cyber Monday Deal #3: 60% Off From 11:00 AM to 8:00 PM Pacific Time, you can still save big with a 60% discount on our Backup and Recovery course. Get it for only $15.98! Enroll Now with a 60% savings: https://stedman.us/60BACK Coupon Code: 60BACK We understand that these discounts may seem too good to be… Read More »Cyber Monday – 60% off until 8pm pacific time.
- Cyber Monday – 80% off 8am to 11am pacific timeCyber Monday Deal #2: 80% Off Between 8:00 AM and 11:00 AM Pacific Time, enjoy an incredible 80% discount on our Backup and Recovery course. Get it for just $7.99! Enroll Now with 80% savings: https://stedman.us/80BACK Coupon Code: 80BACK Cyber Monday Deal #3: 60% Off From 11:00 AM to 8:00 PM Pacific Time, you can… Read More »Cyber Monday – 80% off 8am to 11am pacific time
- Cyber Monday – 90% off 7:00am to 8:00am pacific timeCyber Monday Deal #1: 90% Off From 7:00 AM to 8:00 AM Pacific Time, get a whopping 90% off our Backup and Recovery course. Enroll for just $3.99 instead of $39.99! This is the lowest markdown we’ve ever offered. Enroll Now at a 90% savings: https://stedman.us/90BACK Coupon Code: 90BACK Cyber Monday Deal #2: 80% Off… Read More »Cyber Monday – 90% off 7:00am to 8:00am pacific time
- Saturday Sale: 50% Off SQL Server Replication Course!Celebrate Small Business Saturday with 50% Off Our SQL Server Replication Course! Small Business Saturday is here, and to celebrate, we’re offering 50% off our SQL Server Replication course—but only for one day! Whether you’re managing databases in a small business or a larger enterprise, SQL Server replication is a crucial skill that can help… Read More »Saturday Sale: 50% Off SQL Server Replication Course!
- Stedman Solutions Black Friday Exclusive!Discover the Secrets Behind SQL Server Blocks with Stedman Solutions Our Black Friday sale is here, and we at Stedman Solutions have a ONE DAY SALE that you simply can’t miss! Black Friday Exclusive: 25% Off! Enroll in our Track Blocking Queries course and get: 2 hours of personalized coaching with Steve Stedman, the SQL… Read More »Stedman Solutions Black Friday Exclusive!
- DBA and Developer Interview Course: Promo is almost 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 Aspiring DBAs and Developers: Aiming for a role in the SQL Server domain? This course caters to your every need, featuring comprehensive… Read More »DBA and Developer Interview Course: Promo is almost over
- Happy Thanksgiving (US)In observance of the US federal holiday Thanksgiving, Stedman Solutions, LLC will be closed for the Fourth Thursday in November. If you need emergency help during this time, you can reach us through the contact us form, or for existing customers just contact one of us by our cell phone or text. -Steve Stedman
- One-Day Thanksgiving SaleOne-Day Thanksgiving Sale: Secure Your SQL Server & Job with 60% Off! Happy Thanksgiving to our cherished community. As we all look forward to a festive Black Friday, we’re serving up an early treat that’s valid for today only. This isn’t just another course sale; it’s an investment in crisis-proofing your professional future. Why This… Read More »One-Day Thanksgiving Sale
- Why my SQL Server is slow?Understanding Why My SQL Server Is Slow If you’re wondering, “Why my SQL Server is slow?”, you’re not alone. SQL Server performance issues can disrupt critical business operations, delay projects, and frustrate users. A slow SQL Server often points to underlying issues that can be diagnosed and resolved with the right approach. In this blog… Read More »Why my SQL Server is slow?
- WRITELOG Wait Type in SQL ServerUnderstanding the WRITELOG Wait Type in SQL Server What is the WRITELOG Wait Type? The WRITELOG wait type in SQL Server occurs when a task is waiting for the log buffer to be written to disk. SQL Server relies on a transaction log to guarantee data integrity, ensuring that all database modifications are recorded in… Read More »WRITELOG Wait Type in SQL Server
- Podcast Episode 8 – Business ContinuityWatch / Listen Now – The Business Continuity episode Steve Stedman discusses the availability of the Stedman Solutions SQL podcast on YouTube and Spotify, and announces November class promotions with discounts up to 60% off. He emphasizes the importance of business continuity planning, especially in light of recent storms in the Pacific Northwest. Stedman outlines… Read More »Podcast Episode 8 – Business Continuity
- Unlock Peak Performance with Our SQL Server Performance Tuning CourseHey there, Are you ready to supercharge your SQL Server’s performance? If so, you’re in luck! We’re thrilled to announce an exclusive limited-time offer on our comprehensive SQL Server Performance Tuning course, designed to equip database professionals with the skills and knowledge needed to optimize SQL Server performance effectively. 50% OFF – Enroll Now for… Read More »Unlock Peak Performance with Our SQL Server Performance Tuning Course
- Common Waits Reported by Daily Monitoring November 2024Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP MEMORY_ALLOCATION_EXT CXSYNC_PORT CXPACKET ASYNC_NETWORK_IO LCK_M_SCH_S LCK_M_S PREEMPTIVE_OS_GETPROCADDRESS CXCONSUMER Our daily monitoring product… Read More »Common Waits Reported by Daily Monitoring November 2024
- The Perfect Bundle: Database Health Monitor + Blocking Query MonitorIn our commitment to offer top-tier tools for database professionals, we’re thrilled to spotlight a bundle that’s a match made in tech heaven! Dive deep into the synergy of the Database Health Monitor and the Blocking Query Monitor, and discover how they not only complement each other but provide the ultimate solution to your SQL… Read More »The Perfect Bundle: Database Health Monitor + Blocking Query Monitor
- Week 3 Class Discount Wrap-UpAnother exciting week of promotions is coming to a close, and we want to make sure you don’t miss out on the fantastic discounts we’ve offered. These exclusive deals are about to expire, so grab them while you still can! In just a couple of days, these discounts will be replaced by exciting Thanksgiving, Black… Read More »Week 3 Class Discount Wrap-Up
- Mastering the DBA and Developer Interview: Essential Prep CourseWhether you’re a recruiter searching for the perfect Database Administrator or an aspiring SQL Developer gearing up for that critical interview, navigating the intricate nuances of the SQL Server domain can be challenging. Our comprehensive “DBA and Developer Interview Questions” course is tailored just for you! https://stedman.us/INTERVIEW25 Unlock Your Potential with Expert-Designed Content For Candidates:… Read More »Mastering the DBA and Developer Interview: Essential Prep Course
- Podcast Episode 7 – Brandie Kayser joins us!Join us this week as we discuss IT budgeting on the podast. Stedman SQL Server Podcast Ep. 7 Steve Stedman hosts the seventh episode of his podcast, discussing the importance of IT budgeting with Brandie Kayser from ROC-IT. Brandie emphasizes the need for regular IT assessments and budgeting to avoid unexpected expenses. She highlights the… Read More »Podcast Episode 7 – Brandie Kayser joins us!
- An Introduction to SQL Server: A Guide for BeginnersNavigating the intricate world of databases can be daunting, especially if you’re new to SQL Server. Recognizing this challenge, we have designed a beginner-friendly course titled “Getting Started with SQL Server.” This course is tailored specifically for individuals who are unfamiliar with SQL Server, offering them a smooth transition into understanding its functionalities and tools.… Read More »An Introduction to SQL Server: A Guide for Beginners
- Limited Time Offer: Dive into Our Exclusive Track Blocking Queries Course and ScriptIn the rapidly evolving world of digital technology, a keen understanding of SQL Server blockages is non-negotiable. To help professionals like you harness the full potential of SQL Server, we’ve curated an exceptional course, complemented with our state-of-the-art track blocking queries script. Why is this offer different? Exclusivity: Beyond traditional coursework, you will have privileged… Read More »Limited Time Offer: Dive into Our Exclusive Track Blocking Queries Course and Script
- SQL Server Long Running QueriesHow to Monitor SQL Server Long Running Queries Monitoring long running queries in SQL Server is crucial for maintaining a well-performing database. When left unchecked, long running queries can slow down the server, increase resource consumption, and create bottlenecks that affect other processes. In this blog post, we’ll explore how to monitor SQL Server long… Read More »SQL Server Long Running Queries
- Podcast Episode 6 – October Database Health Monitor New FeaturesStedman SQL Podcast Episode 6 In episode six of the Stedman SQL podcast, Shannon Lindsay hosts George and Mitch to discuss new features in the database health monitor. They introduce a Quick Scan check for unscheduled SQL Server Agent jobs, which is particularly useful in cloud environments like RDS and Azure. Two major additions in… Read More »Podcast Episode 6 – October Database Health Monitor New Features
- Nov Week 2 Class Discounts Roundup: Limited-Time Offers Expire Soon!Greetings, fellow learners and SQL enthusiasts! Time is of the essence, as we approach the end of another fantastic week of classes here at [Your Institution Name]. We’ve been delighted to see your enthusiasm for acquiring new skills and knowledge in the world of SQL Server. As we gear up for the upcoming week, it’s… Read More »Nov Week 2 Class Discounts Roundup: Limited-Time Offers Expire Soon!
- Peak Performance with Our SQL Server Performance Tuning CourseHey there, Are you ready to supercharge your SQL Server’s performance? If so, you’re in luck! We’re thrilled to announce an exclusive limited-time offer on our comprehensive SQL Server Performance Tuning course, designed to equip database professionals with the skills and knowledge needed to optimize SQL Server performance effectively. 50% OFF – Enroll Now for… Read More »Peak Performance with Our SQL Server Performance Tuning Course
- Daily Server Monitoring – SQL Versions for 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 client information to expose here. What is this service? With this service we detect and alert you of any issues that arise… Read More »Daily Server Monitoring – SQL Versions for November
- Unlock Advanced SQL Techniques with Our Special Offer!Attention SQL enthusiasts and professionals! Our highly anticipated course on aggregation and window functions in SQL is now available at a promotional price. For a limited time, dive into the intricacies of SQL Server querying for just $3! This offer stands until November 15th. Coupon code AGG3
- 40% Off: Enhance Your SQL Skills with Common Table ExpressionsCommon Table Expressions (CTEs) are an integral feature in SQL Server, enabling developers to produce more organized, readable, and maintainable code. Recognizing their importance, we’ve invested over 9 years into curating a course that encompasses every facet of CTEs. Drawing from experiences presenting at esteemed conferences, authoring a specialized book, and hosting myriad online sessions,… Read More »40% Off: Enhance Your SQL Skills with Common Table Expressions
- Last Chance: Exclusive Week 1 Class Discounts!Hurry, there’s only a limited window of opportunity to snag these incredible deals on our SQL Server classes for November. In a few days, these offers will be history, making way for fresh promotions. 1. SQL Joins Type Class at a Whopping 40% Off Regularly priced at $29.99 USD, our best-selling JOINS Type class is… Read More »Last Chance: Exclusive Week 1 Class Discounts!
- The Everything SQL Server Class BundleHello SQL enthusiasts! Today, we are thrilled to bring to the spotlight our class offering – The Everything SQL Server Bundle. Specially curated for both the budding enthusiasts and the seasoned pros, this comprehensive package is here to revolutionize your SQL Server learning journey. Inside the Bundle From gearing up for those key interviews to… Read More »The Everything SQL Server Class Bundle
- Unlock the Power of TSQL Output Clause: Only $2 for Limited Time!Enhance your SQL Server toolkit with an in-depth understanding of the TSQL Output Clause. For a mere $2, using the coupon code OUTPUT2, this course will guide you through the intricacies of one of SQL Server’s most underutilized features. Why is the SQL Server output clause so transformative? Immediate Feedback on Operations: Ever wanted instant… Read More »Unlock the Power of TSQL Output Clause: Only $2 for Limited Time!
- Exclusive Offer: SQL Joins Course at 40% OffOur SQL Joins class is among the top favorites of our esteemed learners. At its regular pricing of $29.99 USD, many consider it an incredible value. Now, with our special offer, it gets even better. Use the coupon code JOINSNOV to avail a 40% discount and enroll in the course for just $17.99 USD. Course… Read More »Exclusive Offer: SQL Joins Course at 40% Off
- SQL Server Class Specials this November at Stedman SolutionsNovember has always been a special month at Stedman Solutions, synonymous with outstanding offers on our SQL Server courses. As we transition into the festive season, we are thrilled to announce an entire month of unparalleled discounts and promotions. At Stedman Solutions, we’ve always believed in delivering unparalleled value. This November, we continue this tradition… Read More »SQL Server Class Specials this November at Stedman Solutions
- Patching SQL ServerThe Risks of Patching vs. Not Patching SQL Server Patching SQL Server is essential for security, performance, and compatibility. However, it can introduce risks like downtime or compatibility issues. Let’s look at both sides. Risks of Not Patching Security Vulnerabilities: Unpatched servers are prone to breaches and Ransomware. Data Corruption: Bugs can lead to data… Read More »Patching SQL Server
- Podcast Episode 5 – PerformanceStedman SQL Podcast Ep. 5 – Performance In episode five of the Stedman Solutions SQL Server podcast, Steve Stedman and Shannon Lindsay discuss common performance issues in SQL Server. They highlight the importance of indexing, emphasizing the need for proper index creation and avoiding multiple identical or single-column indexes. They address the impact of functions… Read More »Podcast Episode 5 – Performance
- Final Days to Seize October Special at Stedman Solutions!For the month of October you will receive a free year of our SQL Server Daily Monitoring with the purchase of a SQL Server Assessment. Time is running out! There are only a few days left in October, which means you have a limited opportunity to benefit from our exclusive offer at Stedman Solutions. Purchase… Read More »Final Days to Seize October Special at Stedman Solutions!
- Cost of Unplanned DowntimeHow to Calculate the True Cost of Unplanned Downtime: Every Business is Different Unplanned downtime can wreak havoc on any organization, but the true cost is often far greater than what meets the eye. Whether it’s caused by hardware failure, data Corruption, or system crashes, the financial impact varies widely from business to business. However,… Read More »Cost of Unplanned Downtime
- TSQL Output Clause CourseThe output clause is one of the wow factor query items, where when people see you use it the just go WOW, I did not know you could do that. I can remember working with a client and showing that to them and getting that same reaction of WOW. Have you seen our SQL short… Read More »TSQL Output Clause Course
- Unleash the Power with SQL Performance TuningHey there, Steve Stedman here, and I couldn’t be more excited to share some insights on a service that has been making waves in the world of database management. Today, I want to shine a spotlight on Stedman Solutions’ exceptional SQL Performance Tuning service, which has helped countless businesses optimize their database performance and streamline… Read More »Unleash the Power with SQL Performance Tuning
- Your Performance Tuning ToolkitHow Database Health Monitor Can Be Your Performance Tuning Toolkit For more informationon Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at http://DatabaseHealth.com/download2. As a SQL Server DBA or developer, keeping your databases running smoothly is a top priority. One of the most challenging aspects of… Read More »Your Performance Tuning Toolkit
- Common Waits Reported by Daily Monitoring This MonthEach month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP MEMORY_ALLOCATION_EXT CXSYNC_PORT CXPACKET LCK_M_SCH_S CXCONSUMER LCK_M_S RESOURCE_SEMAPHORE_QUERY_COMPILE LCK_M_IS Our daily monitoring product… Read More »Common Waits Reported by Daily Monitoring This Month
- What Are the 3 Types of Replication in SQL Server?Replication in SQL Server is a powerful feature that allows you to copy and distribute data and database objects from one database to another and keep them synchronized. This is especially useful for scenarios like load balancing, high availability, or geographically distributed databases. Understanding the types of replication available in SQL Server is crucial for… Read More »What Are the 3 Types of Replication in SQL Server?
- SQL Join Types PosterDownload the Join Types poster today for FREE!Available for both SQL Server (TSQL) and MySQL. Check out the poster, it is a versatile, print-on-demand resource which you can customize according to your preference of size. This tool has been tailored to serve as a useful reference for both SQL Server developers and database administrators, simplifying… Read More »SQL Join Types Poster
- Empower Your Projects with our Skilled TeamEmpower Your Projects with our Skilled DBAs and Programmers: A Comprehensive Solution With a technical team of 5 people with well over 100 years of combined experience we are available to help with your next project. Our team of highly experienced Database Administrators (DBAs) and programmers is uniquely qualified to support and elevate your projects.… Read More »Empower Your Projects with our Skilled Team
- Automatic SQL Server Tuning: The Pros and ConsAutomatic SQL server tuning can seem like a dream come true for many database administrators and developers. The idea of software handling the intricate and time-consuming task of optimizing SQL queries automatically, freeing up time for other priorities, is appealing. But like any tool, Automatic SQL Tuning has its benefits and drawbacks. In this post,… Read More »Automatic SQL Server Tuning: The Pros and Cons
- Podcast Episode 4 – ReplicationReplication on SQL Server – podcast episode by Steve Stedman. October 9, 2024 Steve Stedman discusses SQL Server replication, highlighting its use in synchronizing data between servers. He covers snapshot, transactional, and merge replication, explaining their functionalities and limitations. Snapshot replication provides a one-time copy of data, but can be inefficient during updates. Transactional replication… Read More »Podcast Episode 4 – Replication
- Unlock the Full Potential of Your SQL ServerUnlock the Full Potential of Your SQL Server with Stedman Solutions’ Managed Services In today’s fast-paced world, your SQL Server database is more crucial than ever. It’s the powerhouse behind your most critical operations. That’s where Stedman Solutions, LLC, steps in. We offer flexible, fully managed services tailored to the unique demands of your SQL… Read More »Unlock the Full Potential of Your SQL Server
- LCK_M_RIn_S_LOW_PRIORITY Wait Type in SQL ServerUnderstanding the LCK_M_RIn_S_LOW_PRIORITY Wait Type in SQL Server In SQL Server, understanding wait types is crucial for diagnosing performance issues and improving database efficiency. One of the less commonly encountered wait types that can impact performance is LCK_M_RIn_S_LOW_PRIORITY. Let’s dive into what it means, the context in which it occurs, and how to mitigate this… Read More »LCK_M_RIn_S_LOW_PRIORITY Wait Type in SQL Server
- WRITE_COMPLETION Wait TypeUnderstanding the WRITE_COMPLETION Wait Type in SQL Server and Its Performance Impacts When it comes to SQL Server Performance tuning, understanding wait types is essential. One such wait type that often flies under the radar but can signal important I/O issues is WRITE_COMPLETION. This wait type can point to problems with your disk subsystem, particularly… Read More »WRITE_COMPLETION Wait Type
- Understanding and Avoiding SQL Server LCK_M_U and LCK_M_X Wait TypesIn SQL Server, Performance Tuning often involves examining Wait Statistics to understand what’s causing delays in query execution. Two common wait types that can significantly impact performance are LCK_M_U (Update Lock) and LCK_M_X (Exclusive Lock). These wait types occur when queries are blocked due to locking conflicts in the database. If you don’t manage locking… Read More »Understanding and Avoiding SQL Server LCK_M_U and LCK_M_X Wait Types
- Podcast Episode 3 – Stedman SQL Server PodcastOctober, 2 2024 Steve Stedman emphasizes the critical importance of SQL Server data in business operations, highlighting the severe consequences of data loss. He recounts a ransomware attack on a regional hospital that resulted in the complete loss of patient data and backups, underscoring the need for robust backup and business continuity plans. Stedman stresses… Read More »Podcast Episode 3 – Stedman SQL Server Podcast
- Podcast Episode 1September 18, 2024 Steve Stedman announced the transition of their live stream to a weekly podcast called the Stedman SQL Podcast. Shannon will assist with editing and streaming. The team is planning six months of content, including SQL Server training and new features for the Database Health Monitor (DHM). George and Mitchell, developers of DHM,… Read More »Podcast Episode 1
- Daily Server Monitoring – SQL Versions for OctoberOut of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise… Read More »Daily Server Monitoring – SQL Versions for October
- Top 10 Techniques to Turbocharge Your SQL Server PerformanceFor the month of October you will receive a free year of our SQL Server Daily Monitoring with the purchase of a SQL Server Assessment. Top 10 Techniques to Turbocharge Your SQL Server Performance Understanding how to optimize your SQL Server performance is crucial for ensuring your applications and data-driven processes run smoothly. In this… Read More »Top 10 Techniques to Turbocharge Your SQL Server Performance
- Daily Monitoring ProductA great way to keep tabs on the overall health of your SQL Server. Pricing: $129.99 per month per SQL Server instance when paid month to month. Payment on a recurring payment by credit card plan required. We provide monitoring tools that alert us when there is an issue so that we can recommend fixes… Read More »Daily Monitoring Product
- The Power of an SQL Server Health AssessmentOptimizing Efficiency and Security: The Power of an SQL Server Health Assessment In today’s fast-paced technology landscape, businesses depend on efficient and secure data management to stay competitive. An SQL Server health assessment plays a crucial role in ensuring that your systems are running optimally, safeguarded from vulnerabilities, and prepared for future growth. In this… Read More »The Power of an SQL Server Health Assessment
Additional Thoughts
Thank you for exploring our SQL Server blog! We’re committed to providing fresh, relevant, and actionable content to help you navigate the complexities of SQL Server. From troubleshooting performance issues to mastering advanced features, our articles are designed to empower you with the knowledge you need to succeed. Whether you’re solving a specific problem or expanding your expertise, we’re here to support you every step of the way.
SQL Server is constantly evolving, and so are the challenges and opportunities that come with managing it. That’s why we frequently update our blog with new posts, insights, and tutorials. By staying engaged with our latest articles, you’ll gain an edge in understanding new features, identifying best practices, and applying innovative solutions in your SQL Server environment. We aim to keep you informed and ahead of the curve.
If you’ve found value in the content here, be sure to bookmark this page and check back regularly. With each new post, we strive to address the topics that matter most to SQL Server professionals, based on the real-world scenarios we encounter every day. Our goal is to create a resource you can rely on for timely, trustworthy, and practical SQL Server advice.
Don’t miss out on future updates! Whether it’s an in-depth guide, a quick tip, or a thought-provoking perspective, there’s always something new to discover. And if you have specific topics you’d like us to cover, we’d love to hear from you. Keep checking back, and let us help you make the most of your SQL Server journey.