Steve Stedman

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 SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …

My Join Types 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: PREEMPTIVE_OLEDBOPS 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 ASYNC_NETWORK_IO PREEMPTIVE_OS_GETPROCADDRESS LCK_M_SCH_S LCK_M_S MEMORY_ALLOCATION_EXT CXCONSUMER LCK_M_IX Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

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 SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …

Join Types Shirt Read more »

Here is a short video that I created explaining the difference between Push and Pull replication. Watch it on YouTube. https://youtu.be/ykHsAHH-ggs?si=Msr4jRgeygOs3_Gq Replication Course Enrollment Information Want to learn more about replication? If you’re ready to take your SQL Server skills to the next level, visit Stedman’s SQL School SQL Server Replication Course to learn more and enroll today. We look …

Push vs Pull Replication Video Read more »

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 SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …

Join Types on your wall Read more »

In addition to its customizable dashboard, intelligent alerting system, and powerful reporting capabilities, the Database Health Monitor also provides valuable insights into wait statistics and blocking queries. Wait statistics are a crucial component of database performance monitoring, as they provide information about the amount of time that queries spend waiting for various resources, such as locks, I/O operations, or CPU …

Database Health: Wait Statistics and Blocking Queries Read more »

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 SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …

Don’t Miss Out With Join Types Month Read more »