| 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 |
| 103 |
Introduction to Microsoft Fabric |
Microsoft Fabric |
11/06/2023 |
| 104 |
Lakehouses in Microsoft Fabric |
Microsoft Fabric |
02/12/2023 |
| 105 |
Use Apache Spark in Microsoft Fabric |
Microsoft Fabric |
04/12/2023 |
| 106 |
Working with Delta Lake tables in Microsoft Fabric |
Microsoft Fabric |
06/12/2023 |
| 107 |
Dataflows (Gen2) in Microsoft Fabric |
Microsoft Fabric |
08/12/2023 |
| 108 |
Data Factory pipelines in Microsoft Fabric |
Microsoft Fabric |
10/12/2023 |
| 109 |
Medallion Architecture in a Microsoft Fabric lakehouse |
Microsoft Fabric |
12/12/2023 |
| 110 |
Data Warehouses in a Microsoft Fabric |
Microsoft Fabric |
17/12/2023 |
| 111 |
OneLake in Microsoft Fabric |
Microsoft Fabric |
28/12/2023 |
| 112 |
OneLake Shortcuts in Microsoft Fabric |
Microsoft Fabric |
30/12/2023 |