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.

6 Steps to Enable Transactions in WCF

by Shivprasad koirala

6 steps to enable transactions in WCF

A convenient DataGrid Pager Control

by zhengdong jin

It's very easy to use and the most conventient DataGrid pager control.

A general-purpose service engine for unattended processing execution

by Alberto Venditti

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

A generic bulk insert using DataSets and OpenXML

by poodull76

Create T-SQL command text to update a table with OpenXML quickly and with minimal effort.

A generic loading of data in a DropDownList using caching mechanism

by santosh poojari

This article shows you how to make use of DataAccessLayer and caching.

A helper object to migrate SQL Reporting Service items

by Mark Brandon

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

A lightweight AJAX.NET-enabled grid control

by Simon Gulliver

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

A Master-Detail Solution Using Single Input Controls

by TofuBug24

Shows a solution for creating a Master-Detail relation using textboxes.

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

by Paul Rony

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

A simple Database Viewer - DBViewer

by Uri Lavi

A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).

A simple example of SQL server admin tools.

by Md. Marufuzzaman

A simple example of SQL server admin tools.

A Simple RSS News Generating Tool

by Stephan Pilz

A tool to generate/manage news and provide news via RSS.

A Simple Use of SQL CASE Expression

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.

A Simplified SQL-CSV Import/Export Functionality

by codeajay

A simplified SQL-CSV import/export functionality.

A SQL Management Console for MSSQL 2000 & 2005, MySQL 5.0,...

by gan.gary

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

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

by qubing

WITH Clause AND EXEC sp_executesql Clause Used In MSSQL 2005

A Tool to Compare SQL Database Schema Versions

by Lindsey Lewis

An article about a tool for comparing SQL database schema versions

A web based application configuration wizard

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.

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

by Steve Abraham

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

AD, SQL Server, GMail synchronizer tool

by michael.neubrander

Multi account synchronizer for GMail, AD, and SQL Server.

Add "Select All" to parameter lists in SQL Reporting

by Sven Cipido

How to add a "select all" option to your parameter lists in SQL Reporting.

Add/Drop LinkedServers using SMO

by arunpv

Add/drop Linked Servers using SQL Server 2005 SMO

Administrate SQL Server2000 from Pocket PC

by rasheed1979

This article demonstrates administrating SQL Server 2000 from Pocket PC on the fly.

ADO.NET 101: SQL Connection

by mysorian

A tutorial on connecting to SQL 2000 Server.

ADO.NET and OPENXML to Perform Bulk Database Operations

by mfmaneef

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

agStoredProc

by Alexander German

With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.

AJAX Stock Symbol Drop-down List

by Thanh Huu Nguyen (Tony)

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

Alternate Rows Coloring in SQL Reporting

by Jay Kulaindevelu

To change the row colors in reports.

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

by salysle

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

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

by Md. Marufuzzaman

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

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

by Md. Marufuzzaman

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

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

by siva pinnaka

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

Applying Robustness Analysis on the Model–View–Controller (MVC) Architecture in ASP.NET Framework, using UML

by Shams Mukhtar

This article will enhance your vision on the usage of Robustness Analysis in conjunction with Model View Controller, using UML with application in ASP.NET. This article is a sequel to my articles on Architecture and Design with ASP.NET.

Architectural Best Practices - Automating SQL Parameter Creation and Assignment

by Anton Pious Alfred

Most systems that use Stored Procedures make use of SQL parameters to send and receive information from the database. The code to create these SQL parameters and then populating them is repeated throughout the system. This article describes how to automate this code.

Armadillo: Unit Testing of inline SQL with a little help from Attributes and Reflection

by Pedro J. Molina

This article provides a way for automatically testing SQL embedded in your Data Access Layer (DAL) before publishing a new release of your application.

Array Parameter Handling in a Stored Procedure

by Srinath Gopinath

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

ASP.NET 2.0 Custom SQL Server ResourceProvider

by Jeff Modzel

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

ASP.NET and SQL 2000 Reporting Services

by mysorian

Walkthrough of generating a report from a SQL 2000 Server using the Reporting Services.

ASP.NET Caching Interview Questions: Part 2

by Shivprasad koirala

ASP.NET Caching Interview Questions Part 2

ASP.NET configuration management: an alternative to web.config

by Alberto Venditti

An alternative and flexible way to manage config settings for multiple web applications.

Asp.Net Interview Question Part 3

by Shivprasad koirala

Asp.Net Interview Question Part 3

ASP.NET Interview Questions: Part 1

by Shivprasad koirala

ASP.NET interview questions: Part 1.

ASP.NET Report Kit Grasshoper (Race to Linux)

by osohare

Porting and deploying the report starter kit to Linux (RH7.3/Tomcat5.0.28/Grasshoper1.61)

ASP.NET Reports Starter Kits Porting from Windows to Linux (Race to Linux)

by Abi Bellamkonda

ASP.NET Reports Starter Kit Porting from Windows to Linux using Mainsoft's Grasshopper

ASP.NET Time Tracker Starter Kit Port to Linux using Mainsoft's Grasshopper

by Mark Cafazzo

Race To Linux - How to port a Visual Studio .NET web application to the J2EE Framework on Linux

ASP.NET TimeTracker Starter Kits Porting from Windows to Linux (Race to Linux)

by Abi Bellamkonda

ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper

ASP.NET using GridView Control as Lookup

by Amit K Bhagat

ASP.NET using GridView control as lookup

Audit for DB programming

by jangtimjang

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

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

by acarpio1975

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

Automate query execution by using xml and helper class

by ashishinfra

The generalized class has static functions that return dataset and datareader objects , It accepts string(name of xml tag that stores the query) and value to be supplied in case query accepts parameters

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

by icemanind

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

Auto-SQL DataGrid component Part II: The full-featured version

by Sangra

ASQLDataGrid is a useful component when working with RDBMS applications. It is capable of automatically constructing and executing SQL statements based on its properties.

Auto-SQL DataGrid component. Part I: Non-editable version

by Sangra

ASQLDataGrid is a useful component when working with RDBMS applications. It is capable to automatically construct and execute SQL statements based on its properties.

Backup Microsoft SQL Database and Upload to FTP

by funklet

Make backups of SQL databases and upload them to FTP server

BooProd.Core - Context sensitive Connexion String

by Boo!

This article is to help you create context sensitive connexion string: choosen dynamically, depending on which server the application is running.

Brief about Triggers in SQL Server 2000

by SquaredRomi

A trigger is a database object that is bound to a table. In many aspects, it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure".

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

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.

Build SQL Server Stored Procedures From Information_Schema Tables

by Dwight Johnson

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

Building a Hybrid Active Directory and SQL Table DataSource View

by noahhath

Building a hybrid Active Directory and SQL table DataSource view.

Building a Shared Code Library as a VS.NET Plug-in

by paul heap

A plug-in for VS.NET that stores code snippets in a database. From the plug-in you can add code, search the database for code snippets. Also includes examples on how to integrate with the IDE as a plug-in.

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

by Vimalsoft(Pty) Ltd

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

Building Blocks For ASP.NET Applicationa: Part 1

by Agha.net

This is a series of articles providing Building Blocks for any ASP.NET application.

Building Dynamic SQL In a Stored Procedure

by John-ph

This article explains about building and executing a Dynamic SQL in a stored procedure.

Building robust middle tier

by rafael_p

One of the many solutions to build a quick and robust middle tier.

Business Object Introduction

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.

Business Objects for CodeSmith

by JR Hull

Save time when developing large applications, by using code generation for your business objects.

C# Code Generator for Stored Procedures

by PaulMcKenzie

This stored procedure will generate all the C# code for calling any Stored Procedure

C# Coding Standards and Best Programming Practices

by T Manjaly

Anybody can write code! With a few months of programming experience, you can write "working applications." Making it work is easy, but doing it the most efficient way requires more work than just making it work!

Calendar control in Data Grid in C#

by kokilaB

Trigerring a Calendar in a Datagrid

Calling Stored procedures in ADO.NET

by sandeep@s

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

Century Date Tables

by John Bevilaqua

SQL DDLs for creating table structures and inserting the data for a set of tables suitable for producing pick lists for validation of the Month Names, Month Numbers, Days in each Month and Years in the 20th Century

Check Database Size with Summary

by Kuldip Rindani

This script calculates size of every user database with summary

Check Validity of SQL Server Stored Procedures, Views and Functions

by IPC2000

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

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

by Emil Lerch

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

Choosing between XML and SQL in .NET Content Management Systems

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.

Code Review Checklist

by Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

CodeSmith generated Audit Log Triggers

by RichardRoe

CodeSmith template for creating Audit Log Triggers on SQL tables.

Coding an N-Tier Application in C# without any Wizard - Part I

by Vimalsoft(Pty) Ltd

Beginner to intermediate in N-Tier

Coding an N-Tier Application in C# Without Any Wizard: Part II

by Vimalsoft(Pty) Ltd

Coding an N-Tier application in C# without using Wizards.

Combining External Data Sources with a MS SQL Server Database to Create Google Maps Using AJAX and ASP.NET

by MarkWei

To dynamically generate a Google Map with combined data sources from an external web service or API and from an internal MS SQL database, using AJAX and the ASP.NET environment.

common functions oftenly used in projects

by Rohit Wadhwa(Devp)

Compare SQL Database Schema

by Paritor

Application to show differences between two SQL Server databases.

Complete Remote (Intra/Inter) SQL Server Manager

by Chaudhary

SQL Server manager for remote monitering and managing.

Composite Login Control

by vikas vohra

This article shows the implementation of Composite Server Control to provide Login features

Computed Column Specification in SQL Server

by Padoor Shiras

Computed Column Specification for populating nth column

Constructing Web Interfaces on the Fly

by Gil Shabat

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

Continuous Database Integration

