20

Jul

Behavior Change for VSS Backups on VMs with Basic Availability Groups

https://blogs.msdn.microsoft.com/sql_server_team/behavior-change-for-vss-backups-on-vms-with-basic-availability-groups/Source: https://blogs.msdn.microsoft.com/sql_server_team/behavior-change-for-vss-backups-on-vms-with-basic-availability-groups/   This week we released SQL Server 2016 SP2 CU2 and SQL Server 2017 CU9. In this blog, I’d like to go into a little more detail on one of the fixes that is part of these CUs READ MORE

19

Jul

Tiger Team at Data Platform Summit 2018
Tiger Team at Data Platform Summit 2018

https://blogs.msdn.microsoft.com/sql_server_team/tiger-team-at-data-platform-summit-2018/Source: https://blogs.msdn.microsoft.com/sql_server_team/tiger-team-at-data-platform-summit-2018/   Tiger Team (@mssqltiger) represented by (Tejas Shah and Sourabh Agarwal) will be presenting about the recent investments in SQL Server at the Data Platform Summit (#DPS10), Asia’s Premier Data & Analytics Conference taking place on 9-11 August READ MORE

19

Jul

The July release of SQL Operations Studio is now available

We are excited to announce the July 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 June release is the eighth major update since the announcement. If you missed it, the June release announcement is available here.

Highlights for this release include the following.

SQL Server Agent preview extension Job configuration support SQL Server Profiler preview extension Improvements Combine Scripts Extension Wizard and Dialog Extensibility Social content Fix GitHub Issues

For complete updates, refer to the Release Notes.

SQL Server Agent configuration

As part of our story of bringing over SSMS features and improving user experience, we are excited to introduce SQL Agent configuration support.

Summary of changes include:

Added view of Alerts, Operators, and Proxies and icons on left pane Added dialogs for New Job, New Job Step, New Alert, and New Operator Added Delete Job, Delete

19

Jul

Score one for the IT Pro: Azure File Sync is now generally available!

Azure File Sync replicates files from your on-premises Windows Server to an Azure file share. With Azure File Sync, you don’t have to choose between the benefits of cloud and the benefits of your on-premises file server – you can have both! Azure File Sync enables you to centralize your file services in Azure while maintaining local access to your data.

Visit our product page to learn more about Azure File Sync.

We created Microsoft Azure Files with the goal of making it easy for you to reap the benefits of cloud storage. We know from decades of experience building Windows file server that file shares are useful for more than just application development; file shares are used for everything under the sun. With Azure Files, we are focused on building general purpose file shares that can replace all the file servers and NAS devices your organization has, and today, we are happy to share an important milestone on that journey: the general availability of Azure File Sync! 
 
Azure File Sync grew out of our conversations with thousands of customers about the challenge of balancing the need for local and fast access to their frequently accessed data with the

18

Jul

7/19/18 Webinar: Next Generation Location and Data Analysis using Mapbox and Power BI

https://powerbi.microsoft.com/en-us/blog/7-19-18-webinar-next-generation-location-and-data-analysis-using-mapbox-and-power-bi/Source: https://powerbi.microsoft.com/en-us/blog/7-19-18-webinar-next-generation-location-and-data-analysis-using-mapbox-and-power-bi/           Join Charles Sterling and Sam Gehret as they walk through how Mapbox and Power BI can use location data to tell your story using next generation maps.

18

Jul

Azure Marketplace June container offers
Azure Marketplace June container offers

We continue to expand the Azure Marketplace ecosystem. In June, 42 container offers from Bitnami successfully met the onboarding criteria and went live. See details of the new offers below:

ACME Solver Container Image: ACME Solver is part of the Cert Manager project. It will periodically ensure certificates are valid and up to date, and it will attempt to renew certificates at an appropriate time before expiration.

AlertManager Container Image: AlertManager handles alerts sent by client applications, such as the Prometheus server. It takes care of deduplicating, grouping, and routing them to the correct receiver integrations.

Apache Solr Container Image: Apache Solr is an extremely powerful, highly reliable open-source enterprise search platform built on Apache Lucene. It’s flexible, scalable, and designed to quickly add value after launch.

Blackbox Exporter Container Image: The Blackbox Exporter allows black-box probing of endpoints over HTTP, HTTPS, DNS, TCP, and ICMP. Bitnami container images are secure, up-to-date, and packaged using industry best practices.

