Data Warehouse to OData to Excel and R
How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.
2015-03-03
6,351 reads
Benjamin Seidle
It's OK to be an Outfitter, not a Prospector
As data professional I have played with Analytics and found I'm better suited to development and administration, and that's ok.
2015-02-03
96 reads
Pairing Data Vault and Biml for DW Agility
Agile data warehousing can be challenging. Pairing the right methodologies and tools can help. Here is how my team met the challenge by using Data Vault methodology and BIML scripting.
2014-09-04
2,571 reads
Blogs
Migrating from EverNote to Joplin
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Forums
Database copy issue through - COPY DB WIZARD
I have a production server with SQL server 2016 version (13.0.5026.0) and a database...
Help with a SQL Unpivot
I am trying to use unpivot to extract some data, however, the results are...
how to de escalte a isolation level, and are there any implications.
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...
Ask SSC