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

Simple Data Access in C#

11 Jan 2009 by 6opuc

Fast and easy to use data access class library.

SQL-Server-2005

SQL-server-2000

Useful tips on Reporting Services

23 Oct 2008 by aakanksh

Some useful tips on using Reporting Services

SQL-Server-2005

Effective paging with List View control in ASP.NET

9 Nov 2012 by Abdul Quader Mamun

To develop scalable applications, effective paging is essential. Devoid of smart and effective paging and sorting to handle thousands of thousand data takes extra time and system resources.

SQL-Server-2005

16 Aug 2012 by Abdul Quader Mamun

Framework makes application more organized and efficient way to coding. It is helpful for newly assigned developer to understand code structure within a short time. It is essential for large application.

SQL-Server-2005

SQL-server-2000

Crystal Reports with Dynamic Number of Columns with Typed Dataset

4 Aug 2010 by Abdul Quadir Saifee

Creating Crystal reports with dynamic number of Columns with Typed dataset with SQL Server 2005

SQL-Server-2005

SQL Server Profiler Step by Step

22 Feb 2008 by Abhijit Jana

SQL Server Profiler Step by Step: SQL Server 2005

SQL-Server-2005

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

Overview of Views in SQL Server 2005

28 Jul 2009 by Abhijit Jana

Overview of Views, system Views, creation of Views, and binding and securing Views.

SQL-Server-2005

Quick Overview: Temporary Tables in SQL Server 2005

22 Sep 2009 by Abhijit Jana

Basic overview of temporary Tables in SQL Server 2005

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Working with CLR Objects in SQL Server 2005 or Higher: Part I

2 Aug 2009 by Abhishek Sur

Gives an introduction to CLR programming in SQL Server databases. This is the first part of a two-part article series.

SQL-Server-2005

Working with CLR Objects in SQL Server 2005 or Above Part 2

2 Aug 2009 by Abhishek Sur

Gives an introduction of how to create SQL CLR managed objects in SQL server.

SQL-Server-2005

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

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

How to conduct an SMS survey using a cell phone connected SMS gateway and MS Access

16 Oct 2007 by Adam Page

Setting up an SMS gateway to conduct an SMS survey and storing the survey results in an MS Access database, from which you can generate/print out reports.

SQL-Server-2005

SQL-server-2000

SqlProcedure - Improve Database Performance, Eliminate Errors and Reduce Code

23 Nov 2007 by adambl

Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors

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

Distribute your site's contents with RSS 2.0

28 Sep 2007 by AdamNThompson

Distribute your site's contents with RSS 2.0 using ASP.NET/VB.NET/MS SQL Server 2005.

SQL-Server-2005

SQL Server 2005 Distilled - Chapter 3: Enterprise Data Management

31 Mar 2006 by Addison-Wesley

This chapter covers what's new in enterprise database administration. It doesn't just look at the product from a feature list, but groups the features according to some tasks common to database administration.

SQL-Server-2005

Sending Values To and Receiving Values from a JavaScript Popup Window that Uses the MultiView and the GridView Control

17 Apr 2009 by Adnan Faisal

In this article, we will learn how to create a JavaScript popup window, how to use the MultiView control to move between two views, and also to use the GridView control with paging.

SQL-Server-2005

Provider Design Patterns in NET 2.0

29 Oct 2008 by Ahmad Eid Salim

Provider Design Pattern is a new pattern that Microsoft formalized in .NET 2 to increase application performance where there is no need to explicitly instantiate classes.

SQL-Server-2005

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

Introduction to Model Driven Development with Sculpture – Part 1

3 Sep 2008 by Ahmed Negm

This article introduces how to create and manage .NET enterprise applications using your favorite technology (Data Access Application Block, LINQ, NHibernate, ASMX, and WCF) with the Model Driven Development approach by Sculpture.

SQL-Server-2005

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

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

Implementing an Ugly Tab Structure in Reporting Services

24 Jun 2008 by akjoshi

Implementing a tab control like structure in SQL Server 2005 reporting services report using tables and text boxes

SQL-Server-2005

Introducing Distributed Messaging using Service Broker in SQL Server 2005

28 Sep 2005 by Akram Hussein

An article on distributed messaging using Service Broker in SQL Server 2005.

SQL-Server-2005

Power yourself against XSS

7 Aug 2007 by albert arul prakash

