New 400GB and 200GB caches available on Azure Analysis Services

In April we announced the general availability of Azure Analysis Services, which evolved from the proven analytics engine in Microsoft SQL Server Analysis Services. The success of any modern data-driven organization requires that information is available at the fingertips of every business user, not just IT professionals and data scientists, to guide their day-to-day decisions. Self-service BI tools have made huge strides in making data accessible to business users. However, most business users don’t have the expertise or desire to do the heavy lifting that is typically required, including finding the right sources of data, importing the raw data, transforming it into the right shape, and adding business logic and metrics, before they can explore the data to derive insights. With Azure Analysis Services, a BI professional can create a semantic model over the raw data and share it with business users so that all they need to do is connect to the model from any BI tool and immediately explore the data and gain insights. Azure Analysis Services uses a highly optimized in-memory engine to provide responses to user queries at the speed of thought.

Today we are introducing two new SKU sizes, the S8 and S9 allowing you to build data models up to 400 GB in size.

The S8 offers up to 200 GB of cache with 320 QPUs, while the S9 offers up to 400 GB of cache and 640 QPUs. The cache sizes refer to the size of the memory to hold data in after it has been compressed. You do need to reserve some cache for processing and querying. A Query Processing Unit (QPU) in Azure Analysis Services is a unit of measure for relative computational performance for query and data processing. As a rule of thumb, one virtual core approximates to roughly 20 QPUs, although the exact performance depends on the underlying hardware and the generation of hardware used.

The new S8 and S9 SKUs are currently only available in the East US 2 and West Europe datacenters. To learn more about pricing for S8 and S9, please visit our pricing page.

New to Azure Analysis Services? Find out how you can try Azure Analysis Services or learn how to create your first data model.
Quelle: Azure

Microsoft and Cisco enable Azure IoT Suite to connect to Cisco Fog Deployments

As we announced recently, Microsoft thinks there is a natural balance between the cloud and the edge in IoT. Why? Cloud is a natural place to manage IoT devices, to collect data from them, gain insights using analytics and then operationalize those insights. Edge is a natural place to collect, optimize and react to data with low latency based on the insights generated in the cloud. In this way, cloud and edge work together to help IoT reach its full potential. 

Today Microsoft is participating in Cisco’s IoT World Forum in London where conversations like this are taking place and how to help customers gain intelligence from their data faster and more easily. 

Microsoft Azure recently announced support for edge intelligence with Azure IoT Edge, and we strongly believe in giving customers options in picking the right the edge technology to meet their needs. Today at Cisco’s IoT World Forum we announced we’re partnering with Cisco to make it possible for the Azure IoT Suite to connect to and interoperate with Cisco Fog deployments.

This will have the following benefits for our joint customers: 

Enabling them to build and host their IoT applications in Azure, while extending the power of those applications to the edge via Cisco’s Fog computing solutions
Bring intelligence and processing capabilities closer to where the data is originated so that critical decisions can be processed in real time
Help them optimize their IoT deployment costs by only sending the necessary information to the cloud, while processing the rest at the edge  

We believe IoT, Cloud and IoT Edge will continue to play a critical role in digital transformation. We’re excited to extend our work with Cisco and bring the Value of Microsoft’s IoT technologies and solutions to even more customers.   

– Sam
Quelle: Azure

Deploy Cognitive Toolkit model to Azure Web Apps

Azure offers several ways of deploying a deep-learning model including Windows Web App, Linux Web App, and Azure Container Services. For those less experienced with a Linux environment/containers, Windows Web Apps offers familiar territory. In this post we will deploy a ResNet-18 model to Azure Web Apps and then submit some test pictures to it using a sample HTML interface, and also via python.

Demo results

HTML interface

Python

The above screenshot is taken from this notebook. If you wish to run some speed-tests, this notebook on GitHub shows how to submit asyncrochonous requests to the created API to get an idea of how long it takes to classify images in bulk. In this example we get 0.86 seconds per image.

Replicate demo

1. Download the contents of the repo and open a Command Prompt in the folder.

2. Run the following commands to check you have git and azure-cli installed:

az –version # time-of-writing: 2.0.1
pip install azure-cli # otherwise install azure-cli
git –version # time of writing: 2.9.2.windows.1

3. Set your username and password for local git deployment. Please note, you only need to do this once. For example:

set uname=<username_for_local_git_deployment>
set pass=<password_for_local_git_deployment>
# Create a user-name and password for git deployment of all your apps
az appservice web deployment user set –user-name %uname% –password %pass%

4. Create your web-app by running the below commands:

# Name for your web-app
set appn=<app_name>
# Name for resource-group containing web-app
set rgname=<name_for_resource_group_that_contains_app>
# Login to azure
az login
# Create a resource-group
az group create –location westeurope –name %rgname%
# Create a paid 'S2' plan to support your app
# The standard paid plans are: S1, S2, S3
az appservice plan create –name %appn% –resource-group %rgname% –sku S2
# Create the web-app
az appservice web create –name %appn% –resource-group %rgname% –plan %appn%
# Configure for local git deployment (SAVE URL)
az appservice web source-control config-local-git –name %appn% –resource-group %rgname% –query url –output tsv
# Initialise your git repo
git init
# Add the azure endpoint
git remote add azure <PASTE_URL_FROM_ABOVE>
# e.g. git remote add azure https://ilia2ukdemo@wincntkdemo.scm.azurewebsites.net/wincntkdemo.git

5. We will now install Python. Navigate to your web-app on Azure Portal, scroll down to the "Extensions" blade and click select:

6. Then, click on "Add", locate "Python 3.5.3 x64", and add it. Please note, you must use this extension.

Make sure you get a notification that this has installed successfully.

7. (Optional) Under the "Application settings" blade set "Always On" to "On" to reduce the response time since your model will be kept loaded.

8. Deploy this demo by running:

git add -A
git commit -m "init"
git push azure master

If everything has gone successfully you should see the following line in the script output:

remote: Successfully installed cntk-2.0rc1
remote: ..
remote: 2.0rc1

You should now be able to navigate to your web-app address and upload a photo that will be classified according to the CNN: ResNet-18.

Advanced modifications (run your own)

You can include references to other modules (e.g. pandas or opencv) in your model.py file, however you must add the module to the "requirements.txt" file so that python installs the module. If the module needs to be built, you can download the pre-built wheel file to the wheels folder. Don't forget to add the wheel path to the "requirements.txt" file at the root of the directory. Note: Numpy, Scipy, and CNTK wheels are automatically installed inside the "deploy.cmd" script. To change this you can edit the deploy.cmd file to point to whichever numpy wheel you require.

Editing deploy.cmd – The install script automatically adds the binaries for CNTK v2.0 rc1. However, if you want to use Python 3.6 or CNTK v2.0 rc1+, alter the below in the "deploy.cmd" script:

:: VARIABLES
echo "ATTENTION"
echo "USER MUST CHECK/SET THESE VARIABLES:"
SET PYTHON_EXE=%SYSTEMDRIVE%homepython353x64python.exe
SET NUMPY_WHEEL=https://azurewebappcntk.blob.core.windows.net/wheels/numpy-1.12.1+mkl-cp35-cp35m-win_amd64.whl
SET SCIPY_WHEEL=https://azurewebappcntk.blob.core.windows.net/wheels/scipy-0.19.0-cp35-cp35m-win_amd64.whl
SET CNTK_WHEEL=https://azurewebappcntk.blob.core.windows.net/cntkrc/cntk-2.0rc1-cp35-cp35m-win_amd64.whl
SET CNTK_BIN=https://azurewebappcntk.blob.core.windows.net/cntkrc/cntk.zip

