Token-based authentication support for Azure SQL DB using Azure AD auth
First published on MSDN on Feb 09, 2016 SQL Server security team would like to announce token based authentication support for Azure SQL DB V12 authentication using Azure Active Directory (AD). Currently we support two authentication methods: Azure AD …
Row-Level Security block predicates are generally available on Azure SQL Database
First published on MSDN on Dec 01, 2015 Azure SQL Database’s Row-Level Security (RLS) feature now officially supports block predicates. In contrast to filter predicates, which limit the rows visible to a user, block predicates prevent a user from …
Using the Azure Key Vault Key Store Provider for Always Encrypted
First published on MSDN on Nov 10, 2015 During the SQL PASS Summit 2015, we released a custom key store provider that enables support for column master keys stored in Azure Key Vault to Nuget.org . As you may recall, an earlier blog post discusse …
Azure Key Vault Integration for Azure SQL Server VMs
First published on MSDN on Nov 03, 2015 Last week, the SQL VM team announced the Azure Key Vault Integration feature . The Azure Key Vault (AKV) Integration feature simplifies the process for setting up your Azure SQL Server VM to use Azure Key Vault f …
Azure SQL Database Transparent Data Encryption General Availability
First published on MSDN on Oct 14, 2015 I’m pleased to announce the general availability of Azure SQL Database Transparent Data Encryption to protect your data and help you meet compliance requirements by encrypting your database, associated backups, a …
New Row-Level Security functionality: Block predicates (preview)
First published on MSDN on Oct 02, 2015 Block predicates are now available as a preview enhancement for Row-Level Security (RLS) on Azure SQL Database. Block predicates address a common point of customer feedback, by enabling security policies to preve …
Examples of some connection errors for Azure Active Directory Authentication
First published on MSDN on Sep 28, 2015 Mirek Sztajno Last updated on 09/28/15 Examples of some connection errors for Azure Active Directory Authentication with Azure SQL DB V12 (*) Please note that this table does not represent a complete sample …
Creating Custom Key Store Providers for Always Encrypted (Azure Key Vault Example)
First published on MSDN on Sep 25, 2015 Updates: The syntax for column master keys have been updated. Please refer to http://blogs.msdn.com/b/sqlsecurity/archive/2015/10/28/new-enhancements-in-always-encrypted.aspx for details on what is new in Always …
Azure Active Directory Authentication – troubleshooting potential connectivity issues
First published on MSDN on Sep 16, 2015 To troubleshoot potential connectivity issues for Azure AD authentication feature available for public preview (see https://azure.microsoft.com/documentation/articles/sql-database-aad-authentication/ ), the « User …
Recommendations for using Cell Level Encryption in Azure SQL Database
First published on MSDN on May 12, 2015 Update: Fixed an error on the sample code. When we introduced Transparent Data Encryption (TDE) to Azure SQL Database, we also introduced Cell-Level Encryption (CLE, also known as SQL Server key hierarchy). For m …
How to: Scale out multi-tenant apps using RLS and Elastic Database Tools
First published on MSDN on May 07, 2015 In response to a common customer ask, we’ve published guidance for developing multi-tenant applications on Azure SQL Database using row-level security (RLS) for tenant isolation and elastic database tools (former …
Announcing Transparent Data Encryption for Azure SQL Database
First published on MSDN on Apr 29, 2015 Available today, SQL Database Transparent Data Encryption (preview) protects your data and helps you meet compliance requirements by encrypting your database, associated backups, and transaction log files at rest …
Updated MSDN Documentation for Azure SQL Database Row-Level Security
First published on MSDN on Jan 30, 2015 Row-Level Security Preview
Row-Level Security for Azure SQL Database
First published on MSDN on Jan 29, 2015 I’m so excited to announce that we are deploying Row-Level Security, a programmability feature to ease the writing of business security logic in the database, to Azure SQL Database. Coming to a region near you as …