Mapping types between R and SQL Server can be tricky. [...Read More]

A new-ish approach that's more forgiving with inconsistent data. [...Read More]

Another way to PIVOT data in SQL Server...with a catch. [...Read More]

One possible approach for obfuscating sensitive data. [...Read More]

A quick walk-through using the R.exe command line utility. [...Read More]

How to remove those pesky double quotes when using OPENROWSET. [...Read More]

Now that SQL Server supports JSON, schema-on-read should be a thing. Right? [...Read More]

Thoughts on JSON functions and some suggestions for the future. [...Read More]

A T-SQL solution eluded me. But there are other ways... [...Read More]

SSIS packages are pretty easy to document if your deployments are old school. [...Read More]