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

15

Feb

Microsoft updates Cognitive Services terms
Microsoft updates Cognitive Services terms

This post was authored by the Microsoft Cognitive Services Team.

We understand that the commitments we make about data are essential for any organization. To give customers more control, we’ve updated our Cognitive Services terms for customer data. Here’s what this means for our customers.

On February 1, we started moving Cognitive Services under the same terms as other Azure services. Under the new terms, Cognitive Services customers own, and can manage and delete their customer data. With this change, many Cognitive Services are now aligned with the same terms that apply to other Azure services.

Terms for Computer Vision, Face, Content Moderator, Text Analytics, and Speech services have already changed, with updates coming to Language Understanding on March 1 and Microsoft Translator on May 1. As new products are added to Cognitive Services, they will align with the same standards as other Azure services, with the exception of Bing Search Services.

Bing Search Services data will continue to be treated differently than other customer data. For example, we use search queries that you provide to Bing Search Services to improve our search algorithms over time.

We are making these updates because we strive to be transparent in our privacy

Share

15

Feb

The February release of SQL Operations Studio is now available
The February release of SQL Operations Studio is now available

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

We are excited to announce the February release of SQL Operations Studio is now available.

Download SQL Operations Studio and review the Release Notes to get started.

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:

Added Auto-Update Installation feature Added Connection Dialog ‘Database’ Drop-down Added functionality for new query tabs keeping active connection Fixed bugs in SQL Editor and auto-completion

For complete updates, refer to the Release Notes.

Auto-Update Installation

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).

To discover updates faster,

Share

15

Feb

Sync SQL data in large scale using Azure SQL Data Sync
Sync SQL data in large scale using Azure SQL Data Sync

This post is authored by Xiaochen Wu, Program Manager, SQL Server.  

Azure SQL Data Sync allows users to synchronize data between Azure SQL Databases and SQL Server databases in one-direction or bi-direction. This feature was first introduced in 2012. By that time, people didn’t host a lot of large databases in Azure. Some size limitations were applied when we built the data sync service, including up to 30 databases (five on-premises SQL Server databases) in a single sync group, and up to 500 tables in any database in a sync group.

Today, there are more than two million Azure SQL Databases and the maximum database size is 4TB. But those limitations of data sync are still there. It is mainly because that syncing data is a size of data operation. Without an architectural change, we can’t ensure the service can sustain the heavy load when syncing in a large scale. We are working on some improvements in this area. Some of these limitations will be raised or removed in the future. In this article, we are going to show you how to use data sync to sync data between large number of databases and tables, including some best practices and how to

Share

15

Feb

Announcing the Visual Studio Team Services (VSTS) Solution Template

https://powerbi.microsoft.com/en-us/blog/announcing-visual-studio-team-services-vsts-solution-template/Source: https://powerbi.microsoft.com/en-us/blog/announcing-visual-studio-team-services-vsts-solution-template/           Announcing Visual Studio Team Services (VSTS) Solution Template Blue Margin, Inc., Microsoft Gold Partner in Data Analytics and Data Platform just released a VSTS solution template to provide project…

Share