Experiments, tutorials and ideas on developing business intelligence solutions
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 …
Hi, When the data grows large, i mean really large one has to come up with ways to bring in techniques where even the slightest can make a difference. In this post I am going to share a technique where by when one is faced storing the large text data set, say receipts, articles which Read More …