Click here to Skip to main content
15,867,835 members
Everything / Database Development / SQL Server / SQL Server 2008R2

SQL Server 2008R2

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 Title

SQL Server 2008R2 

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.
1 Apr 2014 by formlesstree4
13 Nov 2014 by Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
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.
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.
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.
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
4 Sep 2014 by Dukhabandhu Sahoo
Explore the Entity Framework Code First convention and configuration for creating primary key
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
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.
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.
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
18 Aug 2014 by DiponRoy
Here, we will see the basic differences or similarities between various joins of MS SQL Server.
13 Aug 2015 by KASQLDBA
Downgrading from Enterprise to standard edition (SQL server) for those servers which are not using any of enterprise features.
6 Dec 2015 by Den367
Short glance at drawing on geographical tiles by using of Microsoft.SqlServer.Types assembly.
10 Apr 2016 by Abhinav Kumar singh (Aman)
Learn an interesting way to design database with coder's perspective
21 Jul 2014 by _Asif_
Article will demonstrate how to develop generalize framework for creating Outlook style Auto Refresh Count of Menu Items
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
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
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
19 May 2017 by Christian Luketa Kanyinda
This article will allow you to govern your resources and to control them to optimize your server
20 Nov 2014 by Afzaal Ahmad Zeeshan
This article provides an overview of the hashing process of passwords in ASP.NET's Crypto class.
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
30 Sep 2014 by Afzaal Ahmad Zeeshan
This article tells the beginners the basic concepts about connecting to the SQL Server database using C#.
27 Jun 2014 by Philipp Katscher
How to use barcodelib generated Barcodes in SSRS (consider Barcode fonts don't work in runtime)
27 Mar 2016 by Manish kumar choudhary
In this article, I will explain how to schedule a daily mail from SQL Server 2008.
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.
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
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
21 Dec 2016 by John C Rayan
1 Oct 2014 by Dukhabandhu Sahoo
Handle optimistic concurrency using Entity Framework Code First.
29 Sep 2015 by DotNetSteve
Variety is the spice of life - rewarding PDF AcroForm reader
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.
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.
26 Jun 2014 by Philipp Katscher
Fetching Records from a DB using Barcode and updating the same or others with this nifty configurable tool
12 Oct 2014 by Jitendra Ku. Sahoo
In this article we will discuss how to write Sargable query in SQL server.
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.
26 Oct 2014 by Bimaln
Describe about the SOAP message in WCF with example.
15 Sep 2014 by DiponRoy
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
22 Sep 2014 by Jitendra Ku. Sahoo
Overview of SQL server error anatomy.
26 Aug 2016 by Neeraj Prasad Sharma
This article deals with performance difference with literal values
4 Mar 2015 by DiponRoy
Table Hierarchy or Generation Finder For Relational Database In SQL Server
16 Aug 2016 by Alexandros Pappas
An SQL script to see the table hierarchy in a database.
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.
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
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.
17 Mar 2015 by Sergey Kizyan
This article explains how to merge your local SQL DB content to Azure DB from scratch
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
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.
20 Jan 2017 by Ole Oren
Fast and simple REST development for SQL devs
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.