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.

7 Questions You Always Wanted to Ask about Content Management Systems

by Petr Palas

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

A conversion of the popular DotNetNuke web application to C#

by andrewcates

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

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

by msalmank

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

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 method to migrate and automate exisitng DSTX SSIS package from SQL server 2005 to 2008 R2

by santosh poojari

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

A Neat Solution to GridView Custom Paging

by Fadrian Sudaman

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

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

by Mike Borozdin

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

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

by Naveen Karamchetti

This article describes the new functoids in BizTalk Server 2006.

A simple example of SQL server admin tools.

by Md. Marufuzzaman

A simple example of SQL server admin tools.

A Simple GUI Tool for SQL 2005 Reports Deployment Without using BI Development Studio

by Ahmed IG

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

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 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 T-SQL Regular Expression Library for SQL Server 2005

by Steve Abraham

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

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

by AlexS9999

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

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

by code-frog

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

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.

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

by Petr Palas

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

Access .NET assembly through SSIS (Script Component)

by Malpani Amol

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

Access SSIS package activities and variable through .NET application

by Malpani Amol

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

Accessing MSMQ from Microsoft SQL Server

by Wojtek Jeziorczak

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

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

Active Directory Tool

by yairrose

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

Add/Drop LinkedServers using SMO

by arunpv

Add/drop Linked Servers using SQL Server 2005 SMO

Adding Custom Assemblies in SQL Server Reporting Services 2005

by Mohamed Abdelghani

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

Adding values to a dropdown using AJAX

by Ganesan Sankaran

How to add values to a dropdown using AJAX.

ADO.NET and OPENXML to Perform Bulk Database Operations

by mfmaneef

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

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

by AdamNThompson

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

Advanced SQL 2005 SQLNotificationRequest Functionality with C#

by Todd Wilder

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

AJAX grid with ASP.NET 2005

by LeleHalfon

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

AJAX Stock Symbol Drop-down List

by Thanh Huu Nguyen (Tony)

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

AJAX, WCF, LINQ to Entities demo application

by Kurush Rastkar

Using most of the recent technologies in one application

AJAX-enabled Name Selector User Control

by Steve Krile

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

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

by n_ahid

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

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.

An Overview of Log Shipping in SQL Server 2005

by Abhijit Jana

Overview of Log Shipping in SQL Server 2005

Anonymous Personalization Trick in Web Parts

by Daron Yndem

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

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.

APPLY Operator of SQL Server 2005

by Mohammed Ghouse Barq

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

Arabic currency conversion from numbers to letters

by Wael R. Mansour

Convert numbers to characters for Arabic applications.

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

by Nirosh

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

Array Parameter Handling in a Stored Procedure

by Srinath Gopinath

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

ASCII/Multibyte to Unicode Conversion

by carlop()

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

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 Caching Interview Questions: Part 2

by Shivprasad koirala

ASP.NET Caching Interview Questions Part 2

ASP.NET Custom Control + Crystal Report Dynamic Text Format

by Sachin Somanath Mumbare

Custom control for display client formatted text in Crystal report

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 MVC Flexigrid sample

by Todd Smith

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

ASP.NET using GridView Control as Lookup

by Amit K Bhagat

ASP.NET using GridView control as lookup

Asynchronous Setup Grid

by Babak Ansari

A custom asynchronous setup with progress indicator.

Asynchronous T-SQL Execution Without Service Broker

by Oleg Vorkunov

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

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.

Auto Binding a TreeView control from a self referencing table

by Bassam Saoud

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

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

Automation Helper for Stored Procedures in C#

by Jeff Bramlett

Helper classes for automation of stored procedures

AutoRefresh Entity Framework Data Using SQL Server Service Broker

by Harry von Borstel

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

Backup Microsoft SQL Database and Upload to FTP

by funklet

Make backups of SQL databases and upload them to FTP server

Backup SQL Server with Relative File Path and Progress

by theit8514

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

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

by MrTimmins

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

Binary Copy files in T-SQL with helps of CLR

by Levente Kupás

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

Bind Image from Database to DataGrid (web Application)

by Anandhi Swamy

Handles uploading /downloading images into/from database to DataGrid

Binding dropdowns using Ajax

by Ganesan Sankaran

How to populate a dropdown in another dropdown change

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

by Himanshu Thawait

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

Build a Silverlight 2 Web Chat Application

