Skip to content

Author Archives: Basant Singh

Basant is a talented software developer who is very engaged in web & cloud platforms on a daily basis. He is a contributor to codingthis.com reporting on various news and troubleshooting on various platforms. Basant is very strong in SQL and a great asset to the CodingThis community.
Go Programming – Arrays and Slices

Arrays are collection of similar items that share a common name. A common scenario would be a case where you want to store student’s scores in an exam. Array Declaration var score 3[int] The above can be read as – Score is an array of type integer that can hold a maximum of 3 records. […]

Continue Reading: Go Programming – Arrays and Slices →

Golang Switch Case with Sample Code

Switch Case statements are an efficient alternative to if…else construct. Both the constructs i.e. if…else & switch case are similar and used to select & execute one of many available code blocks based on certain conditions. So, when to use switch case? When the number of alternatives/options are high (say more than 4) an if else looks […]

Continue Reading: Golang Switch Case with Sample Code →

Parsing XML Data in MS SQL Server

In the first part of this article titled XML Data Processing in MS SQL Server we saw how we can represent relation data in SQL Server in XML format by using FOR XML clause in one of the following four ways: AUTO RAW EXPLICIT PATH In this article, we will continue with Parsing XML Data in MS SQL Sever. […]

Continue Reading: Parsing XML Data in MS SQL Server →

XML Data Processing in MS SQL Server

XML is a special data type introduced in SQL Server 2005. Its purpose is to store data in a specific format so that the data can be queried / analyzed easily whenever required. Optional Info: XML has now become a standard way of data sharing & data transport across various heterogeneous platforms. XML data processing in […]

Continue Reading: XML Data Processing in MS SQL Server →

SQL Server Import Data Wizard for Data Migration

In our last post titled – SQL Server Data Migration Example for Non-SQL Data Sources we have seen data migration from non-SQL sources using: Bulk Insert BCP command-line utility In this article we will see how to migrate data to a SQL Sever database using Import Data Wizard. P.S. The steps covered in this article should work […]

Continue Reading: SQL Server Import Data Wizard for Data Migration →

SQL Server Data Migration Example for Non-SQL Data Sources

Overview of SQL Server Data Migration Migrating data from non-SQL data sources into SQL Server is a commonplace scenario encountered where we need to extract data from a source which is not a relational database (e.g. a flat-file or a spreadsheet). It can even be the output from a biometric system coming in the form […]

Continue Reading: SQL Server Data Migration Example for Non-SQL Data Sources →

Code Example – If Else in Go Programming

Google’s Go programming language (Golang) is gaining momentum and IMHO it has the potential to become one of the most popular languages in near future. It’s clean, simple and at the same time addresses a few of the challenges of modern computing. There’s no statistics to support but Go is getting popular with programmers of […]

Continue Reading: Code Example – If Else in Go Programming →

Exception Handling and Using Transactions in WCF Service

Exception handling – WCF perspective WCF service is a programming paradigm that offers a common platform for writing service contracts using Microsoft provided CLR environment where heterogeneous platforms/clients technology may consume these contracts. So propagation of exception details occurred in service to the client applications must happen in a platform-agnostic manner so that a client […]

Continue Reading: Exception Handling and Using Transactions in WCF Service →

An Introduction to ASP.Net MVC – Working Code Sample

The objective of ASP.Net MVC design pattern is separation of concern i.e. segregation of three building blocks of any application – 1. Model – comprises the business objects or the raw entities 2. View – the representation / interaction of the entities with the real world 3. Controller – the heart of any application where the business rules […]

Continue Reading: An Introduction to ASP.Net MVC – Working Code Sample →