Sites Microsoft


Azure Key Vault Integration for Azure SQL Server VMs

Publié le 3 novembre 2015 sur sql server security blog
 

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 for key protection. If you are planning on …

OPENJSON – one of best ways to select rows by list of ids

Publié le 3 novembre 2015 sur Microsoft SQL Server database engine blog
 

Selecting table rows by id in SQL Server In this post I will talk about different way to select rows from the table by list of ids. I will compare performance of some common approaches (IN, LIKE, and OPENJSON). Problem Let’s talk about simple and commo …

SSMS Encryption Wizard – Enabling Always Encrypted in a Few Easy Steps

Publié le 1 novembre 2015 sur sql server security blog
 

As we explained in the previous articles, Always Encrypted is a client-side encryption technology – the database system (SQL Server or Azure SQL Database) does not have access to plaintext encryption keys and cannot encrypt or decrypt data protect …

Dynamic Data Masking is now generally available for Azure SQL Database

Publié le 31 octobre 2015 sur sql server security blog
 

  We’re delighted to announce the general availability of Dynamic Data Masking for Azure SQL Database version V12. Dynamic Data Masking (DDM) is used to limit access to sensitive data in the database by obfuscating it on-the-fly in query res …

SSMS Encryption Wizard – Enabling Always Encrypted in a Few Easy Steps

Publié le 31 octobre 2015 sur sql server security blog
 

As we explained in the previous articles, Always Encrypted is a client-side encryption technology – the database system (SQL Server or Azure SQL Database) does not have access to plaintext encryption keys and cannot encrypt or decrypt data p …

Oil & Gas Security Demo with SQL Server 2016

Publié le 30 octobre 2015 sur sql server security blog
 

At our security session today at PASS Summit 2015, we were extremely fortunate to be joined by Jamey Johnston, a Data Scientist at a large independent Oil & Gas company, who shared a comprehensive demo using Row-Level Security, Dynamic Data Masking …

Samples for SQL Server 2016 CTP3

Publié le 29 octobre 2015 sur Microsoft SQL Server database engine blog
 

CTP3 of SQL Server 2016 was just announced, and is available for download. To accompany CTP3, we also created an updated version of AdventureWorks, called AdventureWorks2016CTP3, and we created a number of samples to showcase some of the new functional …

Microsoft Business Intelligence – our reporting roadmap

Publié le 29 octobre 2015 sur sql server team blog
 

For eight consecutive years, Microsoft has been positioned as a Leader in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms. And while each year has seen advances across our product line, this past year’s progress is tr …

New Enhancements in Always Encrypted

Publié le 28 octobre 2015 sur sql server security blog
 

The new version of SQL Server Management Studio (October 2015 Preview – build 13.0.700.242) and .NET Framework 4.6.1 RC bring several exciting enhancements to Always Encrypted. In the next few articles, we will cover these enhancements in details …

SQL Server 2016: Everything built-in

Publié le 28 octobre 2015 sur sql server team blog
 

This post was authored by Joseph Sirosh, Corporate Vice President of the Data Group at Microsoft.   Announcing SQL Server 2016 CTP 3.0, Azure Data Lake preview and much more. We live in the age of data, and the ability to extract actionable intell …

SQL Server 2016 Community Technology Preview 3.0 is available

Publié le 28 octobre 2015 sur sql server team blog
 

The SQL Server engineering team is pleased to announce the availability of SQL Server 2016 October public preview release CTP 3.0. The download will be available during the PASS Summit this week. This release is a key milestone for SQL Server 2016 with …

Announcing SQL Server Management Studio – October 2015 Release

Publié le 28 octobre 2015 sur microsoft sql server release services
 

Today, we are very pleased to announce the latest preview of SQL Server Management Studio (SSMS). This release includes all updates includes in the September release, and features a new modern installer, a new Always Encrypted column encryption wizard. …

Announcing SQL Server Management Studio – October 2015 Release

Publié le 28 octobre 2015 sur microsoft sql server release services
 

Today, we are very pleased to announce the latest preview of SQL Server Management Studio (SSMS). This release includes all updates includes in the September release, and features a new modern installer, a new Always Encrypted column encryption wizard, …

Reminder to Update Your SQL Server Connector

Publié le 27 octobre 2015 sur sql server security blog
 

If you are currently using the SQL Server Connector to interface with your Azure Key Vault, please make sure your version is updated to the latest Public Preview refresh version which was released in August. The previous version released in January wil …


Pages :