AzureCAT – Technical Customer Profiles

Last Updated: 4/12/18 Over in this blog post, we mentioned why we’re named AzureCAT: CAT stands for “Customer Advisory Team.” We work with customers who act as feedback Advisors back to our product teams, by working on engagements with those customers and building ground-breaking solutions!   While we help customers architect those solutions, we learn…


PIX 1703.20.002 – NVIDIA GPU counters, file IO traces, shader edit & continue, and pixel cost visualizer

Today we released PIX 1703.20.002 beta.  New in this release: NVIDIA GPU counters File IO traces Shader edit & continue Pixel Cost visualizer Improved Warnings UI.  Where possible, warning hyperlinks now point to the GPU rather than CPU event list. Added an option to disable Capture GPU timings when taking timing captures.  Turning this off…


.NET Core 2.0 – How to publish a self-contained application

If you are new with .NET Core 2.0, please take a look at the post .NET Core 1.1 – Where to Start first.   I am assuming you already have an ASP.NET MVC application created and build. If you don’t have, please check the following post: NET Core 1.1 – Creating an ASP.NET Core using the…


Microsoft Drivers 4.1.7 Previews for PHP for SQL Server Released!

Hi all, we are delighted to share the Preview of the Microsoft Drivers 4.1.7 for PHP for SQL Server. The new driver enables access to SQL Server, Azure SQL Database and Azure SQL DW from any PHP 7+ application on Windows, Linux and Mac. The major highlights of this release are: Added Support for Mac…


SP2013/SP2016 – Switching tenant on a Cloud SSA : Onboarding

Hi Folks Starting a series of quick posts on the Cloud SSA so you could take full advantage of its capabilities and enrich your SPO Search experience. Today’s Problematic I came across the necessity to re-onboard a Cloud SSA on my SP2013 environment against a different tenant. There are few considerations when doing so. In this…


Check for const correctness with the C++ Core Guidelines Checker

This blog post was written by Sunny Chatterjee and Andrew Pardoe The C++ Core Guidelines focus on simple ways that you can improve the correctness and safety of your code. We introduced the C++ Core Guidelines Checkers to help automate enforcement of the C++ Core Guidelines in your code. One of the easiest and most…


Announcing general availability for MySQL in-app

MySQL in-app was a preview feature launched last year in August.  The feature primary objective was to make it easier to build and test MySQL based applications on App Service.  Today, I am excited to announce general availability of MySQL in-app feature. Note : This MySQL in-app is specific to Windows version of Azure app…


BW Queries by factors faster using FEMS-pushdown

Complex SAP BW queries often contain FEMS-filters. These filters used to be applied on the SAP application server, which was not very efficient. A new SQL statement generator in SAP BW implements an optimized algorithm for FEMS processing. We have seen performance improvements up-to factor 100. The actual performance improvement varies heavily for different BW…


Orleans 1.4 and 2.0 Tech Preview 2 for .NET Core released

Orleans 1.4.0 A few weeks ago we release Orleans 1.4.0 to NuGet.org, where the main new themes were: – Revamped JournaledGrain for event sourcing with support for geo-distributed log-based consistency providers. – Abstraction of Grain Services with fixed-placed per-silo application components with their workload partitioned via cluster consistency ring. – Support for heterogeneous silos with…


[Azure SQL Database] DTU使用率が100%になった時にやるべき事

    SQL Server/Microsoft Azure SQL Database サポート 田中 真人 皆さん、こんにちは。 Microsoft SQL Server/Microsoft Azure SQL Database サポートチーム です。 日ごろから、SQL Database をご愛顧頂き誠にありがとうございます。   今回は、日々のサポート業務において、比較的お問合せをいただく事象についてご紹介させていただきます。 SQL Database の DTU使用率が突然上がり、SQL Database に接続できない、クエリが失敗した、確認するとCPU使用率が100%に達していた。どのように対応すればよいか確認したい。というお問合せを頂く事があります。 この場合、CPU のリソース不足により要求が失敗している事が考えられるのですが、皆様はそのような経験はございますでしょうか。   リソース不足の原因は、一般的にその時実行されているクエリに原因があります。その為、CPUがリソース不足になった原因となっているクエリを特定し、クエリのチューニングを実施する事が一般的な対処法となります。 データI/Oにおける負荷も同様の事が言えます。   そこで今回は、SQL Database に負荷をかけているクエリの特定方法について紹介します。   SQL Database に負荷をかけているクエリは、クエリ ストアという機能を使用して特定する事ができます。 クエリ ストアのご利用方法につきまして、以下の順に記載致します。   +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1)クエリ ストア機能のご利用について 2)負荷をかけているクエリの特定方法 3)クエリ特定後の対応について ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1)クエリ ストア機能のご利用について…