The Cloud Database Administrator—Tech success at scale
As a database administrator (DBA), Ive always known what the role involved. Developers swing by my desk requesting a new database, a data refresh, or help with challenges theyre facing. They sometimes get frustrated with me when their database or data …
Always Encrypted with Secure Enclaves – Try It Now in SQL Server 2019 Preview!
First published on MSDN on Sep 24, 2018 Last year, we revealed our efforts to bring confidential computing capabilities of Always Encrypted to the next level , by leveraging secure enclave technologies. Over the last twelve months, the SQL team, alongs …
Azure SQL Vulnerability Assessment – now with PowerShell support!
First published on MSDN on Aug 02, 2018 You can now manage your SQL Vulnerability Assessments at scale using the new SQL VA PowerShell cmdlets. The cmdlets can be found in the Azure Resource Manager module, AzureRM 6.6.0, within the AzureRM.Sql package …
Getting Started with Always Encrypted using PowerShell
First published on MSDN on Jan 04, 2017 In the previous articles from the Always Encrypted blog series , we demonstrated how to configure Always Encrypted using SQL Server Management Studio. In this article, we will show you how to configure Always Enc …
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 …