Click here to Skip to main content
14,577,604 members

SQL-Server-2008R2

Great Reads

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
by Muhammad Hassan Tariq
Glimpse Extension for server side debugging and diagnostic information of ASP.NET applications
by PIEBALDconsult
A stored procedure I use to find duplicate records in tables and views.
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

by DiponRoy
A utility query to find table generations in SQL Server relational database.
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.
by DiponRoy
How to do string split and join in SQL Server
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

Sort by Score

SQL-Server-2008R2 

20 Jun 2014
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
29 Aug 2018
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.
28 Dec 2014
Snesh Prajapati
In this article series, I am sharing how to create report using Report Builder by fetching data from Oracle DB.
17 Mar 2015
Sergey Kizyan
This article explains how to merge your local SQL DB content to Azure DB from scratch
13 Aug 2015
KASQLDBA
Downgrading from Enterprise to standard edition (SQL server) for those servers which are not using any of enterprise features.
29 Sep 2015
DotNetSteve
Variety is the spice of life - rewarding PDF AcroForm reader
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format
1 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format
11 Jul 2014
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.
18 Aug 2014
DiponRoy
Here, we will see the basic differences or similarities between various joins of MS SQL Server.
26 Oct 2014
Bimaln
Describe about the SOAP message in WCF with example.
21 Oct 2014
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.
3 Oct 2016
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.
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format
4 Sep 2014
Dukhabandhu Sahoo
Explore the Entity Framework Code First convention and configuration for creating primary key
27 Oct 2015
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.
20 Jul 2014
Mubin M. Shaikh
This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube
26 Jun 2014
Philipp Katscher
Fetching Records from a DB using Barcode and updating the same or others with this nifty configurable tool
13 Nov 2014
Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
15 Sep 2014
DiponRoy
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
29 Sep 2014
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
6 Dec 2015
Den367
Short glance at drawing on geographical tiles by using of Microsoft.SqlServer.Types assembly.
3 Apr 2019
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.
22 Sep 2014
Jitendra Ku. Sahoo
Overview of SQL server error anatomy.
31 Mar 2014
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
20 Nov 2014
Khademul Basher
This article describes the AngularJS JavaScript framework and shows how to use it to develop a Single Page Application.
1 Apr 2014
formlesstree4
Another article on C# .NET SQL, but with smarts
27 Jun 2014
Philipp Katscher
How to use barcodelib generated Barcodes in SSRS (consider Barcode fonts don't work in runtime)
16 Oct 2014
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.
30 Sep 2014
Afzaal Ahmad Zeeshan
This article tells the beginners the basic concepts about connecting to the SQL Server database using C#.
1 Oct 2014
Dukhabandhu Sahoo
Handle optimistic concurrency using Entity Framework Code First.
4 Mar 2015
DiponRoy
Table Hierarchy or Generation Finder For Relational Database In SQL Server
21 Jul 2014
_Asif_
Article will demonstrate how to develop generalize framework for creating Outlook style Auto Refresh Count of Menu Items
20 Jan 2017
Ole Oren
Fast and simple REST development for SQL devs
23 Aug 2014
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
16 Aug 2016
Alexandros Pappas
An SQL script to see the table hierarchy in a database.
26 Jun 2015
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.
3 Oct 2017
Gavin Coates
Creating a multi-tenancy system where each tenants data is stored in a separate database, using ASP.NET MVC
1 Jun 2014
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.
3 Jul 2016
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.
9 Oct 2016
Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
20 Nov 2014
Afzaal Ahmad Zeeshan
This article provides an overview of the hashing process of passwords in ASP.NET's Crypto class.
12 Oct 2014
Jitendra Ku. Sahoo
In this article we will discuss how to write Sargable query in SQL server.
26 Aug 2016
Neeraj Prasad Sharma
This article deals with performance difference with literal values
25 Jul 2014
Kumarbs
In this article we are going to see how we can consume a web api which is hosted on Cloud Azure service
19 May 2017
Christian Luketa Kanyinda
This article will allow you to govern your resources and to control them to optimize your server
27 Mar 2016
Manish kumar choudhary
In this article, I will explain how to schedule a daily mail from SQL Server 2008.
10 Apr 2016
Abhinav Kumar singh (Aman)
Learn an interesting way to design database with coder's perspective
29 May 2015
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.
7 Apr 2014
Stewa11
This case study suggests starting with decoupling the aspx/aspx.cs into the View's CSS3, HTML5, javascript, AJAX and JSON