by Peter Hancock

Using NAnt and CruiseControl.NET to continuously integrate database changes

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

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.

Convert DateTime To .NET Ticks Using T-SQL

by Eron Wright

Convert a datetime value to .NET-compatible Ticks using a T-SQL User-Defined Function. Useful for interoperation between .NET and unmanaged environments such as ASP and VB6

Convert Query Result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report

by Wiltek Ghozali

This utility is used for convert query result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report, supported SQL Server and ODBC connection.

Convert SQL Server DB to SQLite DB

by liron.levi

A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB

Converting Strings to DateTimes for Use in ADO.NET Parameterized Queries using the Data Access Applications Block 3.0

by ritzcoder

This article shows you how to take a date string and use it in a parameterized sql server query

Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table

by Syeda Anila Nusrat

Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.

Create a Database during the installation of a .NET application - Version 1

by Mukund Pujari

This application can be used to create databases, tables, stored procedures during the installation of .NET applications.

Create a Modified On Column in SQL Server

by james.wren

How to add a modified on column in SQL Server using triggers.

Create a Web Based Non-Typed Crystal Reports Application

by junyaoxu

This article explains how to build a generic and data bound Web based Crystal Reports server.

Create an SQL Server Database Using C#

by Phuong Thanh Nguyen

Create a SQL Server database using C#.

Create and Populate Date Dimension for Data Warehouse

by Mubin M. Shaikh

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

Create database during installation of a .NET application - Version 2

by Mukund Pujari

This application can be used to create database, tables, and stored procedures during the installation of a .NET application.

Create INSERT batch files easily with ScriptBuilder

by Gordon Kushner

Utility program for generating SQL Server INSERT scripts

Create Sample Application Using Entity Objects In C#.Net

by justindhas

Create Sample Application Using Entity Objects Using C#.Net

Creating a DAL with SubSonic

by Michael Ceranski

Creating a DAL with SubSonic.

Creating and Deploying Reporting Services using Custom Assembly

by alifaraze

Custom assembly and reporting services

Creating Auto-Suggest Textbox Using ASP.NET 2.0 Client Callbacks

by azamsharp

Implementing an auto-completion feature using ASP.NET 2.0 client callbacks

Creating CSV from SQL Database table attaching it to MS word as datasource and then creating mailmerge document

by Member 3209760

Creating CSV from SQL Database table attaching it to MS word as datasource and then creating mailmerge document

Creating DAL Components Using Custom ASP.NET Build Providers And Compiler Techniques

by Jürgen Bäurle

This article describes how to create Data Access Layer Components (DALC) using ASP.NET build providers and a self-defined description language in C#, including an easy scanner, parser, and CodeDOM generator.

Creating Time Dimension in Microsoft Analysis Services

by Igor Krupitsky

Unlike Date Dimension (with Year, Month, Date), Time Dimension (with Hour, Minutes, and Seconds) is not automatically created by SSAS (Microsoft SQL Server Analysis Services). This article explains how to create and use Time Dimension in Microsoft SQL Server Analysis Services.

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

by aleksisa

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

CrystalReports Push Model with .NET

by Raspberry Man

How to make custom datasource for CrystalReports engine using push model and .NET

Custom MembershipProvider and RoleProvider Implementations that use Web Services

by Shaun Wilde

Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.

Custom MSBuild Tasks: Automated Report and DB Deployment

by Thiago Silva

Automate your Reporting Services report deployment and scripting and database tasks by using these custom MSBuild tasks.

Custom print procedure in MS SQL 2000/7/6.5

by Abhay Dubey

This procedure can be called in another Stored procedure or function and quite handy in debugging and development

Custom Resource Reader

by Palwinder Singh

Implementing custom resource reader with database

Custom Web Visitor Tracking using C#

by Haja

When the IIS log is not sufficient for your web analytics , you can use this simple technique to track the extra data about visitors of your web page

DAL Class and Transact-SQL Generator for C# and VB.NET

by Hamidreza-Ghasemkhah

Automatically generates the required class and stored procedure to work with SQL databases

Dashboards Are For Driving

by Steven A. Lowe

Dashboards are immensely useful not only for business data but also for business applications, but only if they display metrics that can be used to "drive" (or "steer") in real-time.

Data Access Application Block .NET 2.0: Get Return Values, Output Values

by rperetz

Using SqlHelper in .NET 2.0 and getting return values and output values.

Data Access Layer (DAL) with SqlWrapper library

by Andrey Shchurov

With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.

Data Archive

by Nikolai Serdiuk

This article describes creating indexed search systems using relational databases

Data binding a ListView

by theoutlander

An overview on inheriting a ListView and implementing design-time data binding capability.

Data Driven Subscriptions in SQL RS 2000 Standard

by Jason Selburg

How to implement data driven subscriptions in SQL RS 2000, Standard edition.

Data Encryption/Decryption using RSACryptoServiceProvider and X509Certificate2

by ranajitbiswal

Data Encryption/Decryption using RSACryptoServiceProvider and X509Certificate2

Data Generator for SQL SERVER 2000,2005 and MSDE

by ganesan balachandar

The tool can generate the specified number of rows for any table. Can be used for stress testing the application

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

by AnupKumarYadav

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

Data Synchronization in SQL Express

by Ganesan Krishnan

Data Synchronization in SQL Express

Database Build Tool

by Duncan Edwards Jones

An extensible tool to package and deploy database schema objects

Database Class ADODB Command Recordset VB6 ADO FILE HANDLING OPEN

by M Saqib Ali

It is an object of database where we connect the data SQL Server and do working in sqlserver.

Database Comparator

by Amir Mehrabi-Jorshari

With this tool, you can compare two databases and generate a difference report.

Database Deadlocks for Dummies

by Andrew J Dixon

Explaining Database deadlocking to non-technical people

Database Development using Visual C++ and OLE DB: Establishing the connection

by emadns

How to start a connection using ATL OLE DB consumer classes and how to obtain a session so that you can use it to query or edit the database.

Database fields merge for any Office product, just with XML

by mc_kappa

Using this simple, yet elegant and powerful code, you can provide to your users efficient Office document merging; simply exploiting XML technology and basic string manipulation.

Database Helper Class Library to Ease Database Operation

by falconsoon

Database Helper Class Library to Ease Database Operation

Database Image Viewer

by Zoodio

This application will permit the user to create tables in SQL 2000. It will also permit the user to save and view images from the database

Database local cache

by konamiman.MSX

A C# class that uses the local file system to cache binary objects stored in a database.

Database Resetter

by Michiel de Rond

A little tool to make life while developing with databases a little easier.

Database Schema Comparison Utility

by Sean Goodpasture

An article describing a way to find the differences between two database instances

Database Schema Versioning Management 101

by Peter Weissbrod

An introductory approach to synchronizing database schema versions

Database Utilities for C#

by Redskin9

A series of Database utilities for lookup and data manipulation written in C#

Database Viewer and Updater for any Database

by avronp

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

Datagrid Cell Tooltip

by Thiru Sagadevan

Showing Tooltip for each cell with data of a table in a Datagrid

DataGrid Paging - C# Windows Forms

by Manoh

DataGrid paging using C# Windows Forms - Select only the required (page size) records from the table.

DataGrid Paging Using DataReader - C# Windows Forms

by Manoh

DataGrid paging using DataReader.

DataTable with SelectDistinct in C#

by vacen2

Allows you to perform a Distinct query against a Datatable

DataTable with SelectDistinct in VB

by vacen2

Allows you to perform a Distinct query against a DataTable.

Date and Time as Separated Types

by iMuhamad

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

DBInspector - Making the case for code generation

by Mark Williamson

DBInspector is a swiss army knife for database developers. DBInspector helps you generate all types of code based on your database schema.

Dealing with DataTables

by Star_Friend

All you want to know about how to deal with DataTables.

Delete and Constraint Handling Stored Procedure Using SQL Server 2000

by Jeremy Mullinax-Hill

A generalized stored procedure that performs constraint checks before performing deletes.

Delete mechanism.

by Tadas Budvytis

Explains a mechanism of deleting a record when the selected record has related records in other tables.

Deploy Analysis Services 2000 single Cubes

by Manuel C

This script permits to deploy single cubes from one server to another

Deploy SQL Server databases easily with an Installer class

by Stefan Prodan

Deploy MS SQL Server databases using System.Configuration.Install and a VS.NET Setup Project.

Determining Stored Procedure Parameters with SQL 2005

by gtamir

Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005

Develop high performance distributed applications with batching, asynchrony, and parallel computation

by Yuancai (Charlie) Ye

Performance comparison between SocketPro and .NET remoting.

Developing a wireless workflow automation client on Pocket PC/PDAs with a Web Service

by Zenab_Zenab

This article focuses on developing a workflow client device application for Pocket PC in C# 2003.

Developing Next Generation Smart Clients using .NET 2.0 working with Existing .NET 1.1 SOA-based XML Web Services

by Omar Al Zabir

Comprehensive guide to development of .NET 2.0 Smart Clients working with existing Service Oriented Architecture based XML web services, fully utilizing the Enterprise Library

Developing Web Report using Crystal Report in .NET 2005.

by Suranjan Nandi

The report is build on XML Schema and the data and binded the report at runtime.

Dictionary for Google Suggest like Dictionary

by smiling4ever

To make a dictionary that will work with Google Suggest like Dictionary.

Disaster Recovery Plan In MOSS 2007

by Tariq Younas

Article describes how to make backup and recovery plan of MOSS 2007.

Displaying , Exporting and Printing Crystal Reports in ASP.NET

by patelsachin

Displaying , exporting and printing crystal reports in ASP.NET with source code.

Document SQL Server 2000/2005 Database

by Nitinpatel

T-SQL script to generate the document of SQL 2000/2005 database

DotNetNuke Module Packager

