Author Archives: Jonathon Eve-OConnor

SQL PASS Summit 2014 – Day 1

Having spent several days enjoying Seattle and getting to know and enjoy the city the

Continuous Integration With TeamCity – Automating SSAS Build and Deployment

In this blog article I will be detailing how I use Team City to automate

Using TeamCity to Automate Building and Deployment of Database Projects

So far we have seen how to setup TeamCity and connect to TFS. In this

Configuring TeamCity To Connect To Visual Studio

After installing TeamCity to enable Continuous Integration (CI) you will first need to setup a

Getting Started – Continuous Integration – Team City Installation and Setup

I have been working on a project where we have been using Continuous Integration (CI).

Nonclustered Columnstore Indexes And Stored Procedures

I was recently working on a project with a developer who needed to execute a

Optimising SSIS Lookups with HASHBYTES()

In this blog we look at how to optimise SSIS lookups with HASHBYTES. I was

Maintaining Hierarchy State On Report Refresh

I recently had a request from a client who wanted to display use a parent

Word Cloud Reports in SSRS

Whilst SSRS does not have an inbuilt utility for building Word Cloud reports (sometimes also

Adding Strip Lines to SSRS Reports

Once in awhile you happen upon a really useful feature in SSRS that you were