Microsoft Ignite Book of News

19 November,2021 by Tom Collins

Microsoft Ignite Book of News - reveals a ton of developments - SQL Server 2022

 

Some topics for database professionals covered in the latest release 

=>Azure Cosmos DB

=>Azure Database for MySQL

=>Azure Database for Postgres

=> Azure SQL Managed Instance 

=> Azure SQL Managed Instance - Link 

       -Connecting SQL Servers hosted anywhere to Azure SQL Managed Instance 

                       - Example: On-Prem R\W database data replication  to a Azure Cloud R\O Replica 

                                - How is the Instance Link managed?

                                - How is the data replication managed?

                                - Can internal applications access both Instances? 

                                - if the Internal application is SSO based on Internal Active Directory - what is the facility for extending Active Directory to Azure Cloud?

                                                          -> Use Azure AD to create an Active Directory domain in the cloud and connect to AD on-prem domain

                                                          ->Extend existing on-prem AD to Azure by deploying a VM in Azure that runs AD as a Domain Controller.

        -Enable Disaster Recovery and bi-directional migration

        - Azure Private Link

        -How to deal with a Unified Management ?

                            - i.e viewing on-premises & Azure databases . Does Azure Arc require SQL Servers to be deployed on Azure Arc managed databases or can it interface with other clusters?

        -Azure Arc - managing currency          

=> Windows Authentication in SQL Managed Instance

=> SQL Server 2022

               - SQL Server Ledger - bulletproof history of row.Ledger provides a chronicle of all changes made to the database over time.

               - Question: are the cryptographically hashed transactions stored outside of the database? 

               -Question: Is it an Azure only feature ?

          

                                             - 

=> Azure Arc

Click here to access the Microsoft Ignite Book of News

 

Read more on Azure 

Automatically Indexing Millions of Databases in Microsoft Azure SQL Database

Automatic Index Tuning by default on Azure sql server


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Microsoft Ignite Book of News


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer