Click here to Skip to main content

Submit your article

SQL Server 2005

SQL-Server-2005

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.

AJAX-enabled Name Selector User Control

by Steve Krile

Fully AJAX-enabled user control used to select names from a database in a drop-down format.

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

Notification of Silverlight Applications about Database State Changes

by Max Paulousky

This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.

Latest Articles

SQL - Pivot with Grand Total Column and Row

by Narapareddy Shyamprasad

SQL Dynamic Pivots

Select Statement to HTML Table

by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

Use RegEx in SQL with CLR Procs

by JasonShort

Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code? You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!

Code Review Checklist

by Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

All Articles

SQL Server 2005

.NET Installer that Automatically Installs SQL 2005 Express

28 Jul 2008 by John Kenedy S.Kom

This project enables developer to create a setup package that automatically installs SQL 2005 Express and restores database to it

SQL-Server-2005

13 disasters for production web sites and their solutions

6 Aug 2007 by Omar Al Zabir

Learn about 13 production disasters that can bring down your business

SQL-Server-2005

4 steps to use readymade DAL component (Data application blocks)

24 Mar 2009 by Shivprasad koirala

4 steps to use readymade DAL component (Data application blocks)

SQL-Server-2005

SQL-server-2000

5 Tips for Accelerating Your Web Site Development in ASP.NET

11 Jan 2006 by Petr Palas

Did you know there’s an easier way how to create dynamic web sites? Learn how Kentico CMS for ASP.NET will increase your productivity and help you win more clients.

SQL-Server-2005

SQL-server-2000

product-showcase

7 Questions You Always Wanted to Ask about Content Management Systems

23 May 2007 by Petr Palas

What is a content management system? Does it really work? Why should I use it? How does it help me? This article answers the most common questions developers ask about content management systems (CMS).

SQL-Server-2005

product-showcase

A conversion of the popular DotNetNuke web application to C#

11 May 2007 by andrewcates

In an attempt to open DotNetNuke to a wider audience, I have converted the original VB code into C#

SQL-Server-2005

A guide to using Paneled Forms, Multi-Splash Screens, SQL Express, and many more in Windows Application Development

19 Sep 2005 by msalmank

A quick hands-on application to guide you in using paneled forms, multi-splash screens, SQL Express, and many more....

SQL-Server-2005

A helper object to migrate SQL Reporting Service items

10 Sep 2004 by Mark Brandon

A helper object library to automate migration of SQL RS items from development to production servers.

SQL-Server-2005

SQL-server-2000

A lightweight AJAX.NET-enabled grid control

28 Jun 2008 by Simon Gulliver

A lighweight approach to creating AJAX.NET-enabled grids, with advanced functionality built in.

SQL-Server-2005

SQL-server-2000

A method to migrate and automate exisitng DSTX SSIS package from SQL server 2005 to 2008 R2

9 Mar 2011 by santosh poojari

This article will provide the first step towards migrating error free dtsx package to higher version of sql server ssis

SQL-Server-2005

A Neat Solution to GridView Custom Paging

5 Jun 2007 by Fadrian Sudaman

This article shows how to easily extend the GridView to support custom paging and remove the restriction of using ObjectDataSource as the data source.

SQL-Server-2005

A Practical Example Of Using The New Features Of ASP.NET 3.5

22 Jul 2008 by Mike Borozdin

Tutorial on using LINQ, ListView, LinqDataSource, DataPager, ASP.NET AJAX

SQL-Server-2005

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 Quick look at the new functoids in BizTalk Server 2006

20 Mar 2006 by Naveen Karamchetti

This article describes the new functoids in BizTalk Server 2006.

SQL-Server-2005

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 GUI Tool for SQL 2005 Reports Deployment Without using BI Development Studio

25 May 2008 by Ahmed IG

A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio

SQL-Server-2005

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 SQL Management Console for MSSQL 2000 & 2005, MySQL 5.0,...

20 Apr 2008 by gan.gary

An article on a SQL IDE for different type of RDBMS databases

SQL-Server-2005

SQL-server-2000

A SQLProcedure For MSSQL 2005 Of CustomPaging With RowNum And CustomPaging Without RowNum Both For MSSQL 2000 And MSSQL 2005

29 May 2009 by qubing

WITH Clause AND EXEC sp_executesql Clause Used In MSSQL 2005

SQL-Server-2005

SQL-server-2000

A T-SQL Regular Expression Library for SQL Server 2005

13 Dec 2008 by Steve Abraham

This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.

