Native database backup in Azure SQL Managed Instance

Azure SQL Managed Instance is a new fully managed PaaS offering in Azure cloud that will be publicly available in the near future. It will expose entire SQL Server Instance, support almost all features available in SQL Server 2017 and combine this with instant scaling and intelligence that is available in Azure PaaS service. Managed…


Enabling Confidential Computing with Always Encrypted using Enclaves (Early Access Preview)

Last week at Ignite, we announced a major SQL security investment that enhances Always Encrypted with secure enclave technologies to enable: Rich computations on encrypted columns, including pattern matching, range comparisons, and sorting, which unlocks Always Encrypted to a broad range applications and scenarios that require such computations to be performed inside the database system….


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…


Cloud SOLID Part II: Cloud Architecture and the Open/Closed Principle

Authored by Casey Watson (AzureCAT). Edited by RoAnn Corbisier. Reviewed by Jonathan Gardner (AzureCAT), Michiel van Otegem (AzureCAT), and Shawn Weisfeld (One Commercial Partner). This is the second article in the Cloud SOLID series. If you haven’t done so already, you may want to begin by reading the first article, Cloud SOLID Part I: Cloud…


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…


Migrating On premise SQL database to Azure SQL database using DMA v3.2

Hi all, This blog covers the steps to migrate the On premise SQL Server database to Azure SQL database using Database Migration Assistant v3.2 (DMA) tool.   Data Migration Assistant (DMA) tool provides 2 options: Assessment: To asses the on premise database and check for any compatibility issues while upgrading to target database platform. Migration: Actual migration of the schema and…


Early technical preview of JDBC 6.3.2 for SQL Server released!

We are excited to release a new early technical preview of the JDBC Driver for SQL Server.  Precompiled binaries are available on GitHub and also on Maven Central. Below is a summary of the new additions to the project, changes made, and issues fixed. Added Added new connection property: sslProtocol #422 Added “slow” tag to…


REST API Sample for exporting a database

While working on an Azure SQL Database support case, I needed to provide a REST API sample for exporting a database. I struggled a bit to get it to work, as the syntax is not really intuitive and requires creating an Azure AD application. To save you from the same struggle, here is the sample…


Visual Studio 2017 で Python 環境を構成し、SQL Server 、 Azure Data Services(Azure SQL Database 、 Cognitive Services 等 ) にアクセスしてみよう

Microsoft Japan Data Platform Tech Sales Team 清水 みなさん、こんにちは。以前の投稿では、 Visual Studio 2015 で Python 環境を構成しましたが、今回は、 Visual Studio 2017 で Python 環境を構成し、 SQL Server  、 Azure Data Services(Azure SQL Database 、 Cognitive Services 等 ) にアクセスする際の手順、ポイントをお伝えします。


Token-based authentication including Multi-factor auth (MFA) for Azure SQL DB using Azure Active Directory (AD)

SQL server security team presents an application solution for token-based authentication with multi-factor (MFA) support for SQL DB using Azure AD auth. The zip file attached below with the codes sample and a Readme doc present more details on this topic. For additional information see also Azure AD authentication extensions for Azure SQL DB and SQL DW tools. For further…