Click here to Skip to main content

Submit your article

SQL Server 2008R2

SQL-Server-2008R2

Great Reads

Update Multiple Rows of GridView using JSON in ASP.NET

by Debabrata_Das

This article will talk about how to update multiple records in a GridView on a single button click using JSON in ASP.NET

Debug ASP.NET MVC Application with Glimpse

by Muhammad Hassan Tariq

Glimpse Extension for server side debugging and diagnostic information of ASP.NET applications

SQL Server Procedure to Report Duplicates

by PIEBALDconsult

A stored procedure I use to find duplicate records in tables and views.

FOR XML Basics (AUTO Mode): 2 of 4

by AhsanAhmed

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

Latest Articles

SQL Server: Find Table Order/Generation And Relation Details

by DiponRoy

A utility query to find table generations in SQL Server relational database

AngularJS MVC Repository Dispose

by Mahsa Hassankashi

This is the simplest tutorial on AngularJS and Repository Pattern for developing professional MVC applications. It includes a source code about practical permission management project.

SQL Server: Doing String Split And Join

by DiponRoy

How to do string split and join in SQL Server

Streamline Log Shipping Failovers

by Micah Nikkel

SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.

All Articles

SQL Server 2008R2

Update Multiple Rows of GridView using JSON in ASP.NET

20 Jun 2014 by Debabrata_Das

This article will talk about how to update multiple records in a GridView on a single button click using JSON in ASP.NET

SQL-Server-2008R2

FOR XML Basics (AUTO Mode): 2 of 4

2 Jun 2017 by AhsanAhmed

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL-Server-2008

Creating Report using Report Builder and Oracle DB - Part 2

28 Dec 2014 by Snesh Prajapati

In this article series, I am sharing how to create report using Report Builder by fetching data from Oracle DB.

SQL-Server-2008R2

Streamline Log Shipping Failovers

29 Aug 2018 by Micah Nikkel

SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

Reading Acrofields from PDF Files

29 Sep 2015 by DotNetSteve

Variety is the spice of life - rewarding PDF AcroForm reader

SQL-Server-2008R2

FOR XML Basics (EXPLICIT Mode): 3 of 4

1 Jun 2017 by AhsanAhmed

A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL-Server-2008

Synchronization between local and Azure SQL DB using SLQ Management Studio "Export Data..."

17 Mar 2015 by Sergey Kizyan

This article explains how to merge your local SQL DB content to Azure DB from scratch

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Downgrade SQL Server 2008R2 from Enterprise to Standard Edition

13 Aug 2015 by KASQLDBA

Downgrading from Enterprise to standard edition (SQL server) for those servers which are not using any of enterprise features.

SQL-Server-2008R2

Strategy considerations when migrating ASP.NET forms to MVC

7 Apr 2014 by Stewa11

This case study suggests starting with decoupling the aspx/aspx.cs into the View's CSS3, HTML5, javascript, AJAX and JSON

SQL-Server-2008R2

Automated dynamic report reconciliation process for SSRS using C#.NET and Nunit(.NET)

29 May 2015 by Asanka Perera

This process can be set up to run on a daily basis to make sure that reports which are interrelated does reconcile with each other, in order to make sure the consistency in report quality.

SQL-Server-2008R2

Differences Between Various Joins in MS SQL Server

18 Aug 2014 by DiponRoy

Here, we will see the basic differences or similarities between various joins of MS SQL Server.

SQL-Server-2008R2

Complex Jquery Datatable with Database State Saving & Basic Use of jQuery Templates with ASP.NET C# 4.5, Entity Framework

11 Jul 2014 by Arindam Jha

Understanding of complex jQuery Datatable tricks and Save it's state in SQL Server with a basic concepts of jQyuery template. Sample Application used .NET 4.5, Entityt Framework.

SOAP message in WCF services.

26 Oct 2014 by Bimaln

Describe about the SOAP message in WCF with example.

SQL-Server-2008R2

Resizing and Storing Image Files - File System and Database Part 1

21 Oct 2014 by Steven T. Schowiak

This article will describe and demonstrate a technique for resizing and storing image files on the local file system and image meta data in SQL Server using ASP.NET 4.51.

SQL-Server-2008R2

Use one SSRS Report to Find All Your Microsoft SQL Servers, Out of Date Editions, and Service Packs

3 Oct 2016 by Mark W Solomon

In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.

SQL-Server-2005

SQL-server-2000

reporting-services

Strategy considerations when migrating ASP.NET forms to MVC

4 Apr 2014 by Stewa11

A simple case study

FOR XML Basics (RAW Mode): 1 of 4

2 Jun 2017 by AhsanAhmed

A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

RESTful SignalR Service

27 Oct 2015 by Wonde Tadesse

An article that explain hows to expose SignalR feature through an ASP.NET Web API, which helps applications that can use REST service and to broadcast a real-time message to their clients.

Create Primary Key using Entity Framework Code First

4 Sep 2014 by Dukhabandhu Sahoo

Explore the Entity Framework Code First convention and configuration for creating primary key

SQL-Server-2008R2

entity-framework

Use SQL to develop your REST API

20 Jan 2017 by Ole Oren

Fast and simple REST development for SQL devs

Custom Roles Based Access Control (RBAC) in ASP.NET MVC Applications - Part 2 (Role Based Reporting)

26 Jun 2015 by Stefan Wloch

An introduction to Custom Roles Based Reporting for ASP.NET MVC applications using the Entity Framework. Protecting confidential information is a business requirement and in many cases also an ethical and legal requirement.

Create First SSRS Report with SQL Server Analysis Services OLAP Cube

20 Jul 2014 by Mubin M. Shaikh

This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube

SQL-Server-2008R2

Retrieve/Update SQL Records based on Barcodes

26 Jun 2014 by Philipp Katscher

Fetching Records from a DB using Barcode and updating the same or others with this nifty configurable tool

SQL-Server-2008R2

SQL-Server-2012

ASP.NET C# Tutorial - Development with Nido Framework for Dummies

13 Nov 2014 by Nirosh

This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.

SQL-Server-2008R2

SQL Queries to Manage Hierarchical or Parent-child Relational Rows in SQL Server

15 Sep 2014 by DiponRoy

Some queries to find generation of each row, all possible children, all possible parents, managing recursion

SQL-Server-2008R2

HierarchicalDatagrid

Highcharts in asp.net using jquery ajax

29 Sep 2014 by Amol Jadhao

Looking for a way to draw charts like line,column,bar,pie,area with C#? This is the perfect tutorial for you and its easy to implement.This article will help you to understand how to bind a Pie Chart by calling a web service from jQuery AJAX in ASP.NET

SQL-Server-2008R2

SQL Server: Detect Circular Relations In A Relational Database

4 Mar 2015 by DiponRoy

Table Hierarchy or Generation Finder For Relational Database In SQL Server

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Drawing shapes on spatial tiles with SQL CLR

6 Dec 2015 by Den367

Short glance at drawing on geographical tiles by using of Microsoft.SqlServer.Types assembly.

SQL-Server-2008R2

AngularJS MVC Repository Dispose

3 Apr 2019 by Mahsa Hassankashi

This is the simplest tutorial on AngularJS and Repository Pattern for developing professional MVC applications. It includes a source code about practical permission management project.

SQL server error details.

22 Sep 2014 by Jitendra Ku. Sahoo

Overview of SQL server error anatomy.

SQL-Server-2012

SQL-Server-2008R2

MVC With Ajax - Push Start For Beginners(Part - 3)

31 Mar 2014 by Er. Puneet Goel

This is quick tutorial how to start with ajax in mvx with all basic Add, Update, Edit and delete functionality in a sinlge page

SQL-Server-2008R2

Single Page Application using AngularJS and Web API and Responsive using Bootstrap.

20 Nov 2014 by Khademul Basher

This article describes the AngularJS JavaScript framework and shows how to use it to develop a Single Page Application.

SQL-Server-2008R2

Handling NULL in T-SQL

23 Jan 2017 by Bhim B Thapa

Handling NULL in T-SQL

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Another C# SQL class

1 Apr 2014 by formlesstree4

Another article on C# .NET SQL, but with smarts

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

How to Embed Barcodes in Your SSRS Report

27 Jun 2014 by Philipp Katscher

How to use barcodelib generated Barcodes in SSRS (consider Barcode fonts don't work in runtime)

SQL-Server-2008R2

Handle errors in WCF with and without FaultContract attributes.

26 Oct 2014 by Bimaln

Handle errors in Wcf.

SQL-Server-2008R2

Web-based real-time SQL Server Performance Dashboard

16 Oct 2014 by Omar Al Zabir

SQL Server Performance Dashboard (SSPD) is a small open source web app that shows you performance & problems of one or more SQL Server instances and their databases in near real time.

SQL-Server-2008R2

How to Connect SQL Database to your C# Program - Beginner's Tutorial

30 Sep 2014 by Afzaal Ahmad Zeeshan

This article tells the beginners the basic concepts about connecting to the SQL Server database using C#.

SQL-Server-2008R2

Optimistic Concurrency in Entity Framework Code First

1 Oct 2014 by Dukhabandhu Sahoo

Handle optimistic concurrency using Entity Framework Code First.

SQL-Server-2008R2

Flexible Framework For Attaching Number of Items [Count] to Menus

21 Jul 2014 by _Asif_

Article will demonstrate how to develop generalize framework for creating Outlook style Auto Refresh Count of Menu Items

Developing Fully Functional Data Grids with Jquery DataTable and ASP.Net Generic Handler

23 Aug 2014 by Muhammad Shoaib Raja

Fully functional web data grids with multi column sorting, filtering and pagination using JQuery based data table plugin and .Net generic handlers

Multi-Tenancy System With Separate Databases in MVC

3 Oct 2017 by Gavin Coates

Creating a multi-tenancy system where each tenants data is stored in a separate database, using ASP.NET MVC

SQL-Server-2008R2

SQL-Server-2012

Load More Records in ASP.NET Gridview on Button Click from SQL Server Table

1 Jun 2014 by Webcodeexpert.com

In this article, I am going to demonstrate how to get more data on demand i.e. On every click of button fetch more records from SQL Server database table and load in GridView with wait/progress/loading image as shown in image in ASP.NET using both C# and VB languages.

SQL-Server-2008

SQL-Server-2008R2

Authorization Filters in ASP.NET Web API 2 & AngularJS

3 Jul 2016 by Shashangka Shekhar

In this article, we are going to explore the security issue which will help us to prevent unauthorized access of web API access using custom Authorization Filter.

SQL-Server-2008R2

Stored Procedure for Single & List Object in ASP.NET MVC with angularJS

9 Oct 2016 by Md._Mehedi_Hasan

CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.

Hashing Passwords using ASP.NET's Crypto Class

20 Nov 2014 by Afzaal Ahmad Zeeshan

This article provides an overview of the hashing process of passwords in ASP.NET's Crypto class.

SQL Table Hierarchy

16 Aug 2016 by Alexandros Pappas

An SQL script to see the table hierarchy in a database.

SQL-Server-2008R2

Sargable query in SQL server.

12 Oct 2014 by Jitendra Ku. Sahoo

In this article we will discuss how to write Sargable query in SQL server.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Sql Server In Clause With Multiple Literal Values Performance Behaviour

26 Aug 2016 by Neeraj Prasad Sharma

This article deals with performance difference with literal values

SQL-Server-2008

SQL-Server-2005

SQL recursive common table expression in Project Scheduling practice

14 Oct 2015 by csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

SQL-Server-2008

SQL-Server-2008R2

stored-procedure

Custom Queries with RAW SQL under ADO.NET EF

15 Jun 2014 by Tamas Lorincz

Deploying Web Applications using Team Foundation Build Server – Part 2 (Database Deployment)

30 Jul 2014 by mkalos

Learn how to deploy database schema using Team Foundation Server

SQL-Server-2008R2

MyBatis.NET

21 Dec 2016 by John C Rayan

MyBatis.NET as DataMapper

SQL-Server-2008R2

Creating and Consuming Web API hosted on Azure Emulator

25 Jul 2014 by Kumarbs

In this article we are going to see how we can consume a web api which is hosted on Cloud Azure service

SQL-Server-2008R2

Govern and control your server ressources Using SQL Server

19 May 2017 by Christian Luketa Kanyinda

This article will allow you to govern your resources and to control them to optimize your server

SQL-Server-2008R2

How to Send Mail Using SQL Server: Part 3

27 Mar 2016 by Manish kumar choudhary

In this article, I will explain how to schedule a daily mail from SQL Server 2008.

SQL-Server-2012

SQL-Server-2008R2

E-Commerce Product Management Database Model with Coder's and DBA Perspective

10 Apr 2016 by Abhinav Kumar singh (Aman)

Learn an interesting way to design database with coder's perspective

SQL-Server-2008R2