SteveStedman

Today Microsoft released a new update for SQL Server. SQL Server 2022 CU16 for 2022 (16.0.4165.4 – November 2024) CU15 + GDR (16.0.4155.4 – November… Read More »New SQL Update from Microsoft

Hey there, fellow SQL DBA and Developers I’ve been immersed in the world of database administration for over 33 years now, and if there’s one… Read More »Limited Time Offer: Dive into SQL Server Blocking with Our Exclusive Script

Automatic SQL Tuning: The Pros and Cons Automatic SQL tuning aims to simplify the optimization of SQL queries by automating the process. It can save… Read More »Automatic SQL Server Tuning

Today Microsoft released a new update for SQL Server. SQL Server 2016 CU17 + GDR for SP2 (13.0.5893.48 – June 2022) CU17 for 2016 SP2… Read More »New SQL Update from Microsoft

Welcome to all SQL enthusiasts! We’re ecstatic to introduce our comprehensive offering – The Everything SQL Server Bundle. Whether you’re just starting out or a… Read More »The Everything SQL Server Class Bundle

Understanding the CXPACKET and CXCONSUMER Wait Types in SQL Server In SQL Server, two of the most commonly encountered wait types are CXPACKET and CXCONSUMER.… Read More »CXPACKET and CXCONSUMER

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… Read More »November Week 2 Discounts Offers Expire Soon!

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.… Read More »SQL Server Wait Type: PAGEIOLATCH_UP

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… Read More »Unlock Peak Performance with Our SQL Server Performance Tuning Course

DBCC FREEPROCCACHE is a DBCC command in Microsoft SQL Server that can be used to clear the procedure cache, which is a region of memory… Read More »SQL Server DBCC Commands: DBCC FREEPROCCACHE