When you need to deploy an assembly (.net DLL) SQL Server CLR Function on Azure SQL Server Managed Instance, you have to do it slightly differently. I'll show you how to do this with the least amount of effort! On…
Toby Riley24 October 2020
Power BI can use a wide variety of data sources. This is one of the things that makes it very powerful. In this post I show how you can use an R script as a data source. If you have…
Lee Hawthorn15 June 2019
Cleaning data is a big part of Data Science. Being able to script data cleaning makes it repeatable and transparent. The best tools to do this with in my opinion are R/Python/Power Query/SQL. In this post I take some scrapped…
Lee Hawthorn10 June 2019
We can use DiagrammeR & Sprockit to discover Server Integration Services (SSIS) Dependencies. SSIS is a mature data integration tool bundled with SQL Server. SSIS like many other tools can lead to 'dependency hell'. This is where packages or stored…
Lee Hawthorn5 June 2019