Steve Stedman

In the fast-paced digital world we live in, data is everything. Whether you’re a seasoned DBA or a junior developer, understanding how to properly backup and restore SQL Server databases is essential for protecting this invaluable asset. To those searching for the most comprehensive and easy-to-understand training, look no further. Stedman’s SQL School has created an outstanding course on SQL …

Why SQL Server Backup and Recovery Skills are a Must-Have and How to Master Them Read more »

Watch this sneak peek we put together for you! In today’s digital age, robust data backup and recovery systems are more crucial than ever. One minor glitch, hardware failure, or cyber-attack could spell disaster, especially for businesses that rely heavily on data. If you’re looking to secure your SQL Server data, Stedman’s SQL Server Backup and Recovery Course is an …

Backup and Restore Course Overview Read more »

Monitoring disk I/O is an essential part of database performance monitoring, as disk I/O can significantly impact query performance and slow down database response times. The Database Health Monitor for SQL Server provides insights into disk I/O, enabling you to identify potential issues and optimize database performance. Disk I/O refers to the input and output operations performed on your server’s …

Database Health: Monitoring Disk I/O Read more »

Mastering SQL Server Replication: A Comprehensive Class by Stedman Solutions Are you ready to take your SQL Server skills to the next level? Join us in this detailed video where we dive into our comprehensive SQL Server Replication class. Whether you’re a database administrator, data architect, or IT professional, this class is designed to provide an in-depth understanding of SQL …

Mastering SQL Server Replication Read more »

SQL DBA and Developer Interview Prep Course Watch this video by Steve Stedman to find out more. For additional informative videos, visit my YouTube channel at https://www.youtube.com/@SteveStedman. There, you’ll find a wide range of content covering various topics, all designed to provide valuable insights and help you stay informed. Get Ready for Your Next Interview Whether you’re about to hire …

SQL DBA and Developer Interview Prep Course Read more »

As an IT manager or business owner, you’ve got a lot on your plate. From ensuring system uptime to managing daily operations, your workload is already full. But what happens when your SQL Server environment starts experiencing performance issues or, worse, suffers a critical failure? The impact on your business can be significant, from lost productivity to potential data loss. …

Why SQL Server Managed Services Are Essential for Your Business Read more »

Boost Your SQL Server Performance with Expert Guidance! In this video, Steve Stedman from Stedman Solutions introduces his comprehensive SQL Server Performance Tuning course. Learn essential techniques to optimize your SQL Server, enhance query performance, and ensure efficient database management. Perfect for DBAs and IT professionals, this course covers everything from indexing strategies to performance monitoring. Enroll today and transform …

SQL Server Performance Tuning Course Read more »

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 database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …

SQL Server Wait Type: Read more »

Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP CXPACKET CXSYNC_PORT ASYNC_NETWORK_IO MEMORY_ALLOCATION_EXT LCK_M_IX LCK_M_SCH_S LCK_M_IS PREEMPTIVE_OS_GETPROCADDRESS Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

August Promotion SQL Daily Checkup 6 months free with any new or renewing mentoring client. Sign up for a 4 or 8 hour mentoring package in August and receive 6 months of our daily checkup service for free. If you already are using our SQL Daily Checkup, we will extend your subscription by 6 months. Offer expires August 31. Greetings, …

Special Offer: Get a Complimentary SQL Daily Checkup with Stedman Solutions’ Mentoring Service in August! Read more »