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,397 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
108 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,592 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Removing the REST Endpoint in the Data API Builder
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
T-SQL Tuesday #182: Personal Integrity
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
Forums
TDE for multiple databases and severs
We are self hosting sql servers, we are not using Azure for sql servers....
Help with parent/child query please
Hi everyone, Trying to get this data to the following format but I can't...
The user data source credentials do not meet the requirements to run this report
I am trying to implement a SSRS reporting dashboard similar to the SQL-performance-dashboard-reports that...
Question of the Day
Sparse Column Storage
When does a column declared as SPARSE use no storage?
See possible answers