22

Feb

Get started with Azure Cosmos DB through this technical training series

Are you building a new application which requires low latency at any scale? Or are you in the process of migrating your NoSQL databases to the cloud? Or looking for the right resources to help you get started with Azure Cosmos DB?

Join us for one or all of a seven-week Azure Cosmos DB technical training series, which explores the capabilities and potential of Azure Cosmos DB. Whether you’re brand new to Azure Cosmos DB or an experienced user, you’ll leave this series with a better understanding of database technology and have the practical skills necessary to get started.

Azure Cosmos DB is the world’s first globally distributed, multi-model database service with native NoSQL support. Designed for the cloud, Azure Cosmos DB enables you to build planet-scale applications that bring data to where your users are with SLA-guaranteed low latency, throughput, and 99.99% availability.

In this training series, you’ll learn everything necessary to get your cloud database up and running. In the first session, we covered a technical overview of Azure Cosmos DB, and, in the following weeks, we’ll progress into deeper topics like migrating Mongo DB applications to Azure Cosmos DB, building serverless applications, and enabling real-time analytics with

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

21

Feb

Monitor network connectivity to applications with NPM’s Service Endpoint Monitor – public preview

As more and more enterprises are hosting their applications in cloud and are relying more on SaaS and PaaS applications to provide services, they are increasingly becoming dependent on multiple external applications and the networks in between. The traditional network monitoring tools work in silos and do not provide end-to-end visibility. Therefore, if an application is found to be running slow, it becomes difficult to identify whether the problem is because of your network, the service provider or the application. Network Performance Monitor (NPM) introduces Service Endpoint Monitor that integrates the monitoring and visualization of the performance of your internally hosted & cloud applications with the end-to-end network performance. You can create HTTP, HTTPS, TCP and ICMP based tests from key points in your network to your applications, allowing you to quickly identify whether the problem is due to the network or the application. With the network topology map, you can locate the links and interfaces experiencing high loss and latencies, helping you identify external & internal troublesome network segments.

Some of the capabilities of NPM’s Service Endpoint Monitor are listed below:

Monitor end-to-end connectivity to applications

Service Endpoint Monitor monitors total response time, network latency and packet loss between

21

Feb

Unlock Query Performance with SQL Data Warehouse using Graphical Execution Plans

The Graphical Execution Plan feature within SQL Server Management Studio (SSMS) is now supported for SQL Data Warehouse (SQL DW)! With a click of a button, you can create a graphical representation of a distributed query plan for SQL DW.

Before this enhancement, query troubleshooting for SQL DW was often a tedious process, which required you to run the EXPLAIN command. SQL DW customers can now seamlessly and visually debug query plans to identify performance bottlenecks directly within the SSMS window. This experience extends the query troubleshooting experience by displaying costly data movement operations which are the most common reasons for slow distributed query plans. Below is a simple example of troubleshooting a distributed query plan with SQL DW leveraging the Graphical Execution Plan.

The view below displays the estimated execution plan for a query. As we can see, this is an incompatible join which occurs when there is a join between two tables distributed on different columns. An incompatible join will create a ShuffleMove operation, where temp tables will be created on every distribution to satisfy the join locally before streaming the results back to the user. The ShuffleMove has become a performance bottleneck for this query:

Taking

21

Feb

New Azure GxP guidelines help pharmaceutical and biotech customers build GxP solutions

We recently released a detailed set of GxP qualification guidelines for our Azure customers. These guidelines give life sciences organizations, such as pharmaceutical and biotechnology companies, a comprehensive toolset for building solutions that meet GxP compliance regulations. 

GxP is a general abbreviation for “good practice” quality guidelines and regulations. Technology systems that use GxP processes such as Good Laboratory Practices (GLP), Good Clinical Practices (GCP), and Good Manufacturing Practices (GMP) require validation of adherence to GxP. Solutions are considered qualified when they can demonstrate the ability to fulfill GxP requirements. GxP regulations include pharmaceutical requirements, such as those outlined in the U.S. Food and Drug Administration CFR Title 21 Part 11, and EU GMP Annex 11.  

Life sciences organizations are increasingly moving to the cloud to increase efficiency and reduce costs, but in order to do so they must be able to select a cloud service provider with processes and controls that help to assure the confidentiality, integrity, and availability of data stored in the cloud. Of equal importance are those processes and controls that must be implemented by life sciences customers to ensure that GxP systems are maintained in a secured and validated state.

Life sciences organizations building GxP

21

Feb

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

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 temporarily work around database and table limitations.

Sync data

21

Feb

Introducing backup for Azure file shares

Today, we are excited to announce the public preview of backup for Azure file shares. Azure Files is a cloud-first file share solution with support for industry standard SMB protocol. Through this preview, Azure Backup enables a native backup solution for Azure file shares, a key addition to the feature arsenal to enable enterprise adoption of Azure Files. Using Azure Backup, via Recovery Services vault, to protect your file shares is a straightforward way to secure your files and be assured that you can go back in time instantly.

Key features Discover unprotected file shares: Utilize the Recovery Services vault to discover all unprotected storage accounts and file shares within them. Backup multiple files at a time: You can back up at scale by selecting multiple file shares in a storage account and apply a common policy over them. Schedule and forget: Apply a Backup policy to automatically schedule backups for your file shares. You can schedule backups at a time of your choice and specify the desired retention period. Azure Backup takes care of pruning these backups once they expire. Instant restore: Since Azure Backup utilizes file share snapshots, you can restore just the files you need instantly

20

Feb

2/21 Webinar: Be a Full Stack Power BI Jedi – A walkthrough of Power BI most advanced features through Star Wars data

https://powerbi.microsoft.com/en-us/blog/2-21-webinar-be-a-full-stack-power-bi-jedi-a-walkthrough-of-power-bi-most-advanced-features-through-star-wars-data/Source: https://powerbi.microsoft.com/en-us/blog/2-21-webinar-be-a-full-stack-power-bi-jedi-a-walkthrough-of-power-bi-most-advanced-features-through-star-wars-data/           Be a Full Stack Power BI Jedi – this week’s webinar walks through of Power BI most advanced features through Star Wars data with Power BI MVP, Gil Raviv.

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

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