Released: SQL Server Migration Assistant (SSMA) v7.4

Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions). What is new? SSMA for Oracle now…

0

The Migration Guide is now available for Public Preview!

We are pleased to announce Public Preview availability of a new database Migration Guide for enterprise customers, partners, and business decision makers who are interested in moving to the Modern Data Platform, for example migrating from Oracle to SQL Server or to Azure Data Services. Overview Hosted on the Microsoft Web, the Migration Guide is…


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…


Migration approach for Oracle features

This blog posting focuses on tasks associated with migrating an Oracle database to the latest version of SQL Server. If preparing for a migration requires changes to Oracle features/functionality, then it is important to carefully consider the potential impact of each change on the applications that use the database. This posting provides links to detail about workaround…

0

DEA 2.0: Telemetry and Local Audit for Database Experimentation Assistant

Database Experimentation Assistant contains an internet-enabled feature that can send telemetry information back to Microsoft. The same information is saved on your computer for Local Audit so that you can always see what information is being collected. All log files from DEA are saved in %temp%\DEA. In addition, you can decide which events get collected,…


DEA 2.0 Technical preview: Release Overview - Database Experimentation Assistant

Overview Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL Server versions (SQL Server 2005 and above) to any new version of the SQL Server will be able to use these…


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: Analysis FAQ  

 What security permissions do I need to generate and view an analysis report on my server? The current logged in user in DEA should have sysadmin privilege to the analysis server.  If the user is part of a group permission, make sure the group has sysadmin privileges as well.   Possible Errors: Explanation / Solution: “Unable to…

0

DEA 2.0: Replay FAQ

For questions regarding configuration, following the instructions provided in Configure Replay Environment. 1. What security permissions do I need to start a replay capture on my target server? The Windows user performing the trace operation in the DEA Application should have sysadmin privileges in the target SQL Server. This is needed to start a trace. The service account, under…

0

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…

0