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 …
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 …
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 …
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 …
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 …
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 …
Hey there, fellow SQL enthusiasts! I’m Steve Stedman, and I’m excited to share my SQL Server course on the TSQL Output Clause. If you’re like me and passionate about mastering SQL Server, then you’re in for a treat! This course is designed to help you unlock the power of the TSQL Output Clause to streamline your database operations. Check it …
SQL School: Master the TSQL Output Clause with My SQL Server Course Read more »
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 been able to get everything. Some have paid the ransom, and some have not. Even some who have paid the ransom did not got their data back. …