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]
OPENROWSET and Quoted Data 2020-01-19 Posted in: Development SQL Server SSMS T-SQL How to remove those pesky double quotes when using OPENROWSET. [...Read More]
The Bridge From NoSQL to SQL Server 2019-12-16 Posted in: Big Data Development JSON SQL Server T-SQL Thoughts on JSON functions and some suggestions for the future. [...Read More]
There is already an object named 'RSExecRole' in the database 2019-11-03 Posted in: Database Administration SQL Server SSRS Troubleshooting an error encountered during SSRS migration. [...Read More]