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,274 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
95 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,523 reads
Blogs
T-SQL Tuesday #137–Notebook Uses
By Steve Jones
It’s actually my month to host T-SQL Tuesday, and I came up with the...
Daily Coping 13 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Converting a SQL Server Docker image to a WSL2 Distribution
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
Forums
SQL Server rename
Instead of SQL Server name I am thinking to use dns cname for connection...
Sorting in R
Comments posted to this topic are about the item Sorting in R
Oracle sequences: The basics
Comments posted to this topic are about the item Oracle sequences: The basics
Ask SSC