Once a data warehouse has been deployed in Azure, you can connect to it from SQL Server Management Studio to develop the database. In this online tutorial, Adam shows how to configure the firewall in Azure to allow remote connections to the data warehouse.
- [Instructor] Once your cloud hosted Azure … SQL Data Warehouse is fully deployed, … you can connect to it from management studio … just like you would with an on-premises SQL Server instance. … To do this, we need to create a firewall rule … on the Data Warehouse Server … in order to allow our computer to connect. … Click on the Dashboard link at the top of the screen, … or over here in the left-hand side menu, … in order to get back to your main Dashboard. … Then if your resources aren't showing here … like mine aren't, go ahead and refresh the page. … Next, I'll click the link for the SQL Data Warehouse … that was just created. … Mine was called KinetEcoAzureDW. … That'll take you to the overview … configuration page for the database. … In the upper right-hand corner will be … the server name that we're going to connect to. … Mine is called adam-kineteco.database.windows.net. … You can hover your mouse over it, … and then click on the little page icon … to copy that to your clipboard. …
Author
Adam Wilbert
Released
10/23/2019- Transactional databases vs. data warehouses
- Star and snowflake schemas
- Creating a data warehouse
- Designing tables and views
- Rebuilding columnstore indexes
- Creating an Azure SQL Data Warehouse
- Establishing control flow beyond ETL
- Enforcing data quality
- Configuring Master Data Services
- Consuming data from the warehouse in BI services
Skill Level Intermediate
Duration
Views
-
Introduction
-
Set up the example databases2m 32s
-
1. Data Warehouse Foundations
-
Data warehouse core concepts3m 58s
-
Dimensions and facts5m 1s
-
Star and snowflake schemas3m 50s
-
Hardware and infrastructure2m 35s
-
-
2. Create a Data Warehouse
-
Design dimension tables5m 46s
-
Design fact tables3m 33s
-
Create an indexed view3m 28s
-
3. Columnstore Indexes
-
4. Implement an Azure SQL Data Warehouse
-
5. Extract, Transform, and Load (ETL)
-
Understand data flow3m 12s
-
Establish control flow1m 54s
-
6. Enforce Data Quality
-
Cleanse data with DQS6m 48s
-
7. Master Data Services
-
Install MDS and IIS4m 37s
-
Deploy a sample MDS model6m 35s
-
Install the MDS Excel add-in2m 28s
-
Update master data in Excel3m 40s
-
8. Consume Data from the Warehouse
-
Conclusion
-
Next steps1m 3s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Develop tables in Azure SQL Data Warehouse