- MDX – a gentle introduction
- MDX query basics –
- Writing your first MDX query
Tools & Utilities
- OLAP PivotTable Extensions: Allows the viewing of the MDX used by an Excel Pivotable
Visual Studio – installing ADOMD client: http://stackoverflow.com/questions/23605901/adomdclient-missing
Deploying SSRS reports the traditional way:
Automating deployment using RS.EXE:
And automating using Octopus
And an overview of the various approaches: http://www.sqlblogspot.com/2014/03/ssrs-deploymentcomplete-automation2012.html.
The mysteries of nuspec….
A Channel 9 general overview of creating a Nuget package. Watch this before reading the blog ‘Automatically create and publish a NuGet package using VSTS‘ as the blog misses some steps/assumes prior knowledge.
Creation of a Nuget package with Visual Studio Team Build:
And for a brief overview of builds a series of Channel 9 videos. These are in a slightly odd sequence & I would recomend starting with 2:
Tips for building Nuget packages:
The official website can be found at: www.nuget.org Some useful pages:
Nuget package explorer:
The following provides an overview of the new TFS 2015 Build approach:
Brief overview of the application, configuration & use: Octopus Deploy 3.0 – Getting started
Short training videos from the official site: https://octopus.com/videos .
Useful GUI front end to Octo.exe, developed by former member of Nuget team: Nuget Package Explorer that allows Nuget packages to be created, viewed and edited.