Enhance Power BI with DAX

Power BI (PBI) is a suite of business analytics tools that deliver insights throughout your organization. The ease of use and powerful features enable PBI to gain a great reception in the market since it was introduced in July 2015. You can find the latest releases, learning guide, detailed documentation as well as in-depth discussion…


Database as a Service (DaaS) Solution

Introduction “We would like to have the data flow to our clients like ‘water from the faucet” stated the customer for which this solution was designed. This on-premises (on-prem) SQL Server based application contains crucial financial data for the external clients of this customer. External clients using this solution subscribe to this data and there…


Report on your consolidated Assessments With PowerBI

In a previous post How to consolidate Assessment Reports we looked at a method to consolidate the JSON output files from the DmaCmd.exe command line tool into SQL Server. Now lets look at a method to put some basic reports on top of that data. For this we will use PowerBi which you can download…

3

How to consolidate Assessment Reports

Starting from Data Migration Assistant (DMA) v 2.1, DMA provides command-line support for running assessments in unattended mode.  This feature helps to run the assessments at scale.  The command-line version of DMA generates the assessment results in the form of a JSON or CSV file. You can assess multiple databases in a single instantiation of…

6

Released: Data Migration Assistant (DMA) v3.0

Overview The Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained…


Database Experimentation Assistant – Replay Trace

Replay trace allows you to replay a trace file (.trc) on another environment. For example, if a production workload is currently run out of SQL Server 2008 R2, the trace file for this workload would need to be replayed twice. Once on an environment with the same SQL Server as production, and secondly on an…

14

Data Migration Assistant: Configuration settings

Certain behavior of Data Migration Assistant (DMA) could be tweaked or fine tuned using configuration values from dma.exe.config file. Here are few key configuration values.  Note You can find the configuration file at  %ProgramFiles%\Microsoft Data Migration Assistant\dma.exe.config, if using DMA desktop application %ProgramFiles%\Microsoft Data Migration Assistant\dmacmd.exe.config if using DMA command line utility Please save a copy…

0

Server Logins migration using Data Migration Assistant (DMA)

In this blog, I will try to demystify the SQL server logins migration using Data Migration Assistant (DMA) DMA assists you to migrate the logins based on a Windows principal (such as a domain user or a Windows domain group) and logins created based on SQL authentication, also called as SQL Server logins. DMA currently doesn’t…

0

Released: Data Migration Assistant (DMA) v2.0

Overview The Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It also allows you to not only move your schema, data, but also uncontained…


Data Migration Assistant: How to migrate your on-premises SQL Server instance to modern SQL Server platforms

Data Migration Assistant (DMA) provides seamless assessments and migrations to modern on-premises SQL Server and SQL Azure VM data platforms.  The following step-by-step instructions will help you to perform your first SQL server migration using DMA. Create new migration project Click on the “New(+)” button on left pane and select “Migration” project type. Set the source and…

0