To create the 'cntk.zip' file you just need to extract the cntk/cntk folder (i.e. the folder that contains 'CNTK.exe' and DLLs; you can remove the python sub-folder which contains the wheels, if it exists) and then reference it with the %CTNK_BIN% environmental variable above.

You can also install a different python extension if you wish, however make sure to reference it properly (and also to get the Numpy, Scipy and CNTK Wheels for it). For example, the "Python 3.5.3 x64" extension is installed in the directory "D:homepython353x64", and thus the script references: SET PYTHON_EXE=%SYSTEMDRIVE%homepython353x64python.exe

Finally, alter the "model.py" script as desired in the folder "WebApp", along with the HTMl template, "index.html" in "templates" and then push your changes to the repo:

git add -A
git commit -m "modified some script"
git push azure master

Quelle: Azure

Sneak Peek – PowerShell in Azure Cloud Shell

At BUILD 2017, we announced the preview of Azure Cloud Shell, which supports the Bash shell. As showcased (at 9:35 min) by Corey Sanders, we are adding PowerShell support to Azure Cloud Shell, which gives you a choice of shell to get work done.

The PowerShell experience will provide the same benefits as the Bash shell in Azure Cloud Shell:

Get authenticated shell access to Azure from virtually anywhere.
Use common tools and programming languages in a shell that’s updated and maintained by Microsoft.
Persist your files across sessions in attached Azure File storage.

Additionally, the PowerShell experience will provide:

Azure namespace capability to let you easily discover and navigate all Azure resources.

Interaction with VMs to enable seamless management into the guest VMs.

Extensible model to import additional cmdlets and ability to run any executable.

Sign-up today to participate in a limited preview of PowerShell in Azure Cloud Shell.

PowerShell is already the default shell for Windows 10. Adding PowerShell to Cloud Shell ensures you’ll have access to the most common automation tool for managing Azure resources from virtually anywhere.

We look forward to sharing this awesome new PowerShell experience with you!
Quelle: Azure

Azure enables cutting edge Virtual Apps, Desktops and Workstations with NVIDIA GRID

Professional graphics users in every industry count on an immersive, photorealistic, responsive environment to imagine, design, and build everything from airplanes to animated films. Traditionally, these high-powered workstations were tethered to physical facilities and shared among professional users such as designers, architects, engineers, and researchers. But today’s enterprises find themselves operating in multiple geographies, with distributed teams needing to collaborate in real-time.

Hence, last year we released Azure’s first GPU offerings targeting high-end graphics applications. NV based instances are powered by the NVIDIA GRID virtualization platform and NVIDIA Tesla M60 GPUs that provide 2048 CUDA cores per GPU and 8GB of GDDR5 memory per GPU as well. These instances provide over 2x performance increase in graphics-accelerated applications as compared to the previous generations.

Targeting the high-end workstation user, you can run NVIDIA Quadro GPU optimized applications such as Dassault Systems CATIA or Siemens PLM per user directly on the NV instances without the need to deal with the complexity of licensing. Additionally, with up to 4 GPUs via NV24 you’re able to run up to 4 concurrent users utilizing these Quadro applications with features such as multiple displays, larger maximum resolutions and certified Quadro software features from hundreds of software vendors.

Furthermore, if your organization has a need to run Virtual Apps or Virtual Desktops using solutions like RDS, Citrix XenApp Essentials, VMware Horizon, or Workspot, you’re now able to run up to 25 concurrent RDSH users per GPU. Office workers and professionals who don’t require Quadro optimized applications, can finally enjoy virtual desktops with a high-quality user experience that's optimized for productivity applications. It's all the performance of a physical PC, where and when you need it. You can now dramatically lower IT operational expense and focus on managing the users instead of PCs.

 

NV6

NV12

NV24

Cores

6

12

24

GPU

1 x M60 GPU

2 x M60 GPUs

4 x M60 GPUs

Memory

56 GB

112 GB

224 GB

Disk

380 GB SSD

680 GB SSD

1.44 TB SSD

Network

Azure Network

Azure Network

Azure Network

Virtual Workstations

1

2

4

RDSH Virtual Apps and Virtual Desktops

25

50

100

“Because so many of today’s modern applications and operating systems require GPU acceleration, organizations are seeking greater flexibility in their deployment and cost options,” says John Fanelli, VP NVIDIA GRID. “With NVIDIA GRID software and NVIDIA Tesla M60s running on Azure, Microsoft is delivering the benefits of cloud-based RDSH virtual apps and desktops to enable broad-scale, graphics-accelerated virtualization in the cloud that meets the needs of any enterprise.”

These new updates will go a long way to making sure that you have the best infrastructure whether you’re running the most graphics demanding CAD application that require Quadro optimization or if you’re just running office productivity applications on the go.

Azure N-Series VMs are now generally available in multiple regions. To launch these VMs please visit the Azure Portal.

Quelle: Azure

Azure Analysis Services new modeling and tooling features

Following the announcement a few weeks ago that 1400 models are now in Azure Analysis Services, we haven’t stopped there! We are pleased to announce the following further features for 1400 models in Azure.

Shared M expressions are shown in the SSDT Tabular Model Explorer, and can be maintained using the Query Editor.
Data Management View (DMV) improvements.
Opening an file with the .MSDAX extension in SSDT enables DAX non-model related IntelliSense.

Shared M expressions

Shared M expressions are shown in the Tabular Model Explorer! By right clicking the Expressions node, you can edit the expressions in the Query Editor. This should seem familiar to Power BI Desktop users.

DMV improvements

DMVs expose information about server operations and server health, settings and model structure. They are used for server monitoring, model documentation and various other reasons.

DISCOVER_CALC_DEPENDENCY

M expression dependencies are included in DISCOVER_CALC_DEPENDENCY. The following query returns the output shown below. M expressions and structured data sources are included for 1400 models.

SELECT * FROM $System.DISCOVER_CALC_DEPENDENCY

WHERE OBJECT_TYPE = 'PARTITION' OR OBJECT_TYPE = 'M_EXPRESSION';

 

The output represents the same information that is shown by the Query Dependencies visual, which is now available in SSDT from the Query Editor. This visual should seem familiar to Power BI Desktop users.

MDSCHEMA_MEASUREGROUP_DIMENSIONS

This release provides a fix for MDSCHEMA_MEASUREGROUP_DIMENSIONS. This DMV is used by various client tools to show measure dimensionality. For example, the Explore feature in Excel Pivot Tables allows the user to cross-drill to dimensions related to the selected measures.

Prior to this release, some rows were missing in the output for 1200 models, which meant the Explore feature did not work correctly. This is now fixed for 1200 and 1400 models.

DAX file editing

Opening a file with the .MSDAX extension allows DAX editing with non-model related IntelliSense such as highlighting, statement completion and parameter info. As you can imagine, we intend to use this for interesting features to be released in the future!

Try it Now!

To get started, simply create a 1400 model in SSDT and deploy it to Azure Analysis Services! See this post on how to create your first model. Be sure to keep an eye on this blog to stay up to date on Azure Analysis Services.
Quelle: Azure

Use SaaS patterns to accelerate SaaS app development on SQL Database

We’re delighted to announce availability of a sample SaaS application and a series of management scripts and tutorials that demonstrate a range of SaaS-focused design and management patterns that can accelerate SaaS application development on SQL Database. These patterns extend the benefits of SQL Database, making it the most effective and easy-to-manage data platform for a wide range of data-intensive multi-tenant SaaS applications.

Database-per-tenant model gives tenant isolation

