SQL Server Archives

The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.

Explore Row-Level Security in SQL Server to control data access without altering application logic effectively.

Discover how Dynamic Data Masking in SQL Server protects sensitive data without complex changes and rewriting code.

John Deardurff passed the DP-200 and DP-201 exam for the Microsoft Certified: Azure Data Engineer certification.

During the summer of 2020, I earned four new Microsoft certifications. This brings me to over sixty in total with 86 Microsoft exams passed.

Explore the Task Execution Model used in the Database Engine for efficient CPU thread scheduling and task management.

Explore SQL Server Page Types and their roles in optimizing performance and managing data storage within your database.

Unlock performance with non-clustered indexes in SQL Server and learn best practices for effective query optimization.

Explore the importance of indexes that cover a query and how they can improve SQL Server performance and eliminate lookups.

Unlock the power of Multi‑Column Indexing in SQL Server to optimize performance and reduce expensive query costs.