XSS gaining popularity to hack into websites. This article describes how to power yourself against XSS

SQL-Server-2005

SQL-server-2000

Improve performace with Sessions using Cache

20 Jul 2005 by Albert Pascual

I wrote this short article to improve your ASP.NET application Sessions using Cache.

SQL-Server-2005

SQL-server-2000

Using SQL Bulk Load to Upload Fixed Width Text Files

3 Mar 2009 by Alden John Snow

This project demonstrates what is likely the fastest way to upload one of those fixed width reports from a mainframe to a SQL server table.

SQL-Server-2005

SQL-server-2000

CRM Customization - Import Leads from Excel via Email into MS CRM

6 Sep 2007 by aleksisa

Build a process to import Leads records from Excel into MS CRM via email.

SQL-Server-2005

SQL-server-2000

SQL Server Reporting Services 2005 XML Extensions

25 Sep 2007 by Alexander Nowak

In SSRS2005, a new provider is available: XML Data provider. This enables you to create reports from ADO.NET datasets or XML documents from URL-addressable resources, e.g. Web services. This article shows a step-by-step example (basic report, no parameters) how to use this new SSRS 2005 feature.

SQL-Server-2005

TransactionScope in .NET 1.1

1 Jun 2005 by Alexander Shirshov

Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.

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

Performance Comparison - Identity() x NewId() x NewSequentialId

16 Jan 2009 by Alfredo_Fernandez

Performance comparison - Identity() x NewId() x NewSequentialId.

SQL-Server-2008

SQL-Server-2005

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

Microsoft Indexing Service and OLEDB

15 Apr 2008 by Ali Hamdar

How we can access the Windows Indexing Service using OLEDB.

SQL-Server-2005

SQL-server-2000

How to change ConnectionString easily

6 Feb 2010 by Ali Marzban

Changing ConnectionString like an attribute in C#

SQL-Server-2005

Using Multiple NHibernate Assemblies with NHSessionManager

1 Feb 2007 by Ali Ozgur

This article describes how NHSessionManager can be configured to use multiple NHibernate assemblies

SQL-Server-2005

SQL-server-2000

NHibernate DaoFactory Exposer with Castle MikroKernel

2 Feb 2007 by Ali Ozgur

How to create DaoFactory instances with Castle/MikroKernel in NHibernate applications

SQL-Server-2005

SQL-server-2000

How to retrieve SqlConnection statistics for executed T-SQL commands

7 Oct 2007 by Ali Ozgur

Sample code describing how to retreive statistical information about the T-SQL commands executed.

SQL-Server-2005

SQL-server-2000

Creating and Deploying Reporting Services using Custom Assembly

14 Jun 2007 by alifaraze

Custom assembly and reporting services

SQL-Server-2005

SQL-server-2000

SingleSimon - Password Manager Application

30 Sep 2008 by alon1980

An open source password manager with some advanced features and cool interface

SQL-Server-2005

Paging and Sorting on SQL Server and Oracle using Sql.Net

21 Feb 2005 by Alon_Catz

This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.

SQL-Server-2005

SQL-server-2000

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

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

LINQ and WF Based Custom Profile Provider for ASP.NET 3.5

8 Dec 2008 by Anas Karkoukli

A new implementation of the Custom Profile Provider for ASP.NET 3.5, using LINQ, Workflow Foundation, and the Responsibility-Centric-Singleton DataContexts pattern.

SQL-Server-2005

Logging System for .NET SOA Applications

30 Dec 2007 by Anders Revsgaard

No matter how well you design your system, a distributed SOA application is always complex. When a SOA application fails, it can be difficult to track down the cause of the problem and the Web service where the error occurred. To handle this difficulty, you need a logging system such as UptoLog.

SQL-Server-2005

Logging System for .NET SOA Applications

30 Dec 2007 by Anders Revsgaard

No matter how well you design your system, a distributed SOA application is always complex. When a SOA application fails, it can be difficult to track down the cause of the problem and the web service where the error occurred. To handle this difficulty, you need a logging system such as UptoLog.

SQL-Server-2005

Web Service via Data Access Object Pattern

9 Oct 2007 by Andrew Golik

A Data Access Object pattern implementation

SQL-Server-2005

SQL-server-2000

Database Deadlocks for Dummies

2 Oct 2008 by Andrew J Dixon

Explaining Database deadlocking to non-technical people

SQL-Server-2005

SQL-server-2000

VB DataGridView Automatically Saving Updates to a Bound Database

11 Jul 2006 by Andrew Timberlake-Newell

Demonstrates how to configure a DataGridView control to automatically store edits to bound datasets into the source database.

SQL-Server-2005

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

Using User Defined Functions in Table Inserts and Seeding with Stored Procedures

26 Aug 2009 by Andy_L_J

Generate unique column values using UDFs and Stored Procedures

SQL-Server-2008

SQL-Server-2005

Consume 32 bit COM DLL in x64 Bit SQL Server 2005

27 Apr 2009 by Aneesur Rehman Khan

Consume 32 bit COM DLL in x64 bit SQL Server 2005

SQL-Server-2005

SqlDataSource with Transactions

14 Sep 2006 by Anil_Kumar_P

One of the best new features of ASP.NET 2.0 will be the SqlDataSource control. However, as I found out in my experimentation, what seems like a simple control has some complex behaviours to master to get it working properly.

SQL-Server-2005

SQL-server-2000

LINQ Demo with ASP.NET Web Application

29 Apr 2011 by anrorathod

A sample application for beginner users who want to start the Linq implementation in ASP.NET

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

TreeToTable hierarchical tables with SQLServer 2005 and C#

12 Aug 2006 by Arjan Pot

Retrieving child records from an hierarchical table

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

Editable GridView in ASP.NET 2.0

26 Nov 2012 by Ashrafur Rahaman

This article will give you an overview of how to use an ASP.NET GridView completely, and how to use RowEditing, RowUpdating, RowDeleting, RowCommand, RowDataBound, RowCancelingEdit, and Pagination in a DataGrid. From this article, you will have a clear view of GridView data inserting, deleting, and

SQL-Server-2005

How Longhorn Transforms Applications

2 Jul 2004 by Ashvil DCosta

See how Longhorn core pillars like WinFS changes the way applications are written, based on metadata relationships.

SQL-Server-2005

Hierarchical XML Data Builder

17 Oct 2007 by asithangae

Data builder that builds XML from a SQL query in hierarchical format.

SQL-Server-2005

DataGrid & Paging using Ajax

25 Oct 2007 by asithangae

Achieving the DataGrid functionality with paging using User control and Ajax

SQL-Server-2005

Truncate Log File in SQL Server 2005

6 Jan 2014 by Assil

A tool that facilitates the truncation of SQL log file

SQL-Server-2005

The 2007 Microsoft Office System and Other Platform Technologies for Building Composite Applications

15 Jun 2007 by Atanu Banerjee

A composite application is a collection of software assets assembled to provide a business capability. These assets can be deployed independently, enable composition, and leverage specific platform capabilities. Microsoft Office's comprehensive platform for this is Office Business Applications (OBA)

SQL-Server-2005

product-showcase

Microsoft Office Sharepoint Server 2007(MOSS 2007) And Microsoft CRM Integration

17 Mar 2008 by Avinish Awasthi

The purpose of the integration is to create collaboration sites on SharePoint 2007 as new accounts or opportunities are created in Microsoft CRM.

SQL-Server-2005

Database Viewer and Updater for any Database

25 Jul 2006 by avronp

View and update any database table and metadata. Includes sample databases.

SQL-Server-2005

SQL-server-2000

SQL And C#

15 Apr 2011 by Ayaz Awan

Generate 100,1000 lines of backend code and stored procedures by just one click on table name in SQL Server

SQL-Server-2005

SQL-server-2000

SharePoint 2010 Logging Database

6 Apr 2010 by Ayman M. El-Hattab

Four reasons to directly query SharePoint logging database

SQL-Server-2008

SQL-Server-2005

Multi Tier Framework in C#

22 Sep 2010 by B. Verboven

Using Microsoft SQL Server or XML files as datastore

SQL-Server-2005

web_development

Asynchronous Setup Grid

5 Oct 2007 by Babak Ansari

A custom asynchronous setup with progress indicator.

SQL-Server-2005

Controlling the XML output when using the FOR XML AUTO statement in SQL Server

26 Jan 2010 by BackyardHackMechanic

Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.

SQL-Server-2005

SQL-server-2000

Loading image files from a database, using ADO

27 Jan 2006 by Bahrudin Hrnjica

Putting and retrieving images files to and from a database, via ADO.

SQL-Server-2005

SQL-server-2000

Simple Data Paging

23 Oct 2005 by Barend Jnr

Simple Data Paging

SQL-Server-2005

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

Customary Functions of GridView in ASP.NET 3.5

25 Mar 2009 by Behrouz Rad

The most advanced things which you can do with GridView in ASP.NET 3.5

SQL-Server-2005

Record Versioning with SQL Server

15 Feb 2007 by Ben Allfree

Learn how to store data with a version history.

SQL-Server-2005

SQL-server-2000

Implementing Efficient Data Paging with the Datalist Control in ASP.NET 2.0

11 May 2006 by Bernard Ho-Jim

Extending the Personal Web site Starter kit by implementing efficient data paging to the Photo Gallery.

SQL-Server-2005

Inserting Value of Collection into Database

7 Aug 2008 by bhadeliaimran

Inserting value of Collection into Database

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

How to Use a Multi-Result Set Stored Procedure in SSIS

31 Dec 2008 by BobP1339

How to use a script component as a data source for multi-result set Stored Procedures.

SQL-Server-2008

SQL-Server-2005

Multi Language Reports in SSRS

31 Mar 2009 by BobP1339

Explains how to do multi language reports in SSRS

SQL-Server-2008

SQL-Server-2005

Using XML Serialization with SQL's FOR XML PATH

20 Nov 2007 by BoneSoft

Describes a method for loading data objects using SQL Server 2005's new FOR XML PATH mode and XML serialization.

SQL-Server-2005

SQL Server Object Search

22 Aug 2007 by Brady Kelly

An application that seeks to emulate the F4 object search function from Query Analyser

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

HowTo: Install the Northwind and Pubs Sample Databases

18 Oct 2013 by Brian C Hart

To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express.

SQL-Server-2005

HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express

18 Oct 2013 by Brian C Hart

To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!

SQL-Server-2005

SQL-server-2000

Data Visualization in WPF with LINQ to SQL and Data Binding

21 Dec 2007 by Bruno Sonnino

This article will show how to use data binding and styles to show data coming from a Microsoft SQL database using the new object-relational model introduced in Visual Studio 2008, LINQ to SQL, allowing grouping, sorting and filtering of data with almost no code.

SQL-Server-2005

Implementing a Data Processing Extension

16 Jan 2008 by Bryan Avery

I will take you through how to deploy your own Custom Data Process Extension for SQL Server Reporting Server 2005, both on the server and for use within your development environment.

SQL-Server-2005

Telephone Numbers in SQL Server 2005: Part 2 – Formatting

13 Mar 2008 by Bryan Kowalchuk

Formatting telephone numbers in SQL Server.

SQL-Server-2005

Telephone Numbers in SQL Server 2005: Part 1 – The Data Type

13 Mar 2008 by Bryan Kowalchuk

Efficiently storing telephone numbers in SQL Server.

SQL-Server-2005

Malleable Software and Systems Design

30 Oct 2007 by Bryan Kowalchuk

Implementing Agile Software Development

SQL-Server-2005

Retrieving and Storing Call History

19 Dec 2007 by Bryan Sachdeva

This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.

SQL-Server-2005

SQL-server-2000

Three-tier .NET Application Utilizing Three ORM Technologies

30 Jan 2010 by Bryan Thomas Weikel

LINQ to SQL, Entity Framework, and NHibernate used in a parallel fashion in a three-tier WinForms application.

SQL-Server-2005

Visual Representation of SQL Joins

3 Feb 2009 by C.L. Moffatt

This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.

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

T-SQL Coding Standard

1 Oct 2008 by Casper Leon Nielsen

T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)

SQL-Server-2005

SQL-server-2000

Easier Database Transactions - Extending the Using Statement to Perform Automatic Database Transactions

25 Oct 2004 by Chad Z. Hower aka Kudzu

Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.

SQL-Server-2005

SQL-server-2000

Impersonation using Code

8 Mar 2007 by Chirag R Darji

Impersonation using Code

SQL-Server-2005

SQL-server-2000

Using Visio 2003 for Enterprise Architects to Design SQL Server Databases

9 Jan 2007 by Chris Buckett

Using the Visio database model diagram to design a complex database within sql server (or why it's worth paying for MSDN Premium).

SQL-Server-2005

SQL-server-2000