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,339 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,546 reads
Blogs
Daily Coping 23 Sep 2022
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
Snowflake – Where is the explain/execution plan?
By Arun Sirpal
Whatever your database background is you will have heard of an execution / explain...
Daily Coping 22 Sep 2022
By Steve Jones
Today’s coping tip is to ask a trusted friend to tell you what strengths...
Forums
When use sql graph on sql server 2019 ?
I working on sql server 2019 . i read more about sql graph but...
how to change hard coded dates to ytd please
Dear Helpers, Below query is working fine giving me what i needed but if...
Couldn't allocate new page for database alert even the Database has free space
Hi, We have a database. We received the alert Could not allocate new page...
Ask SSC