Azure
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
24 October 2020
Articles
Idea's & Technical Articles
Azure
SQL Server Managed Instance IO Performance
SQL Server Managed Instance IO Performance is dependant on a few settings. Service Tier vCore Count File Sizes !! Yes,
24 June 2020
Analytics
Microsoft Dynamics Nav SQL Queries
As part of our ERP query series we bring you Navision / Microsoft Dynamics Nav / Dynamics 365 Business Central
21 April 2020
Azure
Upload Multiple Files to Azure Storage with PowerShell
A simple code example that takes a pipeline input of file names, appends an optional date stamp and uploads the
14 March 2020
Azure
Azure & Office 365 IP Address Ranges Reference
Quick Reference to where the latest various Azure IP ranges are located across the Microsoft documentation Resources. I’ll keep this
14 March 2020
Microsoft Business Intelligence
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
29 January 2020
Microsoft Business Intelligence
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
15 June 2019
Data Science
Making a Classification Prediction with Neural Networks
In this post I give an example of making a prediction with R stats for a type of business problem
15 June 2019
Microsoft Business Intelligence
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.
10 June 2019
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
5 June 2019
