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

Lesson Learned #2: Do you need SQL Server Agent for Azure SQL DB?

Many questions came to us, about SQL Server Agent for Azure SQL DB. Unfortunately, we don’t have the SQL Agent service in the same way that you have in OnPremise, but we have a multiple solutions for it: If you are able to maintain the SQL Agent, you could create a linked server against to…


Lesson Learned #1: Capturing a TSQL Command Timeout

In many support cases that we worked our customer needs to know that is the query that caused a Command Timeout issue. In this example below, you could find out the extended event that we share to our customers in order to capture it.   CREATE EVENT SESSION ssEventoTimeout ON DATABASE ADD EVENT sqlserver.sql_batch_completed ( ACTION …


How to move Azure SQL server to another subscription

This post is about what we DO NOT want you to do and how to do it right. if you want to move Azure SQL server from one subscription to another do not delete it assuming you will be able to create the server in the other subscription. this will not work for you (read why…