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

Friday, 29 June 2018

Upcoming event - PowerBI Days

Just got my session confirmed for Power BI Days 2018 - Belgium on the 23rd of September.


Should be an epic event.


More info at http://www.powerbidays.com/

Wednesday, 27 June 2018

Sunday, 24 June 2018

Oh my Gawd I can't believe that I missed that!!

Iv'e been working on this customer data take-on procedure this whole weekend (last 36h with 3h sleep)
and there is this one part that was just taking forever.. 

The efficient delete... that now had become ULTRA inefficient...


Below is a Video on how I solved it and what the actual problem was, so if you are interested in solving SQL problems take a look:




Monday, 18 June 2018

How to create Delta Load Patterns in SSIS

Below is a video tutorial on how to create a Delta incremental pattern in SSIS

Source code for the demo is in the video description.

Saturday, 16 June 2018

How to avoid Pagelocks in large deletes

Here is a video I made about Deleting data from large tables, code samples in the video description.




Friday, 15 June 2018

Using PowerBI Desktop as an IDE

Its been a while since i posted anything here, but here goes nothing, below is a Video that I made as a DevOps / IDE tutorial for PowerBI, Enjoy.