by junnark

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

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 a Web Chat Application using ASP.Net 3.5, LINQ and AJAX (in C# 3.5 or VB 9.0)

by junnark

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

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 Business Day and Holiday Database Subsystem

by Paul Reynolds

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

Building a Hybrid Active Directory and SQL Table DataSource View

by noahhath

Building a hybrid Active Directory and SQL table DataSource view.

Building a Web Message Board using Visual Studio 2008, Part I - The Basic Message Board

by Rama Krishna Vavilala

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

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 an SQL Logic Engine

by Steve Marsh

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

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

by Ramy Mahrous

How to build Reporting ASP.NET Web application

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

by Omar Al Zabir

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

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

by Sekhar Lanka

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

Business Logic with Entity Framework

by Bishoy Demian

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

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.

C# Project on Database for Beginners

by Hasan Habib Surzo

Class, Database Connection, Login Winform

Cache IQueryable for Better LINQ-to-SQL Performance

by Zimin Max Yang

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

Calling a Web Service from a SQL Integration Services package

by Simon Bonello

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

Calling Stored procedures in ADO.NET

by sandeep@s

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

Cancellable SQL Server Query

by Scott G Blood

A Cancellable threaded query for SQL Server using .net 3.5

Central Key Management

by Brian Bayless

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

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

Checking the New DST 2007 from a DBA Perspective

by jamesplewis

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

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.

CLR Function for Persian Date Converter in Microsoft SQL Server

by Ali-DN

CLR Function for Persian Date Converter in Microsoft SQL Server

CLR Stored Procedure and Creating It Step by Step

by Virat Kothari

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

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.

Compare SQL Database Schema

by Paritor

Application to show differences between two SQL Server databases.

Computed Column Specification in SQL Server

by Padoor Shiras

Computed Column Specification for populating nth column

Concatenate Field Values in One String Using CTE in SQL Server

by Navdeep Bhardwaj

Concatenate field values in one string using CTE in SQL Server.

Configure MS SQL Server 2005 Remote Access ( mixed mode )

by hong_wei_li@yahoo.com

Configure MS SQL Server 2005 Remote Access ( mixed mode )

Configuring Database Access for an ASP.NET Application

by Eugene Mirotin (Guard)

Demonstrates the easiest way to use all the advantages of SqlDataSource and GridView, and to allow flexible DataSource configuration.

Configuring Plastic SCM Database Backend

by parallelcoder

Configuring Plastic SCM database backend

Connecting to Database Express 2005 with VS 2005

by efero

Codes to help to connect VS 2005 to SQL Express manualy

Connecting to Database SQL Express 2005 with VS 2005

by efero

Connecting to SQL Express Manualy

Connecting to Database Using Custom Webpart in Sharepoint 2007

by Hithendra Reddy

Building Custom Webparts to interact with Database

Connection Pooling in ASP.NET

by Muhusin Khan

Effective perfomance for database application uses database

Connection Pooling in multithreaded applications

by User-Rock

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

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.

Consume 32 bit COM DLL in x64 Bit SQL Server 2005

by Aneesur Rehman Khan

Consume 32 bit COM DLL in x64 bit SQL Server 2005

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

by Niladri_Biswas

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

Continuous Database Integration

by Peter Hancock

Using NAnt and CruiseControl.NET to continuously integrate database changes

Continuous Integration for Databases with Visual Studio

by Adam Nachman

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

Controlling IP traffic from Internet to DMZ or Intranet

by snp157

Controlling IP traffic from Internet to DMZ or Intranet

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

Cool DVD Movie Catalog

by Dannover Arroyave M.

Developing a catalog of DVDs

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 SQL Database Programmatically

by Moustafa Refaat

In this article, I will explain how to use Microsoft SQL Management Objects (SMO) to create a Microsoft SQL database from C# code.

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 data driven PDF on the fly by using SQL server reporting service (SSRS)

by simonp_ca

A free, mean and lean way to create data driven PDF on the fly by using SQL server reporting service (SSRS)

Create database in sql server using asp.net with C# (VS2005)

by Joshy_geo

Create database in sql server using asp.net with C# (VS2005)

Create Drill-Through Reports using ReportViewer in ASP.NET 2.0

by ShirleySW

This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0.

Create Drill-Through Reports using ReportViewer in ASP.NET 2.0

by ShirleySW

This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0.

Create Drill-Through Reports using ReportViewer in ASP.NET 2.0

by ShirleySW

This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0.

Create INSERT batch files easily with ScriptBuilder

by Gordon Kushner

Utility program for generating SQL Server INSERT scripts

Create md5 Hash-code using Assemblies in SQL Server 2005

by Denis Strukachev

Create md5 hash-code using assemblies in SQL Server 2005

Create SQL Server Database using asp.net

by Jatin Prajapati

Here I am showing, How to Create SQL Database and Run SQL Script File Using asp.net.

Creating 3DBarChart using ASP.NET 2.0

by Ravikumar Commuri

How to Create 3DBarChart with Graphics, Bitmap Objects in ASP.NET 2.0

Creating a DAL with SubSonic

by Michael Ceranski

Creating a DAL with SubSonic.

Creating a Date Process Library and WCF Service for Date and Age Processing

by Paul Reynolds

This is phase 2 of a 3 phase project. This phase accesses the database created and loaded in phase one to expose an API of common business date functions.

Creating and Deploying Reporting Services using Custom Assembly

by alifaraze

Custom assembly and reporting services

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 Managed Objects in SQL Server 2005

by Nishith Pathak

Creating managed objects in SQL Server 2005.

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.

Creating User-Defined Data Types in SQL Server 2005

by subai

An article on how to create user defined data types using .NET languages for SQL Server 2005.

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.

Cross Domain/Platform Authentication and Data Transfer

by Tomz_KV

Introduces a methodology for authenticating user in cross domain/platform and transferring user data from one site to another during the authentication process.

Crystal Reports with Dynamic Number of Columns with Typed Dataset

by Abdul Quadir Saifee

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

CrystalReports Push Model with .NET

by Raspberry Man

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

Custom Assemblies in SQL Server 2005 Reporting Services

by Krishna Prasad V.R.

This article focuses on the problems you might face and the probable solution when using .NET custom assemblies. This article also gives in-depth details of modifying .NET assemblies for which you do not have the source code.

Custom Membership Providers - Task Manager

by Karthik. A

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

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 Rule Engine in WPF - MVVM

by Renil Joy, Bangalore

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

Custom SSIS Control Flow Component

by Ray Gorski

Create a custom control flow component for SQLServer 2005 Integration Service

Custom XML file(s) named from a database fields

by Cristi Paraschiv

Custom XML file(s) named from a database fields (Sql Server 2005 DB)

Customary Functions of GridView in ASP.NET 3.5

by Behrouz Rad

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

Customize the built-in Outlook Select Names dialog (or any other)

by Helmut Obertanner

In this article, you will learn how to customize the built-in Select Names dialog and use different external data sources for your own dialog.

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 Entry application with PIVOT processing in GridView

by Ole Oren

Describes building a WorkGroup TimeSheet with GridView

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 Mining with SQL Server 2005 without Analysis Services

by kvlcek

A C# implementation of CHAID for MSSQL 2005 à la Cognos scenario.

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

Data Visualization in WPF with LINQ to SQL and Data Binding

by Bruno Sonnino

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

Database Concurrency Patterns - SIP and SUP

by George Zabanah

Take a look at two new patterns to help with database concurrency: SIP and SUP.

Database Deadlocks for Dummies

by Andrew J Dixon

Explaining Database deadlocking to non-technical people

Database Documentation - Microsoft SQL Server 2005/2008

by pavan k vadlamudi

Creates database documentation table(s) schema

Database Driven Banner Rotator Control

by hussain.attiya

A database-driven banner rotator control rotating based on a specific time (and not on page refresh). Each banner will have a display time (in seconds) to move to the next one.

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 local cache

by konamiman.MSX

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

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 table editor framework

by db_developer

This article consists of a data layer and forms for database tables editing.

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 & Paging using Ajax

by asithangae

Achieving the DataGrid functionality with paging using User control and Ajax

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

DB Manual Copy Visual Studio 2005 Add-In

by Tommi G

Add-in for copying SQL Server 2005 Express data files between project main folder and output folders.

DBMapper - A New ORM Tool

by Koray Dakan, PMP

DBMapper - A new ORM tool for vendor-neutral solutions

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

by Pieter Van Parys

Creating profiling information in our ProxyDbxxx classes

DBTree

by MH2538

A DB Base Tree that load it's nodes from a table

Defining Indexes with SQL Server 2005

by Indrajeet Sutar

All about SQL Indexes - Query Optimizer, Index, Unique Index, Clustered Index, Full Text Index, XML Index and SQL commands to create, delete, and rename SQL indexes.

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

by Tarek Najem

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

Deploy and Debug CLR store procedure

by Malpani Amol

This article will drive you, how deploy and debug CLR store procedure

Deploying Reports in Reporting Services Programmatically

by Ramy Mahrous

How to deploy your reports programmatically in away like BIDS

Deployment Of Web Application Executing SSIS Package In Web Server.

by santosh poojari

This article describes the prerequisite needed for .Net And SSIS integrated deployment.

Design of a .NET brain dump for the forgetful software engineer

by User 1575800

Capture, storage, query, and transformation of quick notes and drawings before any actual design or programming.

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

by David Catriel

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

Determining Stored Procedure Parameters with SQL 2005

by gtamir

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

Developing a SSIS Package

by karun123

An article on configuring an SSIS Package.

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 Office SharePoint 2007 application

by Moim Hossain

Describes how to develop custom business portal application using WSS 3.0 and Office SharePoint Server 2007

DEVELOPING SSIS in Visual Studio 2005

by hussain.attiya

DEVELOPING SSIS to import oracle records to sql server

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.

DevShot - Database Snapshots for Developers

by Tommi G

How to create runtime backups from SQL Server 2005 and restore them.

Digging SSIS object model

by Moim Hossain

Describes SQL server 2005 Integration Service object model and different data flow components

Disaster Recovery Plan In MOSS 2007

by Tariq Younas

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

Distribute your site's contents with RSS 2.0

by AdamNThompson

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

Document SQL Server 2000/2005 Database

by Nitinpatel

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

Download SharePoint Zipped List Items

by Mohamed Zaki

This custom UI Action for SharePoint extends the lists action menu to allow users to zip document library items and download all of them with or without version.

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

by S. M. Ahasan Habib

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

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 Management Views [DMV] – A SQL Server 2005 Feature

by Hari Prasad K

The DMVs; newly introduced in SQL Server 2005 gives database administrator information about the current state of the SQL Server machine.

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.

Editable GridView in ASP.NET 2.0

by Ashrafur Rahaman

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

Editable GridView without ObjectDataSource Concepts

by Sasha Risner

A C# sample for binding a GridView to a DataTable with sorting, filtering, updating, deleting, and inserting allowed.

Effective paging with List View control in ASP.NET

by Abdul Quader Mamun

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

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.

Efficient Paging with Repeater and SQL Server 2005 / 2008

by perels

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

Encrypting windows application connection strings

by Daniel Kuettel

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

Enterprise Application Architecture: Designing Applications and Services in .NET - Part I

by venugopalm

A guided tour of the distributed enterprise application design in .NET

Enterprise Application Architecture: Designing Applications and Services in .NET - Part II

by venugopalm

Database and Library Design for Customer Order Management System

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!

Enterprise Configuration Management

by gaurav_verma_mca

Configuration of .NET applications using database

Excecute SSIS package (DTSX) from ASP.Net

by santosh poojari

This article demonstrate the step by step procedure to create SSIS Package and Execute the same using ASP.net

Excel Report Generation Using XMLSS

by Sujith John Thomas

This article explores the concepts of XMLSS and its transformation to XL.

Exception Handling in 3-Tier Architecture

by Sohail Maroof, Farrukh Hashmi

Exception handling in 3-Tier Architecture using Enterprise Library

Execute Access 2003 Macros in SSIS Package

by Deepu M.I

Execute Access 2003 Macros in SSIS Package. How to call Access Macros in SSIS Package

Execute SQL Server 2005 Integration Services package from C#

by Jeff Modzel

Learn how to load and execute a SQL Server 2005 Integration Services package from C# code

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

by Akbar Ali Bhatti

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

Export a complete database to an Excel file

by Dennis Betten

Export all tables and data to an 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

Features of Yukon (SQL Server 2005)

by Vidya Vrat

This article talks about SQL Server 2005

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

by Md. Marufuzzaman

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

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

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 ASP.NET AdRotator using Database

by Pramod S Kumar

Implement a Flash ASP.NET AdRotator to fetch ads from a database.

Form Authentication for MOSS 2007 Site

by NagendraGunaga

The purpose of this document is to provide the step by step information about enabling the Form Based Authentication (FBA) for MOSS 2007 site.

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

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

Generate Classes and CRUD Procedures

by ColinBashBash

Generate classes / CRUD procedures.

Generate SQL Script Programmatically

by Md. Marufuzzaman

How to generate SQL object script using C#.NET

Generating PDF reports programmatically using SQL Server Reporting Services 2005, in C#

by Sivakumar Mahalingam

An article on how to generate PDF reports programmatically using SQL Server Reporting Services 2005, in C#.

Generating Word Reports / Documents

by lepipele

Generate Word documents by appling XSLT on XML data.

Get a table with all dates in a month

by TDunk

This SQL Server 2005 Table values function returns a table with all dates of a month for a provided date.

Get List of Extended storedProcedures that are Allowed to you for Common Use

by Md. Marufuzzaman

An easy way to get a list of extended storedProcedure allowed to you for common use

Get SQL Table Information

by Md. Marufuzzaman

Get SQL Table Information

Getting the Changed DataTable

by RamMajeti

Consider a situation in which you have a datagrid with all or most of its rows in editable mode.

Getting the Place Name that Goes with a Zip Code

by Eddy Vluggen

How to import a database-dump from GeoNames.org into SQL Server

Global Variables in SQL Server

by Md. Marufuzzaman

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

Globalization Resources for Multilanguage Development

by Evaldas Jocys

Provides required tables and data for multilanguage projects

GPS Tracer Extension: storing the path on SQL2005 via Web Services

by Lorenzo Consegni

This article extends Leonardo Salvatore's project "A GPS tracer application for Windows Mobile CE 5" using the Web Service Software Factory. It shows how to create a robust solution for storing the path on a DB server, using Web Services and SQL

GPS Tracer Extension: Storing the Path on SQL2005 via Web Services

by Lorenzo Consegni

This article extends Leonardo Salvatore's project using the Web Service Software Factory

GridView Order Page Shopping Cart Page ASP.NET SQL

by T.Ashraf

GridView Image order page shopping cart page

GridView to a DataTable

by ZeroDev

Convert the current Gridview to a datatable

Gridview with SQL Paging

by Tom Bauto

A simple and detailed ASP.NET program using Gridview with paging in SQL 2005

Hebb neural network

by Mohammad Mehdi Norian

implementation of ocr by hebb algorithm

Hide the Datagrid Columns Which are Not Intended to be Displayed at Runtime

by Jatin.Prajapati.ER

Hide the datagrid columns which are not intended to be displayed at runtime

Hierarchical Tree Represented by Modified Preorder Tree Traversal Technique using C# 3.0 and SQL 2005

by Wael Alghool

Gathering of various algorithms into one library to transform Hierarchical trees between various formats, and allows them to be represented into SQL 2005, the formats supported are TreeView, Textual, Tabular, Modified Preorder Tree Traversal and Graphical.

Hierarchical XML Data Builder

by asithangae

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

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 Longhorn Transforms Applications

by Ashvil DCosta

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

How Many Records Are There in your Database?

by Md. Marufuzzaman

How many records are there in your database?

How SQL Server deletes records

by DLM@TD

How SQL Server deletes records

How to Build C# code based on DB Script

by Xavier Cruz

These Alpha App is a tool used to create C# classes based on SQL Server Express DB script

How to Call SSIS Package from the Stored Procedure

by JustChiragPatel

No need to create web service for SSIS package call

How to change ConnectionString easily

by Ali Marzban

Changing ConnectionString like an attribute in C#

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 Create a Logger in SSIS

by Deepu M.I

The concept of SSIS Logging is to capture log-enabled events that occurs at run time.

How to Create your First SQL Server Integration Services (SSIS) Package - Part 1

by Md. Marufuzzaman

How to create your first SQL Server Integration Services (SSIS) package - part 1

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 find if only one particular column has been modified in a trigger

by Master DJon

How to find if only one particular column has been modified in a trigger.

How To Handle Concurrency in LINQ to SQL?

by Shivprasad koirala

How to handle concurrency in LINQ to SQL?

How to Hide GridView Cloumn Cell and how retrive value of a hidden cell

by T.Ashraf

Hide and Retrive value of cloumn of a GridView

How to improve your LINQ query performance by 5 X times?

by Shivprasad koirala

Tips to improve your LINQ query performance.

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 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 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 populate DataGridView, GridView with SQL statement in C#

by hong_wei_li@yahoo.com

How to populate DataGridView, GridView with SQL statement in C#

How to Restore SQL Server 2005 Suspect Database

by Suvendu Banik

How to Restore SQL Server 2005 Suspect Database

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 Rotate a Pie Chart in SSRS 2005

by Matt Bowman

How to change the angle of the first slice of a Pie chart in SSRS 2005.

How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005

by hong_wei_li@yahoo.com

How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005

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 Select What Fields to Display on a Report from a Multi-value

by pengyi

How to select what fields to display on a report from a multi-value

How To Send Mail Using SQL Server: Part 2

by Manish kumar choudhary

In this article, you will learn how to select data from a table and send that data to an email using SQL Server 2008.

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 Truncate Log File in SQL Server 2005

by hong_wei_li@yahoo.com

How to truncate log file in SQL Server 2005

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

by Ponytail Bob

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

How to use global variable in Microsoft SSIS (DTS) package

by hong_wei_li@yahoo.com

How to use global variable in Microsoft SSIS (DTS) package

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 SQL Server to Select Records for a Scheduled Date

by Vilhelms

Retrieving appointments without having to store all future occurrences

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

How-To: Automatically Rename Foreign Keys on a DB

by Lino Barreca

Use T-SQL and system views/stored procedures to give consistent names to every relation in a database

HowTo: Install the Northwind and Pubs Sample Databases

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.

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!

IGotMessage - Send a Video Message

by PAPAYA

IGotMesasge is an open source Web-based application that allows individuals to easily record and send video messages to others. The software is free to download, install and use, and is easy to integrate with any website.

Impersonation using Code

by Chirag R Darji

Impersonation using Code

Implementing a CLR Stored Procedure in a LINQ based n-tier architecture

by Virat Kothari

CLR Stored Procedures can be efficiently implemented in an n-tier architecture.

Implementing a Data Processing Extension

by Bryan Avery

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

Implementing a TreeSize-like application with C#, SQL and Analysis Service, part 1

by krysstof

Tool developped to manage and analyse disk space on multiple fileserver in my company

Implementing an Ugly Tab Structure in Reporting Services

by akjoshi

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

Implementing Audit Trail using Trigger

by Shivprasad koirala

Implementing Audit trail using trigger

Implementing Dynamic WHERE-Clause in Static SQL

by John-ph

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

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

by Bernard Ho-Jim

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

Implementing Logging & Transaction for NHibernate through Configuration Files using Aspect Oriented Programming via Unity

by Niraj Bhatt

Applying AOP using Unity on NHibernate

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.

Import Data to SQL Server from Excel or Access using TSQL Script

by Waynes World

An article on importing data from external data sources to SQL server without using wizards

Import Excel files to SQL Server dynamically

by Mohammad Al Hoss

This article shows how to import Excel files to SQL Server dynamically.

Importing data with the SSIS Object model

by Moim Hossain

Describes how to use the SSIS object model for importing data to SQL server 2005

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.

Inserting Bulk Data in SQL Server from Text file

by S.Vinothkumar

Inserting Bulk Data in SQL Server from Text file

Inserting Value of Collection into Database

by bhadeliaimran

Inserting value of Collection into Database

Inside Recursive CTEs

by gjvdkamp

A step by step explanation of how a recursive CTE actually works.

Integrating Database Development in Visual Studio

by venugopalm

Integrating database development into Visual Studio to collaborate application development team and the database designers

Integrating Reporting Services 2005 Into a Web Application

by DDarren

This article provides step-by-step instructions on how to integrate a MS Reporting Services report into an ASP.NET web application using the ReportViewer control. It also includes an HTML template than can be used for the layout and tackles a couple of known problems with the ReportViewer control.

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 Distributed Messaging using Service Broker in SQL Server 2005

by Akram Hussein

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

Introducing SilverlightDesktop.net

by defwebserver

SilverlightDesktop.net is a Open-Source ASP.NET framework that allows you to dynamically load Silverlight modules into resizable draggable windows.

Introducing the Boomerang Framework

by psined

Introduction to Boomerang Framework

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.

Introduction to Model Driven Development with Sculpture – Part 1

by Ahmed Negm

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

Inversion of Control with nHydrate

by Christopher R Davis, Michael S Knight

Generate applications using Inversion of Control with the nHydrate code generator.

Invoke .Net Assembly using SSIS:Email Framework

by santosh poojari

This article demonstrate use of SSIS package that helps in invoking .Net Assembly having email component in it.

Invoking a WCF Service from a CLR Trigger

by Sam Shiles

A step by step guide to communicating with WCF from a CLR Trigger in SQL Server 2005

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

LayerGenMMX

by icemanind

Easily create Business and Data Layers!

Lean and Mean Blogging Revisited

by Mustafa Ismail Mustafa

An alternative approach to blogging engines

Learn to Write Custom MDX Query First Time

by Mubin M. Shaikh

Learn Custom MDX Query Step by Step

Library for scripting SQL Server database objects with examples

by Kanasz Robert

This article is about library for scripting SQL Server database objects and examples representing how this library can be used.

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

by Anas Karkoukli

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

LINQ Challenges and SQL Server Compact Edition

by Matt Sollars

Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.

LINQ Code generator

by Sree Nivas

This generates Basic linq codes just by giving necessary inputs

LINQ Demo with ASP.NET Web Application

by anrorathod

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

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

Loading image files from a database, using ADO

by Bahrudin Hrnjica

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

Localization of SSRS Reports

by Sandeep Mewara

How to localize the SQL Server Reporting Services Reports

Logging System for .NET SOA Applications

by Anders Revsgaard

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

Logging System for .NET SOA Applications

by Anders Revsgaard

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

Making OUTER and CROSS APPLY work for you

by Michiel du Toit

Explaining and demonstrating the use of the APPLY keyword for SQL Server

Malleable Software and Systems Design

by Bryan Kowalchuk

Implementing Agile Software Development

Manage ViewState Using ASP.NET 2.0 Provider Architecture

by Oleg Sobol

Serverside ViewState management using custom providers based on ASP.NET 2.0 provider pattern architecture.

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

Market Basket Analysis in SSAS 2005+

by Igor Krupitsky

This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).

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.