by perlmunger

This article describes the DotNetNuke Module Packager application and source code. The application enables the user to generate DotNetNuke private assemblies that are useable out of the box from a custom module defined in the programmer's development environment.

Dynamic Creation of DTS-packages in VB

by Andrey Chuvahin

Example dynamic configuration of DTS-packages for transferring DBF files to SQL Server with VB

Dynamic Cross Tabs and Pivots, A Different Approach

by Kannan K R

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

Dynamic Cursor with sp_executesql and OpenXML

by Tina83

A cursor for dynamic query.

Dynamic Data Grouping Using Microsoft Reporting Services

by Asif Sayed

Generate multiple outputs from a single physical report template using dynamic data grouping.

Dynamic 'Sales by Week' Procedure in SQL Server

by Mike Ellison

An approach to creating an aggregate report with a set of dynamic columns based on dates.

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

by Venkat Chaitanya Kanumukula

Export SQL Server Tables to Excel Files Dynamically

Dynamically Generating Html/Excel/Word Document Files with SQL Server data using SSIS 2005

by Venkat Chaitanya Kanumukula

Export SQL Server tables to HTML/Excel/Word Document files dynamically.

Easier Database Access with Diamond Binding (Part 1)

by Matty22

An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding

Easier Database Access with Diamond Binding (Part 2)

by Matty22

An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding

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

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.

Easy way to create your Join queries

by Emad Al-Ashi

An easy graphical way to create complex nested SQL Join queries.

Efficient data processing with ADO in C++: Method GetRows

by Vitaly Tomilov

Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.

Encrypting windows application connection strings

by Daniel Kuettel

This article shows a simply method of encrypting connection strings for windows applications

Enhanced Document workflow approval v2

by Refky Wahib

This Article supporting these features: Logging to file, TransactionScopeActivity, WorkflowCommitBatchService, SqlTrackingService, fault Handler Activity and Bi-Directional communication using custom services

Enterprise ASP.NET Suite

by David Hoyt

Easy to use ASP.NET suite that gives you everything you need to get started and makes it all pathetically easy to use - Windows services (with UAC), localization (webpage and e-mail), e-mail templating, configuration, and much, much more!

Enumerate SQL Server Instances in C#, Using ODBC

by earmitage

An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on SQLDMO. Based on the C++ article by Santosh Rao.

Everything you wanted to know about State Management in ASP.NET

by chintu222

This article will emphasize on the mechanisms of State Management that are available with ASP.NET and the steps to learn and understand their implications for usability, performance and scalability.

Execute DTS Through VB.NET

by Suresh Suthar

How to execute DTS packages through VB.NET and use global variables.

Export large data from a GridView and DataReader to an Excel file using C#

by Fuad Bin Omar

An article on exporting large data to excel file

Exporting Stored Procedure Results into Tables Dynamically with T-SQL

by Venkat Chaitanya Kanumukula

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

File Synchronization using a NAnt Task

by Shuqian Ying

Codes for file synchronization between local and local/remote target directory trees that can be run under the NAnt or a console are provided.

Find "Leaked" Database Connections in ASP.NET Web Applications

by Todd Denlinger

Presents a method for monitoring the amount of time database connections stay open in ASP.NET applications.

Find multiple strings in selected columns

by akhil khare

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

Find Primary Key or ID column of Table in SQL Server 2000/2005

by idreeskhan

Get or find Primary Key or ID column of Table in SQL Server 2000/2005

Find Stored Procedures called within a procedure

by brip

Sometimes its tedious to find all calls made to different stored procedures within a stored procedure and generate reports in case we have large databases. This tool is aimed to script all SPs and extract SP calls made with additional information such as author name and description.

Find Week in Given Date in SQL Server

by Rajaraman.net05

This sql function is used to find the week in Given Date.

Finding performance bottlenecks and their resolutions in windows services

by Sajid.Majeed

This article will address tools and technologies to identify bottlenecks and key consideration points for performance improvement.

Finding the nth day of the nth week

by harry_kochhar

This SQL Server function helps to get the nth day of the nth week.

Five reasons for using an O/R mapping tool

by Iqbal M. Khan

An O/R mapping tool generates persistence objects for your .NET application.

Five steps to using a logging utility in your projects using Application Blocks

by Shivprasad koirala

Steps to use a logging utility in your projects using Application Blocks.

Flash and .NET with FlashRemoting

by daniel_nilsson

Testing FlashRemoting with .NET.

Flexible and Plug-in-based .NET Application using Provider Pattern

by Shahed.Khan, David.Grinberg

This paper demonstrates creating a flexible, extensible, plug-in-based .NET application (JOM - Smart Job Manager). JOM is an asynchronous job processing engine built using the MS Provider design pattern and the .NET technology available today.

Format Excel Sheet from DTS when Excel is Not Installed on SQL Server

by s_arun_kumar

Format Excel Sheet from DTS when Excel is not installed on SQL Server

Format Number to 2 Decimals in MS SQL without Rounding

by ashishnaik1

Format any Number to 2 decimal Number without Rounding

Full-Text Indexing Files with Microsoft SQL Server

by István Kovács (HU)

Indexing Word, Excel and other types of documents is easy with SQL Server

Full-text searching with IFilter's

by Klaus Salchner (Canada)

Indexing Server, SQL Server, Windows SharePoint Services, SharePoint Portal Server, Exchange Server and Windows Desktop Search provide full-text search capabilities. Each utilizes the so called IFilter components to index the content and then allows clients to search the index.

Fully Customized Reusable ASP+ Vertical/Horizontal Marquee Consuming XML/MS SQL

by Ameen AboDabash

Vertical/horizontal Marquee Web Custom Control consuming SQL Server DB/XML, with great design time attributes.

Generate Classes and CRUD Procedures

by ColinBashBash

Generate classes / CRUD procedures.

Generate Insertion Scripts Using .NET 2.0

by Benedict Chan

Using .NET 2.0 to get the SQL Server schema and generate insertion statements.

Generate SQL Select, Insert, Update and Delete

by samitcom

This will generate a SQL Select Query, Insert Query, Update Query and Delete Query by selecting SQL Database Connection and Choose a table to generate the script for using in class or DataCommand.

Generating INSERT statements in SQL Server

by Sumit Amar .

Stored procedure to generate INSERT..VALUES statements in SQL Server.

Generating INSERT statements in SQL Server

by ilorgat

This is an alternative for "Generating INSERT statements in SQL Server"

Generating osql Batch Scripts

by Michael Erasmus

This article is on a tool I wrote to generate executable osql deployment batch scripts.

Generator-less! C# wrapper for SQL Stored Procedures

by Brian Perrin

Eliminate the pain of calling SQL stored procedures from C#.

Generic Login Control

by Barathan

Generic Customizable login control for VB.NET Windows Forms.

Get Control Properties at runtime using Reflection

by Suni1111

Easy Access to Control Properties in .NET

Global Variables in SQL Server

by Md. Marufuzzaman

A list of Global variables in SQL Server and their uses in Transact-SQL

Google Suggest like Dictionary

by Gavi Narra

An implementation of Google suggest using remote scripting.

Grant Execute on all procedures to a user

by Sumit Amar .

This stored procedure grants execute privilege on all procedures to specified user

Gridview, ObjectDataSource Making life easy

by Tapan Dantre

This Article will give some briefing on sorting, searching, paging in gridview with ObjectDataSource.

Handle Sql server and Foxpro database with .NET

by Gaurav K Singh

This article aids in rapid application development for database handling, for desktop and web applications

Handling Keyboard Events of DataGrid Cells

by Asher Syed

Handling Key-Down and similar events for DataGridCells in a DataGrid

Hands on how to configure the Microsoft MSDE

by Lars-Inge Tønnessen

An article on how to setup and configure the MSFT MSDE 2000.

Having the CheckBoxList support many-to-many relationships

by _JERKER_

Example of implementing many-to-many multiple choice functionality the declarative way.

Highlighting Important Dates in Calendar

by azamsharp

Highlighting important dates in the Calendar control.

How design patterns can help you in developing unit testing-enabled applications

by Marcelo Ricardo de Oliveira

This article shows how you can mix together Model-View-Presenter, Domain Model, Services, ActiveRecord, and Repository patterns to create a testable application.

How Do I Protect My Stored Procedure Code

by Md. Marufuzzaman

This article will demonstrate the best practice to protect SQL server code object.

How to Call SSIS Package from the Stored Procedure

by JustChiragPatel

No need to create web service for SSIS package call

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

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.

How to Config Linked Servers in a Minute

by Kamran Hazari

How to create Linked servers in a minute in an easy way

How to convert DataGrid into Data Entry Form

by Jimmy M Joy

This article explains how to convert DataGrid into a data entry form for same kind of data.

How to Exactly Enumerate SQL Server from LAN by using SQLDMO

by Wang Xuemin

An article on how to use SQLDMO to enumerate SQL Server instances.

How To Exactly Enumerate SQL Server From LAN By Using SQLDMO

by Wang Xuemin

An article on introducing how to use SQLDMO

How to execute multiple long running SQL Statements Asynchronously in small chunks

by Khorshed Alam, Dhaka

How to execute multiple long running SQL Statement Asynchronously in smaller chunks

How to Get a Reference to Parent Form from a Component

by David Catherman

Components don't have a .Parent property like controls do. Getting a reference to the instance of the parent form the component was on is very difficult.

How To Handle Concurrency in LINQ to SQL?

by Shivprasad koirala

How to handle concurrency in LINQ to SQL?

How to Implement a NavigationPanel Using AJAX

by Mohammad Akbarizadegan

This article demonstrates how to implement web applications based on AJAX and ClientScriptCallBack as it presents a simple example. Also, the article tries to point at the key features of working with ASP.NET ClientCallback and AJAX.