The discussion around patterns starts with the consideration of what data model to use. Multi-tenant applications have traditionally been implemented using a multi-tenant database. While multi-tenant databases remain effective for some applications, particularly where the amount of data stored per tenant is small, many SaaS applications benefit from the isolation inherent in using a database per tenant. The fully-managed nature of SQL Database and the use of elastic pools have made managing massive numbers of databases practical. Many ISVs are now running SaaS applications on SQL Database with tens of thousands of tenant databases in elastic pools. MYOB, a leading Australian accounting ISV, is managing over 130,000 tenant databases without breaking a sweat! A database-per-tenant model allows these customers to achieve levels of tenant isolation not possible with a multi-tenant database, with improvements in data security, privacy, performance management, extensibility, and more.

Learning from customer experience

By working closely with many of these customers, and learning from their experience, we have harvested a set of design and management patterns applicable to any business domain that simplify the adoption of a database-per-tenant approach and its use at scale. Based on these patterns, a sample SaaS application and a set of management scripts, backed by easy-to-follow tutorials, is now available, with all code on GitHub and the tutorials online.

You can install the sample application in less than 5 minutes and explore the patterns first-hand by playing with the app and looking at how it’s built using the Azure portal, SQL Server Management Studio, and Visual Studio. By studying the app and management scripts, and working through the tutorials, you can jump start your own SaaS app project.

The sample app is a simple event listing and ticketing SaaS app, where each venue has its own database with events, ticket prices, customers, and ticket sales, all securely isolated from other venues’ data. The app uses a canonical SaaS app architecture for the data layer. Each tenant is mapped to its database using a catalog database, which is used for lookup and connectivity. Other databases are installed to enable other scenarios as you explore the various tutorials.

SaaS scenarios explored

The app and management scripts address many common SaaS-related scenarios, including:

Tenant registration, including database provisioning and initialization, and catalog registration
Routing and connection from the app to the correct tenant database
Database performance monitoring, alerting and management, including cross-pool monitoring and alerting
Schema management, including deployment of schema changes and reference data to all tenant databases
Distributed query across all tenant databases, allowing ad hoc real-time query and analysis
Extract of tenant data into an analytics database or data warehouse
Restoring a single tenant database to a point in time

A load generator simulates unpredictable tenant activity, allowing you to explore resource management scenarios, including scaling pools to handle daily or weekly workload patterns, load-balancing pools, and managing large variations in individual tenant workloads. A ticket-generator allows you to explore analytics scenarios with significant amounts of data.

The app also benefits from other SQL Database features that are especially relevant in a database-per-tenant context, including automatic intelligent index tuning, that optimizes tenant database performance based on each tenant’s actual workload profile.

Integrated with other Azure Services for an end-to-end SaaS scenario

Several other Azure services are also showcased as part of the app, including App Services and Traffic Manager in the app layer, Log Analytics (OMS) for monitoring and alerting at scale, SQL Data Warehouse for cross-tenant analytics, and Azure Resource Management (ARM) templates for deployment.

The app will be extended over time to include more scenarios, from additional management patterns to deeper integration with other Azure services, including Power BI, Azure Machine Learning, Azure Search, and Active Directory, to build out a complete E2E SaaS scenario. We also want to explore the same scenarios with a multi-tenant database model in due course.

These SaaS patterns are also informing planning for future improvements to the SQL Database service.

Get started

Get started by installing the app with one click from GitHub, where you can download the code and management scripts.  Learn more about the patterns and explore the tutorials. Let us know at saasfeedback@microsoft.com what you think of the sample and the patterns, and what you’d like to see added next.
Quelle: Azure

We're all about the quality: Azure achieves ISO 9001:2015 certification

As part of our ongoing effort to deliver the broadest and deepest set of compliance offerings, Microsoft Azure is proud to announce that we obtained the ISO 9001:2015 certification, addressing Quality Management systems.

This international standard is based on seven quality management principles:

Customer focus
Leadership commitment to quality objectives
Employee engagement in the quality goals set by leadership
Process-driven approach to achieve quality objectives
Continuous Improvement
Evidence-based decision making
Customer and partner relationship management

