SQL Gubbins

Articles and notes covering all aspects of SQL, its use, commands and related infrastructure.

CTE’s

NOLOCKS & performance

MERGE

Couple of excellent articles from PurpleFrog giving and introduction to MERGE:

 

Advertisements

OLAP

MDX

 

Tools & Utilities

Accessing SSAS from .Net

Alteryx: https://community.alteryx.com/t5/Data-Sources/SSAS-Cube-Connection-and-MS-Power-Query/td-p/13405

  • Microsoft.AnalysisServices.AdomdClient
  • System.Data.DataSetExtensions

 

Visual Studio – installing ADOMD client: http://stackoverflow.com/questions/23605901/adomdclient-missing

 

 

SSRS

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.

Octopus.

RS Scripter.

How to fix rsInvalidDataSourceReference:

Nuget

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:

 

Versioning of Nuget packages

Nuget official website & guidance

The official website can be found at: www.nuget.org Some useful pages:

Tools & Utils

Nuget package explorer:

Making sense of Visual Studio/TFS builds and Octopus deployments

The following provides an overview of the new TFS 2015 Build approach:

Training videos:

Octopus.

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.