SQL-Server-2008R2

Great Reads

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

by Nirosh

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

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

by Md. Marufuzzaman

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

A Simple Example of Microsoft SQL Server Pad String

by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

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.

Latest Articles

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

by Nirosh

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

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

by Md. Marufuzzaman

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

A Simple Example of Microsoft SQL Server Pad String

by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

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.

All Articles

top

SQL-Server-2008R2

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

by Nirosh

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

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.

Another C# SQL class

by formlesstree4

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

Authorization Filters in ASP.NET Web API 2 & AngularJS

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.

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

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.

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

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.

Create First SSRS Report with SQL Server Analysis Services OLAP Cube

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

Create Primary Key using Entity Framework Code First

by Dukhabandhu Sahoo

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

Creating and Consuming Web API hosted on Azure Emulator

by Kumarbs

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

Creating Report using Report Builder and Oracle DB - Part 2

by Snesh Prajapati

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

Custom Queries with RAW SQL under ADO.NET EF

by Tamas Lorincz

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

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.

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

by mkalos

Learn how to deploy database schema using Team Foundation Server

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

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

Differences Between Various Joins in MS SQL Server

by DiponRoy

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

Downgrade SQL Server 2008R2 from Enterprise to Standard Edition

by KASQLDBA

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

Drawing shapes on spatial tiles with SQL CLR

by Den367

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

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

by Abhinav Kumar singh (Aman)

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

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

by _Asif_

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

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

FOR XML Basics (EXPLICIT Mode): 3 of 4

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

FOR XML Basics (RAW Mode): 1 of 4

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

Govern and control your server ressources Using SQL Server

by Christian Luketa Kanyinda

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

Handle errors in WCF with and without FaultContract attributes.

by Bimaln

Handle errors in Wcf.

Handling NULL in T-SQL

by Bhim B Thapa

Handling NULL in T-SQL

Hashing Passwords using ASP.NET's Crypto Class

by Afzaal Ahmad Zeeshan

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

Highcharts in asp.net using jquery ajax

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

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

by Afzaal Ahmad Zeeshan

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

How to Embed Barcodes in Your SSRS Report

by Philipp Katscher

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

How to Send Mail Using SQL Server: Part 3

by Manish kumar choudhary

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

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

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.

Multi-Tenancy System With Separate Databases in MVC

by Gavin Coates

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

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

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

MyBatis.NET

by John C Rayan

MyBatis.NET as DataMapper

Optimistic Concurrency in Entity Framework Code First

by Dukhabandhu Sahoo

Handle optimistic concurrency using Entity Framework Code First.

Reading Acrofields from PDF Files

by DotNetSteve

Variety is the spice of life - rewarding PDF AcroForm reader

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

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.

RESTful SignalR Service

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.

Retrieve/Update SQL Records based on Barcodes

by Philipp Katscher

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

Sargable query in SQL server.

by Jitendra Ku. Sahoo

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

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

by Khademul Basher

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

SOAP message in WCF services.

by Bimaln

Describe about the SOAP message in WCF with example.

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

by DiponRoy

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

SQL recursive common table expression in Project Scheduling practice

by csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

SQL server error details.

by Jitendra Ku. Sahoo

Overview of SQL server error anatomy.

Sql Server In Clause With Multiple Literal Values Performance Behaviour

by Neeraj Prasad Sharma

This article deals with performance difference with literal values

SQL Server: Detect Circular Relations In A Relational Database

by DiponRoy

Table Hierarchy or Generation Finder For Relational Database In SQL Server

SQL Table Hierarchy

by Alexandros Pappas

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

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

by Md._Mehedi_Hasan

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

Strategy considerations when migrating ASP.NET forms to MVC

by Stewa11

A simple case study

Strategy considerations when migrating ASP.NET forms to MVC

by Stewa11

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

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.

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

by Sergey Kizyan

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

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

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

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.

Use SQL to develop your REST API

by Ole Oren

Fast and simple REST development for SQL devs

Web-based real-time SQL Server Performance Dashboard

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.