Experiments, tutorials and ideas on developing business intelligence solutions
Hi, Working in Qlikview, would bring you across files which are gigantic and balloons up in your RAM once loaded (depending on the data set loaded in them). But its an amazing technology and the power it enables business user to so quickly slice-dice the data which are inter-related. All things good about Qlikview, but Read More …
Hi, Well today’s post is a simple one, but this one which gave me a good fight to get the trick right !!! Situation: I have 2 date ranges, and I need to know the number of days over-lapping between these 2 date ranges The above highlighted red area is what I am interested in Read More …
Hi, Well I believe this post is going to be fancy, but yet quite productive one. In a team where the members are over-burdened with task, and yet they are asked to create TFS work-items for each relevant email which has the associated task for them. They kinda not happy with the effort and wish Read More …
Hi, This is my new article on the VSTS (Visual Studio Team Services) automation. VSTS is a popular and a very important tool in any organisation where by the developer can version their code, manage work, documentation relating the project and much more. Recently i wrote an article SQL – Backup Database Schema and SQL Read More …
Hi, In this post I would like to share the bulk insert methodology via C# rather than using SSIS. In the first place, why would i do that ??? Hmm… Well i cam across this situation when I am working with substantially large data-sets, the strategy to process them as fast as possible is to Read More …