Is your organization prepared for the General Data Protection Regulation (GDPR)?

If your company does business in Europe, you’ll need to be aware of this new privacy law, which is set to bolster data protections for individuals living within the European Union (EU) starting on May 25, 2018.

The GDPR introduces several specific rights for EU residents, such as the right to access their personal data, correct inaccuracies in their data, erase data, object to the processing of their data, and to obtain a copy of their data. It aims to ensure that personal data is protected no matter where it’s sent, processed, or stored.

For your organization, this means taking a fresh look at how you control exposure to personal data, employ security mechanisms to protect personal data, detect and notify supervisory authorities of breaches within a timely manner, keep records of data-processing activities, and document risks and security measures.

The cost of non-compliance is high, reaching up to €20 million or 4 percent of the worldwide annual revenue of the prior fiscal year, whichever is higher.

06

Mar

Looking to transform your business by improving your on-premises environments, accelerating your move to the cloud, and gaining transformative insights from your data? Here’s your opportunity to learn from the experts and ask the questions that help your organization move forward.

Join us for one or all of these training sessions for a deep dive into a variety of topics, including products like SQL Server 2017, Azure SQL Database, and Azure Cosmos DB, along with Microsoft innovations in artificial intelligence, advanced analytics, and big data.

SQL Server 2017

It’s all about choice. Now, you have the flexibility of leveraging SQL Server 2017’s industry-leading performance and security wherever you like—whether that’s on Windows, Linux, or Docker containers. We’re hosting two training sessions this month to help you learn more about the many exciting features of SQL Server 2017.

Automated tuning features such as Adaptive Query Processing and Automatic Plan Correction for faster, more consistent performance. Advanced security features such as encryption at rest and in use, dynamic data masking, and row-level

24

Feb

https://blogs.msdn.microsoft.com/sql_server_team/sql-server-replication-enhancement-dynamic-reloading-of-agent-profile-parameters/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-replication-enhancement-dynamic-reloading-of-agent-profile-parameters/ With SQL Server 2017 Cumulative Update 3, we introduced an improvement to SQL Server Replication wherein, changes to the Replication agent parameters can be reloaded dynamically, without having to restart the agent. This improvement will be available READ MORE

21

Feb

https://blogs.technet.microsoft.com/dataplatforminsider/2018/02/21/announcing-a-new-update-for-mssql-cli-special-commands/Source: https://blogs.technet.microsoft.com/dataplatforminsider/2018/02/21/announcing-a-new-update-for-mssql-cli-special-commands/ This post is authored by Alan Yu, Program Manager, SQL Server. We have released our first major update for mssql-cli since our recent Public Preview announcement in December. You can view the public preview announcement here. READ MORE

SSMS 17.5 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available.

In addition to enhancements and bug fixes, SSMS 17.5 comes with several exciting new features:

Data Discovery and Classification is a new feature for discovering, classifying, labeling and reporting sensitive data in your databases. Query Editor now has support for a SkipsRows option for the Delimited Text External File Format for Azure SQL Data Warehouse. Showplan has enabled the display of estimated plan button for SQL Data Warehouse.

SSMS 17.5 also includes key bug fixes to Showplan, Query Editor, SMO, and Templates, which can be found in the Release Notes.

Data Discovery and Classification

SQL Data Discovery and Classification introduces a new tool built into SQL Server Management Studio (SSMS) for discovering, classifying, labeling and reporting the sensitive data in your databases.

Discovering and classifying your most sensitive data (business, financial, healthcare, PII, etc.) can play a pivotal role

SSMS 17.5 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available.

In addition to enhancements and bug fixes, SSMS 17.5 comes with several exciting new features:

Data Discovery and Classification is a new feature for discovering, classifying, labeling and reporting sensitive data in your databases. Query Editor now has support for a SkipsRows option for the Delimited Text External File Format for Azure SQL Data Warehouse. Showplan has enabled the display of estimated plan button for SQL Data Warehouse.

SSMS 17.5 also includes key bug fixes to Showplan, Query Editor, SMO, and Templates, which can be found in the Release Notes.

Data Discovery and Classification

SQL Data Discovery and Classification introduces a new tool built into SQL Server Management Studio (SSMS) for discovering, classifying, labeling and reporting the sensitive data in your databases.

Discovering and classifying your most sensitive data (business, financial, healthcare, PII, etc.) can play a pivotal role

20

Feb

https://blogs.msdn.microsoft.com/sql_server_team/more-showplan-enhancements-udfs/Source: https://blogs.msdn.microsoft.com/sql_server_team/more-showplan-enhancements-udfs/ As I mentioned on yesterday’s post, with the recent release of SQL Server 2017 CU3, we released yet more showplan enhancements: you can see other posts related to showplan enhancements here. In this article I’ll talk about READ MORE

19

Feb

https://blogs.msdn.microsoft.com/sql_server_team/more-showplan-enhancements-row-goal/Source: https://blogs.msdn.microsoft.com/sql_server_team/more-showplan-enhancements-row-goal/ As I shared before, we have been working for over a year to make showplan the one-stop-shop for query performance analysis and troubleshooting (as much as possible). With the recent release of SQL Server 2017 CU3, we READ MORE

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our GitHub.

SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this February release is the third major update since the announcement. If you missed it, the January release announcement is available here.

The February release includes several major repo updates and feature releases, including:

We want to use the February Insiders builds to test the auto-update feature. The 0.26.2 build will be released as an auto-update to 0.26.1 (assuming there are no issues that require publishing a new build to successfully support auto-update).