Articles and notes covering all aspects of SQL, its use, commands and related infrastructure.
NOLOCKS & performance
- Never mind the NOLOCKS
- The 7 Sins against SQL Performance
Couple of excellent articles from PurpleFrog giving and introduction to MERGE:
- Excellent introduction to basics of the MERGE statement from PurpleFrog and then taking you further in to the use of MERGE with Slowly Changing Dimensions:
- Another excellent article covering much the same material:
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.
How to fix rsInvalidDataSourceReference:
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:
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.