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.
SQL Server Data Types – What You Must Know About Them

As a part of my work, I frequently get opportunity to review database models. As I am a little more specific about the usage of data types I feel a bit restless when I see a developer using the data type bigint or varchar(max) when a tinyint or varchar(50) would have sufficed. DB developers who argue […]

Continue Reading: SQL Server Data Types – What You Must Know About Them →

OFFSET FETCH Clause: SQL Server 2012/14 – New T-SQL Feature

There are certain practical scenarios when you are required to fetch tens of thousands of rows of records from a database. Most of the ASP.Net applications are connected to a SQL Server database and unlike MySQL and Oracle databases, SQL Server had no easy Paging feature till SQL Server 2012 release! There were convoluted solutions to a […]

Continue Reading: OFFSET FETCH Clause: SQL Server 2012/14 – New T-SQL Feature →

SQL Code Snippet – A Quicker Way to Code – SQL Server

What is SQL Code Snippet? MS Visual Studio is one of the richest editors that has an advanced intellisense support. Many of the full stack MS developers always complaint about the lack of rich intellisense support in the MS SQL Server editor  (i.e. SQL Server Management Studio, Query window). SQL code snippet is a feature that helps you […]

Continue Reading: SQL Code Snippet – A Quicker Way to Code – SQL Server →

9 Google Search Tips: How to Search Like an Expert?

Google has now become synonymous with the term search, and that’s the reason more often you’ll hear the term Google it than search it! Gradually Google (other search engines also followed) has become so smart that whatever you type in the search box you will get dozens of pages as search results. You can keep on […]

Continue Reading: 9 Google Search Tips: How to Search Like an Expert? →

What are SQL Server “Sequences”?

Sequences were introduced in SQL Server 2012. To locate the Sequences in database, log in to SQL Server Management Studio [2012 edition] (SSMS) and navigate to Programmability node under any database. See the below screenshot to locate the Sequence and to get started with SQL Server Sequence: Before we create our first sequence let us […]

Continue Reading: What are SQL Server “Sequences”? →

Getting Started with Microsoft Azure SQL Database

Objective of this article Sharing a brief of the 2 best options available in MS Azure for SQL Server deployment. Deployment via SQL Server Management Studio (SSMS, using SQL Server 2012) Accessing SQL Azure from SSMS and through browser. Prerequisites for this article MS Azure subscription. You can Sign-up for a free trial account here. […]

Continue Reading: Getting Started with Microsoft Azure SQL Database →

Dynamic Search Without Using Dynamic SQL

There can be some scenarios where you have to search a database using multiple criteria where you don’t know in advance as which criterion or the combination of criteria the end user would select. For example, consider the following scenario There’s a table which contains some basic information about employees, say it has the following […]

Continue Reading: Dynamic Search Without Using Dynamic SQL →

A Message to Middle-aged, Obsolete and Unemployable Programmer

What Made Me to Write this Post? I first read the above comment when it appeared in the comment section of a popular blog for programmers. If you do a little Google search, similar contexts has appeared at many places on various blogs and forums throughout the web. Coincidentally, the screen shot here shows the […]

Continue Reading: A Message to Middle-aged, Obsolete and Unemployable Programmer →

SQL Server Pivot – A Simple and Practical Example

SQL Server Pivot was introduced in SQL Server 2005. It is a useful feature but it’s syntax and implementations sounds a bit complex. Let us try to understand this by a simple example. Problem Scenario You are working for software project for a client who has 5 stores located in say 5 different cities. Each […]

Continue Reading: SQL Server Pivot – A Simple and Practical Example →