T-SQL Patterns

By: Oketunji, Finbarrs

T-SQL is more than syntax. Production SQL Server work demands safe query patterns, predictable performance, clear concurrency behaviour, and robust security and operational controls.

This book is a practical guide to T-SQL patterns for SQL Server. It covers query building, data modification, index design, performance tuning, security, stored procedures, functions, views, ETL, temporal data, concurrency, testing, monitoring, disaster recovery, migrations, and automation with GitHub Actions.

Each chapter includes implementation-focused examples you can lift into real systems. The examples prioritise correctness, readability, and operational safety.

• Format: Paperback
• Language: English
• ISBN: B0DMKSQ769
• ISBN13: 9798346015611
• Release Date: November 2024
• Publisher: Independently Published
• Length: 322 Pages
• Weight: 2.28 lbs.
• Dimensions: 0.8" x 8.5" x 11.0"