Connecting to SQL Server using RODBC package in R
Connecting to SQL Server using RODBC package in R

RODBC is a useful package for making SQL queries to SQL Server database for R users. To start using this package, first we need to make sure it is loaded into R studio. is.installed <- function(mypkg) is.element(mypkg, installed.packages()[,1]) if(!is.installed('RODBC')) { install.packages("RODBC") } library(RODBC) Now that the package is installed/loaded into our environment, let’s start making... » read more

Uploading Unknown Format Excel File To A SQL Database
Uploading Unknown Format Excel File To A SQL Database

Introduction Usually it is expected from client side to upload only structured Excel sheets (sheet with defined Column Names and data types for Rows) to load to server. But sometimes you might also require to dump whatever is in the Excel directly to your database. While there is a tool that is provided by SQL... » read more

Post on ASP.NET Web API

Here are links to my two other posts which were published on TutsPlus. Introduction to ASP.NET Web API Securing the Web API You can find the full code in my git repo. Thanks!        

A Knight’s Watch
A Knight’s Watch

Recently I came across this interesting problem through Toptal (on Codility) which kept me thinking hard for a few days. Finally, I now have a solution to this problem and would like to share it here. Problem: Basically, the problem deals with a knight piece on an infinite chess board. Assuming the knight is positioned... » read more

7 Handy SQL Scripts for SQL Developers

Finally got my article published at Tuts+ I had written this article “7 Handy SQL Scripts for SQL Developers” referencing some of the common scripts that I most frequently use @ work. Some of these scripts were collected from different sites while some were developed by myself. ———————————————————————————— “A lot of things that we do... » read more