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, 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 …
Hi, In this post i would like to showcase a feature in which i was able to send out on-demand SQL notification to slack channel via web hooks. This methodology is useful in the areas where users can skip instead of email notification, they can opt to subscribe the Slack channel to keep updated of Read More …