Lesson Learned #19: How to obtain the deadlocks of your Azure SQL Database?

In Azure SQL Database we have already running an Extended Event that captures the deadlocks without any additionally action for customer side. In this post we are going to learn how to obtain the deadlocks, how to obtain the deadlock graphic and how to reproduce a deadlock for testing.   How to obtain the deadlocks  …


Azure Relay Namespace Separation

We wanted to provide an update on this blog post about separating our namespaces. You may have noticed we didn’t include specific dates for Azure Relay namespace separation. This was done so we could focus first on Service Bus queues and topics and Event Hubs. Now we are ready to follow a similar process for…


Optimize delivery time with Ad Extension Scheduling

Using ad extension scheduling you can now optimize what time of the day your ad extensions are delivered and ensure that you get more value from your ads. More details on the feature are available in our recent announcement. This feature is available in both the Campaign and Bulk APIs. The changes in each service…


Lesson Learned #18: Database cannot be downgraded to a lower database tier.

Hello again, I worked on another very interesting service request when our customer received the message: “MODIFY FILE failed. Size is greater than MAXSIZE. Please query sys.database_files and use DBCC SHRINKFILE to reduce the file size first” trying to scale down the Azure database tier. This message happens when the database file size is greater…


ODBC Driver 13.1 for Linux Preview 2 Released

Hi all, we are delighted to share the second preview release of the Microsoft ODBC Driver 13.1 for Linux –  (Ubuntu, RedHat and SUSE). The preview release adds support for Ubuntu 16.10, new features, has bug fixes and enables access to SQL Server, Azure SQL Database and Azure SQL Data Warehouse from any C/C++ application on Linux. …


Figure Out the Line of Code When PowerShell Hang

When executing Powershell script, there could be slowness or hang issue. In order to solve this kind of problems, what can we do? Ideally, we can just add more log and run the script again to reproduce the problem. While, in some condition, the script is just running in production environment and the log is…


Visual Studio 2017 brings Docker Home

Visual Studio 2017 Release Candidate is out for quite a while and the engineering teams must be working very closely with Docker folks to bring containers native experience to Windows 10. In this blog posts, I’ve outlined simple steps to experience Docker support in Visual Studio 2017, Install Docker for Windows Run Visual Studio 2017…


161 articles from Azure CAT, patterns & practices, and SQL CAT

I’m happy to announce my work with Azure CAT (CAT stands for Customer Advisory Team), which is my team at Microsoft. We run customer engagements and feedback across product brands that include Azure, SQL Server, Power BI, BizTalk, Visual Studio, and more! In this article, I list out an initial 161 technical articles we’ve published,…


The test agent being used does not support the feature to execute tests by selecting Test Suite(s)

Scenario: You are trying to execute tests using the “Run Functional Tests” task, in a vNext build. Under Test Selection, you have chosen “Test Plan”, and have provided the plan and suite details, as indicated below.   However, the test execution fails with the below message: “The test agent being used does not support the…