Measurement Unit Conversion Library

by Erich Ledesma

This project allows you to store values along with unit information and conversion between different measurement systems. Also provides a hierarchy to create new converters easily.

Measurement Unit Conversion Library

by George Ziady

This is an alternative for "Measurement Unit Conversion Library"

Merge Replication between SQL 2000 or SQL 2005 using SQLCE

by ihsanps

Merge Replication using SQL 2000 or 2005 using Compact Framework

Microsoft Analysis Services 2005: Displaying a grid using ADOMD.NET and MDX

by khatri.hitesh

The article explains how to fetch data from Microsoft Analysis Services 2005 (OLAP) Cube using ADOMD.NET and MDX, and display it in the form of a grid.

Microsoft Indexing Service and OLEDB

by Ali Hamdar

How we can access the Windows Indexing Service using OLEDB.

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

by Avinish Awasthi

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

Microsoft Reporting Services in Action

by Teo Lachev

Introducing Microsoft Reporting Services.

Microsoft Visual Studio Team System: Single-Server SSL Installation (SP1)

by Mark Bible

Information relevant to installing and configuring Microsoft Visual Studio Team Foundation Server for users who require Secure Sockets Layer (SSL) access over the commercial internet with Basic Authentication in a single-server scenario

Minimalistic Driver-less Native MySql Client