Cassandra Container Image: Apache Cassandra is an open-source distributed database management system designed to handle large amounts of data across many servers, providing high availability with no single

18

Jul

Speech services July 2018 update
Speech services July 2018 update

A lot has happened since we announced that Speech services is now in preview, we have released the Cognitive Services Speech SDK June 2018 update.

Today, we are excited to announce that we have just released the 0.5.0 version of the Speech SDK. With this update, we have added support for UWP (on Windows version 1709), .NET Standard 2.0 (on Windows), and Java on Android 6.0 (Marshmallow, API level 23) or higher. We have made some feature changes and done some bug fixes. Most notably, we now support long-running audio and automatic reconnection. This will make the Speech service more resilient overall, in the event of timeout, network failures or service errors. We’ve also improved the error messages to make it easier to handle the errors. Please visit the Release Notes page for details. We will continue to add support for more platforms and programming languages, as we work toward making the Speech SDK generally available this fall.

Besides the Speech SDK, Custom Voice has also released a new feature to support more training data formats. All ‘.wav’ files (RIFF) with a sampling rates equal to or higher than 16khz are now accepted. Furthermore, we have extended support to more

18

Jul

Getting started with IoT: how to connect, secure, and manage your “things”

The Internet of Things (IoT) is one of the go-to solutions for executives looking for more and better insights about their business. Collectively, IoT is made up of a network of devices and sensors, otherwise known as things, which connect to a company’s network and the cloud by various means. These devices generate data about the organization and its operations, and stream it to data stores and apps where it can be analyzed and acted upon. The resulting insights enable organizations to take action in response to something that has already happened, or which is expected to.

But the value of the data an IoT solution generates depends largely on how effectively you deploy and manage the devices. In addition to their breadth of form factors (from an incredibly small footprint to the size of a manufacturing assembly line), devices also have numerous capabilities and can be controlled at a minute scale. Once installed, they’re designed to perform their jobs without having to be physically touched again. Some operating characteristics may include:

Automatic operation Limited power Limited connectivity Difficult to access Only accessible through the backend Susceptible to being tampered with by the public Managed by special protocols

To help

18

Jul

Foretell and prevent downtime with predictive maintenance
Foretell and prevent downtime with predictive maintenance

The story of predictive maintenance (PdM) starts back in the 1990s. Technologies began to arrive that sense the world in new ways: ultrasound, infrared, thermal, vibration, to name a few. However, until recently the technology has not been available to make predictive maintenance a reality. But now, with advances in cloud storage, machine learning, edge computing, and the Internet of Things — predictive maintenance looms as the next step for the manufacturing industry.

What is predictive maintenance?

There are three strategies for machine maintenance:

Reactive — the “don’t fix what isn’t broken” approach. This means you extract the maximum possible lifetime from a machine. However, costs balloon with unexpected downtime and collateral damage from failures. Preventative — service on a fixed schedule based on the regularity of previous failures. You maximize up-time by fixing machines before they fail. The downside is that components may have life left, and there is still a chance that they will fail before the scheduled maintenance. Predictive — where we use data about previous breakdowns to model when failures are about to occur, and intervene just as sensors detect the same conditions. Until recently this has not been a realistic option, as modeling did not

17

Jul

Intelligent Healthcare with Azure Bring Your Own Key (BYOK) technology

Sensitive health data processed by hospitals and insurers is under constant attack from malicious actors who try to gain access to health care systems with the goal to steal or extort personal health information. Change Healthcare has implemented a Bring Your Own Key (BYOK) solution based on Microsoft Azure Cloud services and introduces Intelligent Healthcare today.

Change Healthcare is enabling payers and providers to have immediate and granular control over their data by transferring the ownership of encryption keys used to encrypt data at rest. This allows Change Healthcare customers to make security changes without involvement by Change Healthcare personnel and have their cloud-based systems re-encrypted and operational without service interruptions. The BYOK management capabilities include revoking access to encryption keys and rotating or deleting encryption keys on demand and at the time of a potential compromise. 
 
For the Intelligent Healthcare solution, Change Healthcare implemented Azure SQL Database Transparent Data Encryption (TDE) with BYOK support. TDE with BYOK encrypts databases, log files and backups when written to disk, which protects data at rest from unauthorized access. TDE with BYOK support integrates with Azure Key Vault, which provides highly available and scalable secure storage for RSA cryptographic keys backed by