Key takeaways from the ebook "Migrating SQL Server to Azure SQL Database Managed Instance"

The ebook "Migrating  SQL Server to  Azure SQL Database Managed Instance" [PDF] provides a quick summary of Azure SQL Database Managed Instance features & steps to migrate to it.

Key points from the ebook -

Data Migration Assistant reviews the target migration environment and surfaces new features that will benefit your data post-migration. It checks for database compatibility and feature parity

The Azure Database Migration Guide can help you plan your migrations  and provide information about migration tools that are available. Input your source and target platform choices into the guide, and it will create a customized playbook to suit your individual scenario

Azure Database Migration Service is a fully managed migration service designed to enable seamless migrations from multiple database sources to Azure data platforms with minimal downtime


Figure 2: How Azure Database Migration Service works

Restore of system databases is not supported. To migrate instance-level objects (stored in master or msdb databases), Microsoft recommends that you script them out and run T-SQL scripts on the destination instance.

Native RESTORE from URL is an alternative to using Database Migration Service for migration  to Azure SQL Database Managed Instance.

Azure SQL Database Managed Instance performs backups for you automatically. You can restore to any point in time within the retention period using Point in Time Restore (PITR).

Database Migration Service does not yet support migrating SQL Server Integration Services (SSIS), SQL Server Analysis Services, or SQL Server Reporting Services (SSRS) components from SQL Server on-premises environments.

For migrating SSIS, you can provision Azure-SSIS integration runtime (IR) in Azure Data Factory.

For SQL Server Analysis Services, you can migrate to Azure Analysis Services.

SSRS currently has no cloud-based equivalent, but you can rewrite reports by using Microsoft Power BI or migrate reports to SSRS on an Azure virtual machine.

Azure SQL Database Managed Instance offers the following security features -
- Encryption for data in motion via Transport Layer Security, which also provides protection for sensitive data in flight, at rest, and during query processing via Always Encrypted.
- Dynamic Data Masking to limit exposure to sensitive data by masking it from non-privileged users and helping to prevent unauthorized access to it.
- Row-Level  Security (RLS) helps you to control access to rows in a database table based  on the characteristics of the user executing a query. 
- Azure SQL Database Threat Detection detects anomalous activities, flagging unusual or potentially harmful breaches.
- Database-level authentication via Azure Active Directory to centrally manage database users and simplify permission management.
- Monitoring of database activities via auditing and threat detection

Comments

Post a Comment

Popular posts from this blog

Maven Crash Course - Learn Power Query, Power Pivot & DAX in 15 Minutes

Image
In the Maven Crash Course " Learn Power Query, Power Pivot & DAX in 15 Minutes ", Chris Dutton walks through a hypothetical business case while showcasing the power of modern Excel tools like Power Query, Power Pivot and DAX. Power Query is used to extract, transform, and load data from external sources like SQL databases, PDF and CSV files. A relational model is created to join the tables without writing a single formula. Exploratory analysis is done using Power Pivot and Data Analysis Expressions (DAX). Data Analysis Expressions is the language that we can use to define new calculated columns and measures to enhance our Data Model instead of the traditional cell formulas that we'd typically use if our data was stored in worksheets. Pivot Charts and slicers are used to design a simple interactive report that the sales managers can use to analyze revenue trends and product performance.
Read more

"Data Prep & Exploratory Data Analysis" course by Maven Analytics

Image
The Maven Analytics course on " Data Prep & Exploratory Data Analysis " by Alice Zhao is a beginner-friendly introduction to machine learning with Python. It covers the key steps of the data science workflow, including: Gathering Data Scoping a Project Modeling Data Sharing Insights Cleaning Data Exploring Data Modeling Data  Sharing Insights The presentation deck which is available as a download crisply summarizes the essential details and is a great reference to keep going back to. The course is well-suited for aspiring data scientists looking to get hands-on experience with the data prep and EDA stages of the machine learning workflow using Python and Jupyter Notebook. 
Read more

Oracle Cloud Infrastructure 2024 Generative AI Professional Course & Certification Exam (1Z0-1127-24)

Image
I was happy to learn about the Oracle Cloud Infrastructure 2024 Generative AI Professional Course with video tutorials and the Certification Exam (1Z0-1127-24) from their newsletter. I found it extremely useful, timely, and relevant. The course, with about 6 hours of videos, provided me with a comprehensive view of what it takes to build a Generative AI application. Although some parts reference OCI services, much of the course remains vendor neutral. Rohit Rahi and his team at Oracle have done a great job of structuring the beginner-friendly yet comprehensive course so well, covering all the essentials across four modules. The curriculum strikes an excellent balance between depth and accessibility.  While Gen AI output is typically non-deterministic, I was surprised to learn that they can be made completely deterministic under certain conditions. Specifically, in the OCI Gen AI service, setting the temperature parameter to 0 produces consistent, deterministic output for a g...
Read more