Deep dives, bold ideas and hands-on technical articles from the front line of modern data.
Deploying a .NET assembly as a SQL Server CLR function on Azure SQL Managed Instance, where file-based CREATE ASSEMBLY isn't allowed.
IO performance on Managed Instance depends on service tier, vCore count and, yes, file sizes. A proc to show what tier your data files land on.
Part of our ERP query series. Fifteen SQL queries for Navision, Dynamics NAV and Business Central that turn up in every ETL and BI project.
A quick reference to where the latest Azure and Microsoft 365 IP ranges live across the Microsoft documentation.
A pipeline-friendly PowerShell script that takes file names, appends an optional date stamp and uploads them to Azure Storage with the Az module.
When Power Query can't follow an API's 308 redirect, a few lines of Python make a perfectly good Power BI data source.
A worked example in R: fitting a single-hidden-layer neural network with nnet to classify car acceptability, and reading the confusion matrix.
Power BI can run an R script as a data source. A worked example pulling Google Trends data, and the refresh gotcha to know about.
Scripting data cleaning makes it repeatable and transparent. Reshaping fifteen seasons of European football data with tidyverse, then exploring it in Shiny.
Escape SSIS dependency hell. A stored procedure that emits Graphviz from Sprockit's process table, drawn with DiagrammeR in R.
Bring it to us. The fix might become the next article.
Cookies
With your permission we use Google Analytics and Microsoft Clarity to see how the site is used, and Google Ads to measure our advertising. Nothing is set unless you accept. Privacy policy
