Buffer Pool

Here is a curated list of Buffer Pool related links that I recommend visiting:

Buffer Pool Articles:

Buffer Pool Presentations:

Buffer Pool Articles from SQL Monitoring Tools:

Buffer Pool Videos:

  • SQLPassion – SQL Server Quickie #22 – The Buffer Pool – by Klaus Aschenbrenner
    • Direct YouTube Link:

  • SQL Masters Consulting – SQL Server 2014 – Buffer Pool Extension
    • Direct YouTube Link:

  • SQLServer Work – What is the Buffer Pool
    • Direct YouTube Link:

Baseline

Here is a curated list of Baseline related links that I recommend visiting:

Baseline Articles:

Baseline Presentations:

Baseline Articles from SQL Tool Providers:

Baseline Videos:

PASS DBAFundamentals Virtual Chapter

  • SQL Server Performance Monitoring & Baselining

PASS PowerShell Virtual Chapter

  • Maintain SQL Server Performance Baseline with PowerShell

PASS Women In Technology Virtual Chapter

  • SQL Server Take Over Establishing a Baseline with Lowry Kozlowski

SQL Workbooks

  • Collect and Baseline Wait Statistics (Dear SQL DBA Episode 14)

 

Always Encrypted

Here is a curated list of Always Encrypted related links that I recommend visiting:

Always Encrypted Articles:

Always Encrypted Presentations:

Always Encrypted Articles from SQL Tool Providers:

Always Encrypted Videos:

  • Microsoft Ignite
    • Make it real with Always Encrypted, Stretch Database and Temporal Tables

  • Pragmatic Works
    • New Security Features in SQL Server 2016

  • PASS Security Virtual Chapter
    • Deep Dive on Encryption in SQL Server/SQL Database by Raul Garcia

  • DBAFundamentals
    • SQL Server Encryption

 

AlwaysOn

Here is a curated list of AlwaysOn related links that I recommend visiting:

AlwaysOn Articles:

AlwaysOn Presentations:

  • SentryOne – Monitoring and Performance Tuning for AlwaysOn by Kevin Kline
  • Professional Association for SQL Server (requires free login)
    • PASS Summit Recordings
      • http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
        • SQL Server 2016 on Flash: Fast Track DW, SOFS, Columnstore, & AlwaysOn by Brian Walters
        • AlwaysOn in SQL Server 2016 by Kevin Farlee
        • Install an AlwaysOn Failover Cluster and Availability Group by Ryan Adams
        • SQL Server AlwaysOn QuickStart by Ryan Adams
        • Introduction to AlwaysOn Availability Groups by Adam Belebczuk
        • SQL Server 2014 AlwaysOn (High Availability and Disaster Recovery) by Kevin Farlee
        • Troubleshooting AlwaysOn Availability Groups in SQL 2014 by Trayce Jordan
        • Into the Blue: Extending AlwaysOn Availability Groups by Joseph D’Antoni
        • AlwaysOn in SQL Server 2014 by Luis Vargas
        • CAT: AlwaysOn Customer Panel – Lessons Learned & Best Practices by Ayad Shammout, David Smith, Michael Steineke, Sanjay Mishra, and Thomas Grohser
        • and many, many, more…

AlwaysOn Articles from SQL Monitoring Tools:

AlwaysOn Videos:

  • PASS – High Availability Disaster Recovery Virtual Chapter – Microsoft SQL Tiger Team – Availability Group Troubleshooting Improvements
    • Direct YouTube Link:

  • Grant Fritchey’s Availability Group Monitoring in SQL Monitor
    • Direct YouTube Link:

  • PASS – High Availability Disaster Recovery Virtual Chapter’s “TroubleShooting AlwaysOn Availability Groups in SQL Server 2015” by Trace Jordan
    • Direct YouTube Link:

  • 24Hours of PASS
    • SQL Server 2016 AlwaysOn Availability Groups Enhancements by Jimmy May
      • Direct YouTube Link:

  • 24Hours of PASS
    • SQL Server AlwaysOn Quickstart by Ryan Adams
      • Direct YouTube Link:

  • 24Hours of PASS
    • AlwaysOn in Microsoft SQL Server 2014 by Luis Vargas
      • Direct YouTube Link:

  • Virtual Group Webinars
    • SQL Server 2016: Always On Enhancements by Percy Reyes
      • Direct YouTube Link:

  • Virtual Group Webinars
    • Migration to SQL Server AlwaysOn lessons learned
      • Direct YouTube Link:

  • Virtual Group Webinars
    • AlwaysOn Multi-Site configurations by John Martin
      • Direct YouTube Link:

  • Virtual Group Webinars
    • Install an AlwaysOn Failover Cluster and Availability Group by Ryan Adams
      • Direct YouTube Link:

  • Virtual Group Webinars
    • Troubleshooting AlwaysOn Availiablity Groups in SQL 2014
      • Direct YouTube Link:

  • Virtual Group Webinars
    • Is AlwaysOn the Right high Availability and Disaster Recovery Plan for me? by Ryan Adams
      • Direct YouTube Link:

  • Pragmatic Works
    • What’s New in AlwaysOn Availability Groups in SQL Server 2016
      • Direct YouTube Link:

  • Pragmatic Works
    • How to video: AlwaysOn Availability Groups
      • Direct YoutTube Link:

 

  • SentryOne
    • AlwaysOn Monitoring with Performance Advisor
      • Direct YouTube Link:

Deadlocks

Here is a curated list of Deadlock related links that I recommend visiting:

Deadlock Articles:

Deadlock Presentations:

Deadlock Articles from SQL Monitoring Tools:

Deadlock Videos:

  • Grant Fritchey’s SQL Monitor and Deadlocks
    • Direct YouTube Link:

 

  • Kendra Little’s “Setting Up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)”
    • Direct YouTube Link:

 

  • Kendra Little
    • Direct Vimeo Link:

 

 

  • Pluralsight’s “Take a Good Hard Look At SQL Server Deadlocks”
    • Direct YouTube Link:

 

  • SentryOne’s “SQL Server Deadlocks”
    • Direct YouTube Link:

Index Tools

Here are some Indexing tools you may find helpful:

Index Related Tools: