Amol Pandey

Experiments, tutorials and ideas on developing business intelligence solutions

Skip to content
Menu
  • Home
  • About Me

Category: SQL

BI Data Stability, Consistency and Sanity Checks – C# Test Case
.NET

BI Data Stability, Consistency and Sanity Checks – C# Test Case

Posted on December 13, 2021December 13, 2021 by Amol Pandey

In any enterprise BI setup, over time it becomes a challenge to ensure the stability of all the input data streams (via any mechanism like…

Runaway SSIS Package Manager – Managing Long Running Packages
SQL

Runaway SSIS Package Manager – Managing Long Running Packages

Posted on December 11, 2021December 11, 2021 by Amol Pandey

Hi, There has been few instances where the source systems had few glitches, and that led to SSIS packages to cling on connecting (zero timeout)…

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 – 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…

Posts navigation

Page 1 Page 2 Page 3 Next Page

Hot Topics

Backup C# Catalog CD CI Code command config CSharp Cube Data Deploy Deployment Docker Gulp Jenkins Job Key long Management Master MSSQL MVC NET pandas pem Processing Python Query Report running Script Service Setup SQL SSAS SSIS SSISDB ssl SSRS TFS ubuntu UDF VSTS Web

Categories

Archives

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