Scraping Web Pages 2020-07-12 Posted in: Development Machine Learning Services R SQL Server T-SQL Acquire web page data in-database with Machine Learning Services. [...Read More]
Data Obfuscation for SQL Server 2020-06-14 Posted in: Development Machine Learning Services R SQL Server T-SQL In-database utilities for obscuring sensitive data. [...Read More]
sp_execute_external_script and Bytecode Version Mismatch 2020-04-04 Posted in: Development Machine Learning Services R SQL Server Mapping types between R and SQL Server can be tricky. [...Read More]
An Alternative to BCP 2020-03-10 Posted in: Development Machine Learning Services R SQL Server T-SQL A new-ish approach that's more forgiving with inconsistent data. [...Read More]
Pivoting Data Without TSQL 2020-02-25 Posted in: Development Machine Learning Services R SQL Server T-SQL Another way to PIVOT data in SQL Server...with a catch. [...Read More]
Generating Fake Data in SQL Server With R 2020-02-01 Posted in: Development Machine Learning Services R SQL Server One possible approach for obfuscating sensitive data. [...Read More]
Installing R Packages for SQL Server Machine Learning Services 2020-02-01 1 Comments Posted in: Development Machine Learning Services R SQL Server A quick walk-through using the R.exe command line utility. [...Read More]
R Script Visual in Power BI 2019-05-28 Posted in: Data Visualization Development Machine Learning Services Power BI R R Script Visual in Power BI [...Read More]
Machine Learning Services and Result Sets part 3 2017-12-13 Posted in: Development dplyr Machine Learning Services R T-SQL WITH RESULT SETS is no box of chocolates-you have to know what you're gonna get from sp_execute_external_script. Or do you? [...Read More]
Machine Learning Services and Result Sets part 2 2017-11-16 Posted in: Development Machine Learning Services Python R SQL Server SQL Server 2017 Dave ponders Machine Learning Services and sp_execute_external_script WITH RESULT SETS...again. [...Read More]