by Ladislav Nevery

Native MySql Client not requiring any special driver or library

Minimum Database Permissions Required for SqlDependency

by Michael Vanhoutte

This article explains how to give a user the minimum rights required for SqlDependency to work

Module Installer

by defwebserver

A DotNetNuke style framework that allows you to upload modules to enable an end-user to easily update and enhance a web application.

MOSS 2007 – Enabling Forms Authentication

by vivekthangaswamy

An article about how Forms Authentication is enabled in Microsoft Office SharePoint Server 2007

MRU Manager

by Eddie Velasquez

MRU Manager for Visual Studio 2005/2088 and SQL Server 2005

MS SQL Server Profiler with .NET

by Praveen Nair (NinethSense)

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

Multi Language Reports in SSRS

by Ponytail Bob

Explains how to do multi language reports in SSRS

Multi Line GridView Column Cell

by T.Ashraf

Display multi line of text saved in the database

Multi Tier Framework in C#

by B. Verboven

Using Microsoft SQL Server or XML files as datastore

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

Multiple Profiles with the Membership and Profile API

by Razwan Kader

Implement and maintain multiple profiles of a user using the Membership and Profile API.

MyStream: Social Lifestreaming with ASP.NET 4.0

by Tanzim Saqib

Turn your current static website or blog into a lifestreaming portal with all your social activities with ASP.NET 4.0, C# 4.0, PLINQ, Task Parallel Library, Dependency Injection, and plug-in architecture.

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!

NHibernate DaoFactory Exposer with Castle MikroKernel

by Ali Ozgur

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

NHibernate Templates for Smart Code Generator

by Danilo Mendez

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

nHydrate Generator Template

by Christopher R Davis, Michael S Knight

Extend nHydrate with your own custom generator templates.

Northwind N-Tier Blueprint Application Using WPF/WCF/LINQ to SQL

by The Cool Wayfarer

A blueprint application to showcase an enterprise standard architecture using the .NET 3.5 technologies like WPF, WCF, and LINQ to SQL.

Notification of Silverlight Applications about Database State Changes

by Max Paulousky

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

Object Persistence: The way to n-tier Nirvana

by James Westgate

Use an agile managed database framework, and feel you've finally reached programming heaven.

Online Query Management Studio 1.0

by Shubham Choudhary

OQMS 1.0 allows you to connect your server online and manage the table like Select, Insert, Update and Delete statements.

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

Overview of SQL Server 2005/2008 Table Indexing (Part-1)

by Md. Marufuzzaman

Basic overview of SQL Server 2005/2008 Table Indexing

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

Overview of Views in SQL Server 2005

by Abhijit Jana

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

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 GridView with ROW_NUMBER()

by Socrate1

This article explains how to implement custom paging in the GridView web control using the ROW_NUMBER() function of SQL Server 2005

Paging without a wizard (SqldataSource control)

by Vimalsoft(Pty) Ltd

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

Parameter Discovery on Microsoft Access With XML option. Using Microsoft Patterns and Practices

by Patrickquinn1212

Automation of command parameter building targeting Microsoft Access

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 an Array as Parameter to SQL Server Procedure

by Mohammad Al Hoss

Passing an array as parameter to SQL server Procedure

Passing Arrays in SQL Parameters using XML Data Type in SQL Server 2005

by Vincent-Philippe Lauzon

Using XML data types in SQL Server 2005, we can pass an array of values from an application server to the database.

Password Recovery

by Emre Onyurt

A password recovery system.

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

by Alfredo_Fernandez

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

Performing Data Merge and Audit with SSIS

by xbadenx

Merge data tables with validation audits and error logging.

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.

Picture Cache & DAL

by Krisztian Batyai

