פרק 153 - טרי טרי מהתנור עם ניילון

שיחות בין DBAs

גיא ואיתן מדברים על SQL Server 2022 ששוחרר באופן רשמי לציבור הרחב, על כנס PASS Data Community Summit, ועוד.

קישורים רלוונטים:

• SQL Server 2022 is now generally available - Microsoft SQL Server Blog
• רשימת חידושים בענן אז'ור:
  • Azure SQL Public Preview updates for mid-November 2022
  • Azure SQL General Purpose updates for mid-November 2022
  • Azure SQL Managed Instance Public Preview Feature Wave updates for November 2022
  • Azure SQL Managed Instance General Availability Feature Wave for November 2022
  • Public preview: License Geo-redundant Disaster Recovery for SQL Managed Instance for free
  • General availability: DR secondary free with SQL Server on Azure Virtual Machines
  • New Azure Virtual Machines and SQL Managed Instance DR Licensing Benefits - Microsoft SQL Server Blog
• Named WINDOW definition clause (Transact-SQL)
• Strategies for Data Archival in SQL Server at Scale by Aaron Bertrand
  • Part 1 - Data Archival Strategies in SQL Server
  • Part 2 - Data Archival in SQL Server using Partitioning and Archive Tables
  • Part 3 - Automate Table Creation for Data Archival in SQL Server
• Archiving Format Considerations
  • Parquet compression ratios
  • Clustered Columnstore compression ratios
• The Itzik Ben-Gan trick for Batch Mode on Rowstore