How to implement an incremental search using a grid column (UltraWinGrid)

by CQüeb

This article pretends to show how to implement an incremental search doing double click in a UltraWinGrid column.

How to Integrate an OLE Object with SQL Server

by Md. Marufuzzaman

This article will demonstrate how we can integrate T-SQL with an external application.

How to Integrate an OLE Object with SQL Server v2

by Md. Marufuzzaman

This article will give you an idea about how to integrate an OLE Object that is a COM+ API with SQL Server and write a message into a Windows event log.

How to link different data sources together

by Klaus Salchner (Canada)

Describes how you can link SQL Server with many different data sources like a directory as Active Directory Application Mode, a Microsoft Indexing Server catalog, a Microsoft Access database and a Microsoft Excel spreadsheet. Also explains how to query linked servers using the OPENQUERY command.

How to make your app secure

by Salil Khedkar

If you are into development or quality assurance of enterprise solutions, you must be aware of the security aspect of your application. This article provides a checklist for the same...

How to Non-alphabetically Sort GridView Columns with Text Data

by Christopher Geyer

Creating a sortable GridView is easy. But, what if you want to perform a nonalphabetic sort on a column that is alphabetical? Answer below...

How To Pass Value from User Web Control to Parent ASPX Page

by T.Ashraf

How to pass values between user control and ASPX page without JavaScript

How to retrieve SqlConnection statistics for executed T-SQL commands

by Ali Ozgur

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

How to Script Out SQL Server Objects

by ozkary

A VBScript script which allows to script out all the SQL Server objects in each independent file

How to Set Up SQL Server Integrated Security For Using With SMS

by Ahmed_EL Sayed

How to set up SQL Server Integrated Security for using with SMS.

How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File

by Vimalsoft(Pty) Ltd

How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File

How To Store Any File into SQL Database

by Md. Marufuzzaman

An easy technique to store any file into SQL database

How to use data caching in a .NET Windows Forms application

by Simon Steed (SimonAntony)

This article explains how using caching within your Windows Forms application can speed up data access for frequently used data and avoid performance bottlenecks over the network.

How to use OLAP cubes for reporting, and get your business users the data they need today.

by InterScape, Inc.

Creating reports today has become a nightmare for a lot of developers. I can contest to the late nights and many lines of code in order to build custom reports, then have a user never use a report because it was slow or did not contain the data they wanted to see.

How to Use Stored Procedures in VB6

by Sujith C Jose

Describes how to use a simple stored procedure in Visual Basic 6.0

How to Validate ASP.NET and MVC Web Forms Using Business Rules Engine

by Misha1964

Learn how to validate complex web forms using business rules engine

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

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!

Identifying NHibernate-Related Bottlenecks through Performance Monitoring

by Peter Weissbrod

A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues

Impersonation using Code

by Chirag R Darji

Impersonation using Code

Implementation of Unicode in SQL Server

by josekonoor

Information about Unicode implementation in SQL Server.

Implementing Audit Trail using Trigger

by Shivprasad koirala

Implementing Audit trail using trigger

Implementing Database Versioning

by Ezhilan Muniswaran

This database script provides a template for properly maintaining multiple versions of a database.

Implementing Dynamic WHERE-Clause in Static SQL

by John-ph

This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.

Implementing multi-level trees in MS SQL Server

by Duong Ba Hong Minh

A good way to setup and install a multi-tree level structure by using a MS SQL Server database.

Implementing WS-SecureConversation in Microsoft IssueVision

by Weidong Shen

Adding secure communications to the Microsoft IssueVision sample application using WSE 2.0.

Importing CSV Data and saving it in database

by Mukund Pujari

This article shows how to import CSV data and store it in database.

Improve hierarchy performance using nested sets

by James Simpson

This article describes how to use nested sets to improve performance of hierarchies within SQL Server and other relational databases

Improve performace with Sessions using Cache

by Albert Pascual

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

Improving the performance of queries using SQL Server: Part 1

by Pete O'Hanlon

The first in a series of articles on prioritizing and improving query performance in SQL Server.

Improving the performance of queries using SQL Server: Part 2

by Pete O'Hanlon

These articles are on prioritizing and improving query performance in SQL Server.

Independent Data Access Layer (Ddocumentation in Progress)

by Salvatore Vetro

The art of swap from a database to another changing a flag

Index XML Documents with VTD+XML

by Jimmy Zhang

Introduces a simple, efficient, human-readable XML index called VTD+XML.

Insert and retrieve data through stored procedure

by Tariqaziz

All about stored procedure

Inserting XML formatted data into SQL Server 2000

by faisal abdul aziz

This article explains Parent-Child insertion into SQL Server 2000 using XML Support provided by SQL Server 2000 and Visual Studio.NET

Install and Configure SQL Server for SQLCE replication

by Garth Tissington

After pulling my hair out for several days I finally figured out how to install and configure SQLCE with SQL Server for replication to a Windows CE device. I hope this saves you some pain

Installing MSDE with .NET Application

by Mukund Pujari

This article shows how to distribute or install MSDE with a .NET application.

Integer Arrays Using T-SQL

by Chris_Martinez

How to pass an array of integers to SQL Server

Integrate Reporting Services with VS.NET pages and VS.NET controls

by Frank Kerrigan

Integrate reporting services with VS.NET pages and VS.NET controls.

Integrated College Management System[Credit Hours Sys.] --Part 1-- Class Library & Database

by Ameen AboDabash

This project is established for helping students to make registration easily. It also simplifies this process for both students and employees and prevent usual problems the Credit Hours System faces.

Integrating Microsoft Access DB, SQL Reporting Services and Visual Studio .NET

by Anand Santhanam

In this article, I would like to demonstrate how we can leverage the SQL Reporting Services feature on to a Microsoft Access database, using the Visual Studio .NET as IDE.

Integration of .Net Application With SAP

by Jayawant

Connecting .Net & SAP

Internet programming primer (general overview and history of ASP.NET)

by Kevin Staunton-Lambert

A general overview of Internet technologies including what the Internet actually is, what HTML and XML are, using Web forms, CGI/MIME, IIS ISAPI, ASP and creating HTML based front ends to databases via ODBC32, OLE DB, ADO and ASP.NET

Introducing WF4.0: Building Distributed Apps with WF 4.0 and WF 4.0 Services

by mohamad halabi

Shows how to build new-design distributed applications with WF 4.0 and Data Services.

Is Your Data Valuable To You?

by Ujwal Watgule

The article discusses threats to application in the absence of proper validation procedure.

Iserver Cyber Cafe

by goodtime68

Cyber café software to keep track of buisness.

JohnKenedy Data Access Layer Library

by John Kenedy S.Kom

This is a .NET 3.5 library that acts as Data Access Layer with many automatic features

Keeping Admins and clients happy with Cache usage

by hurddar

Optimization considerations for your code management

KS Technologies Crystal Report

by | Muhammad Waqas Butt |

Show Crystal Report On Selection Base

LayerGenMMX

by icemanind

Easily create Business and Data Layers!

LINQ Code generator

by Sree Nivas

This generates Basic linq codes just by giving necessary inputs

LINQ FAQ: Part 3

by Shivprasad koirala

Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.

LINQ to SQL

by Le Sourcier

How to use LINQ to SQL

LINQ to SQL Transformation: Examples and Source Code

by Muigai Mwaura

LINQ to SQL Transformation: Open Source implementation of IQueryable, examples and source code

LinqToSQL: Query Multiple Databases in One LINQ Expression and More...

by Muigai Mwaura

Query multiple databases in one expression e.g. an Microsoft Access Database and an SQL Server Database

Load/Unload images into/from DB table

by Maxim Alekseykin

Explains how to load a BLOB data into a DB table and how to get it from the DB table.

Loading image files from a database, using ADO

by Bahrudin Hrnjica

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

Locate SQL Server instances on the local network

by James Curran

An article on locating MS SQL Server instances on the local network, and retrieving information about them.

Mapping Tables, Relations Between Tables, and Columns Info of a SQL Server Database

by felipesabino

Shows a way to map tables, relations between tables, and columns info of a SQL Server 2000/2005 database; also generates INSERT, UPDATE, DELETE, and SELECT SQL statements at runtime using C# (TableReader).

Master Detail Report: the use of labels vs. grids; Forms Authentication

by JSpruell

A primer on creating ASP.NET pages that use User.Identity.Name available from Forms Authentification to permit a customer/employee to logon, retrieve their specific records, and format the information as a Master Detail record.

MCMS Connector for SharePoint Technologies Review

by Stephen Huen

Review of MCMS Connector for SharePoint Technologies.

MCMS Manager

by Chester Ragel

A tool which can be used to do common tasks which Microsoft Content Management Server API provides.

MCMS Placeholder Content Web Part

by Stephen Huen

Display content from a Content Management Server placeholder in a WSS site.

MCMS SharePoint List Items Placeholder

by Stephen Huen

Lists items in a Windows SharePoint Services (WSS) list.

Merge Replication between SQL 2000 or SQL 2005 using SQLCE

by ihsanps

Merge Replication using SQL 2000 or 2005 using Compact Framework

Merge Replication between SQL Server 2000 and SQL Server CE

by sebagomez

An article on how to configure a SQL Server 2000 and SQL CE on different PPC that syncronize their data with the SQL Server 2000

Methods for a location proximity search using GPS (WGS-84) mathematics

by Thomas Kurek

Unsatisfied with the accuracy of code online that assumes the Earth is a sphere, I have implemented the oblate spheroid model used in GPS.

Microsoft Content Management Server Crawl Page for Search

by Stephen Huen

Provides a start page for search engines to crawl a Content Management Server (MCMS) web site.

Microsoft Content Management Server Search Controls

by Stephen Huen

Gives Content Management Server web sites search capability using SharePoint Portal Server as the search engine.

