Tags : #sqlserver

20

Mar

SSMS 17.6 is now available: Managed Instance and many bug fixes

This post is authored by Alan Yu, Program Manager, SQL Server.

Download SSMS 17.6 and review the Release Notes to get started.

SSMS 17.6 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.6 comes with several exciting new features:

Added more support for Azure SQL Database Managed Instance. Fixed a key performance issue in SMO where scripting tables on SQL Server 2016 took 30 seconds, but now take less than one second. Object Explorer: Added settings to allow users not to force brackets around names when dragging and dropping from Object Explorer to Query Window. Data Classification: Improvements and bug fixes.

SSMS 17.6 also includes key bug fixes to Always On, SMO, and Database mail, which can be found in the Release Notes.

Azure SQL Database Managed Instance

Azure SQL Database Managed Instance (preview) is a new flavor of Azure SQL Database, providing near 100 percent compatibility with SQL Server on-premises, a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for on-premises SQL Server customers.

Source from Managed Instance Documentation

Share

15

Mar

Complying with General Data Protection Regulation (GDPR) on Microsoft Data Platform technologies

This post is authored by Frederico Pravatta Rezende, Senior Product Marketing Manager, CADD & AI.

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

If your company does business in Europe, youll 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 its 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.

Microsoft is committed to the GDPR, and

Share

15

Mar

Complying with General Data Protection Regulation (GDPR) on Microsoft Data Platform technologies

This post is authored by Frederico Pravatta Rezende, Senior Product Marketing Manager, CADD & AI.

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.

Microsoft is committed to the GDPR, and

Share

06

Mar

February Cloud data and AI services training roundup
February Cloud data and AI services training roundup

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.

Industry-leading performance and security with SQL Server 2017
In this webinar, learn more about innovative SQL Server 2017 features that enhance your applications, analytics, and business intelligence (BI) workloads, including:

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

Share

24

Feb

SQL Server Replication Enhancement – Dynamic Reloading of Agent Profile Parameters

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

Share

21

Feb

Announcing a new update for mssql-cli: Special Commands

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

Share

20

Feb

https://blogs.msdn.microsoft.com/sqlsecurity/2018/02/20/introducing-sql-information-protection-for-azure-sql-database-and-on-premises-sql-server/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2018/02/20/introducing-sql-information-protection-for-azure-sql-database-and-on-premises-sql-server/   We are delighted to announce the public preview of SQL Information Protection (Data Discovery & Classification), introducing advanced capabilities built into Azure SQL Database for discovering, classifying, labeling & protecting the sensitive data in your databases. Similar capabilities READ MORE

Share

20

Feb

What’s new in SSMS 17.5: Data Discovery and Classification
What’s new in SSMS 17.5: Data Discovery and Classification

This post is authored by Alan Yu, Program Manager, SQL Server.

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.5!

Download SSMS 17.5 and review the Release Notes to get started.

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

Share

20

Feb

What’s new in SSMS 17.5: Data Discovery and Classification
What’s new in SSMS 17.5: Data Discovery and Classification

This post is authored by Alan Yu, Program Manager, SQL Server.

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.5!

Download SSMS 17.5 and review the Release Notes to get started.

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

Share

20

Feb

More Showplan enhancements – UDFs
More Showplan enhancements – UDFs

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

Share