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,329 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,542 reads
Blogs
Storage Field Day 23 – HammerSpace
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Daily Coping 16 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Why You (usually) Want a Clustered Index
By alevyinroc
Note: I originally wrote this a few years ago but never posted it. It...
Forums
Migration of Data from one Database to Multiple Databases
Hello, I have a requirement to migrate the data from existing AWS RDS DB...
AWS Beginner questions
I'm having some trouble wrapping my head around the relationship between EC2 instances and...
How to get weekly and Monthly view from daily in sql server
Hello All, I have a table like below. I need to get daily,weekly and...
Ask SSC