Click here to Skip to main content

Submit your article

SQL Server 2008

SQL-Server-2008

Great Reads

How to Set Default Value or Binding for BLOB DataTypes on SQL Server

by Wonde Tadesse

This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

Create & Populate Time Dimension with 24 Hour+ Values

by Mubin M. Shaikh

Create time dimension with 24 hour plus values and time buckets in your data warehouse

Zip Rendering Extension for SQL Server Reporting Services 2005/2008/2012

by Harmen Brouwer

How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.

Rename a Database and its MDF and LDF files in SQL Server

by Tecfield

This tip shows how to rename a database and its MDF and LDF files in SQL Server.

Latest Articles

Export All Tables from Microsoft SQL Server Database in Flat File format (csv, txt) at one Go !!

by Mubin M. Shaikh

Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format

by Alaa Ben Fatma

Explore your MMSQL server tables in a professional way

Security on the Web by Advanced Encryption Standard (AES) and Security Assertion Markup Language (SAML)

by Mahsa Hassankashi

Best approach for having more secure channel to transfer user information throughout the web

Automatic Table Generation in any Database by NHibernate ORM and CodeDom for Code Generation

by Mahsa Hassankashi

This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.

All Articles

SQL Server 2008

A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET

22 Aug 2014 by Gurdeep Singh Toor

A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.

A general-purpose service engine for unattended processing execution

23 Sep 2015 by Alberto Venditti

Using a .NET Windows service as an engine for specialized custom plug-ins execution

SQL-server-2000

A LINQ Tutorial: Adding/Updating/Deleting Data

11 Dec 2009 by Abby Fichtner (Hacker Chick)

A tutorial that walks through adding/updating/deleting data in your database with LINQ to SQL while keeping your class relationships (M:M, 1:M, and M:1) synchronized.

SQL-Server-2008

A LINQ Tutorial: Mapping Tables to Objects

12 Dec 2009 by Abby Fichtner (Hacker Chick)

A beginner's LINQ tutorial that walks you through mapping your SQL Server database tables and relationships to objects, and how to retrieve that data via simple LINQ queries.

SQL-Server-2008

A LINQ Tutorial: WPF Data Binding with LINQ to SQL

11 Dec 2009 by Abby Fichtner (Hacker Chick)

A tutorial and application on using WPF Data Binding with LINQ to SQL classes. This is part 3 of a three-part tutorial on using LINQ to SQL.

SQL-Server-2008

A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation

27 Apr 2011 by Niladri_Biswas

This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.

SQL-Server-2008

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 5

19 Sep 2009 by Paul Rony

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application

SQL-Server-2005

SQL-server-2000

A scheduler GUI for SQL Server Agent

10 May 2012 by Alberto Venditti

An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs

SQL-Server-2008

A simple example of SQL server admin tools.

13 Sep 2009 by Md. Marufuzzaman

A simple example of SQL server admin tools.

SQL-Server-2005

SQL-server-2000

A Simple Use of SQL CASE Expression

19 Aug 2009 by Md. Marufuzzaman

This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

A uniform interface for large texts for a C# SQL client

26 Jul 2009 by AlexS9999

The article provides a simple interface for handling large text in SqlClient and C# file streams.

SQL-Server-2008

SQL-Server-2005

Abstract Nonsense in Software Development. Databases

18 Jan 2014 by Petr Ivankov

Application of abstract approach to database domain

An Alternative to Sync Data from SQL Server to MySQL

16 Aug 2012 by scott_liu

It employs a dynamic trigger, a CLR Stored Procedure, and a Web Service to sync data from a MS SQL Server to MySQL.

An Easy But Effective Way to Split a String using Transact-SQL

9 Aug 2009 by Md. Marufuzzaman

This article will demonstrate how to split a string using Transact-SQL.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

An Easy Way to Get a File Name or a File Extension from a User Defined File Path using Transact-SQL

9 Aug 2009 by Md. Marufuzzaman

This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

An End-To-End LightSwitch HTML Example

15 Jun 2013 by defwebserver

Step-by-step tutorial to create a HTML5 LightSwitch application

An indespensible SSIS transformation component - Script Component

9 May 2011 by Niladri_Biswas

This article will demonstrate as how to work with SSIS Script component with two live example

SQL-Server-2008

An Introduction to Sql 11 (Code Name Denali) -Part IV (Contained Database in CTP 1)

19 May 2011 by Niladri_Biswas

In this article we will look into the basics of Contained Database that has been shipped with Sql 11 (Code Name: Denali) CTP 1

SQL-Server-2008

An Introduction to Sql 11 (Code Name Denali) –Part III (SSIS Features in CTP 1)

9 May 2011 by Niladri_Biswas

In this article we will explore on the new features that Denali has offer us from SSIS perspective

SQL-Server-2008

An Introduction to Sql 11 (Code Name Denali) –Part VI (T-Sql Features in CTP 3)

1 Sep 2011 by Niladri_Biswas

In this article we will explore on the new features that Denali CTP 3 has offer us from a T-Sql perspective

SQL-Server-2008

An Introduction to Sql 11 (Code Name Denali) –Part VII (Column Store Index in CTP 3)

1 Sep 2011 by Niladri_Biswas

In this article we will explore on the Column Store Index- A new feature in SSIS Denali CTP3

SQL-Server-2008

An Introduction to Sql 11 (Code Name Denali) –Part VIII (Data Quality Services(DQS) in CTP 3)

3 Sep 2011 by Niladri_Biswas

In this article we will explore the Data Quality Services(DQS)- A new feature in SSIS Denali CTP3

SQL-Server-2008

An Introduction to SSIS Balanced Data Distributor Transformation Component

30 Aug 2011 by Niladri_Biswas

In this tutorial, we will learn about SSIS Balanced Data Distributor (BDD)

SQL-Server-2008

Arabic currency conversion from numbers to letters

9 Aug 2009 by Wael R. Mansour

Convert numbers to characters for Arabic applications.

SQL-Server-2008

SQL-Server-2005

Architecture Guide: Windows Forms, Generics, Auto-Mapper, Entity Framework, Framework Design, and many more..

12 Dec 2013 by Nirosh

Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.

SQL-Server-2005

Audits on MS SQL Server 2008

8 Mar 2011 by Keshav Singh

An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.

SQL-Server-2008

Auto Adjusting Date Ranges on Entry of a New Range using SQL

27 Sep 2009 by acarpio1975

Given date ranged data, adjust existing ranges on entry of a new ranged data.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Automatic Table Generation in any Database by NHibernate ORM and CodeDom for Code Generation

3 Apr 2019 by Mahsa Hassankashi

This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.

SQL-Server-2008

AutoRefresh Entity Framework Data Using SQL Server Service Broker

14 Sep 2012 by Harry von Borstel

How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes

SQL-Server-2008

SQL-Server-2005

Backup SQL Server with Relative File Path and Progress

11 Jun 2010 by theit8514

This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.

SQL-Server-2008

SQL-Server-2005

Binary Copy files in T-SQL with helps of CLR

22 Jan 2013 by Levente Kupás

Managing SQL backups can be more simple by using this FileRelay CLR

SQL-Server-2008

SQL-Server-2005

Build a Silverlight 2 Web Chat Application

12 Feb 2009 by junnark

We are going to build a simple web chat application using Silverlight 2 and the technologies surrounding it like, ASP.NET 3.5, C#, WCF, and LINQ-to-SQL. We will use MS SQL Server to store user details and messages from this chat room.

SQL-Server-2005

Build a Silverlight Web Chatroom with Multiple Rooms and Private Chat - Part 2

16 Mar 2009 by junnark

In Part 1, we built a simple web chat using Silverlight 2. We are going to add functionalities so that users are able to choose from multiple chat rooms as well as chat privately with other users.

SQL-Server-2005

SQL-server-2000

Building a Hybrid Active Directory and SQL Table DataSource View

8 Jun 2009 by noahhath

Building a hybrid Active Directory and SQL table DataSource view.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Building High Performance Queue in Database for storing Orders, Notifications, Tasks

11 Jun 2011 by Omar Al Zabir

Building High Performance Queue in Database for storing Orders, Notifications, Tasks

SQL-Server-2008

SQL-Server-2005

Business Logic with Entity Framework

26 May 2009 by Bishoy Demian

How to use Entity framework to do some basic logic when a change happens in related Entities or Associations

SQL-Server-2005

C# and Table Value Parameters

20 Aug 2009 by gaurav_verma_mca

How to send bulk data using table value parameters from C#

C# Project on Database for Beginners

6 Jan 2014 by Hasan Habib Surzo

Class, Database Connection, Login Winform

SQL-Server-2005

Cache IQueryable for Better LINQ-to-SQL Performance

21 May 2012 by Zimin Max Yang

An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.

SQL-Server-2005

Calculating simple running totals in SQL Server

12 Dec 2014 by Wendelius

Some simple scenarios to calculate running totals in SQL Server.

SQL-Server-2008

Calculating Tree Cost in Microsoft SQL Server

2 Jan 2014 by mihirj

This article explains database schema design for storing tree structure and an algorithm to compute its cost.

SQL-Server-2008

Cancellable SQL Server Query

23 Jul 2012 by Scott G Blood

A Cancellable threaded query for SQL Server using .net 3.5

SQL-Server-2008

SQL-Server-2005

Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode

23 Oct 2009 by Md. Marufuzzaman

Cannot alter Microsoft SQL Server 2008 Table Object in design mode

SQL-Server-2008

CDC - Change Data Capture

13 Sep 2009 by Donsw

Audit of SQL inserts, udpates, and deletes

SQL-Server-2008

Change Data Capture (SQL Server 2008)

11 Aug 2008 by Muhammad Shujaat Siddiqi

Change Data Capture in SQL Server 2008 (shujaatsiddiqi.blogspot.com)

SQL-Server-2008

CLR Stored Procedure and Creating It Step by Step

22 Aug 2009 by Virat Kothari

CLR Stored procedures are very simple and can be used in most complex scenarios when dealing with database.

SQL-Server-2005

Code First Approach using Entity Framework 4.1, Inversion of Control, Unity Framework, Repository & Unit of Work Pattern and MVC3 Razor View

26 Nov 2014 by Akhil Mittal

My effort in this article was to put some light on building a generic multilayered architecture using Entity Framework 4.1 and MVC3 razor view engine.

SQL-Server-2008

Committable Transactions in C#/SQL

31 Jan 2010 by skennedyny

Simple console app which shows how to use the .NET CommittableTransaction class

SQL-Server-2008

Common Table Expressions(CTE) in SQL SERVER 2008

7 Oct 2011 by Sunitha Sudheesh

Coding in SQL with Common Table Expressions (CTE)

SQL-Server-2008

Configuring IIS, ASP.NET, and SQL Server

29 Oct 2013 by Juan Davel

This article is an updated one discussing the configuration of IIS, ASP.NET and SQL Server.

SQL-Server-2008

Configuring SQL Server Accent-Insensitivity

21 Feb 2012 by Daniel Miller

This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.

SQL-Server-2008

Connection Pooling in ASP.NET

5 Dec 2009 by Muhusin Khan

Effective perfomance for database application uses database

SQL-Server-2005

Connection Pooling in multithreaded applications

1 Mar 2010 by User-Rock

Approaches describing a design to handle connection objects and pools in C#.

SQL-Server-2005

Connectivity to SQL Azure in Microsoft SQL Server 2008 R2 November CTP

17 Nov 2009 by Ramy Mahrous

Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1

SQL-Server-2008

Constructing Web Interfaces on the Fly

26 Jan 2009 by Gil Shabat

Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.

SQL-Server-2005

SQL-server-2000

Consuming a Web Service created through Sql Server HTTP Endpoints via Web Service task in SSIS

19 May 2011 by Niladri_Biswas

In this article we will see how we can consume a web service expose through HTTP Endpoint via Web Service Task of SSIS

SQL-Server-2008

SQL-Server-2005

Consuming Webservice using JQuery ASP.NET Application

18 Mar 2010 by Rajendra Malav

Consuming webservice using JQuery ASP.NET application

SQL-Server-2008

Continuous Integration for Databases with Visual Studio

23 Nov 2010 by Adam Nachman

Provides a framework for predictably compiling, extracting, and deploying a database project.

SQL-Server-2005

Copy Files from One Location to Another and Rename Them after Putting Time Stamp

27 Apr 2011 by Niladri_Biswas

A program to demonstrate the copy files from one location to another and rename them after putting time stamp by using Sequence Container, Foreach Loop Container, File System Task and Script task

SQL-Server-2008

Create and Populate Date Dimension for Data Warehouse

4 Sep 2013 by Mubin M. Shaikh

This article shows how to create and populate date dimension for data warehouse.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Create custom transformation component(Email Validator) in SSIS- Step by step

3 Aug 2011 by Niladri_Biswas

In this article we will look into how we can make a custom SSIS transformation component.The custom component is a simple

SQL-Server-2008

Create INSERT batch files easily with ScriptBuilder

8 Dec 2009 by Gordon Kushner

Utility program for generating SQL Server INSERT scripts

SQL-Server-2005

SQL-server-2000

Custom Membership Providers - Task Manager

9 Apr 2011 by Karthik. A

This article extends what was built in the previous article. This is a task manager application that uses the custom provider designed in the last part.

SQL-Server-2005

Custom paging with ASP.NET GridView

26 Jun 2012 by tanweer

Easy way to implement ASP.NET GridView paging .

Custom Rule Engine in WPF - MVVM

11 Sep 2010 by Renil Joy, Bangalore

Custom Rule Engine approach which can evaluate complex combinations of business rules. A sample application is provided in WPF following the MVVM pattern.

SQL-Server-2005

Data Structure Implementation to Query Binary Tree for Upline / Downline Node without using Recursion

9 Dec 2010 by AnupKumarYadav

Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Data Transformation from Rows to Columns Using Dynamic SQL

2 Jan 2013 by Tomz_KV

A custom solution to transform data from rows to columns using dynamic SQL.

SQL-Server-2008

Database Documentation - Microsoft SQL Server 2005/2008

2 Mar 2009 by pavan k vadlamudi

Creates database documentation table(s) schema

SQL-Server-2008

SQL-Server-2005

DataBinding in WPF Browser Application using SQL Server Compact

22 Aug 2011 by RameshSengamalai

DataBinding in WPF Browser Application using SQL Server Compact

Date and Time as Separated Types

25 May 2010 by iMuhamad

use date and time as separated components in SQL Server 2000 and above

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

DbExpressions - A Step Towards Independency

2 Feb 2011 by seesharper

An abstract syntax tree implementation for SQL

DBMapper - A New ORM Tool

2 May 2013 by Koray Dakan, PMP

DBMapper - A new ORM tool for vendor-neutral solutions

SQL-Server-2005

DbProvider Profiler using WCF and DbProviderFactory Injection: Part II of IV

20 Sep 2011 by Pieter Van Parys

Creating profiling information in our ProxyDbxxx classes

SQL-Server-2005

Delete duplicate entries from a data store while leaving a single copy

5 Apr 2009 by Tarek Najem

How to delete duplicate entries from a data store, while leaving a single copy.

SQL-Server-2008

SQL-Server-2005

Deploying Reports in Reporting Services Programmatically

30 Oct 2009 by Ramy Mahrous

How to deploy your reports programmatically in away like BIDS

SQL-Server-2005

Detailed SQL Server data audit through a .NET (CLR) trigger

19 Dec 2011 by David Catriel

Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.

SQL-Server-2005

Direct access to C++ native code from C++/CLI MSSQL Stored Procedure

19 Sep 2014 by Konstantin Tchoumak

Reading hardware information in Stored Procedure

Distributed Transaction between Microsoft SQL Server and MariaDB - A Myth

23 Oct 2013 by BharatRamV

Distributed transaction between MS SQL Server and MariaDB - A myth.

SQL-Server-2008

Duplicate Rows/XML-Nodes Identification and Clean-up from Database

27 Nov 2013 by S. M. Ahasan Habib

In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.

SQL-Server-2008

SQL-Server-2005

Dynamic Cross Tabs and Pivots, A Different Approach

22 Sep 2010 by Kannan K R

In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Dynamic Excel file loading with SSIS

23 Apr 2012 by Kuthuparakkal

SSIS and Excel Automation

SQL-Server-2008

Dynamically Create ASP Form from SQL Stored Procedure

17 Jul 2013 by Tom Glick Philadelphia, US

Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)

Dynamically creating Excel File, ExcelSheets and Exporting Data from SQL Server using SSIS 2005

15 Jan 2012 by Venkat Chaitanya Kanumukula

Export SQL Server Tables to Excel Files Dynamically

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Dynamics AX Data Maintenance & Migration Tips

29 Jun 2012 by Venkat Chaitanya Kanumukula

Maintenance of Definition's in multiple Dynamics AX Environments

SQL-Server-2008

Efficient Paging with Repeater and SQL Server 2005 / 2008

16 Dec 2011 by perels

An efficient implementation of paging using a Repeater and the OVER() keyword in SQL Server 2005.

SQL-Server-2008

SQL-Server-2005

Enterprise Configuration Management

23 Nov 2009 by gaurav_verma_mca

Configuration of .NET applications using database

SQL-Server-2005

Entity Framework Performance

12 Mar 2012 by Not Active

A comparison of performance between ADO.NET and Entity Framework.

Event-Driven Architecture in the Clouds with Windows Azure

5 Feb 2010 by John Mokkosian-Kane, Daniel Hsu

To demonstrate Azure and EDA, this article will show you how to build a flight delay management system for all US airports in clouds with Windows Azure.

SQL-Server-2008

Executing a Web Service in a CLR Based Table Valued Function and Representing its IEnumerable Type Output as a Table in SQL Server

16 Jun 2010 by Akbar Ali Bhatti

Executing a web service in a CLR based Table Valued Function resolving the problems faced during its execution and finally representing the IEnumerable output as a table in SQL Server.

SQL-Server-2008

SQL-Server-2005

Export All Tables from Microsoft SQL Server Database in Flat File format (csv, txt) at one Go !!

14 Jul 2020 by Mubin M. Shaikh

Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format

SQL-Server-2008

Exporting Stored Procedure Results into Tables Dynamically with T-SQL

11 Jan 2012 by Venkat Chaitanya Kanumukula

T-SQL Code for Converting Stored Procedure results to Tables Dynamically

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Fast declarative typesafety with DynamicMethods for SQL

16 Oct 2013 by tcassisi

Generating typed field accessors and applying them to object mapping and SQL Stored Procedures

SQL-Server-2008

Few Step(s) to Remove SQL Server Database User(s)

20 Mar 2010 by Md. Marufuzzaman

Few step(s) to remove SQL Server database user(s) when you are facing error like “The database principal owns a database role and cannot be dropped.” for dropping a user.

SQL-Server-2008

SQL-Server-2005

Find multiple strings in selected columns

28 Aug 2012 by akhil khare

Find multiple strings (delimenated by space) in all selected columns.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Fingerprint Reader Integration using the M2SYS SDK

10 Aug 2009 by Friedrich Brunzema

An article exploring integrating a fingerprint reader into a user's application

FIPS Encryption Algorithms and Implementation of AES in C# and SQL Server 2008

2 Oct 2013 by Dnyaneshwar Pawar

Implementation of AES in C# and SQL Server 2008.

SQL-Server-2008

FOR XML Basics (AUTO Mode): 2 of 4

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

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL-Server-2008

FOR XML Basics (EXPLICIT Mode): 3 of 4

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

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL-Server-2008

Generate Classes and CRUD Procedures

5 May 2009 by ColinBashBash

Generate classes / CRUD procedures.

SQL-Server-2005

SQL-server-2000

Generate SQL Script Programmatically

8 Sep 2009 by Md. Marufuzzaman

How to generate SQL object script using C#.NET

SQL-Server-2005