Microsoft Content Management Server Search Controls (C#)

by Stephen Huen

Gives Content Management Server web sites search capability using SharePoint Portal Server as the search engine.

Microsoft Indexing Service and OLEDB

by Ali Hamdar

How we can access the Windows Indexing Service using OLEDB.

Microsoft Reporting Services in Action

by Teo Lachev

Introducing Microsoft Reporting Services.

Minimalistic Driver-less Native MySql Client

by Ladislav Nevery

Native MySql Client not requiring any special driver or library

Monitoring Group of Linked SQL Servers from a SQL Server

by Kuldip Rindani

Monitoring group of Linked SQL Servers from a SQL Server

Move Computers in Active Directory Using a SQL Server Datasource

by smoore4

Move multiple computers from one OU to another using a SQL Server table as a datasource.

Move DTS Package from one MS SQL Server to another

by Haiyan Du

Do you know the easiest way to move DTS package from one SQL server to another? The answer is here.

MS SQL Server Profiler with .NET

by Praveen Nair (NinethSense)

This article describes how to develop a Microsoft SQL Profiler with .NET.

MS SQL Server script validation with NAnt Task

by Stefan Fork

Validate MS SQL Server scripts with NAnt to improve continuous integration.

MS SQL Server to FireBird migration

by firefalcon

A real example of database migration (MS SQL -> FireBird).

Multi Line GridView Column Cell

by T.Ashraf

Display multi line of text saved in the database

Multi-field Grouping Repeater

by Daniel Schaffer

Data repeater that can group by multiple database fields.

Multiple Database Connection File Manager

by TSells

Utility to manage multiple DB connection strings for an application.

Multiple filters on a WHERE clause

by fhunth

How to write multiple filters on a WHERE clause on a sql sentence

nAML: A New Revolutionary Way to Model Your .NET Applications!

by Mohammad Ashraful Alam

Along with specification, examples and tools, a new visual modeling technique is being introduced, termed as “nAML” (.NET Application Modeling Language), which overcomes the limitation of typical modeling languages in a revolutionary way!

Navigation using dynamic SiteMapPath file

by Himanshu D

This article demonstrates the ASP.NET 2.0 feature to extend menu generation using SiteMapPath.

NHibernate Best Practices with ASP.NET, 1.2nd Ed.

by Billy McCafferty

This article describes best practices for leveraging the benefits of NHibernate 1.2, ASP.NET, generics and unit testing together.

NHibernate DaoFactory Exposer with Castle MikroKernel

by Ali Ozgur

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

NHibernate Helper Kit

by Murat YILMAZ

Here is a tool to help you build your NHibernate ORM applications.

NHibernate Templates for Smart Code Generator

by Danilo Mendez

Describes how to generate NHibernate objects and ASPX pages using Smart Code

NUKEleus - A DotNetNuke Installation Program

by Todd Davis

An installation program for the popular DotNetNuke ASP.NET portal.

Object Mapping Using Reflection

by Stu Ellerbusch

Object mapping using reflection, with C# and SQL Server.

ODBC Database Access – A Templatised Approach

by Dave Handley

A library of template classes that enables the rapid production of client-side database code.

On Importing an Access Parametric Report into SQL 2000 Reporting Services

by mysorian

Describes importing of an Access 2000 parametric report into SQL 2000 Reporting Services.

On the Road with .NET Mobile Controls

by Gishoma

Here's the scenario: your boss wants information on the go, but he hates to haul along his laptop. He's sick of the hassle of bringing it on airplanes and lugging it around. He wants a mobile application that provides him with the information he usually accesses on your extranet.

Optimized Calculation Algorithm for Business Days

by Gaurang Desai

Library that implements business days and age calculation and also implements the DateDiff function in C#.

Optimized Paging and Sorting using Object Data Source

by Muhammad Akhtar Shiekh

An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.

Optimizing LINQ Queries using DataLoadOptions

by Shivprasad koirala

Optimizing LINQ Queries using DataLoadOptions

Optimizing Performance in NHibernate: Part 2: A Collection of Enhancements

by Peter Weissbrod

This is the second part in a two-piece article focused on optimizing the efficiency of your NHibernate ORM layer.

Oracle to SQL Server VB.NET Utility application

by hoquet

A utility program that allows you to enter SQL to select data from Oracle, the program will then create a table in SQL Server and copy the data using SQLBulkCopy.

Other Row Paging Technique Using T-SQL

by bluechip_asia

Simple Row Paging Using T-SQL at Stored Procedure

Overview of SQL Server 2000 Database Clustering using MSCS

by Pankaj A. Chitriv

An article which gives an overview of SQL Server DB clustering using MSCS.

Overview of SQL Server database Triggers

by Md. Marufuzzaman

Overview of SQL Server database Triggers

Overview of SQL Server Stored Procedure

by Md. Marufuzzaman

Overview of SQL server stored procedure

PagerPanel

by machocr

Simple data paging control for Windows Forms.

Pagination with Repeater Control

by Navin Pandit

Pagination with Repeater control / custome pagination with data control in C# ASP.NET 2.0

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

by Alon_Catz

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

Paging in SQL Server by using TSQL

by Muhammad Kashif Akram

Facilitating efficient Sql Server paging by giving T-SQL query as input to this generic stored procedure

Paging of Large Resultsets in ASP.NET

by Jasmin Muharemovic

An article about optimization and performance testing of MS SQL Server 2000 stored procedures used for paging of large resultsets in ASP.NET

Paging without a wizard (SqldataSource control)

by Vimalsoft(Pty) Ltd

How to use paging without a wizard in ASP.NET.

Parameter Discovery on Ms Access and SqlServer. using Microsoft Patterns and Practices DataBlock version 3.0 final

by Patrickquinn1212

Uses DataBase Schema to aid in Parameter Building for commands.

Passing a Comma Delimited Parameter to a Stored Procedure

by -Dr_X-

Passing multiple values as a single Parameter to a Stored Procedure

Passing an Array as Parameter to SQL Server Procedure

by Mohammad Al Hoss

Passing an array as parameter to SQL server Procedure

Pattern to Update Multiple Fields

by Mark

An article describing a pattern for updating only certain values that have changed in a web form.

Performing Data Merge and Audit with SSIS

by xbadenx

Merge data tables with validation audits and error logging.

Persist Objects with Attributes

by Thomas Lykke Petersen

Enable persistance and population of objects without writing ADO.NET code.

Persisted Permutations

by Daniel Aioanei, Adi Malinaru, Andrei Postolache

An article on how to persist permutations of items in relational databases.

Persistent Object Management in Less than 300 Lines of Code

by Nick Higgs

Presenting a lightweight method to cut out most of the repetitive work of creating data classes.

Persisting Rich Text

by Declan Brennan

Extending the RichTextBox to support form persistance and data binding.

PinPoint your exact location and show the world where you are

by TylerBrinks

Geo-Locating C# Smart Client Application using the 2.0 Framework

Pitfalls Encountered and their Workarounds during Development of BizTalk Projects

by Abhijit Mahato

This article discusses the pitfalls encountered and their workarounds during development of BizTalk Projects

Pitfalls with Merge Replication in a SQL 2000 Environment

by Psycho-*Coder*-Extreme

This article covers pitfalls found while doing a merge replication in SQL 2000

Pop3 Client Service Engine instead of SQLMail

by Sigura

Pop3 Client Service (instead of SQLMail): Pop3 Class + DB Halper Class + Read XML Class + SQL Connection Dlg Control + BLOB to File Util

Power yourself against XSS

by albert arul prakash

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

Procedure to Shrink the Database Transaction Log

by Md. Marufuzzaman

This article will demonstrate the procedure to shrink the database transaction log.

Project RDL - Open Source Report Definition Language implementation in C#

by Kim Sheffield

The RDL Project is an open source (GPL) implementation of the RDL for the .NET environment created by fyiReporting Software. RDL is an XML based language created by Microsoft with the goal of promoting interoperability of reporting products. Project RDL is a compact implementation of RDL.

QASharp V1.3 [Query Analyzer like tool for MSDE database]

by Rajesh Pillai

This project is meant to provide a tool similar to query analyzer which can be used to execute queries, create tables, and do all other common database activities.

Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup

by pinaldave

Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup

QueryCommander SQL Editor

by Mikael Håkansson

QueryCommander SQL editor with IntelliSense, wrapped in a Visual Studio type of environment. QueryCommander supports: Microsoft SQL Server 6.5-2005, MySQL 4.*-5.1, and Oracle 9i.

Quick Overview: Temporary Tables in SQL Server 2005

by Abhijit Jana

Basic overview of temporary Tables in SQL Server 2005

Quick Screen Development in ASP.NET

by Balachandar Ganesan

Auto Generate the ASPX page quickly

Quickly add reports to your website

by Matt Perdeck

Shows how to add a Crystal Reports report to an ASP.NET page, with grouping, filtering, and drill down.

Ranking Query in Sql Server 2000

by Mustakim Mansuri

Sql Query in Sql Server 2000 for getting rank on particular numeric field in table.

Rapid Web Application Development

by Andrew M Baldwin

An article about the Multiformity Open Source project.

Reading RPT File Then Display Report as PDF

by bluechip_asia

This Article Teach You How To Use External RPT File Rather Than Embedded RPT File (.DLL)

Ready-to-use Mass Emailing Functionality with C#, .NET 2.0, and Microsoft® SQL Server 2005 Service Broker

by Shahed.Khan

This paper demonstrates an extensible mass emailing framework (Smart Mass Email SME). The demo implementation uses cutting edge .NET technologies available today such as C#, .NET 2.0, Microsoft® SQL Server 2005 Service Broker, MS Provider Pattern, Enterprise Library January 2006 etc.

Record Versioning with SQL Server

by Ben Allfree

Learn how to store data with a version history.

Remove duplicate records from SQL tables

by Eugene Ochakovsky

A generic procedure to retrieve and delete duplicate records from MS SQL Server tables.

Reporting Services 2005 101 using Web Client

by Asif Sayed

A step by step tutorial demonstrating the power of locally processed Reporting Services with the ASP.NET Web Client..

Requirements for Developing WebApplications & ASP .NET Problems

by Star_Friend

Web Applications & ASP .NET

Restore SQL Server Backup Files into any database

by Phorozan

When you create a backup, you must be able to restore this backup into the same database and same location. But this code also helps you to restore a backup into a new database or existing database.

Restoring Datbase Using BatchFile(*.Bat)

by Deepak.M

This article describes on building a Database from scratch using Batch File from the existing Database

Retrieve SQL Server Password

by Rajneesh Noonia

This tool is used to retrieve the forgotten SQL Server Password and passwords of registered servers.

Retrieving and Storing Call History

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.

Robust MD5 Digest Extended Stored Procedure for Microsoft SQL Server 2000

by David A. Gray

MD5 Digest XSP with error trapping and full Unicode support, in and out.

Row Numbers in SQL Query (Microsoft SQL Server 2000 and 2005)

by P. Ganesh Kumar

Helps in assigning row numbers in the returned result of an SQL query

Row Paging Using Temporary View

by bluechip_asia

Row Paging Using Temporary View

Run an SqlServerr Job from MS Access

by Seifedine kadry

Run an SqlServerr Job from MS Access

Running DotNetNuke 4.0.2 on Windows XP Home or on any other system lacking IIS

by Vlad Hrybok

This article describes how to run DotNetNuke content management system on UltiDev Cassini web server, which unlike IIS can run on Windows XP Home and can be redistributed along with the DotNetNuke applications.

Sample code for AJAX in VB.NET, ASP.NET without using Ajax.dll

by Bala Murali S

Sample project containing source code to implement AJAX without Ajax.dll in VB.NET, ASP.NET.

Save An Image Into SQL Server 2000 Database

by vivekthangaswamy

How to upload files to Web pages in ASP.NET? How to read an image from a database using ADO.NET and display it in a Web page?

Saving and Retrieving Wav files from MSSQL, MSDE and MySQL databases

by j1webb

This code will let you save .WAV files to either a MSSQL, MSDE or MySql database and then retrieve them

Schema.ini override and bulk upload using SQLXML

by Aravind Rajagopal K

Schema.ini override and bulk upload using SQLXML

Script SQL Server 2005 diagrams to a file

by craigd

Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.

seach in database

by hamidreza Talebi

search Using textbox

Securely backup your SQL Server database and other files to a remote machine

by wallace turner

An effective utility to securely backup an SQL Server database and/or a group of files to a remote machine

SELECT * FROM, sp_helptext ShortCut for SQL Query Analyzer

by Paresh Goyal

A Key ShortCut for 'SELECT * FROM' for tables and to see text of the stored procedures.

Server Side Message Box in VB.NET and C#

by Anwar Hussain (Technical Specialist)

A custom control - server side MessageBox in VB.NET and C#.

Setting the SharePoint database straight

by Vivek Shaurya

Investigating the database created by SharePoint for use in your .NET application.

SharpCMS, an Open Source portal server built on ASP.NET 2.0

by Wouter van Vugt

A CMS built using WebParts and MasterPages.

Simple & Advanced Pivots with C# and ASP.NET

by Nitesh Maharaj

How to create simple and advanced pivot tables in C# and ASP.NET

Simple & Advanced Pivots with C# and ASP.NET

by Jean-Francois Lanouette

This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"

Simple bit of Transact SQL to help locate text in a database

by codelion

Simple bit of Transact SQL to help locate text in a database using cursors

Simple Data Access in C#

by 6opuc

Fast and easy to use data access class library.

Simple data export

by R. Giskard Reventlov

Simple export of data from database a to database b using identical tables (SQL Server).

Simple Data Paging

by Barend Jnr

Simple Data Paging

Simple ODBC Wrapper

by TomKat

Simple ODBC Wrapper + Connection classes for several database types.

simple search use multiple words in textbox

by hamidreza Talebi

Using simple code for searching in database

Simple SQL Connection String Manager Class

by Pawel Zarzycki

Simple class that helps accessing and managing SQL Connection Strings.

Simple Stored Procedures in .NET

by HRiazi

Use stored procedures in your code - as simple as 1,2,3

Simple use of Ajax

by realhossam

Simple use of Ajax technology in .net

Simplified phonetic search with MS SQL Server

by vini2k1

Perform phonetic search on MS SQL Server using Soundex.

Simplify data entry with AutoComplete

by Asif Sayed

A tutorial demonstrating the power of the AutoComplete feature of the TextBox control using a Windows Forms client and SQL Server 2000 data.

Simulating Recordsets with ADO.NET

by Alberto Venditti

A proposed class to simulate the ADODB.Recordset behavior in .NET.

Single Instance Application A Simple Way!

by skullz_softwares

Making Single Instance Application a Simple Way!!

Smart Code Generator-How to create Templates

by Danilo Mendez

Smart Code the Open Source Code Generator

Smum County IO

by Lou Flees

An ADO.NET toolbox that is meant to serve as the lowest level database IO layer for an application based on an Access, Microsoft SQL Server, or Oracle database.

SOA: The Subscriber-Publisher Model, Introduction and Implementation

by DGoins

This article explains a brief introduction to SOA and a Subscriber-Publisher model, along with how to implement one using WSE SOAP Receiver and WSE SOAP Sender classes inside a Windows .NET application.

Solving problems while passing XML into a Stored Procedure

by Ashutosh Singhal

Having problems while passing XML into a Stored Procedure because of Namespaces? This script would probably solve it.

Sort Database Tables By Foreign Keys

by Dave Elliott

How to sort tables so data can be retrieved for offline sychronization and not violate foreign key relationships.

SparkLines

by Igor Krupitsky

SparkLine is a small, high resolution line chart. This article explains how to create and use SparkLines in your ASP.NET application.

SQL - Time Table With Stored Procedure (SQL Server)

by Romelard Fabrice (Alias F___)

A Stored Procedure for Create a Time Table with all interesting details

SQL And C#

by Ayaz Awan

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

SQL and VB.NET Code Generator

by Raj Settipalli

An article on generating SQL strored procedures and VB.NET function calls.

SQL as a set-oriented language

by j.Auer

SQL works if the commands are set-based. Procedural elements may helpful, but shouldn't be used on the wrong place. The article begins with a procedural sample and changes it into a set-based version.

SQL Battleship 2008

by craigd

Single-player game using GEOMETRY datatype and spatial functions in SQL Server.

SQL Classes Encapsulation (simplified stored procedure calls, queries and DataSet returns with .NET)

by Xodiak

A class that encapsulates SQL connection classes to make queries and stored procedures very easy to run in .NET. Contains methods like ExecuteStoredProcedure and ExcuteSelectStatement to return DataSets.

SQL Compare and SQL Packager

by Redgate Software

A simple solution to scripting when sysdepends are damaged

SQL Database Backup Scripts

by Edward Steward

Quickly create a full backup regime for your SQL database(s).

Sql Database Connection DLL Written in C#

by Member 2260574

Connect and close a sql database with internal error reporting using Event Logs

SQL Database Editor

by Charl Pohlmann

An article on a SQL database editor.

SQL Database Relation Builder

by Charl Pohlmann

An article on automatically building the relationships between tables in a DataSet.

SQL Database Table Space Used Data as a CSV File

by Ted Bouskill

This is a simple console application that can be scheduled to create CSV files with table space used data.

SQL Encryption and Decryption Library (Using Rijndael)

by George Oakes

This library allows a user to use functions in SQL Server to encrypt and decrypt text.

SQL Framework

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 injection attacks

by Amit Kukreti (A)

An article on SQL injection attacks.

SQL Injection Attacks and Some Tips on How to Prevent Them

by Colin Angus Mackay

Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.

SQL Optimizer for Visual Studio: Automatically make your queries faster using this extension from Quest Software

by Daniel Wood

Learn how changing the way you write queries can make them run faster. This article will describe the automated approach to optimizing SQL. DBA's have been doing it for years, now it's available for developers.

SQL Performance: Good Practices for Beginners

by Praveen Nair (NinethSense)

This article gives simple practical guidelines which will help a developer to design good performance, high quality SQL databases.

SQL Query Optimization FAQ Part 1 (With video explanation)

by Shivprasad koirala

SQL Query Optimization FAQ Part 1 (With video explanation)

SQL Refactor – making order out of chaos

by Redgate Software

This article describes how you can use SQL Refactor to sharpen up your T-SQL.

SQL Reporting Service Superscript issue

by Vinoth Kumar.S

Superscripts in SQL Reporting Services.

SQL Reporting Services Tips with Footer Text problem

by Vinoth Kumar.S

A tip for one of the problems found with Footer Text of ReportDesigner

SQL Reporting Services Tips with Footer Text Problem

by wburdick

A tip for one of the problems found with Footer Text of ReportDesigner

SQL Reporting Services Viewer Page Using SOAP API

by Marian Dumitrascu

A report viewer page for SQL Reporting Services that uses exclusively its SOAP API.

SQL Reporting Services with Dynamic Column Reports

by JeyKey

An article on generating dynamic column reports.

SQL Script Executer or Reader Executes Microsoft SQL Scripts

by idreeskhan

SQL Script Executer or Reader executes the scripts which are already generated and you want to execute them. Just change the path where your scripts reside.

Sql Script Generator in C# From SQL Table

by idreeskhan

SQL Script Generator generates the SQL Scripts to run on SQL query to analyze only insert and update queries

SQL SERVER - 2005 - Introduction and Explanation to sqlcmd

by pinaldave

SQL SERVER - 2005 - Introduction and Explanation to sqlcmd

SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table

by pinaldave

SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table

SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database

by pinaldave

SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database

SQL Server – Active Directory Interaction

by ThomasMiller

Descripe the SQL Server 2000/2005 interaction with Active Directory on Windows 2000 or 2003 server

SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download

by pinaldave

I tried to accommodate all of them in the last post in the series. I hope this series is helpful to all candidates who are seeking job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer to at your convenience.

SQL SERVER – Order of Columns in Update Statement Does not Matter

by pinaldave

SQL SERVER – Order of Columns in Update Statement does not matter

SQL Server 2000 - Merge Replication Step by Step Procedure

by D J Nagendra

Merge replication step by step procedure for SQL Server 2000.

SQL Server 2000 Collation Changer

by Alex Baker

Change collation order for all text columns in a database

SQL Server 2000 Deadlock Analysis

by Tijoy Tom

Deadlock analysis in SQL Server 2000.

SQL Server 2000 Paging and Sorting Using ROWCOUNT and SQL_VARIANT

by DejaVudew

An article discussing how to accomplish paging and sorting in Microsoft SQL Server 2000 without using concatenated SQL.

SQL Server 2000 Reporting Services: Creating a report from scratch

by mysorian

A step-by-step approach to creating a report from scratch using the SQl Server 2000 Reporting Services.

SQL Server 2000 Using Tranasaction on Distributed servers - Linked Servers

by R. Senthil Kumaran

Using tranasaction on distributed servers and querying them - Linked Servers in SQL Server.

SQL Server 2000/2005: Automated Database Backups and Restorations

by Neeraj Kr

Provides an insight into creating automated process for Backups and Restorations

SQL Server 2005 Database Backup and Restore using C# and .NET 2.0

by Bappi M Ahmed

SQL Server 2005 database backup and restore using C#, .NET 2.0, and SMO.

SQL Server Alerts

by Muhammad Shujaat Siddiqi

Defining SQL Server Alerts (shujaatsiddiqi.blogspot.com)

SQL Server backup utility

by User 992674

Restore/backup selected objects in SQL Server.

SQL Server Database Backup Utility using VB.NET and SQL-DMO (New version)

by User 992674

A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures

Sql Server database Backup with bat file

by Moiz hakimi

This is an article about backup utility of SQL server from Command prompt

SQL Server database versioning with Subversion (SVN)

by Ewout Stortenbeker

This tool (ScriptDB4Svn) enables you to add your SQL Server databases to Subversion (SVN) source control.

SQL Server extended stored procedure to send UDP messages

by Rod VanAmburgh

SQL Server extended stored procedure to send UDP messages.

SQL Server Finder

by ericm1000

A simple Windows screen host utility that returns connection information (server name and port number) for all instances of SQL Server 2005, 2000, and 7.0 on a local machine.

SQL Server report compress solution (Zip format)

by prabhu.subbiah

To compress large SQL Server reports and allow the user to download the same in ZIP format.

SQL Server Report Compress solution (Zip format)

by prabhu.subbiah

To compress a SQL Server report which allows the user to download the report in Zip format.

SQL Server Runner - Part 1

by Enrique Albert

Console and GUI utility application that executes SQL scripts against SQL Servers (7, 2000, and 2005) - version 2.0.1.2 is now available.

SQL Server Schema Comparison Tool in Visual Studio 2010

by KarthikAnbarasan

This article explains the new tool in Visual Studio 2010 which most of the users use to see the comparison report of the 2 different database schemas.

SQL Server to SQL Server Compact Edition Database Copy Utility

by johnnycantcode

Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases

SQL Server Transactions and Error Handling

by Saumendra Poddar

SQL Server Transactions and Error Handling

SQL Server Unit Testing Framework

by Duncan Edwards Jones

A simple unit testing framework for T-SQL

SQL Stored Procedure Debugging from SQL Query Analyzer

by Sarfraz Munna

Debugging a SQL Stored Procedure in SQL Server 2000 Query Analyzer

SQL String Printing

by Yildirim Kocdag

Long SQL query printing.

SQL Tuning Tutorial - Understanding a Database Execution Plan (1)

by Gael Fraiteur

If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.

SQL User Defined Function to Parse a Delimited String

by SQLMonger

SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.

SQL Wizardry Part 2 - Select, beyond the basics

by Christian Graus

The second in my series digs in to some of the different things you can do within a select statement.

SQL Wizardry Part Eight - Tally Tables

by Christian Graus

A description of the best way to create tally tables, and how to use them

SQL Wizardry Part Five - when not to use DISTINCT

by Christian Graus

Just a quick explanation of why it's not always a good idea to use DISTINCT

SQL Wizardry Part Seven - PIVOT and arbitrary lists of data

by Christian Graus

Discussion on pivot and other ways to turn columns of data in to rows in SQL Server

SQL Wizardry Part Six - Windowing Functions

by Christian Graus

A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012

SQL Wizardry Part Three - Common Table Expressions (CTEs)

by Christian Graus

In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks

SQL XML Documentation

by Evaldas Jocys

How to create and compile SQL XML Documentation comments

SqlBulkCopy in ADO.NET 2.0, SqlBulkCopy Class in C#, SqlBulkCopy help, SqlBulkCopy guide, SqlBulkCopy class, SqlBulkCopy tutorial

by idreeskhan

SqlBulkCopy in ADO.NET 2.0, SqlBulkCopy Class in C#, SqlBulkCopy help, SqlBulkCopy guide, Transferring Data Using SqlBulkCopy - SqlBulkCopy - Copy Table Data Between SQL Servers at High Speeds, perform bulk copies with .NET 2.0's SqlBulkCopy class, SqlBulkCopy tutorial

SqlDataSource with Transactions

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-DMO: Search and Regenerate Stored Procedures in Seconds

by Triet Ho

Use SQL-DMO Object Library for quick searching and generating stored procedures script

SqlDoc: Document your SQL Server Database

by Jose A. Gonzalvo

A small command prompt utility to help you document your SQL Server/MSDE database

SqlProcedure - Improve Database Performance, Eliminate Errors and Reduce Code

by adambl

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

SqlServer2000 Backup Control

by Rai Shahid

This control will allow user to backup SqlServer

sqlTunes - Query Your iTunes Library

by Alexander Kojevnikov

sqlTunes is a small tool that exports iTunes library information to the SQL server.

SSIS Basic OLEDB / ODBC destination script

by madgardener

Simple destination script to use do updates with a sub query.

SSMSKeyBindings - edit keybindings in sql mgt studio

by Johan Sassner

An addin to Sql Server Management studio that lets you configure keybindings

Store and retrieve objects as BLOBs in SQL Server 2000 and 2005 using ASP.NET 2.0

by Ziyad Mohammad

How To: Read and write BLOB data by using ADO.NET through ASP.NET 2.0.

Store or Save images in SQL Server

by User 992674

A sample program to demonstrate how to save or store images in SQL server

Stored Procedure class generator

by b_hardman

Generate code classes to access stored procedures via web services.

Stored Procedure Generator

by RepliCrux

This utility creates basic Select, Insert, Update and Delete Stored procedure for the selected Tables.

Stored procedures generator

by Kujtim Hyseni

Generator for SQL Server stored procedures.

Storing and Retrieving Images from SQL Server using Microsoft .NET

by Kazim Sardar Mehdi

Storing and retrieving images from SQL Server using Microsoft .NET.

Suggest Like Page along with Arrow Buttons used for rendering and selecting recods suggested

by Vishu Gurav

AJAX, ASP Suggest like page using

Synchroniq CodeBase v1.0 (Access database backend version)

by MalakieUSN

Code storage tool for any language but developed using Visual Basic .NET 2005. Includes syntax coloring for VB code and can load via the tools menu external option in Visual Studio 2005.

Synchroniq CodeBase v1.0 (SQLServer database backend version)

by MalakieUSN

Code storage tool for any language but developed using Visual Basic .NET 2005. Includes syntax coloring for VB code and can load via the tools menu external option in Visual Studio 2005.

Table Data Sharing Across Stored Procedures

by ManojKumar19

This tip demonstrates how table data can be shared in two stored procedures.

Take Data Offline Using Microsoft Synchronization Services for ADO.NET

by Rafik Robeal

Build occasionally connected applications using Microsoft Synchronization Services for ADO.NET

Template based code generation

by Wytek Szymanski

An article about template based code generation and a demonstration of how to quickly generate a wrapper class for stored procedures.

The Base Class of Connecting To Database

by Churn Wuang

Perfect interface design for common database which would be used to easily connect to the most kinds of database, such as MS Access, MS SQL Server,..., and so on. Do not worry again about the terrible complex interface of ADO COM, take it easy to implementing your operation logical codes...

The beauty of SQL Server queries - Part I

by Mehdi Mousavi

Discusses the SQL's SELECT statement in details.

The Freedom to Work Fast - SQL Professional Toolbelt

by Redgate Software

Database professionals have a special role in their workplace because they bear responsibility for customer database integrity. This article argues that the 'online' or 'lock ladder' database development model, which uses live instances is the only way to ensure true database integrity.

The LOGIC Behind Mad MAX()

by Joe Negron

The SQL MAX() function is a little tricky when trying to work with numeric data - Not quite the same in other languages.

Themes and Skins in ASP.NET 2.0

by Zeeshan Muhammad

Introduction to themes and skins in ASP.NET 2.0.

Thinking in SQL - Generating Random Numbers

by Christian Graus

A discussion of ways to create random number sequences in SQL Server

Thinking in SQL - Working with dates

by Christian Graus

In this installment, I talk about working with dates and date functions in SQL Server

To create Google Suggest using ASP.NET & AJAX

by Nilesh Surve

To create Google Suggest using ASP.NET & AJAX

To generate insert statement for user defined tables available in SQL Server 2000, through easy to use wizard.

by Vivek Singh - IN

It will generate insert statement as per the tables selected by the user, and it also take cares of Identity inserts in the table.

Tool to script Linked Servers in SQL Server 2000

by Sriram Chitturi

Tool to generate script for Linked Servers in SQL Server 2000, using C# and SQLDMO.

Top 10 Must Have Features in O/R Mapping Tools

by IqbalKhan

O/R mapping tools are becoming more popular each day and people are realizing the productivity gain they provide to developers. Yet, many people don’t know enough about O/R mapping to consider using these tools and many others are weary of using any code generators (including O/R mapping tools).

Track database object dependencies and analyze the potential impact of schema changes with SQL Dependency Tracker

by Redgate Software

SQL Dependency Tracker allows you to graphically visualize database object dependencies. This means that users can track down potential "collateral damage" before pushing database changes through. With this ingeniously simple to use tool, you can also document database dependencies.

TransactionScope in .NET 1.1

by Alexander Shirshov

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

Transfer arguments between modal page and invoker page in asp.net 1.1

by Rouser

Transfer arguments between dialog page and invoker page in asp.net 1.1

Tree utilities in SQL Server 2000 and 2005, and OLAP implementations

by Dan Radu

This article describes how to efficiently store and access tree structures in a SQL Server database, and how to use them in OLAP implementations.

Treeview-creating a treeview of folder structure using javascript ,xsl and .net

by sivakrishna kalvagadda

Creating on fly treeview of folder structure by genrating dynamic xml using asp.net ,this xml is transformed using xslt and following user navigation using javascript.

Triggers -- SQL Server

by Sudipta Chaudhari

This article gives a brief introduction about Triggers in SQL Server 2000/2005.

Trilobita ORMaper solution based on .NET 2005/2008

by WillCaptain

ORMaper solution based on .NET (C#), add-in for VS IDE, and auto generating ORMaper code.

Truly Dynamic and Re-usable DataGrids

by Michael.Piccolo

How to add DataGrid columns dynamically with ITemplate, XML and templated controls.

Truncate SQL Server Transaction Log

by lintom

An easy way to truncate Transaction Log files to your desired size.

T-SQL Coding Standard

by Casper Leon Nielsen

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

TwittiBot: Adventures in Developing a WPF Hybrid Smart Client for Twitter

by Dwayne Macadangdang

An article on creating a Hybrid Smart Client for Twitter using the Windows Presentation Foundation and the TwitterLib class library

Type-Ahead suggest textbox server control with Google AJAXSLT

by Teng-Yong

An ASP.NET type-ahead suggest textbox (Autocomplete) that leveraging on Google AJAXSLT

Uncommon Common Table Expressions (CTEs)

by Jeremy Likness

Common table expressions (CTEs) are a powerful new construct for building advanced queries.

Universal Database Admin for ASP.NET and SQL Server (Reloaded)

by Raj Lal

A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.

Uploading / Downloading Pictures to / from a SQL Server

by Alexandru Ghiondea

Describes how to upload and download pictures to and from a SQL Server database.

URL Decoding in pure T-SQL

by orinoco77

How to decode a URLEncoded URL with T-SQL

Use a Web Control to configure a secure data connection in web.config

by zhengdong jin

This C# web control is used to configure data connection for a web site.

Use of Custom Attributes to Serialise Objects to/from SQL Server Tables

by Duncan Edwards Jones

Shows how you can use custom attributes to save .NET classes directly to an SQL Server table

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 Parameters to Overcome Ad Hoc Performance Issues

by Mark J. Miller

Defining (rather loosely) ad hoc queries as SQL commands built as strings by an SQL client application and submitted to SQL Server.

Using .NET 3.0 to Automatically Generate Word 2007 Documents

by Dungtran

This article describes how to automatically generate Word 2007 documents using .NET 3.0

Using ADO.Net for your Data Access Classes

by Muhammad Asad Siddiqi

This articles describes the workling of ADO.Net using .Net base classes for database access

Using ADO.NET programmatically with C#

by Umut ŞİMŞEK

An article on using ADO.NET programmatically.

Using C# to Enumerate Through Stored Procedures in MS SQL Server 2000

by DreamInHex

This guide will show you how to enumerate through the stored procedures in MSSQL 2000, as well as retrieve parameter information for a stored procedure.

Using C#, OpenXML, and Microsoft SQL Server 2000 to create a multi-threaded Rules Engine Webservice

by DreamInHex

Create a simple, scalable XML-consuming rules engine in just a few minutes, using OpenXML.

Using CheckBoxes within the DataGrid control to select records

by Ansil

This article is about using CheckBoxes in a Datagrid control to select records as in a mail box.

Using config file for Custom Assembly in Reporting Services (Step by Step)

by alifaraze

A trick to use config file for Custom assembly in reporting services

Using EntitySpaces Business Objects in XAML

by dakeefer

An exploration of how to use the EntitySpaces business object framework within a WPF application.

Using Integrated Windows Authentication (IWA) in a Distributed Application Architecture

by GraemeKMiller

This article explains how you can use IWA to improve your Users' experience and it also explains how it benefits your IT support team.

Using MD5 Encryption with C# and MSSQL 2000

by DreamInHex

Demonstrates methods for creating and validating MD5 encrypted passwords in MSSQL 2000.

Using Multiple NHibernate Assemblies with NHSessionManager

by Ali Ozgur

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

Using RowCount for sorting when paging large result sets

by benoityip

Fast paging with large result set.

Using SQL Bulk Load to Upload Fixed Width Text Files

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.

Using SQL DMO to Alter the Data Type of Table Columns

by Sarith Sutha

This article describes the usage of SQL DMO to automate few aspects of DB maintenance.

Using SQL DMO to Script Tables

by Vinod Kumar M

This article shows the power of using SQL-DMO with SQL Server 2000 to script out objects. In this example we would script out tables.

Using SQL Server CE Mobile with SQL Server through RDA

by Tolga Birdal

This article is on communicating with a server through Remote Data Access objects.

Using SQL trigger to create unlimited unique id's

by VincentGee1

Using SQL trigger to create unlimited unique id's

Using SQLParameters with VB.NET/C#

by dotScott

Using SqlParameters with stored procedures in .NET.

Using TableAdapters with transactions

by Danko Greiner

Use TableAdapters with transactions.

Using the ASP.NET 2.0 Wizard Control

by ShirleySW

How to dynamically create an ASP.NET 2.0 Wizard control and load child controls at run-time.

Using Transactions in ADO.NET

by netbard

An introduction to SQL Server transactions and how to use them in ADO.NET.

Using Visio 2003 for Enterprise Architects to Design SQL Server Databases

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).

VCMBox, an MVC - FuseBox Hybrid Framework

by Simon Segal

An MVC meets FuseBox Hybrid pattern for .NET, implmented in C# with the the Northwind database.

Velde.Utilities - C# Utility Class for Active Directory, Databases, Files, Networking etc.

by xExTxCx

C# Utility class for Active Directory, databases, files, networking etc.

Versatile and Extendible Data Access Factory

by G Ryno

Using and extending the data access classes, and runtime selection and instantiation using a factory and XML configuration file.

Very fast test data generation using exponential INSERT

by weilidai2001

Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.

Very Lightweight Data Access Layer in C# and .NET 2.0

by Fitim Skenderi

Very Lightweight Data Access Layer in C# and .NET 2.0

Views in SQL 2000/2005

by GaryWoodfine

An explanation of Views in SQL server 2000/2005 and the advantages of them

ViewState Provider - an implementation using Provider Model Design Pattern

by Elvin Cheng

Solve the ViewState problems using the industry well-known pattern - Provider Model design pattern.

Visual Representation of SQL Joins

by C.L. Moffatt

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

WCF DataContract with FaultException Details

by SP.Murugesa Pandian

WCF DataContract

Web Based Job Scheduler

by Igor Krupitsky

A complete VB.NET application to schedule DOS command tasks online

Web control to generate database design documents in HTML

by Olivier_Giulieri

Just 200 lines of VB.NET to document your SQL Server databases.

Web enabling data on a SQL Anywhere Server using a native web service

by mysorian

An HTML Native web Service on SQL Anywhere Database Server

Web Service via Data Access Object Pattern

by Andrew Golik

A Data Access Object pattern implementation

Web Service: Calling a web service using Ajax (XML SOAP request)

by Virendrachandra

This is the simple example of web service and Ajax. Web service method is calling using xmlRequest using SOAP. Here javascript code is written a way like OOPS.

Webservice sample - example of using SOAP protocol to access Internet Database Server

by Nguyen-Thanh-Tung

Use SOAP to communicate with a remote DB Server (Here I use SQL Server) on the Internet and get information or interact with the database

Where Vs Having / Difference between having and Where clause

by gouravverma

Basic difference between Sql Where and Having Clause

Workaround: When a user clicks "Select All", the report should pass a blank value instead of parsing everything in the MultiSelect DropDown parameter

by Shobhit Dixit

If you have a long list of drop down items and you want to pass in one value, you can use this method

Wrapper Code Generator for MS SQL Server Databases

by Nirosh

The application generates database wrapper classes for MS SQL Server databases automatically. I got lots of good reviews and comments as I discussed about this with my colleagues. Now that the application is built, let's see what you have to say about this.

Wrapper Generator for SQL Server Stored Procedures

by Charles Horan

A utility application that generates .NET code for wrapping stored procedures.

Writing Extended Stored Procedures in C++

by David Salter

Writing extended stored procedures in C++ for SQL Server.

Writing SQL queries in XML – A support intensive approach

by _Asif_

Article that helps writing SQL in XML to provide better support

Writing SQL Server Database tables description into Word Document

by satya.rapelly

Window application generates the document with Sql Server database tables