This step doesn't seem to work with Internet Explorer but does work with Chrome

Hello,
I updated the Before the lab document to reflect the correct header & license info but it's missing the TOC and Requirements sections that are in the template. I don't know the coding to add the TOC, sorry. Please update

Where do I get bcp_commands.txt file in Exercise 3 Task 1? It is not in the labfiles folder.

Task 4 asks user to use a region that was previously used. However, we've provisioned 3-4 resources at this point in the lab and each could have been to a different region. We need to give clearer guidance here.

Please repeat user name and password from previous steps so that users don't have to scroll around for this info.

In the lab an on-prem database gets scripted for a SQL Server on-prem destination. Afterwards users need to remove the filegroup statements, the use statements, some go statements... But in Management Studio an on-prem database can be scripted for an Azure Data Warehouse destination, which does all this cleanup automatically, so I would suggest to alter Exercise 2, task 2, step 6 in using the Advanced option of scripting, and configure the options Script for the database engine type Microsoft Azure SQL Database, Script for the database engine edition: Microsoft Azure SQL Data Warehouse Edition:

Then the next step where the script needs to altered can be removed!

We are creating resources in 3-4 resource groups. We should use one to make clean up easier.

Correct screenshot to show ON [PRIMARY] . Current screenshot does not reflect square brackets. Square brackets required for successful completion of step.

Provide the password on this line

Provide more details to direct users to Triggers item in left-hand navigation (instead of the Triggers button on the current pane).

Correct screenshot to highlight Next button. Screenshot currently highlights Previous button.

Users should change the processing to Process Full. Because the AS model is in a fully processed state following restore, Process Default does not trigger any data processing. Process Full will force AS to connect to the Azure DW to reprocess itself. Our users will know enough about AS to catch this.

The instruction reads: Select the C:\LabFiles\CustomerInfoData.csv, C:\LabFiles\CustomerMrktResearchData.csv and C:\LabFiles\CustomerInfoData.csv files and click the Upload button.

The C:\LabFiles\CustomerInfoData.csv is mentioned twice, probably another filename is needed

Please provide the Resource Group name within which this is created. By this point we have a lot of RGs to navigate, esp if we are using a Subscription used for other work.

The VM has too little memory to function properly.

• In around 33% of the cases, the post-deployment script fails (at least in region westeurope)
• During the workshopk Google chrome crashes regularly while working in the Azure portal inside the VM

Suggestion: assign a VM with more memory during the deployment in the ARM script.

• Updated screenshots
• Simplified Deployment (template)
• Simplified resource groups

Add a step to create a master key in the EDW. Without this step, you get this error message:

Msg 15581, Level 16, State 6, Line 1
Please create a master key in the database or open the master key in the session before performing this operation.

Several images missing alt-text.

Usually, when I hover over an image in GitHub, I see the alt-text title. Then, when it's in HTML we see the full alt-text. On your workshop, I don't see the title either....can you please look into why? Thanks!

Hi,

I'm trying to execute the script below to change the user's resource class but getting an error.
EXEC sp_addrolemember 'xlargerc', 'dataloader';

Error: Cannot alter the role 'xlargerc', because it does not exist or you do not have permission.
Then I checked the sys.database_principals view and the workload management database roles don't exist.

Please advise.

There needs to be instruction on how to set Select Public Inbound Ports

Hello,
Please correct the workshop title from Migrating and Enterprise Data Warehouse to Azure SQL Database on the README.md to Migrate EDW to Azure SQL Data Warehouse. Also correct the repo title and all other documents/links to match if needed.
Thanks,
Dawnmarie

The link in the page referring to the Power BI Service is broken (https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-indepth/)

Correct screenshot to show default check mark for Encyrpt Connection. This will trigger questions.

Slide 25 - missing alt-text

Small inconsistency: Near the end of the lab students have to download Power BI. In the first screenshot one has to download the 32 bit version, in the remainder of the screenshots you're using the 64 bit version

