episodes # Title Category Date 57 Send Notification Email from Data Factory or Azure Synapse pipeline Azure Synapse 13/02/2022 58 Implementing Slowly Change Dimension in Azure Synapse SQL pool Azure Synapse 23/02/2022 59 Using Primary Key with large number of fields is not the best option SQL Server 29/07/2022 60 Page Splits SQL Server 05/08/2022 61 Using Extended Properties SQL Server 11/08/2022 62 TSQL Functions SQL Server 2022 16/08/2022 63 Time Series Functions SQL Server 2022 18/08/2022 64 Bit Manipulation Functions SQL Server 2022 19/08/2022 65 SQL Windowing Enhancements SQL Server 2022 22/08/2022 66 Distinct Predicates SQL Server 2022 23/08/2022 67 The Approximate Percentile Functions SQL Server 2022 24/08/2022 68 New JSON Functions SQL Server 2022 25/08/2022 69 Statistics AUTO_DROP SQL Server 2022 26/08/2022 70 Resumable Table Constraints SQL Server 2022 29/08/2022 71 Accelerated Database Recovery (ADR) improvements SQL Server 2022 30/08/2022 72 Trim Functions Improvements SQL Server 2022 31/08/2022 73 Virtual Log File growth changes SQL Server 2022 05/09/2022 74 XML Compression SQL Server 2022 06/09/2022 75 Dynamic Data Masking SQL Server 2022 07/09/2022 76 New Fixed Server Roles and Permissions SQL Server 2022 12/09/2022 77 Improved backup metadata SQL Server 2022 14/09/2022 78 Auto Update Statistics Async with Low Priority SQL Server 2022 19/09/2022 79 Transact-SQL snapshot backup SQL Server 2022 21/09/2022 80 TDS 8.0 and TLS 1.3 support SQL Server 2022 02/10/2022 81 Crypto and Encryption Enhancements SQL Server 2022 03/10/2022 82 The Ledger SQL Server 2022 07/10/2022 83 SQL Server backup to URL for S3-compatible object storage SQL Server 2022 10/10/2022 84 Parameter Sensitive Plan Optimization SQL Server 2022 16/10/2022 85 Data Lake Virtualization with S3 compatible object Storage SQL Server 2022 18/10/2022 86 Azure Synapse Link for SQL SQL Server 2022 23/10/2022 87 Query Store Hints SQL Server 2022 31/10/2022 88 Cardinality Estimation (CE) Feedback SQL Server 2022 01/11/2022 89 Degree of Parallelism (DOP) Feedback SQL Server 2022 02/11/2022 90 Optimized Plan Forcing SQL Server 2022 05/11/2022 91 Memory Grant Feedback Persistence SQL Server 2022 13/11/2022 92 Query Store and Secondary Replicas SQL Server 2022 15/11/2022 93 System page latch concurrency enhancements SQL Server 2022 01/12/2022 94 Contained Availability Groups SQL Server 2022 03/12/2022 95 Azure Arc enabled SQL Server and PAYG Licensing SQL Server 2022 05/12/2022 96 SQL Server 2022 Revealed SQL Server 2022 12/12/2022 97 Working with Hypothetical Indexes SQL Server 18/12/2022 98 Monitor Auto Update Statistics SQL Server 29/12/2022 99 Row-level Security in SQL Server SQL Server 30/01/2023 100 Introduction to Encryption in SQL Server SQL Server 19/02/2023 101 Encrypted Backups SQL Server 21/02/2023 102 Transparent Data Encryption (TDE) SQL Server 26/02/2023