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

20

Feb

Sessions for Data & BI Summit now available
Sessions for Data & BI Summit now available

https://powerbi.microsoft.com/en-us/blog/sessions-for-data-bi-summit-now-available/Source: https://powerbi.microsoft.com/en-us/blog/sessions-for-data-bi-summit-now-available/           Data & BI Summit, held in Dublin, Ireland 24-26 April is quickly approaching – plan your schedule today, sessions details are now available.

Share

20

Feb

Announcing the Power BI Usage Metrics Solution Template
Announcing the Power BI Usage Metrics Solution Template

https://powerbi.microsoft.com/en-us/blog/announcing-the-power-bi-usage-metrics-solution-template/Source: https://powerbi.microsoft.com/en-us/blog/announcing-the-power-bi-usage-metrics-solution-template/           Today, we want to highlight one of the newest solution templates available on AppSource, the new Power BI Usage Metrics Solution Template, built by our partner Neal Analytics.

Share

20

Feb

Migrating to Azure SQL Database with zero downtime for read-only workloads

Special thanks to MSAsset engineering team’s Peter Liu (Senior Software Engineer), Vijay Kannan (Software Engineer), Sathya Muhandiramalage (Senior Software Engineer), Bryan Castillo (Principal Software Engineer) and Shail Batra (Principal Software Engineering Manager) for sharing their migration story with the Azure SQL Database product team.

Microsoft uses an internally written service called MSAsset to manage all Microsoft data center hardware around the world. MSAsset is used for tracking Microsoft’s servers, switches, storage devices, and cables across the company and requires 24/7 availability to accommodate break-fix requirements.

Before migrating to Azure SQL Database last year, MSAsset’s data tier consisted of a 107 GB database with 245 tables on SQL Server. The database was part of a SQL Server Always On Availability Group topology used for high availability and the scaling out of read-activity.

The MSAsset engineering team faced the following issues:

Aging hardware was not keeping up with stability and scale requirements. There was an increase in high severity data-tier incidents and no database administrator on staff to help with troubleshooting, mitigation, root cause analysis and ongoing maintenance. MSAsset’s database ran on SQL Server 2012. Developers and internal customers were increasingly requesting access to new SQL Server functionality.

After exploring various options

Share

20

Feb

Spring Security Azure AD: Wire up enterprise grade authentication and authorization

We are pleased to announce that Azure Active Directory (Azure AD) is integrated with Spring Security to secure your Java web applications. With only few lines of configurations, you can wire up enterprise grade authentication and authorization for your Spring Boot project.

With Spring Boot Starter for Azure AD, Java developers now can get started quickly to build the authentication workflow for a web application that uses Azure AD and OAuth 2.0 to secure its back end. It also enables developers to create a role based authorization workflow for a Web API secured by Azure AD with the power of the Spring Security.

Getting Started

Take the To-do App, which Erich Gamma showed on SpringOne 2017, as an example. The sample is composed of two layers: Angular JS client and Spring Boot RESTful web service. It illustrates the flow to login and retrieves user’s information using AAD Graph API.

Authorization Flow Chart

The authorization flow is composed of 3 phrases:

Login with credentials and get validated through Azure AD. Retrieve token and membership information from Azure AD Graph API. Evaluate the membership for role-based authorization.

Register a new application in Azure AD

To get started, first register a new

Share

20

Feb

Cray in Azure for weather forecasting

When we announced our partnership with Cray, it was very exciting news. I received my undergraduate degree in meteorology, so my mind immediately went to how this could be a benefit to weather forecasting.

Weather modeling is an interesting use case. It requires a large number of cores with a low-latency interconnect, and it is very time sensitive. After all, what good is a one hour weather forecast if it takes 90 minutes to run? And weather is a very local phenomenon. In order to resolve smaller scale features without shrinking the domain or lengthening runtime, modelers must add more cores. A global weather model with a 0.5 degree grid spacing can require as many as 50,000 cores.

At that large of a scale, and with the performance required to be operationally useful, a Cray supercomputer is an excellent fit. But the model by itself doesn’t mean much. The model data needs to be processed to generate products. This is where Azure services come in.

Website images are one obvious product of weather models. Image generation programs require small scale and can be done in parallel, so they’re great for using the elasticity of Azure virtual machines. The same can

Share

19

Feb

More Showplan enhancements – Row Goal
More Showplan enhancements – Row Goal

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

Share

19

Feb

Last week in Azure: Azure SDK for Go GA, and more
Last week in Azure: Azure SDK for Go GA, and more

On Wednesday, Microsoft CVP, Charlotte Yarkoni announced Microsoft for Startups, a new program that delivers access to technology, go-to-market and community benefits that helps startups grow their customer and revenue base. Of note, the program provides startups with up to $120,000 in free Azure credits, enterprise grade technical support and development tools – supporting the languages of their choice, such as Node.js, Java and .NET.

The Go gopher has cause to celebrate as the Azure SDK for Go became generally available, including an Azure for Go developers documentation hub that brings together quickstarts, code samples, and API reference to manage and interact with Azure services from your Go applications.

Now in preview

Preview of Log Alerts feature for Application Insights – You can now create alerts that automatically run log queries at regular intervals from Azure Log Analytics and Application Insights. If the results of the log query match particular criteria, it will create an alert record and automatically run one or more actions to proactively notify you of the alert, or invoke another process, such as running runbooks using Action Groups.

Microsoft Azure Data Lake Storage in Storage Explorer – public preview – With the release of Azure Data

Share