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
Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the… Read More »Daily Server Monitoring – SQL Versions for November