Managing SQL Server Database Concurrency

links.md

Link to this page: https://git.io/fhA7L

Links to software used in this course:

• SQL Server Downloads (LocalDB, used in the course, is in the SQL Server Express installation):
  • https://www.microsoft.com/en-ca/sql-server/sql-server-downloads
• Azure Data Studio (formerly SQL Server Operations Studio):
  • https://docs.microsoft.com/en-us/sql/azure-data-studio
• SQL Server Management Studio (SSMS):
  • https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms

Docker Containers for SQL Server:

• Windows

  • docker pull microsoft/mssql-server-windows-developer

• Linux

  • docker pull microsoft/mssql-server-linux

Links to Microsoft documentation on concurrency and transactions:

• Transaction Locking and Row Versioning Guide
  • https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-locking-and-row-versioning-guide
• SET TRANSACTION ISOLATION LEVEL
  • https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql
• Transaction Related Dynamic Management Views and Functions
  • https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/transaction-related-dynamic-management-views-and-functions-transact-sql
  • https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-sessions-transact-sql
• Extended Events
  • https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events
• Transactions
  • https://docs.microsoft.com/en-us/sql/t-sql/language-elements/transactions-transact-sql
• TRY...CATCH
  • https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql
• SET XACT_ABORT
  • https://docs.microsoft.com/en-us/sql/t-sql/statements/set-xact-abort-transact-sql
• SET LOCK_TIMEOUT
  • https://docs.microsoft.com/en-us/sql/t-sql/statements/set-lock-timeout-transact-sql

Snapshot Isolation

• Snapshot Isolation in SQL Server
  • https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server
• ALTER DATABASE SET Options
  • https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options

Related Pluralsight Courses:

• SQL Server: Introduction to Extended Events
  • https://app.pluralsight.com/library/courses/sqlserver-basicxevents
• Handling Errors in SQL Server
  • https://app.pluralsight.com/player?course=sql-server-2008-database-development-pt1 Module 8
  • https://app.pluralsight.com/player?course=sql-server-2012-querying-pt2 Module 2
• XML support in SQL Server
  • https://app.pluralsight.com/library/courses/sql-server-xml

Miscellaneous SQL Server documentation links:

• Configuration Functions
  • https://docs.microsoft.com/en-us/sql/t-sql/functions/configuration-functions-transact-sql

Ebooks and other resources:

• Defensive Database Programming
  • https://www.red-gate.com/community/books/defensive-database-programming
• SQL Server Concurrency: Locking, Blocking and Row Versioning
  • https://www.red-gate.com/community/books/sql-server-concurrency
• Troubleshooting SQL Server: A Guide for the Accidental DBA
  • https://www.red-gate.com/community/books/accidental-dba
• sp_whoisactive from Adam Machanic
  • http://whoisactive.com/

Thanks for your prompt reply @gbritton1. Even though this may not be the channel you planned for feedback.

Could you also comment on the phantom reads using READ COMMITTED? I'd like to close out my doubts on that today.

I loved the straightforward way your course lets me explore, hands-on, concurrent behavior using multiple windows. Even one of my technical coaches was impressed because it leaves nothing up to timing chance.

Thanks for your insightful course!