Welcome, 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 with the coupon code OUTPUT2, you can explore its immense potential. Why Every DBA and Database Developer Should Understand the Output Clause: The SQL Server output clause …

Mastering the TSQL Output Clause: Exclusive Offer Read more »

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 a steal. But guess what? With the magic code JOINSNOV, you can snag it at 40% off, bringing it down to just $17.99 USD. Here’s What’s Inside: …

Grab My Favorite SQL Joins Course at a Special Discount! Read more »

In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having too many of them can lead to issues when it comes to inserts, updates, and deletes. In this blog post, we’ll explore the delicate balance of index …

Dangers of Removing Indexes Read more »

With years of development into Database Health Monitor, there are many features there for many difference scenarios from performance to security, to overall server health. With this month being Database Health Montior month we have a special combo offering. I created the Database Health Monitor course to help people get the most value out of using the product, and with …

Database Health Monitor with Coaching Read more »

Today, I’m back to spotlight a deal that’s genuinely too good to ignore, especially if you’re in the realm of SQL Server management. We’re down to the final week of October, and Stedman Solutions is closing in on our exclusive offer. We can help!https://stedman.us/performance What’s The Deal? Until the end of October, if you purchase a SQL Server Assessment from …

Last Call: Just One Week Left for a Phenomenal Deal from Stedman Solutions! 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. CXPACKET SP_SERVER_DIAGNOSTICS_SLEEP ASYNC_NETWORK_IO LCK_M_IS OLEDB LCK_M_IU LCK_M_IX MEMORY_ALLOCATION_EXT LCK_M_S XE_LIVE_TARGET_TVF Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »