Click here to Skip to main content
14,216,563 members

SQL-server-2008R2

Great Reads

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
by Snesh Prajapati
In this article series, I am sharing how to create report using Report Builder by fetching data from Oracle DB.

Latest Articles

by DiponRoy
A utility query to find table generations in SQL Server relational database.
by Mahsa Hassankashi
It is a 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
Mahsa Hassankashi
It is a simplest tutorial on AngularJS and Repository Pattern for developing professional MVC Applications. It includes a source code about practical permission management project.
2 Apr 2014
formlesstree4
Another article on C# .NET SQL, but with smarts
13 Nov 2014
Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
4 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.
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.
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.
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
4 Sep 2014
Dukhabandhu Sahoo
Explore the Entity Framework Code First convention and configuration for creating primary key.
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
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.
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.
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
13 Aug 2015
KASQLDBA
Downgrading from Enterprise to standard edition (SQL server) for those servers which are not using any of enterprise features.
7 Dec 2015
Den367
Short glance at drawing on geographical tiles by using of Microsoft.SqlServer.Types assembly.
10 Apr 2016
Abhinav Kumar singh (Aman)
Learn an interesting way to design database with coder's perspective
21 Jul 2014
_Asif_
Article will demonstrate how to develop generalize framework for creating Outlook style Auto Refresh Count of Menu Items
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
2 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
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
19 May 2017
Christian Luketa Kanyinda
This article will allow you to govern your resources and to control them to optimize your server
20 Nov 2014
Afzaal Ahmad Zeeshan
This article provides an overview of the hashing process of passwords in ASP.NET's Crypto class.
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
30 Sep 2014
Afzaal Ahmad Zeeshan
This article tells the beginners the basic concepts about connecting to the SQL Server database using C#.
27 Jun 2014
Philipp Katscher
How to use barcodelib generated Barcodes in SSRS (consider Barcode fonts don't work in runtime)
27 Mar 2016
Manish kumar choudhary
In this article, I will explain how to schedule a daily mail from SQL Server 2008.
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 Oct 2017
Gavin Coates
Creating a multi-tenancy system where each tenants data is stored in a separate database, using ASP.NET MVC
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
2 Oct 2014
Dukhabandhu Sahoo
Handle optimistic concurrency using Entity Framework Code First.
29 Sep 2015
DotNetSteve
Variety is the spice of life - rewarding PDF AcroForm reader
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.
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.
27 Jun 2014
Philipp Katscher
Fetching Records from a DB using Barcode and updating the same or others with this nifty configurable tool
13 Oct 2014
Jitendra Ku. Sahoo
In this article we will discuss how to write Sargable query in SQL server.
21 Nov 2014
Khademul Basher
This article describe the AngularJS JavaScript framework and shows how to use it to develop a Single Page Application.
26 Oct 2014
Bimaln
Describe about the SOAP message in WCF with example.
15 Sep 2014
DiponRoy
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
22 Sep 2014
Jitendra Ku. Sahoo
Overview of SQL server error anatomy.
26 Aug 2016
Neeraj Prasad Sharma
This article deals with performance difference with literal values
4 Mar 2015
DiponRoy
Table Hierarchy or Generation Finder For Relational Database In SQL Server
16 Aug 2016
Alexandros Pappas
An SQL script to see the table hierarchy in a database.
9 Oct 2016
Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
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
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.
17 Mar 2015
Sergey Kizyan
This article explains how to merge your local SQL DB content to Azure DB from scratch
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
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.
20 Jan 2017
Ole Oren
Fast and simple REST development for SQL devs
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.