Amol Pandey

Experiments, tutorials and ideas on developing business intelligence solutions

Skip to content
Menu
  • Home
  • About Me

Month: August 2018

Dates Overlap – Get the days count overlapping between 2 date ranges (SQL)
SQL

Dates Overlap – Get the days count overlapping between 2 date ranges (SQL)

Posted on August 28, 2018August 28, 2018 by Amol Pandey

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…

VSTS (TFS Online): Create Work Item from Outlook Mail Integration via VSTO
.NET

VSTS (TFS Online): Create Work Item from Outlook Mail Integration via VSTO

Posted on August 26, 2018 by Amol Pandey

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…

VSTS – Automated Code Check-in/Out via C# Code
SQL

VSTS – Automated Code Check-in/Out via C# Code

Posted on August 25, 2018August 25, 2018 by Amol Pandey

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…

MSSQL – Bulk Insert From C# Code not SSIS
SQL

MSSQL – Bulk Insert From C# Code not SSIS

Posted on August 24, 2018 by Amol Pandey

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…

MSSQL – Lets Compress those large text with loads of spaces in it via UDF
SQL

MSSQL – Lets Compress those large text with loads of spaces in it via UDF

Posted on August 24, 2018August 24, 2018 by Amol Pandey

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…

Posts navigation

Page 1 Page 2 Next Page

Hot Topics

Backup C# Catalog Code config CSharp Cube Data Deployment Form Gulp Javascript Job JS Key Management Master MSSQL NET Node Js Npm Paramter PowerBI Processing Query Report Script Service Setup SQL SSAS SSIS SSISDB SSRS TFS Typescript ubuntu UDF VB.NET Visualization Visual Studio Code VSTS Web Webpack Windows

Categories

Archives

© Copyright 2021 – Amol Pandey
Wisteria Theme by WPFriendship ⋅ Powered by WordPress