Continuous Integration for SQL Reporting Services


What is continuous Integration and how this can be leveraged to enhance productivity for SSRS Report development?



Continuous Integration is a software practice of merging developer code into shared mainline repository different times a day.

Continuous Integration is an iterative process, in which we build, run test cases and deploy the components to validate the changes made by the developer. The developer will be notified with the results as soon as the changes have been made. This helps the developer to test the components as he/she develops.

Source Code Checkout for Build :

The CI framework (Build Plan) will checkout the source code from the source control. This code base will be built and the developer will be notified the outcome immediately. This helps the developer to fix the bug as soon as the changes have been checked-in. The build can be manual, scheduled or event driven (Based on the changes to code).

Validate the build:

The build can be validated by running a set of test cases. The success or failure of the test cases will help to validate the changes.

Test as we develop:

All of the above mentioned steps will happen in a short period of time (depends on the volume of the build assets). This helps to fix the bugs during the development.

Users of Continuous Integration (CI):

The CI framework mainly improves the development process. Hence the Developers and Test Engineers will greatly benefit from the process. This also helps to reduce the Release overhead for Release Engineer/Manager.

As the bug gets fixed early in the process, the business confidence will increase. Hence the project management is benefitted with the reduction in development time.

CI Tools:

As CI is a practice , we need a tool to implement this. Jenkins CI is an open source CI tool. Below is a list of commercial CI tools in the industry

  1. Bamboo (Atlassian)
  2. TeamCity (JetBrains)


CI Advantages:

From the above details, it is prudent that Continuous Integration helps to self-test the code.

As the bugs get identified and fixed early in the development process, this helps to reduce the risk.

This process enables the cohesive and agile development methodologies.


Next Steps:


How to become a successful Independent IT consultant in the UK.

Today I have decided to write about “How to become a successful Independent IT consultant in the UK.

It requires lots of courage . The Independent consultant has to face so many challenges.

Key challenges need to be worked out are

  1. Maintaining financial stability
  2. Keep yourself updated about technology
  3. Polishing your soft skills day by day
  4. Maintaining emotional quotient during the market turmoil

However there are some ways to overcome these challenges

Financial Stability:

There are some recommendations to keep liquid cash to manage financial commitments for at least 3 months.  This will give piece of mind that worst case scenario can be faced.

Continuous Learning:

The least expensive way to learn soft skills and technology is to have online training subscription.

Maintaining Emotional Quotient:

This is one of the key skill an independent consultant need to concentrate on. As the job market fluctuates, it is mandatory to face the situation with the right mind set.

The following would help to maintain the balance

  1. Yoga
  2. Breathing exercises
  3. Simple aerobic exercises