Tuesday, 31 July 2018

On the job... Live Stream 2018-07-31

Hey all this stream was based on three work items in my queue some interesting and some not..

all based on T-SQL and SSIS.




Monday, 16 July 2018

How to user Azure Data Factory for ETL

This is a practical demo and step by step video that uses Azure Data factory to collect a file from and FTP server and store it as an Azure Blob then ingest the blob into an Azure SQL Server Database.








The Prerequisites for this is as follows:


FTP Server (I used www.drivehq.com)
An Azure subscription (I use a free trail)

An Azure Blob store (I used v2 Storage Account)
Azure SQL Server
Azure Datafactory

You also need a data set that you can lab with. and SQL Server Management studio 2017 to create tables in the Azure SQL Server database and test your Data Factory Pipeline results with.




Thursday, 5 July 2018

Setting up Azure Analysis Services and Connecting Power BI to it.

This Video is a practical demo on how to Deploy a Tabular data model into Azure Analysis services and how to connect it to Power BI and share it with Role based security.

The video is based on a live stream so it isn't perfect but it does the job :)

PS! 1st 60 seconds is just music.






Requirements:

  • An Azure Subscription (Free 30 day trail available)
  • SQL Server installed on your local machine (I use SQL Server 2017 Developer Edition)
  • A Power BI Account
  • Visual Studio 2017 (To work with Analysis Services Projects)
  • A SQL Server Database (I used Contoso Retail Data Warehouse)
  • Optional second Power BI account to test Role based security
  • SQL Server Management studio 2017