Friday, November 28, 2014

Can someone give me a Template please?

Can someone give me a Template please?

In this post I’m going to explain how to create a custom template that you can add to your Report Server and it will then appear in the Visual Studio installed templates list when you add a new report to your project.

SSIS variables: DateTime data type has no milliseconds

Everyone who has written more than few SQL queries is well aware of the issues that can occur when dealing with dates and times.  After a while you develop methods for getting around different date formats and eventually feel pretty confident that you are on top of the situation.  It’s always good to be aware that there are lots of places in the development world that can trip you up.

Thursday, November 13, 2014

Validation in Stored proc or Code

I believe validating data in a stored proc is better:

-IF you have more than one app looking at that stored proc, the validation is done only once.
-When rules need to be changed, they only changed at one central point.

Wednesday, November 12, 2014

Data Modelling Made Easy

Challenged with the typical time and resources constraints at an entrepreneurial client where rapid LOB system changes are eminent, modelling their data had to be fast and to the point. In order to focus on the business needs with only pockets of time available with decision makers, we needed a tool that is easy to understand and use but comprehensive enough to build the core data warehouse collaboratively whilst abstracting the technical side, in one step.

Monday, November 10, 2014

What is SDLC?

SDLC is a process followed for a software project, within a software organisation. It consists of a detailed plan describing how to develop, maintain, replace and alter or enhance specific software. The life cycle defines a methodology for improving the quality of software and the overall development process.

Customizing Report Manager Home Page

Customizing Report Manager Home Page 

Reporting Services provides default cascading style sheets (.css) files that define styles for the report toolbar in HTML Viewer and for Report Manager’s homepage. In this post we are going to modify the default styles to change the colours, fonts, and layout of the tool bar or Report Manager.