Q&A Performance Tuning SQL Server Using Wait Statistics Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to ...

Securing the server and data Recognizing that more frequent and complex cyberattacks are targeting your environment, SQL Server 2017 Administration Inside Out covers the security capabilities of SQL ...

Two other very nice performance features new to SQL Server 2017 are SSIS Scale Out, for those with data loading needs, and native scoring, which integrates machine learning algorithms into the SQL ...

SQL Server Maintenance Solution Hardening Solution and other SQL Server scripts for health checks and performance tuning. This solution was created partly based on https://www.cisecurity.org (State: ...

Overview This project demonstrates advanced SQL Server querying and performance tuning techniques using a sales reporting system. It is fully containerized using Docker and designed for portability, ...

Enhance indexing The performance of your SQL server will be closely tied to indexing, and part of the tuning process will be establishing whether index fragmentation has occurred. A fragmented index ...