×

DBA Fundamentals Group

January 13, 2023

View Event: The magnificent seven and beyond – Intelligent Query Processing in SQL Server Can we fix query performance issues without any code changes? Making application changes can be an expensive undertaking. Hence, developers and DBAs want the query processor to adapt to their workload needs vs. using options and trace flags to gain performance. […]

CPU Affinity Mask & TF8002

January 13, 2023

Setting CPU affinity in SQL Server is not a task you do every day. Rarely are there use cases when you need to do that. I had a recent requirement to do it. We plan to replace a physical server with half of its current CPU. Primarily due to faster CPU and workload moved off of […]

Capital Area SQL Server User Group

January 9, 2023

View Event: What the heck is a checkpoint, and why should I care?An 8K page is the fundamental unit of data storage in SQL Server. SQL Server performs every data modification operation in memory (buffer pool) for performance reasons and does not immediately write it back to disk. This is where checkpoint comes into play. […]

Birmingham Microsoft Data Platform Group

January 27, 2023

View Event: Azure SQL Database-Business Continuity During Disaster Azure SQL Database is a relational database-as-a-service (DBaaS) based on the Microsoft SQL Server Database Engine’s latest version. You can build data-driven applications and websites in the programming language of your choice without needing to manage infrastructure. While considering Azure SQL Database, two of the most critical […]



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook