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

Restart a SQL Server Scheduled Job If Hanged

15 Jul 2014 by anki.mathur

Restart hanged SQL Server scheduled job

SQL-Server-2014

SQL-Server-2008R2

How to Get Words Separated in a String Concatenated by Delimiter

14 Apr 2014 by Ankur .K. Vishwakarma

This tip shows you a T/SQL function to split a string concatenated by a delimiter.

SQL-Server-2008R2

Connect Visio 2007 to any SQL Server Version after SQL Server 2005

16 Sep 2014 by Anusheel Kamle

How to connect Visio 2007 to SQL Server 2008 R2 for reverse engineering

SQL-Server-2008R2

Using only TCP/IP for connecting to SQL Server 2008 and Changing the SQL Server 2008's default TCP/IP port

9 Apr 2014 by Aqeeel

Implementing security in SQL Server by only allowing TCP/IP Network Protocol and changing default TCP port

SQL-Server-2008R2

Identifying and Deleting Duplicate Records from SQL Server Table

1 Jun 2016 by Aqeeel

Identifying and deleting duplicate records from SQL Server Table

SQL-Server-2008

SQL-Server-2008R2

SQL-Server-2012

How to Improve Performance of Query

8 Oct 2014 by Arora_Ankit

This tip will provide you with an idea about basic things that you can use to get better performance from query.

SQL-Server-2008R2

Import CSV or txt File Into SQL Server Using Bulk Insert.

21 May 2014 by Arvind Singh Baghel

Import CSV or txt File Into SQL Server Using Bulk Insert.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Find the Size of Database mdf and ldf File in sql server

30 Oct 2014 by Arvind Singh Baghel

I show a SQL query which finds the size of database mdf and ldf file in SQL Server.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

SQL Server Health Check Script with Powershell

3 Dec 2014 by Atul_Kapoor

Perform SQL Server Instance health check simultaneously on more than one server using Powershell

SQL-Server-2008

SQL-Server-2005

Rename file using MS sql server(xp_cmdshell), GetAllFileDetails in MS SqlServer (xp_getfiledetails)

1 May 2015 by Avinash Narnaware

Rename file using MS sql server using xp_cmdshell rename, while file name contain space. Get All file Details in MS Sqlserver 2008 using xp_getfiledetails.

SQL-Server-2008R2

How to Get SQL Column Values as Comma Separated String using XML Path Method

16 Oct 2014 by banitabisht

Tip to get comma separated string for a column in SQL query using XML path method

SQL-Server-2008R2

Request for the Permission of Type System.Web.AspNetHostingPermission

23 Sep 2014 by Bimaln

Solved the Permission issue when I hosted my ASP.NET application on IIS7

SQL-Server-2008R2

Handle errors in WCF with and without FaultContract attributes.

26 Oct 2014 by Bimaln

Handle errors in WCF.

SQL-Server-2008R2

SOAP message in WCF services.

26 Oct 2014 by Bimaln

Describe about the SOAP message in WCF with example.

SQL-Server-2008R2

Some Common Mistakes When Querying SQL Database

22 Jun 2014 by Bohdan Stupak

This tip will cover several interesting issues of SQL

SQL-Server-2012

SQL-Server-2008R2

Money Precision Issues

15 Feb 2015 by Bohdan Stupak

This tip shows some primary issue which puts a serious limitation on SQL Server MONEY data type.

SQL-Server-2012

SQL-Server-2008R2

Dynamic Pivot Query in SQL Server

22 Jul 2015 by Chetan Naithani

Transforming dynamic row-level data into columns

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Creating a SSRS Report With Microsoft Dynamics CRM On-line

12 Jun 2015 by coded007

Designing reports with Dynamics CRM

SQL-Server-2012

SQL-Server-2008R2

Using SMO to script all SQL jobs for an instance using C#.Net

25 Jan 2015 by Colm Hoban

A command line utility to script out all jobs from an instance to be used to transfer jobs to another server/environment or to be deposited in source control.

SQL-Server-2008R2

SQL Server Database Backup Status Report

5 Jun 2015 by Dathuraj Pasarge

Know whether your databases are backed up successfully in the last 24 hours or not !!!

SQL-Server-2005

SQL-Server-2008

SQL-Server-2008R2

SQL-server-2000

Creating a SQL Server Database Project Use in Visual Studio 2012 and Use TFS for Version Control

8 Jun 2015 by Diluka Wittahachchige

Creating SQL Server database project use in Visual Studio 2012 and maintain versions use in TFS

SQL-Server-2008

SQL-Server-2005

Post rowversion or timestamp of MsSQL using jquery

22 Jul 2014 by DiponRoy

How to post rowversion or timestamp of MsSQL using jquery

SQL-Server-2008R2

Entity Framework Code First Migrations Alternative

30 Jul 2014 by DiponRoy

How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first

SQL-Server-2008R2

entity-framework

SQL Server: Find Table Order/Generation And Relation Details

29 May 2019 by DiponRoy

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

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL Server: Doing String Split And Join

19 Feb 2019 by DiponRoy

How to do string split and join in SQL Server

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Table Valued Parameters in SQL 2008

5 Mar 2015 by DotNetForAll

The tip describes how the Table Valued Parameters(TVP) are used in SQl server and how they can be utilized using C# code.

SQL-Server-2008R2

How to fix "LocalDB - Requested Login failed"

20 May 2014 by Ed Nutting

How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"

Microsoft SQL: Increase Existing Value In Row Or Add New Row If None Exists

20 Mar 2015 by furytrader

Yes, Virginia, You Can Do This All With One Simple SQL Statement

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Recursive CTE in SQL Server Simplified

7 Feb 2015 by Gaurav_Chaudhary

This tip is a brief introduction to Recursive CTE in SQL Server and how to implement it.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Read & Insert Data Using Stored Procedures in C#

6 Oct 2014 by gayani dassa

Read & Insert Data Using Stored Procedures

SQL-Server-2008R2

Random Date/Time Test Data Generation

25 Aug 2016 by Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

SQL-Server-2005

SQL-server-2000

Read Data from the Next Row

21 Jun 2014 by george bolovan

Read data from the next row

SQL-Server-2012

SQL-Server-2008R2

Using NLog.net in SOA with ILogReceiverServer

25 Apr 2014 by grantliu

Utilize NLog.net in a Service-oriented architecture

SQL-Server-2012

SQL-Server-2008R2

Auto Backup Of Database in SQL Server 2008 & Above

8 Aug 2015 by Harsh Aggarwal - India

It's about making back up of database in SQL server 2008 and above you can get rid of making bak file manually.

SQL-Server-2012

SQL-Server-2008R2

Building DynamicTVP

22 Sep 2015 by hlonihloksDJ

Building DynamicTVP

SQL-Server-2008R2

Useful SQL Snippets & Own Functions for SQL Server, SQL Server CE, MySQL, SQLite, PostgreSQL

7 Mar 2015 by IAndreev93

Standard functions usage, and my own functions... Allowing you simpler process tables... Date and time... Strings...

SQL-Server-2008R2

CRUD in ASP.NET MVC 4 with KnockOut.JS

20 Jan 2016 by Indresh_Prajapati

This tip will help beginners to implement CRUD operations in ASP.NET MVC 4 with scripting language as KnockOut and Database as MS SQL 2008R2.

CRUD in ASP.NET MVC 5 using WebAPI 2 with AngularJS

22 Feb 2016 by Indresh_Prajapati

This tip will help beginners to implement CRUD operations in ASP.NET MVC 5 using WebAPI 2 with scripting language as AngularJS and Database as MS SQL 2008R2.

Save your Data from LDAP Injection Attack

9 Jul 2014 by Jason Parms

Lightweight Directory Access Protocol (LDAP) Injection

SQL-Server-2008R2

Template to Handle Error in SQL Server

29 Sep 2014 by Jitendra Ku. Sahoo

Below is one template to handle error in SQL server.

SQL-Server-2012

SQL-Server-2008R2

Fill factor in SQL server.

22 Oct 2014 by Jitendra Ku. Sahoo

In this article we will discuss about fill factor and its effect on query performance.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Experimenting with Date and Time data types in SQL SERVER 2008

11 Mar 2015 by John C Rayan

An insight into date and time types in SQL SERVER -

SQL-Server-2008R2

Easy Database Table Change History

5 Nov 2014 by Johnny L Washington

Capture data changes in history table

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

To Search Data in Multiple Columns using 'IN' Clause

21 May 2015 by King Fisher

To search data in multiple columns using 'IN' clause

SQL-Server-2008R2

8 May 2014 by kunal r somani

Regarding progress bar

SQL-Server-2008R2

Powershell script to monitor windows servers and populate it into a sharepoint list

29 Jul 2015 by LalithGallage

This powershell script is you to monitor windows servers’ free hard disk and populate it to sharepoint custom list.

SQL-Server-2008R2

Select Statement to HTML Table

2 Feb 2018 by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

SQL-Server-2008

SQL-Server-2008R2

SQL-Server-2005

MSSQL to MySQL Export

16 Apr 2014 by madagaga

Converting MSSQL database to MySQL

SQL-Server-2008R2

Running the SQL Script File By Using The System.Diagnostics.Process Class

1 Jul 2014 by madhusudhanReddy

Running the SQL Script File

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Create Insert SQL Statement from the Records in an Existing Table

8 Mar 2016 by markkang

This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database

SQL-Server-2008

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SSIS - Import Text File

16 Sep 2014 by Math08avan

SQL Server Integration Services - How to read a text file

SQL-Server-2008R2

Get accurate age by date

20 Feb 2010 by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

How to Split Microsoft SQL Server Table Row Data

18 Dec 2015 by Md. Marufuzzaman

This tip shows you an easy way to split Microsoft SQL Server table row data.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

A Simple Example of Microsoft SQL Server Pad String

18 Dec 2015 by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

A Simple and Another Way to Find Rows on n’th Maximum Number from a Table

23 Dec 2015 by Md. Marufuzzaman

A simple tip/trick to get rows on n’th maximum number from a table

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Dynamic Restore SQL Server

31 Aug 2017 by Member 10262330

Dynamic restore SQL Server

SQL-Server-2008R2

Two Way Binding using JavaScript in ASP.NET MVC With Database

8 Aug 2014 by Member 10872251

Two way binding using JavaScript

web_development

Dynamic DropDownList Binding in ASP.NET MVC With Database

14 Aug 2014 by Member 10872251

Cascading DropDownList in ASP.NET MVC

SQL-Server-2008

Performance Tuning of Insert Query

26 Jun 2014 by Member 8826598

Performance Tuning of DML Operation Insert in different scenario

SQL-Server-2012

SQL-Server-2008R2

Fastest way to find row count of all tables in SQL

24 Aug 2014 by Mihir.D.Shah

Simple Queries to find row count of all tables in a MS-SQL Database

SQL-Server-2008R2

SQL Server: Query to Get the Date of First Monday of September

12 Sep 2014 by Mohamad Cheaito

SQL Server: Query to get the date of first Monday of September

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Debug ASP.NET MVC Application with Glimpse

11 Jan 2015 by Muhammad Hassan Tariq

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

SQL-Server-2008R2

Basic Troubleshooting for Microsoft SQL Table Lock

1 Oct 2014 by NaibedyaKar

How to check the query locking the table and to unlock it

SQL-Server-2008R2

SQL-Server-2012

Update Database using Stored Procedure and DataAdapter

20 Jun 2015 by Naresh Patidar

Insert, update and delete operations using stored procedure and DataAdapter in C#

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Another Way to Get Identity from SQL Server

26 Aug 2015 by nithyananthams

Different options to get Identity from SQL Server and how OUTPUT clause helped me to get the accurate Identity value compare with other options.

SQL-Server-2012

SQL-Server-2008R2

Extracting the filename from a full path in SQL Server

19 Jan 2015 by OriginalGriff

Sometimes, you want to extract the filename (with or without the extension) from the full path of a file. It's easy in C# and so forth - just use the Path.GetFileName method. But what if you want it in SQL?

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

WPF and MVVM pattern

5 Aug 2014 by Oussama_Kahoul

Introduction to WPF technology and the MVVM design pattern

T-SQL Function: Add a space between all characters

23 Jul 2012 by Paul M Simpson

Expanding a string by inserting alternating single spaces between characters

SQL-Server-2008

SQL-Server-2008R2

SQL-Server-2005

RDLC Report Grouping with Page Break, Table Header Repeat, Group Totals and Sub Grouping

2 May 2014 by Pavith Goonathilake

RDLC Report Grouping with Page Break for each Group Type, Table Header repeat for each page and Report Totals

SQL-Server-2008R2

Unlimited Category List Table

3 Oct 2015 by Pedram_Niloufari

How to create an unlimited category list table in database and how to read category list

SQL-Server-2012

SQL-Server-2008R2

SQL Server Procedure to Report Duplicates

13 Dec 2014 by PIEBALDconsult

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

SQL-Server-2008R2

Create Table and Stored Procedure in SQL Server and connect it from ASP.NET using C#

17 Aug 2014 by Prakash Lekhak

We will create a Table and Stored Procedure in Sql Server 2008R2 and data will be inserted and retrieved by using Asp.net using C#

SQL-Server-2008R2

Relational Database Design with an Auto Insurance Database Sample

7 Oct 2014 by Prakash Lekhak

Create an ER diagram for complex database

SQL-Server-2012

SQL-Server-2008R2

CURSOR in T-SQL

9 Jul 2016 by Prakash Lekhak

Dynamic SQL to get the list Table names

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL Server 2008 Error: Saving changes is not permitted

22 Apr 2012 by Prasad CM

How to fix this error.

SQL-Server-2008R2

Insert Data Using Stored Procedure in ASP.NET

23 Apr 2014 by Rajendra D. Patel

How to insert data using stored procedure in ASP.NET

SQL-Server-2008R2

Writeback and writethrough using C#

18 Dec 2012 by rakesh1503

Writeback and writethrough using C# with SQL Server 2008 SSAS.

SQL-Server-2008

artificial-intelligence

SQL-Server-2008R2

Query that returns list of all Stored Procedures in an MS SQL database

15 Jan 2015 by Sandeep Khairha

Query that returns list of all Stored Procedures

SQL-Server-2008R2

WCF Restful Service Form Authentication

6 Nov 2014 by sandeep12jain

WCF Restful Service Authentication without SSL Certificate

SSRS Report Integration With Web Api

29 Apr 2015 by santosh poojari

The idea is to source SSRS report datasource with web api output. The datasource can take XML input datasource hence we can allow web api to give us desired XML output dataset in defined format or schema. Once we have that it is easy to sourced or housed it into SSRS reports -RDL or Client RDLC in .

SQL-Server-2008R2

Auditing Failed Logins in SQL Server: Looking Beyond Post-event Analysis

23 Sep 2014 by SatyLepide

By analyzing log-in attempts on SQL server, admins can build the complete picture out of the sequence of events that led to compliance failure or unauthorized access.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Bind Crystal Reports with Dataset or Datatable

5 Aug 2014 by saurav ray

Article determines how to bind a crystal report with a virtual database

SQL-Server-2008R2

Storing Large Binary Data in a SQLSERVER Database

5 Oct 2014 by Schrödter

How to write data to SQLSERVER varbinary(MAX) columns in C++ using ADO

SQL-Server-2008R2

Demonstration Application using MVC SignalR and Entity Framework: Part I

28 Jun 2015 by Shashank S Chandel

Demonstration application using MVC SignalR and Entity framework - Part I

SQL-Server-2008R2

Fast and Simple IDataReader Implementation to Read CSV Files

3 Oct 2015 by shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

Convert CellSet to HTML Table, and From HTML to Json, Array

17 Oct 2014 by Sibeesh KV

Convert CellSet to HTML table

SQL-Server-2008R2

Pivoting on SQL Server Varchar Data Types

22 Feb 2016 by Sifiso W Ndlovu

This tip illustrates a workaround to SQL Server pivoting on variable character data types.

SQL-Server-2005

SQL-server-2000

C# - Google Maps in WinForm with WebBrowser and Google Maps API v3

24 Mar 2015 by SMPS LLC

With this tip, you can show a map in your WinForm application with the Google Maps API v3.

SQL-Server-2008R2

Changing the Crystal Report Database credential and Logon values at runtime

20 Jul 2014 by SREENATH GANGA

How to change the DBservername ,DBName ,password,Userid etc of a crystal report at runtime

SQL-Server-2008R2

How to get output parameter values from stored procedure using Entity Framework.

13 Oct 2014 by SRS(The Coder)

This tip gives an explanation with example on how to get output parameter value from stored procedure using Entity Framework in ASP.Net

SQL-Server-2008R2

entity-framework

Tricky SQL Questions

18 Sep 2014 by sukeshchand

Unexpected SQL Interview Questions

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Cursors Vs. Sets

19 Nov 2014 by Sums Mohs Eds

A brief discussion of when to use cursors and when to use sets.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

data-visualization

TFS Backward Migration from (2012SP1\SQL 2012 ENT) to (2010 SP1\SQL 2008 R2 STD)

14 Oct 2014 by Sushil Pandit

Process for backward migration of code from TFS 2012 to TFS 2010

SQL-Server-2008R2

SQL-Server-2012

Implement Split A/B pages in your ASP NET project

20 Aug 2014 by TheCardProject.co.uk

Quickly set up the ability to serve up several pages and record which was served in SQL Server

SQL-Server-2008R2

UniDAC - database's direct connection

29 Sep 2015 by Thiago Gaidzinski

UniDAC allows you to connect your cross-platform application directly with many database's types.

Pass Parameters from Web Page to Telerik Report

19 Jan 2015 by Thinira

In this tip, we discuss how to pass report parameters from web page to Telerik report programmatically.

SQL-Server-2008R2

Dapper.NET and DapperExtensions to Run Stored Procedures

14 Sep 2015 by Vijaykumar Vadnal

We will discuss about how we can combine Dapper.NET and DapperExtensions to configure DAL to execute normal queries as well as Stored Procedures.

SQL-Server-2008R2

MVC Load Stocks Data on Runtime in a Grid View

19 Sep 2014 by Wajahat Aftab

How to load data from live market stock feed in a grid view

SQL-Server-2008R2

Test and copy files from source to destination in MS-SQL

12 Aug 2015 by XyedBilal

Copying files from source to destination using master..xp_fileexist and master..xp_cmdshell

SQL-Server-2008R2

How to Resolve: "The Data Source value in the connection string specifies an instance of SQL Server that is not installed" or "LocalDB instance does not exist"

21 Oct 2015 by yash soman

The error occurs when we try to create a new Microsoft SQL Server Database File (SqlClient) using Visual Studio IDE

SQL-Server-2008R2