SQL Server CLR Function on Azure SQL Server Managed Instance
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 a locally hosted or native installation of SQL Server, you would reference the assembly locally. […]
Python Script to get Data for Power BI
For a recent meetup I wanted to query the website predithq. They have a dataset of events and I wanted to use this data in a meetup. Unfortunately Power BI isn’t compatible with the API this provider uses. They use a 308 Permanent redirect as the initial response, requiring an additional request. After a bit […]
Using an R Dataframe as a Power BI source
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 folks in your team that can program R you can take advantage of the power […]
Cleaning Football Data with R Tidyverse
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 Football data and clean it up with Tidyverse packages in the R stats eco-system. I’ve […]
SSIS Dependency Diagram with DiagrammeR and Sprockit
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 procedures are developed that carry out many tasks. With many of these packages it can […]