Picture Cache & DAL (WebService & App cache(

Pivot two or more columns in SQL Server 2005

by Mycroft Holmes

A workaround for the limitation of only being able to pivot one column.

Power yourself against XSS

by albert arul prakash

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

Pro SQL Server 2005 Database Design and Optimization

by Paul Conrad

Review of Louis Davidson's Pro SQL Server 2005 Database Design and Optimization

Procedure to Shrink the Database Transaction Log

by Md. Marufuzzaman

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

Programmatically Deploying a SQL Reporting Services 2005 Report

by Sivakumar Mahalingam

This article explains how to deploy SQL reports programmatically into Reporting Server 2005, using Web Services exposed by SQL Reporting Services 2005.

Provider Design Patterns in NET 2.0

by Ahmad Eid Salim

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

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

by pinaldave

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

Query paging by one trip to MS-SQL Server 2005 via one simple query

by Marek Mizov

Query paging by one trip to MS-SQL Server 2005 via a simple query. Without using a Stored Procedure, View, or others features. Only uses T-SQL and .NET.

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

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.

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.

Regular Expressions in MS SQL Server 2005/2008

by db_developer

describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration

Remove duplicate records from SQL tables

by Eugene Ochakovsky

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

Reporting Service on Yukon

by Gaurang Desai

Tutorial for creating basic report using Reporting Service on Yukon

ReportingServices:Application Developer Guide

by veeru.k

Reporting services

RESTful WCF / EF POCO / Unit of Work / Repository / MEF: 1 of 2

by Sacha Barber

A look at designing a service layer using good practices, and the MSFT technology stack.

Restoring Datbase Using BatchFile(*.Bat)

by Deepak.M

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

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.

Robyn Page's SQL Server Date/Time Workbench

by Robyn Page

Some seemingly simple requirements such as getting the DATETIME for the "start of the month" can be surprisingly tricky.

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

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.

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.

Secrets for Setting Up Continuous Integration

by wallism

A few simple tips that should help when you are considering setting up CI

Secure Messaging Solution

by Moustafa Refaat

We are sending and receiving sensitive information over the internet. We want to secure all the messages we are exchanging with our partners.

Security in SQL Server 2005 as seen by a programmer

by Software Developer's Journal

The goal of this article is to present elements of security in SQL Server such as: restrictive access to the server, blocking and safe configuration of services, and reduction of attack space for new elements. Techniques for creating and managing users and for securing data are illustrated.

Select dates of a day between two dates.

by S.S.Cheral

This function gives dates for a day between two dates (e.g. All sundays from Jan-08 to Aug-08)

Send Email Alert on Database Schema Change in SQL Server

by Mubin M. Shaikh

Auto Monitoring On Schema Change within Database in SQL Server and Email Alert

Sending Multiple Rows to Database for Modification

by Nizam Mohd

Am article on how to send multiple rows to SQL Server 2005 database for data modification.

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

by Adnan Faisal

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

Serving SQL XML through a WebService (SQL 2005)

by Russ Quinn

How to serve XML from SQL 2005 through a WebService

Setting the Data Source of Reporting Services at Runtime

by Niladri_Biswas

Access multiple databases by a single SSRS report.

SharePoint 2010 Logging Database

by Ayman M. El-Hattab

Four reasons to directly query SharePoint logging database

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 Stored Procedures in .NET

by HRiazi

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

Simplified phonetic search with MS SQL Server

by vini2k1

Perform phonetic search on MS SQL Server using Soundex.

Simulating Monolog Conversations with SQL Server 2005 Service Broker

by Vincent-Philippe Lauzon

How to use SQL Server 2005 Service Broker technology to simulate monologs and traditional queues

Single Instance Application A Simple Way!

by skullz_softwares

Making Single Instance Application a Simple Way!!

SingleSimon - Password Manager Application

by alon1980

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

Skeleton for a Silverlight business application based on Ria Services and the Ria Services Class Library

by Max Paulousky

This article presents the techniques and caveats of building Silverlight business applications. It describes breaking down applications into tiers, implementing a data access in N-tier applications, implementing a custom authentication, adding a support of https to Ria Services applications.

Slide-Show User Control

by Samir NIGAM

This article describes how to create a slide-show user control with the help of the DataList control.

Small Paging Control for Windows Presentation Foundation (WPF)

by freedeveloper

A small control to control paging in Windows Presentation Foundation.

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.

Solving the collation mix with SAP

by r.stropek

Solving the collation mix with SAP (SQL_Latin1_General_CP850_BIN vs. Latin1_General_CI_AS).

Some Utility Functions using SQL Server 2005 CLR Hosting

by senguptaamlan

This article and code sample briefly describe the creation of User Defined Function in SQL Server 2005 by using CLR Hosting Feature

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 - Pivot with Grand Total Column and Row

by Narapareddy Shyamprasad

SQL Dynamic Pivots

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 Agent: A Job Scheduler Framework

by Danilo Corallo

An easy-to-use .NET solution for Job Scheduling with pluggable actions that runs on a Windows Service. Back up your SQL Server Express and much more!

SQL Alpha Numeric Sort Using CLR Integration

by shteff

How to do a sort on alphanumeric strings in SQL Server.

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 Battleship 2008

by craigd

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

SQL Bundle Developer Edition: V4

by Redgate Software

Essential tools for easy migration to SQL Server 2005.

SQL Champ - A Quiz to Prove Your SQL Knowlege

by r.stropek

software architects invites you to prove your knowledge about certain subjects concerning Microsoft .NET technology by participating in a monthly quiz. This month the quiz is about SQL Server.

SQL Class Shell Generator

by Paw Jershauge

Generate class shells from SQL Server database tables, (SQL 2005 & 2008 only). Output languages supported: C# and VB.NET.

SQL Compact 3.5 Tidbits and Gotchas!

by Jammer

An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.

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 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 Pivot and Table Adapter

by TTGOH

Using TableAdapter to display Pivot result without code.

Sql Queries most asked in job interviews.

by Sudipta Chaudhari

Tricky Sql Queries most asked in SqlServer/.NET Job Interviews.

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 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 Select Top 100 % forgets Order By Clause

by Daniel Ch. Bloch (MCSD, MCAD, MCTS)

SQL 2005+ changes behaviour of order by in relation to Select top 100%

SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints...

by pinaldave

SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects

SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard

by pinaldave

SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard

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 - How To Handle Deadlock

by Nitin Chilka

An article on how to handle deadlock

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 2005 Distilled - Chapter 3: Enterprise Data Management

by Addison-Wesley

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

SQL Server 2005 Paging Results

by Frank Kerrigan

Using SQL Server to do paging of sql results.

SQL Server 2005 reporting service: Display Columns as Rows

by sada.narayanappa1

This article presents a solution to create a report using SQL reporting service that displays a column data as rows; furthermore, the columns are repeated horizontally for each data row. It also provides a sample source project that uses "Northwind" database for data source purpose

SQL Server 2005 Reporting Services – RDL Programming Issues

by Jatin Gupta MS

RDL Programming - some issues and their solutions

SQL Server Agent Proxy

by Muhammad Shujaat Siddiqi

shujaatsiddiqi.blogspot.com

SQL Server Alerts

by Muhammad Shujaat Siddiqi

Defining SQL Server Alerts (shujaatsiddiqi.blogspot.com)

SQL Server Authentication using SMO

by Rupesh Tarwade

Setup a connection string by allowing the user to select the server and database

SQL Server backup utility

by User 992674

Restore/backup selected objects in SQL Server.

SQL Server CLR Integration Part 1: Security

by Mark J. Miller

Understanding how the SQL Server and CLR security models work together to keep your database secure

SQL Server Combo Control

by Emrys81055

Lists all instances of SQL Server found on a local network.

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 Development in Visual Studio

by NaibedyaKar

SQL Server database project creation using Visual Studio 2013

SQL Server Date Format Language

by Cristhian Selah

Perform a conversion in a select, view, and Stored Procedure.

SQL Server Easy Column Search

by Divan van der Watt

Column search functionality that works as easy as sp_help.

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 In Clause With Multiple Literal Values Performance Behaviour

by Neeraj Prasad Sharma

This article deals with performance difference with literal values

SQL Server Integration Services (SSIS) – Part 1: Basics of SSIS and Creating Packages

by KarthikAnbarasan

Part 1 of a series of articles on SQL Server Integration Services - teaches the basics of SSIS and shows how to create packages

SQL Server Integration Services (SSIS) 15 Best Practices

by josekonoor

SQL Server Integration Services (SSIS) best practices.

SQL Server Object Search

by Brady Kelly

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

SQL Server Performance Impacted by New Features

by KP Lee

Specific example for improving some SQL performance problems

SQL Server Procedures And Functions Encryptions

by Mohammad A Gharakhanlou

this application is answer for ;How to encrypt sql server procedures and functions at a time

SQL Server Profiler Step by Step

by Abhijit Jana

SQL Server Profiler Step by Step: SQL Server 2005

SQL Server Reporting Services 2005 XML Extensions

by Alexander Nowak

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

SQL Server 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 Stored Procedure Generator and .NET C# Wrapper as single-layer DAL

by singh

This article shows general code that creates stored procedures for SQL tables and C# DAL

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

SQLCLR, Triggers e Web Services in SQL Server 2005

by raphadesa

Article explaining how to access a web service using SQL Server integration with VS 2005 (SQLCLR)

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

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

SqlTimeSpan

by Giovanni Bejarasco

Porting of System.TimeSpan as a SQL Server UDT.

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

SSRS Series Part I: Various ways of Report creation, deployment and invocation

by Niladri_Biswas

This article will help in understanding the myraid ways of report creation, deployment and invocation of report from various client applications

SSRS Series Part II: Working with Subreports, DrillDown Reports, Expressions and Custom codes, Databars, Indicators, Custom Sorting and Paging and...

by Niladri_Biswas

In this article we will learn creation of subreports, drilldown reports, custom coding and expression, web service and wcf service consumption frm SSRS,custom paging and sorting, working with databars and indicators with real time examples

Static Data Helper (ASP.NET 2.0)

by Declan Bright

A helper class to manage static data for dropdown lists with caching.

Step by Step Introduction to Microsoft SQL AZURE

by Niladri_Biswas

Step by step introduction to Microsoft SQL AZURE

Step-by-Step SQL Mirroring the ASPState Database

by T MacLachlan

SQL Mirroring made easy - setting up a mirror for a database

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 and Retrieve Trees in SQL under C#

by Reza Shojaee

In this article, the ability of Microsoft SQL Server database in storing and retrieving trees will be described.

Store audio in Sql Server 2005 and retrieve it and play it in windows application .net.

by Morteza Naeiamabadi

this article demonstrate how to insert a audio file into SQL Server and how to get the audio file from SQL Server and play it in .Net

Store or Save images in SQL Server

by User 992674

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

Storing And Displaying Image From Database

by N a r e s h P a t e l

This article describe how to add image directly to database and how to view the Image stored from Database.

Storing Images in SQL Server using EF and ASP.NET

by Eduard Keilholz

A quick help for storing images in SQL Server and displaying them on a ASP.NET Website

Sum of previous row values in SqlServer

by S.Vinothkumar

Sum of previous row values in SqlServer

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.

T- SQL - How to get all descendants of a given element in a hierarchical table

by Paolo Costa

This article provides a T-SQL table valued function that retrieves all the descendant rows of a given row in a hierarchical table.

Table Data Sharing Across Stored Procedures

by ManojKumar19

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

Task Management System

by Sayedur Rahman

A web application allows user to manage tasks, projects & employees of an organization and also provide reports on them

Task Manager

by Shakeel Iqbal

Manage your daily tasks and To-Do list using some exciting features of Windows 7.

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

by Bryan Kowalchuk

Efficiently storing telephone numbers in SQL Server.

Telephone Numbers in SQL Server 2005: Part 2 – Formatting

by Bryan Kowalchuk

Formatting telephone numbers in SQL Server.

Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance

by Dmitry Tsuranoff

Determining SQL Server performance for temporary tables and and table variables.

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

by Atanu Banerjee

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

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.

The new reporting horizons with Microsoft Reporting Services 2005

by Dimitar Madjarov

How to use a WebService as a data source to build a report with Microsoft Reporting Services 2005.

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

Three Master-Details Related Grids on the Same Form

by db_developer

An approach to create a master-details grid and to show the parent column in the child table.

Three-tier .NET Application Utilizing Three ORM Technologies

by Bryan Thomas Weikel

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

Tier Generator 1.0

by Shakeel Iqbal

A powerful tool for rapid application development.

To create Google Suggest using ASP.NET & AJAX

by Nilesh Surve

To create Google Suggest using ASP.NET & AJAX

Towards the self-documenting database: extended properties

by William Brewer

With SQL Server, it is strange how some of the most radical improvements that have been introduced over the years have been slipped in almost unnoticed.

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.

Transaction Management Across Application Domains

by gaurav_verma_mca

This article details out the best practices of transaction management across application domains

TransactionScope in .NET 1.1

by Alexander Shirshov

Emulate TransactionScope functionality coming in .NET 2.0 with .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.

TreeToTable hierarchical tables with SQLServer 2005 and C#

by Arjan Pot

Retrieving child records from an hierarchical table

Triggers -- SQL Server

by Sudipta Chaudhari

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

Trouble with Installing SQL 2005 After Uninstalling CTP/Beta

by Dewey Vozel

After uninstalling the SQL Server 2005 CTP, if you are unable to install the release version, here is what you should do.

Truncate Log File in SQL Server 2005

by Assil

A tool that facilitates the truncation of SQL log file

Truncate SQL Server Transaction Log

by lintom

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

Try and Catch Fun in SQL Server 2005

by Rajib Bahar

This article is about exception handling improvements in SQL Server 2005.

T-SQL Coding Standard

by Casper Leon Nielsen

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

Uncommon Common Table Expressions (CTEs)

by Jeremy Likness

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

Understanding SQL Execution Plan (Part I)

by JustChiragPatel

Brief Intro of how out t-SQL is parsed and submitted to SQL Engine to retrive data

Unravelling a Large Database

by trantrum

An article about unravelling a large database

URL Decoding in pure T-SQL

by orinoco77

How to decode a URLEncoded URL with T-SQL

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 RegEx in SQL with CLR Procs

by JasonShort

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

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.

Useful tips on Reporting Services

by aakanksh

Some useful tips on using Reporting Services

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 EntitySpaces Business Objects in XAML

by dakeefer

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

Using Flex to build your real-time chart

by ZHAOBING_NTU

A dynamic Flash chart that can commnunication with your database.

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 Linq to paginate your ObjectDataSource.

by Jason Witty

In this article I walk through an example that binds a gridview control to an ObjectDataSource and uses Linq queries to paginate to achieve true data pagination.

Using LINQ to SQL in N-Tier Architectures

by emad_awad

How to use LINQ to SQL in N-Tier architectures.

Using Multiple NHibernate Assemblies with NHSessionManager

by Ali Ozgur

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

Using Query Notifications in .NET 2.0 to handle ad-hoc data refreshes

by rajiv404

Query Notification in SQL Server 2005 solves the problem of having to maintain a polling database to get the updated data. The new notification service of SQL Server 2005 can perform this amazing task of notifying a .NET code when any DML operations are performed to a specified table.

Using RDLC and DataSets to develop ASP.NET Reporting Services Reports

by david.ribeiro

Developing and invoking RDLC reports without the Reporting Services Server.

Using ROW_NUMBER() to paginate your data with SQL Server 2005 and ASP.NET

by Jason Witty

With the release of SQL Server 2005, Microsoft introduces the long overdue ROW_NUMBER() function. In this article, we will walk through a C# implementation of pagination using the ROW_NUMBER() method.

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 trigger to create unlimited unique id's

by VincentGee1

Using SQL trigger to create unlimited unique id's

Using SqlDependency for data change events

by Not Active

Using SQL Server 2005 and SqlDependency to keep your application's data updated.

Using StoredProcs with Parameters in SQL Reporting Service 2005

by ganti.r

SQL Reporting Service provides an option for using stored procedure in the SQL Server instead of using a query in the report.This article takes you through step by step process of creating a dataset which used a stored procedure with parameters.

Using the ASP.NET 2.0 ReportViewer in Local Mode

by ShirleySW

How to use the ASP.NET 2.0 ReportViewer control in Local mode.

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 the Foreach ADO Enumerator in SSIS

by r.stropek

SSIS has a built in function for loops. In this blog article, I want to demonstrate how to use SSIS's Foreach ADO enumerator to loop through a list of SQL server names and collect some basic data (e.g. name, language, version, etc.) about them.

Using TRY...CATCH in Transact-SQL

by Himanshu Kumar Sinha

I will discuss the Try & catch error handling feature of the SQL SERVER 2005 (Yukon)

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

by Andy_L_J

Generate unique column values using UDFs and Stored Procedures

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

Using XML Serialization with SQL's FOR XML PATH

by BoneSoft

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

VB DataGridView Automatically Saving Updates to a Bound Database

by Andrew Timberlake-Newell

Demonstrates how to configure a DataGridView control to automatically store edits to bound datasets into the source 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.

Very Fast Table Copy from an ODBC Source into Microsoft Access within a C# Project

by David Catriel

An extremely fast and efficient way to import a table from any ODBC-capable database into MS Access (while running in a C# project), by using the Microsoft Access built-in import functionality.

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

Visual Application Launcher

by Dylan Morley

A WinForms UI using WCF services, Entity Framework, repository data access, repository caching, Unit of Work, Dependency Injection, and every other buzz work you can think of!

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.

VSTO 2005 add-ins and Outlook 2003

by RENJUR

Adding a command bar to Outlook 2003.

WCF by Example - Chapter II - Repositories

by Enrique Albert

Introducing the RepositoryLocator pattern.

WCF by Example - Chapter III - Response

by Enrique Albert

WCF service response message patterns

WCF by Example - Chapter IV - Transaction Manager

by Enrique Albert

Generic transaction and exception manager for server side services

WCF by Example - Chapter X - Dependency Injection with Spring.Net

by Enrique Albert

How to use Spring.Net DI reducing coupling and enhancing automated testing.

WCF by Example - Chapter XI - NHibernate Implementation

by Enrique Albert

Unit of work pattern on NHibernate using repositories.

WCF by Example - Chapter XII - WCF Implementation

by Enrique Albert

In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.

WCF by Example - Chapter XIII - Business Domain - Parent and Child Relationships

by Enrique Albert

Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.

WCF by Example - Chapter XIV - Validation & Exception Management

by Enrique Albert

WPF Validation using the IDataErrorInfo interface combined with Validation attributes

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 Browser with C#

by Leo Koach

New functionalities for a web browser (for beginners).

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 Parts Communication

by Raghuram Beemreddy

Explains the communication between Web Parts.

Web Service via Data Access Object Pattern

by Andrew Golik

A Data Access Object pattern implementation

Where is .NET heading with .NET 2.0, VS.NET 2005 and SQL Server 2005?

by Narayana Rao Surapaneni

Where is .NET heading with .NET 2.0, VS.NET 2005 and SQL Server 2005?

Where Vs Having / Difference between having and Where clause

by gouravverma

Basic difference between Sql Where and Having Clause

Windows DTS Package for SQL Server 2005 Database Backup

by Padoor Shiras

Automated Windows DTS Package for SQL Server 2005 Database Backup

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

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

by Abhishek Sur

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

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

by Abhishek Sur

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

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.

WSE 3 Deployment: MSI and ClickOnce

by lepipele

Overview of deployment techniques using example WSE 3 enabled solutions

XML/XSLT Word Report Generator

by Sam Safonov

The tool is based on XML/XSLT, and allows a user to create a Word report from scratch, namely: construct SQL query, construct a WordML template, generate a document.

XQuery basics

by Mayank Dubey

XQuery basics.

Zeta Backup Validator

by Uwe Keim

A small console application that helps you in verifying whether your backups succeed by checking files and folders with various configurable rules

Zeta Helpdesk

by Uwe Keim

An application to manage support request with tickets and events

Zeta Scheduler

by Uwe Keim

An application that helps you in starting tasks at predefined times and with various dependencies.

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

by Harmen Brouwer

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