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,414 reads
oData
Add Some Spark to Your OData: Creating and Consuming Data Services with Visual Studio and Excel 2010
The Open Data Protocol (OData) is an open REST-ful protocol for exposing and consuming data on the web. Also known as Astoria, ADO.NET Data Services, now officially called WCF Data Services in the .NET Framework. There are also SDKs available for other platforms like JavaScript and PHP.
2010-10-20
1,918 reads
Blogs
The PASS Summit on Tour in Dallas
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
SQL Server Auto-settings: The Good, the Bad, and the Ugly
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
Bad Request Error when Running PowerShell Command in Azure Devops
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Question of the Day
Has the PK been used --
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers