Parameterization for Always Encrypted – Using SSMS to Insert into, Update and Filter by Encrypted Columns
First published on MSDN on Dec 13, 2016 SQL Server Management Studio 17.o (the next major update of SSMS, currently available as a Release Candidate) introduces two important capabilities for Always Encrypted: Ability to insert into, up …
Azure samples for Azure AD .Net WebApi using Azure AD « on-behalf of token » to connect to SQL DB and SQL DW
First published on MSDN on Nov 30, 2016 The C# code samples attached in the zip file below present a solution for the front-mid tier architecture allowing client applications to use individual Azure AD user credentials to connect to SQL DB/DW using mid …
Feature Spotlight: Transparent Data Encryption (TDE)
First published on MSDN on Oct 05, 2016 As more and more businesses go digital and towards the cloud, security is more important than ever. We’re not all security experts, but with the responsibility we assume as businesses to be entrusted with p …
SQL Server Connector support for private Azure clouds
First published on MSDN on Sep 14, 2016 Starting today, the SQL Server Connector also supports private Azure clouds. If you’re using a private Azure environment, such as Azure Government, Azure China, or Azure Germany, you can now use the SQL Server Co …
SQL Threat Detection – Your built-in security expert
First published on MSDN on Aug 08, 2016 Azure SQL Database Threat Detection has been in preview for a few months now . We’ve on-boarded many customers and received some great feedback. We would like to share a couple of customer experiences that …
Always Encrypted in Azure SQL Database is Generally Available
First published on MSDN on Jul 11, 2016 I’m happy to announce Always Encrypted in Azure SQL Database is now generally available! Always Encrypted is a feature designed to ensure sensitive data and its corresponding encryption keys are never reveal …
Developing Databases using Always Encrypted with SQL Server Data Tools
First published on MSDN on Jul 05, 2016 We are excited to announce that SQL Server Data Tools (SSDT) now supports developing databases using Always Encrypted . Always Encrypted is a feature in SQL Server 2016 and Azure SQL Database that ensures your se …
SQL Server Connector for Azure Key Vault is Generally Available
First published on MSDN on Jun 13, 2016 Starting today, the SQL Server Connector for Azure Key Vault is Generally Available! The SQL Server Connector is an Extensible Key Management (EKM) Provider that enables SQL Server to use Azure Key Vault as a pla …
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 …