SQL-Server-2005

A Tool to Compare SQL Database Schema Versions

26 Feb 2009 by Lindsey Lewis

An article about a tool for comparing SQL database schema versions

SQL-Server-2005

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

A very simple example for creating a media gallery using VS 2005, C#, and SQL Server 2005

26 Sep 2006 by code-frog

Provide a very simple set of instructions for creating your own media gallery and loading your images from SQL Server 2005.

SQL-Server-2005

A web based application configuration wizard

18 May 2008 by defwebserver

A wizard that allows you to FTP an application to a remote server and then launch the configuration wizard from the web browser to update the database connection.

SQL-Server-2005

SQL-server-2000

Accelerate Web Site Development with Kentico CMS - Content Management System for ASP.NET

10 Apr 2007 by Petr Palas

Do you spend days and nights developing dynamic web sites in ASP.NET? Do you need to simplify your job, get more sites done and gain more clients? Kentico CMS for .NET will help you.

SQL-Server-2005

product-showcase

Access .NET assembly through SSIS (Script Component)

8 Oct 2006 by Malpani Amol

Here is some cool stuff to call .NET assembly from SSIS

SQL-Server-2005

Access SSIS package activities and variable through .NET application

8 Oct 2006 by Malpani Amol

This article will drive you, how to access and update properties and variable of SSIS package using .NET application

SQL-Server-2005

Accessing MSMQ from Microsoft SQL Server

26 Mar 2007 by Wojtek Jeziorczak

How to send/receive MSMQ messages in SQL Server using CLR Integration

SQL-Server-2005

