Skip to content

Sumit Gupta

bookmarking my life

Category: Database

Automate Testing: Gitlab, Dotnet

March 29, 2019March 29, 2019 by Sumit Gupta .NET, Continous Integration, Docker, MS SQL Server, Programming, Project Management

I always want to test my .NET based application on my personal Gitlab based repo. But since, my old project is too much a mess to do the effort for….

Read More

Experience with BitBucket CI

September 29, 2016September 29, 2016 by Sumit Gupta Continous Integration, MySQL, PHP, Programming, Project Management

I have been using bitbucket for quite sometime, and really like their service. Recently, I come to know that they have Beta of CI through pipeline, that can run any…

Read More

SQL Update if Record Exists or Insert

June 9, 2015 by Sumit Gupta Bookmarked, MS SQL Server, SQL

Quite often we need an approach where we need to Insert record if it is not already present. Sometime to manage relationship. There are few different way of doing it,…

Read More

Installing Redmine 2.3.3 on Ubuntu 13

October 26, 2013August 19, 2014 by Sumit Gupta Management, MySQL, Project Management, Server Configuration

Okay, today I install Redmine on Azure hosted Ubuntu 13.04. The steps are easy once I get it done after 2 days of working and finding what is right to…

Read More

Advance SQL: Finding Hierarchical data using Recursive CTE

September 13, 2013September 13, 2013 by Sumit Gupta Bookmarked, Database, MS SQL Server, SQL

Often we have a Table that store Hierarchical data, such as any shopping cart will have product category in table that store parent table within same table. We often use…

Read More

Reading Large Binary Files: Child Play

July 11, 2013August 11, 2014 by Sumit Gupta Blog: My thoughts, MS SQL Server, Programming, SQL, SQlite

Yes, that was funny title, but after your experience it you will agree to me. So, here is the story. I have been working on a software that read some…

Read More

Database Optimization

March 23, 2012 by Sumit Gupta Article, Blog: My thoughts, Database, MS SQL Server, MySQL, SQL, SQlite

Well, most of program use database for their web application. Eventually all web application does have database. But how many of those web application really works good. Well quite few….

Read More

Posts navigation

1 2 3 Next →

© 2025 Sumit Gupta // Powered by WordPress