Implementing GlusterFS on Azure (HPC Scalable Parallel File System)

Authored by Rakesh Patil (AzureCAT). Edited by Nanette Ray and RoAnn Corbisier. A whitepaper of this content is available on Azure.com: Implement GlusterFS on Azure Introduction Recently, AzureCAT worked with a customer to set up GlusterFS, a free, scalable, open source distributed file system that works great for applications hosted on Microsoft Azure. Like our…


Exported database from Azure SQL failed to be imported to Azure SQL or to local SQL Server

Update: (2018-01-30) – Resolved  DacFX version 17.4.1 has been released, this version contains the fix for all of the behaviors related to the master key. you can download it here to confirm you are using the correct version, verify that the file version of SQLPackage.exe is at least 14.0.3917.1 and follow the instructions here: using sqlpackage…


MIM WAL–Installation Guide Part 2

  This post is a continuation of  MIM WAL–Installation Guide Part 1 Navigate to the location where you have the MIM WAL Source Code Open the Folder “ReferencedAssemblies” In this Folder we want to copy the System.Management.Automation.dll file Once the file is copied into this folder Now open the folder “4.1.3496.0” Now copy the following…


MIM WAL–Installation Guide Part 1

Installation of the MIM WAL can sometimes be problematic especially if you are just getting started or even just an armature developer. The objective of this post is to: 1. ) Help in the collection of all files needed to compile the Workflow Activity Library 2.) Prepare solution to be compiled 3.) Install the Workflow…


DEA 2.0: How to Use Database Experimentation Assistant

The Database Experimentation Assistant (DEA) is a new A/B testing solution for changes in SQL Server environments (e.g. upgrade, new indexes, etc.). It assists in evaluating how the workload on your source server (current environment) will perform against your new environment. It guides you through performing an A/B test through three steps: capture, replay, and…


DEA 2.0 – Capture Trace FAQ

What are the events captured while running trace on a production database? The following table provides the list of events and the corresponding column data that we collect for the traces Event Name Columns Text Data (1) Binary Data (2) Database ID (3) Host Name (8) Application Name (10) Login Name (11) SPID (12) Start…