Archives | Hansen BI

Detecting Row Count Anomalies with Simple Linear Regression

by Jeanne Combrinck | Jul 28, 2016 | SQL Girl

A follow up from my previous post on Detecting ETL Duration Anomalies with Simple Linear Regression, I thought I would share how to detect Row Count Anomalies with Simple Linear Regression. This is very useful to detect when tables row counts all of a sudden grow by...

Master Data Services (MDS) 2016 Prerequisites for IIS

by Jeanne Combrinck | Jul 22, 2016 | SQL Girl

This is just a high-level overview of the prerequisites that are needed for IIS. You need to have IIS installed on the server you are installing MDS on in order for MDS to work. The easiest way to check if you have all the prerequisites for IIS installed is to open up...

Tips for Using Azure Data Catalog

by Melissa Coates | Jul 2, 2016 | SQL Chick

It seems there’s a lot of interest in Azure Data Catalog from the customers that I work with. Since I’ve been discussing it a lot recently during projects, I thought I’d share a few thoughts and suggestions. Register only Production data sources....

Detecting Row Count Anomalies with Simple Linear Regression

Master Data Services (MDS) 2016 Prerequisites for IIS

Tips for Using Azure Data Catalog

Top Posts & Pages

Blogroll

Blog History

Recent Posts