Accessing the SQL Server Virtual Device Interface via .NET (C#)

3 Jul 2007 by Steve Abraham

This article is an introduction to the SQL Server Virtual Device Interface and how to access it via any .NET language

SQL-Server-2005

SQL-server-2000

Active Directory Tool

25 Apr 2009 by yairrose

Active directory tool - helps manage active directory oparations (query, update and delete) with easy to use GUI

SQL-Server-2005

Add/Drop LinkedServers using SMO

31 Jan 2006 by arunpv

Add/drop Linked Servers using SQL Server 2005 SMO

SQL-Server-2005

SQL-server-2000

Adding Custom Assemblies in SQL Server Reporting Services 2005

30 Oct 2008 by Mohamed Abdelghani

How to add custom code and custom assemblies to reports in SQL Server Reporting Services 2005

SQL-Server-2005

Adding values to a dropdown using AJAX

6 Jun 2007 by Ganesan Sankaran

How to add values to a dropdown using AJAX.

SQL-Server-2005

ADO.NET and OPENXML to Perform Bulk Database Operations

17 Dec 2007 by mfmaneef

Explains how to send bulk records to a database using OPENXML.

SQL-Server-2005

SQL-server-2000

ADO.NET Data Access Component for SQL Server in C# and VB.NET

28 Sep 2012 by AdamNThompson

A data access component for SQL Server in VB.NET.

SQL-Server-2005

Advanced SQL 2005 SQLNotificationRequest Functionality with C#

24 Mar 2007 by Todd Wilder

Using the SQLNotificationRequest object and the Service Broker to get row and column change notifications, mimicking supposed SQLDependency capabilities

SQL-Server-2005

AJAX grid with ASP.NET 2005

6 Mar 2007 by LeleHalfon

A great AJAX Grid very customizable. In English & Spanish traduction

SQL-Server-2005

AJAX Stock Symbol Drop-down List

15 Oct 2007 by Thanh Huu Nguyen (Tony)

Look up a huge list of stock symbols from MS SQL database

SQL-Server-2005

SQL-server-2000

AJAX, WCF, LINQ to Entities demo application

1 Feb 2009 by Kurush Rastkar

Using most of the recent technologies in one application

SQL-Server-2005

AJAX-enabled Name Selector User Control

24 Aug 2009 by Steve Krile

Fully AJAX-enabled user control used to select names from a database in a drop-down format.

SQL-Server-2005

An alternative way to the MSWord Render extension of SQL Reporting Services using XSLT and XML document mapping

18 Jan 2007 by n_ahid

SQL Reporting Services doesn’t support exporting reports to MSWord yet. Using render extensions for exporting MSWord is not so easy. This article describes an alternative way of converting a SQL report to an MSWord file.

SQL-Server-2005

An Approach to Viewing the Structure of a Database Using VB 2005

14 Sep 2006 by salysle

This article describes an easy approach to examining all of the tables, views, and columns in a database.

SQL-Server-2005

SQL-server-2000

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 Overview of Log Shipping in SQL Server 2005

25 Oct 2008 by Abhijit Jana

Overview of Log Shipping in SQL Server 2005

SQL-Server-2005

Anonymous Personalization Trick in Web Parts

13 Nov 2005 by Daron Yndem

My favorite feature of ASP.NET 2.0 is Web Parts. But the anonymous users in ASP.NET cannot save personalization data and can't use Web Parts design options. This article describes how we can solve this problem in a tricky way.

SQL-Server-2005

Application to migrate data between different environments using the ADO.NET 2.0 SqlBulkCopy

30 Nov 2006 by siva pinnaka

This article explains how to migrate data between different SQL Server environments.

SQL-Server-2005

SQL-server-2000

APPLY Operator of SQL Server 2005

3 May 2007 by Mohammed Ghouse Barq

APPLY operator is a new feature in SQL Server 2005 used in FROM clause of a query. It allows you to call a function-returning TABLE for each row of your outer TABLE. We can pass outer table’s columns as function arguments.

SQL-Server-2005

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

Array Parameter Handling in a Stored Procedure

11 Jun 2008 by Srinath Gopinath

How to handle an array parameter in a Stored Procedure [SQL Server].

SQL-Server-2005

SQL-server-2000

ASCII/Multibyte to Unicode Conversion

16 Feb 2007 by carlop()

An article about converting ASCII/Multibyte to Unicode using C# and SQL/CLR integration.

SQL-Server-2005

ASP.NET 2.0 Custom SQL Server ResourceProvider

22 May 2006 by Jeff Modzel

How to create your own ASP.NET 2.0 custom resource provider to replace resource files (resx) with SQL Server.

SQL-Server-2005

SQL-server-2000

ASP.NET Caching Interview Questions: Part 2

4 Mar 2014 by Shivprasad koirala

ASP.NET Caching Interview Questions Part 2

SQL-Server-2005

SQL-server-2000

ASP.NET Custom Control + Crystal Report Dynamic Text Format

28 Jul 2011 by Sachin Somanath Mumbare

Custom control for display client formatted text in Crystal report

SQL-Server-2005

Asp.Net Interview Question Part 3

18 Oct 2008 by Shivprasad koirala

Asp.Net Interview Question Part 3

SQL-Server-2005

SQL-server-2000

ASP.NET Interview Questions: Part 1

27 Aug 2008 by Shivprasad koirala

ASP.NET interview questions: Part 1.

SQL-Server-2005

SQL-server-2000

ASP.NET MVC Flexigrid sample

31 Oct 2008 by Todd Smith

How to create an ASP.NET MVC sample using LINQ to SQL, Flexigrid for JQuery, and JSON.

SQL-Server-2005

ASP.NET using GridView Control as Lookup

22 Nov 2008 by Amit K Bhagat

ASP.NET using GridView control as lookup

SQL-Server-2005

SQL-server-2000

Asynchronous Setup Grid

5 Oct 2007 by Babak Ansari

A custom asynchronous setup with progress indicator.

SQL-Server-2005

Asynchronous T-SQL Execution Without Service Broker

15 Sep 2008 by Oleg Vorkunov

Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.

SQL-Server-2005

Audit for DB programming

24 Mar 2008 by jangtimjang

Do you want to know what your DB programmers are doing?

SQL-Server-2005

SQL-server-2000

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

Auto Binding a TreeView control from a self referencing table

16 Apr 2007 by Bassam Saoud

A Custom TreeView Control that supports auto binding from a single self referencing table

SQL-Server-2005

Automatically Create Data Access Layers and Business Layers From Microsoft Access or SQL Server Databases

27 May 2016 by icemanind

How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database

SQL-Server-2005

SQL-server-2000

Automation Helper for Stored Procedures in C#

18 Jul 2007 by Jeff Bramlett

Helper classes for automation of stored procedures

SQL-Server-2005

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 Microsoft SQL Database and Upload to FTP

3 Oct 2008 by funklet

Make backups of SQL databases and upload them to FTP server

SQL-Server-2005

SQL-server-2000

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

Basics of Using a .NET Assembly in MS SQLServer - User Functions

2 Sep 2008 by MrTimmins

Introduction to using CLR .NET assemblies in Microsoft SQL Server.

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

Bind Image from Database to DataGrid (web Application)

29 Apr 2007 by Anandhi Swamy

Handles uploading /downloading images into/from database to DataGrid

SQL-Server-2005

Binding dropdowns using Ajax

25 May 2007 by Ganesan Sankaran

How to populate a dropdown in another dropdown change

SQL-Server-2005

BizTalk 2006 Consuming a Web Service and Publishing Orchestration as Web Service and Calling from ASPX

14 May 2008 by Himanshu Thawait

This sample shows BizTalk 2006 consuming a Web Service, then publishing orchestration as a Web Service, and calling it from ASPX.

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

Build a Web Chat Application using ASP.Net 3.5, LINQ and AJAX (in C# 3.5 or VB 9.0)

30 Jun 2008 by junnark

We will create a very simple web chat application using the latest ASP.Net 3.5 technologies from scratch.

SQL-Server-2005

Build SQL Server Stored Procedures From Information_Schema Tables

5 Apr 2006 by Dwight Johnson

Save hours of time by creating stored procedures and code from database metadata.

SQL-Server-2005

SQL-server-2000

Building a Business Day and Holiday Database Subsystem

17 Jul 2007 by Paul Reynolds

This is phase 1 of a 3 phase project. Phase 1 accesses a public holiday Web Service, and loads a SQL Server table that can drive dating and aging logic on large sets of data and assist in creating fast-performing queries and reports.

SQL-Server-2005

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 a Web Message Board using Visual Studio 2008, Part I - The Basic Message Board

30 Dec 2007 by Rama Krishna Vavilala

This article builds a web based message board and uses several new technologies introduced with Visual Studio 2008 such as LINQ, WCF Web Programming, WCF Syndication, ASP.NET ListView, ASP.NET DataPager etc.

SQL-Server-2005

Building an N-Tier Application in VB.NET, in 8 Steps

24 May 2012 by Vimalsoft(Pty) Ltd

This article will show you how to build an N-Tier application in VB.NET.

SQL-Server-2005

SQL-server-2000

Building an SQL Logic Engine

22 Sep 2008 by Steve Marsh

This article describes how to build a logic engine entirely in SQL. In the context of our example, a logic engine is a program that takes in a set of variables and corresponding values, evaluates a set of predefined conditions and builds a result set based on which conditions were found to be true.

SQL-Server-2005

Building ASP.NET Reporting OLAP-Based Application Part-2

21 Apr 2009 by Ramy Mahrous

How to build Reporting ASP.NET Web application

SQL-Server-2005

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

Building managed code using Common Language Runtime (CLR) Integration in SQL Server 2005

23 Oct 2005 by Sekhar Lanka

This article talks about CLR integration and how to program database objects using managed code by using this cool feature of SQL Server 2005.

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

Business Object Introduction

18 May 2007 by derekliang

This article is going to be served as an introduction to Expert C# 2005 Business Object by RockFord Lhotka which was written for business application developer.

SQL-Server-2005

SQL-server-2000

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

Calling a Web Service from a SQL Integration Services package

7 Apr 2008 by Simon Bonello

How to call a Web Service from a SQL Integration Services package.

SQL-Server-2005

Calling Stored procedures in ADO.NET

29 Aug 2006 by sandeep@s

An introduction to executing SQL Server stored procedures and how to retrieve the return parameters

SQL-Server-2005

SQL-server-2000

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

Central Key Management

8 Mar 2006 by Brian Bayless

A central key manager for multiple web server clients in a web farm.

SQL-Server-2005

Check Validity of SQL Server Stored Procedures, Views and Functions

13 Feb 2006 by IPC2000

A handy command line tool that checks whether stored procedures, views and functions in a database compile

SQL-Server-2005

SQL-server-2000

Check Validity of SQL Server Stored Procedures/Views/Functions (updated)

19 Sep 2008 by Emil Lerch

Command line tool to check validity of objects in SQL Server databases

SQL-Server-2005

SQL-server-2000

Checking the New DST 2007 from a DBA Perspective

31 Jan 2007 by jamesplewis

How to check if your Microsoft SQL Server 2005 is ready for the new DST 2007

SQL-Server-2005

Choosing between XML and SQL in .NET Content Management Systems

2 May 2006 by Petr Palas

This article compares various approaches to storing, editing, and displaying structured content on the web. It shows the advantages and disadvantages of using XML and relational SQL databases.

SQL-Server-2005

SQL-server-2000

product-showcase

CLR Function for Persian Date Converter in Microsoft SQL Server

26 Jul 2008 by Ali Daneshmandi

CLR Function for Persian Date Converter in Microsoft SQL Server

SQL-Server-2005

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