ISO 9001:2015 provides guidance on implementing a quality management system focused on delivering quality products and maintaining a constant state of improvement to exceed customer expectations. This certification (our 5th in the ISO family of certifications) is in perfect alignment with our goal to enable customers by providing the leverage of our compliant and quality products across a broad range of regulated industries, markets, and regions.  Achieving this certification underscores our drive to provide the most quality product possible.

The ISO 9001:2015 certificate for Microsoft Azure can be downloaded from here . The certificate covers 52 services across the following offerings: Azure, Cloud App Security, Intune, PowerApps, Power BI, Flow, Genomics, Graph (detailed scope is listed on the certificate).

For more information on Microsoft Azure’s ISO 9001:2015 Certification and our vast compliance portfolio, please visit the Microsoft Trust Center.
Quelle: Azure

Price reductions on General Purpose Virtual Machines

We believe in providing the most innovative cloud offerings at incredibly competitive prices to our customers. As part of this promise, we regularly lower our prices as Azure continues to grow at scale and remain committed to our price match promise.

Last week, at the Microsoft //Build conference, we showcased great new Azure services and improvements. Today, we are pleased to follow up these announcements with additional price reductions that make Azure even more attractive. Specifically, we are lowering prices on previously-launched Dv2 Promo Virtual Machines to provide our customers with the cost savings of our upcoming hyper-threaded Dv3 VMs prior to their launch. 

Effective today, prices of Dv2 Promo VMs will be lower by up to 7% for Linux VMs and by up to 5% of Windows VMs. Below are the price reductions in a few representative regions. The complete set of new prices can be found on our VM pricing page.

Region

Linux

Windows

West US

-7.0%

-5.0%

East US

-7.0%

-5.0%

Canada Central

-6.5%

-4.0%

West Europe

-6.5%

-5.0%

North Europe

-6.5%

-4.0%

UK South

-7.0%

-4.0%

Southeast Asia

-6.0%

-4.5%

Japan East

-7.0%

-4.5%

Australia East

-7.0%

-5.0%

Central India

-6.5%

-4.0%

Korea Central

-7.0%

-4.0%

Brazil South

-7.0%

-5.0%

When we launch our next generation, Dv3 VMs in the next few months, they will be available at these new lower prices as well. For more information on Dv2 promotion and additional details on pricing, please visit the Azure VM pricing page.
Quelle: Azure

New smaller Windows Server IaaS Image

We continue to find ways to make Azure a better value for our customers. Azure Managed Disks, a new disk service launched in Feb '17, simplifies the management and scaling of Virtual Machines (VM). You can choose to create an empty Managed Disk, or create a Managed Disk from a VHD in a storage account, or from an Image as part of VM creation.

The pricing of Managed Disks, both Premium and Standard, is based on the provisioned disk size, which is different from the pricing of Standard Unmanaged Disks. To keep the cost lower, we created lower disk pricing options with smaller 32GB and 64GB Standard Managed Disk sizes. Building on that foundation, we have also added a second set of Windows Server offerings with 30GB OS disks for Windows Server 2008R2, Windows Server 2012, Windows Server 2012R2 and Windows Server 2016 in Azure Marketplace. These smaller images are prepended with  “[smalldisk]” in the image title on Azure Portal. For Powershell, CLI and ARM Templates, the image SKU is appended with "-smalldisk". If your application do not require large amount of OS disk space, you would observe savings of $2.18 per VM if you choose to deploy with 32GB Standard Managed OS disk vs. 127GB. For large scale deployments, the benefit would accumulate and may represent significant cost savings. 

You can also have the flexiblity to expand the OS disk by following the existing guide for expanding OS Disk:

How to expand the OS drive of a Virtual Machine in an Azure Resource Group

If you have expanded the OS Disk, log into your Windows VM and use Disk Management Tool to extend the OS partition to match the OS disk size.
Quelle: Azure