Generating a SQL Server, SSAS, SSIS, SSRS, SQL Agent Memory Dump via PowerShell script (and SQLDumper.exe)

Recently, we published a PowerShell script to create memory dumps of SQL Server, SSAS, SSRS, and SSIS – called it SQLDumpHelper.ps1 . The PS script uses SQLDumper.exe and it makes it very easy to generate the dumps by avoiding having to look up SQLDumper.exe command switches. (Update Dec 2018) Update the script to support a…


Azure IoT Hub Toolkit for Visual Studio Code generally available for managing Azure IoT Hub and Devices with ease

Last year, we release the preview version of Azure IoT Hub Toolkit extension for Visual Studio Code. With our continuous development, the Azure IoT Hub Toolkit has a rich set of features to help IoT developers manage and develop Azure IoT Hub in Visual Studio Code. Now the Azure IoT Hub Hub Toolkit is generally available…


An internal error happened while generating a new DBTS for database ‘Db1’

Recently I worked on an issue that encountered this error and I had to research the source code to figure it out. Msg 42029, Level 16, State 1, Line 3 An internal error happened while generating a new DBTS for database “Db1”. Please retry the operation This error has to do with the Database Timestamp…


Azure Data Architecture Guide – Blog #1: Introduction

I’m proud to introduce you to the recent Azure Data Architecture Guide! This guide acts as a menu or syllabus for data professionals to select their data services and technologies. Find the blog posts in this series here: Azure Data Architecture Guide – Blog #1: Introduction – This one Azure Data Architecture Guide – Blog #2:…


Best Practices: Important and critical headers for EWS

It’s important to set several headers in your code help assure calls will work and to provide information to be used in diagnosing issues. As an example, some calls wither won’t work or may only work against some servers if you don’t set the X-AnchorMailbox header. If there is a need to review your application’s…


Time zone and DST changes in Windows for Morocco and the West Bank and Gaza

As it has in previous years, Morocco is suspending its daylight saving time (DST) period for the observation of the Muslim month of Ramadan from 03:00 on Sunday, May 13, 2018, to 02:00 on Sunday, June 17, 2018, in the Gregorian calendar. Updates are also available for the West Bank and Gaza, as users can revert to “(UTC+02:00) Gaza,…


Azure Functions で SQL Data Warehouse の価格レベルを変更する

今回の投稿は、Azure Functions で SQL Data Warehouse の価格レベルを変更する方法です。 SQL Data Warehouse の価格レベルは、Azure Portal、PowerShell、T-SQL 、REST API などいくつかの変更方法があります。 今回は、Azure Functions から REST API を使用して、SQL Data Warehouse の価格レベルをスケジュール変更する方法をご紹介します。 ※ Azure Functions はサーバーレスでアプリケーションを構築するための Azure の SaaS サービスです。   ■ テンプレートから作成できます! Function App を1から作るのは大変だなぁ・・・と思う方も大丈夫です! 価格レベルをスケジュール変更するための Function App 向けのテンプレートがあります。   タイトル : Azure SQL Data Warehouse で Azure Functions を使用してコンピューティング リソースを管理します。 アドレス…


AzureCAT Whitepaper: High-performance computing on Microsoft Azure: GlusterFS

Download the whitepaper: High-performance computing on Microsoft Azure: GlusterFS This guide is an introduction to creating an Azure HPC cluster and HPC storage. Getting started with high-performance computing (HPC) on Azure doesn’t have to be confusing. This article and the resources in the accompanying GitHub repository were designed by the Azure Customer Advisory Team (AzureCAT)…