This workshop is scheduled for a January 2020 content update. Please review open issues #48 & #54 and give your suggestions for further changes recommended for SME review.

Dear all. I have problems with the prerequisites of the lab. The VM that comes with the template always gives the same error (regarding NLA). I've taken several steps to solve this problem but don't manage to establish a connection.

"your windows DC cannot be contacted to perform NLA."

Lab abstracts don't match what's on the read me page (using WDS abstract). Please update.

Question marks after table name cause syntax error from SQL Server

USE CohoDW
GO
SELECT t.[name] as [Table],
c.[name] as [Column],
c.[system_type_id],
c.[user_type_id],
y.[is_user_defined],
y.[name]
FROM sys.tables?? t JOIN sys.columns c ON t.[object_id] = c.[object_id]
JOIN sys.types y ON c.[user_type_id] = y.[user_type_id]
WHERE y.[name] IN ('geography', 'geometry', 'hierarchyid', 'image', 'ntext',
'numeric', 'sql_variant', 'sysname', 'text', 'timestamp', 'uniqueidentifier', 'xml')
OR (y.[name] IN ('varchar', 'varbinary') AND ((c.[max_length] = -1) or
(c.max_length > 8000)))
OR (y.[name] IN ('nvarchar') AND ((c.[max_length] = -1) or
(c.max_length > 4000))) OR y.[is_user_defined] = 1;

Users need to change both the Data Source and Initial Catalog parameters in the connection string. The restored connection string points to the AdventureWorksDW2014 initial catalog (which users must modify to be CohoDW).

Requirements sections of the labs do not match each other. One has 1 requirement, the other has 2. Is that right?

Add a reference to Ex 1, Task 6, Step 3. Too much time has passed for user to remember the key.

Passwords in the Hands-On Labs sometimes contain a backslash:

Password: Demo@pass123

However, later on when referring to the same password, it is displayed without a backslash:

4. Open a remote desktop session to the SQLCohoDW virtual machine that you created before the lab using the demouser login and Demo@pass123 password.

Task does not indicate which Subscription to select. Other tasks do. We should be consistent.

There are just too many resources being deployed across too many resource groups. Having completed the setup steps, I have a SQL VM, two SQL DBs, a SQL DW, Azure AS, and an Azure Data Factory with its own VM/Runtime. These are spread across 5 resource groups making clean up difficult. This needs to be simplified.

Need to provide clearer guidance on which authentication method to use. For organizations such as Microsoft which have implemented MFA, you must choose the Azure AD - MFA option.

This line:

From the SQLCohoDW virtual machine, open Internet Explorer, and connect to the Azure Portal

When did we ever create a virtual machine named SQLCohoDW. I'm lost.

Be sure to instruct users to click Activated button.

In the Whiteboard Design Session, participants are expected to review migration overview and high-level checklists. However, this documentation seems to have been removed from Azure, and all links about migration (in general, about schema, about data, and about code) redirect to the overview of developing Azure SQL DW (without any migration tips) : https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-develop

In order to complete the WDS, participants should either be pointed to other docs (containing the same information), or the suggested answers in the training guide (at the text "Answer: The data preparation phase or the pre-migration phase is when you plan your migration. Here is a minimal list of or research to get you started:") have to be updated.

There is some documentation in the Azure Database Migration Guide (https://datamigration.microsoft.com/scenario/sql-to-sqldw?step=1), although this guide also contains links to the (now disappeared) SQLDW Migration docs.

This MCW is scheduled for content update.
Opsgility - please review current content and any existing open issues and provide your recommended updates for SME review.

Please add a note referencing the Before the Lab.md in the Step-by-Step HOL instructions. Otherwise, folks will miss this.

Task 2 asks to specify region for ADF v2. These regions do not cover all the regions associated with the ADF RunTime. Users may be confused. We should add a note to indicate that the RunTime does not need to be in the same region as the ADF.