How to Migrate Azure SQL Database to Azure SQL Managed Instance

The latest version of SQLPackage supports migration to Azure SQL Managed Instance (MI) from multiple SQL sources such as Azure SQL Database. Export: Following the below steps, you can export a SQL database using the SQLPackage command-line utility. If possible, use a workstation that has access to the Azure SQL Database and the MI to avoid having…

0

Lesson Learned #61: Using Schemas in Azure SQL Managed Instance

Hello Team, This week I worked on a service request where our customer asked about the compatibility feature using schemas and partitioning, for this reason and thanks to near 100% compatibility of SQL Server we have the option to create schemas and split tables among different filegroups. I would like to share with you the…


Lesson Learned #60: Using Partition Option in Azure SQL Managed Instance

Hello, Time ago, we discussed in this post about partitioning option in Azure SQL Database. One of the main differences creating this partition in Azure SQL Database is all partition will use the same filegroup. In Azure SQL Managed Instance we could create different filegroups and files for each partition having a better performance having multiple…


How to create a native PowerShell app registration to connect to Azure SQL DB

How to create a native app registration This guide assumes that you already own an Azure Subscription, an Azure Active Directory properly setup and your PowerShell environment properly set for running scripts.  You might want to refer to this article first: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/10/26/azure-sql-database-token-base-authentication-with-powershell/ Problem summary:  There might be a time when we you will want to…


Using Certificates in Azure SQL Database : Backup

In the previous article we manage to import into Azure SQL Database a certificate so we could improve the security of our system. But there can be situations where we need to backup the certificate to be used in another Azure SQL Database or for any other reason. So how can we backup an already…

0

Using Certificates in Azure SQL Database : Import

In these last days security is being a common topic on the news not for the best reasons and to help to avoid being the subject of one of those news I will share how to increase the security on our Azure SQL Databases. One way to increase the security on our Azure SQL Database…

0

Fix identities after migrating through SQL Replica

One of the most common migration procedures to SQL Azure is by configuring replication from your previous environment to your brand new SQL DB: https://msdn.microsoft.com/en-US/library/mt589530.aspx   This is a very nice migration process, as it allows original database to be available in Production until very few moments before SQL Database goes live. However, if your…

0

Does Azure SQL DB support automatic indexed views?

Are indexed views used automatically in SQL Azure without “WITH (NOEXPAND)”?How does it work?and How the query optimizer decides to use it or not ? The query optimizer uses indexed views to speed up the query execution. Which means SQL Server’s query optimizer realizes the precomputed sums of all the Quantity values for each value are…

0