Experiments, tutorials and ideas on developing business intelligence solutions
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 …
Hi, Recently an issue attracted my attention where we needed to tame the runaway SQL jobs, where the step in the job to import a file from the FTP source at times would run up to 2 days (which would normally complete in ~2 minutes). Well at times ftp downloads by scripts are affected by Read More …