Click here to Skip to main content
14,669,324 members
SQL-Server » SQL-Server-2005


Great Reads

by AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
by Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
by Abhijit Jana
Overview of Log Shipping in SQL Server 2005
by Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.

Latest Articles

by Narapareddy Shyamprasad
SQL Dynamic Pivots
by Luca Astolfi
User defined procedure for make an HTML table from T-SQL Select statment
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!
by Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages

All Articles

Sort by Updated


11 Jan 2009
Fast and easy to use data access class library.
23 Oct 2008
Some useful tips on using Reporting Services
9 Nov 2012
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.
16 Aug 2012
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.
4 Aug 2010
Abdul Quadir Saifee
Creating Crystal reports with dynamic number of Columns with Typed dataset with SQL Server 2005
22 Feb 2008
Abhijit Jana
SQL Server Profiler Step by Step: SQL Server 2005
25 Oct 2008
Abhijit Jana
Overview of Log Shipping in SQL Server 2005
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
28 Jul 2009
Abhijit Jana
Overview of Views, system Views, creation of Views, and binding and securing Views.
2 Aug 2009
Abhishek Sur
Gives an introduction to CLR programming in SQL Server databases. This is the first part of a two-part article series.
2 Aug 2009
Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
27 Sep 2009
Given date ranged data, adjust existing ranges on entry of a new ranged data.
23 Nov 2010
Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
16 Oct 2007
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.
23 Nov 2007
Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors
28 Sep 2007
Distribute your site's contents with RSS 2.0 using ASP.NET/VB.NET/MS SQL Server 2005.
31 Mar 2006
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.
17 Apr 2009
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.
29 Oct 2008
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.
25 May 2008
Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
3 Sep 2008
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.
16 Jun 2010
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.
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
24 Jun 2008
Implementing a tab control like structure in SQL Server 2005 reporting services report using tables and text boxes
28 Sep 2005
Akram Hussein
An article on distributed messaging using Service Broker in SQL Server 2005.
7 Aug 2007
albert arul prakash
XSS gaining popularity to hack into websites. This article describes how to power yourself against XSS
20 Jul 2005
Albert Pascual
I wrote this short article to improve your ASP.NET application Sessions using Cache.
3 Mar 2009
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.
25 Sep 2007
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.
1 Jun 2005
Alexander Shirshov
Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.
26 Jul 2009
The article provides a simple interface for handling large text in SqlClient and C# file streams.
16 Jan 2009
Performance comparison - Identity() x NewId() x NewSequentialId.
26 Jul 2008
Ali Daneshmandi
CLR Function for Persian Date Converter in Microsoft SQL Server
15 Apr 2008
Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
6 Feb 2010
Ali Marzban
Changing ConnectionString like an attribute in C#
1 Feb 2007
Ali Ozgur
This article describes how NHSessionManager can be configured to use multiple NHibernate assemblies
2 Feb 2007
Ali Ozgur
How to create DaoFactory instances with Castle/MikroKernel in NHibernate applications
7 Oct 2007
Ali Ozgur
Sample code describing how to retreive statistical information about the T-SQL commands executed.
21 Feb 2005
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
30 Sep 2008
An open source password manager with some advanced features and cool interface
29 Apr 2007
Anandhi Swamy
Handles uploading /downloading images into/from database to DataGrid
8 Dec 2008
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.
30 Dec 2007
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.
30 Dec 2007
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.
2 Oct 2008
Andrew J Dixon
Explaining Database deadlocking to non-technical people
11 Jul 2006
Andrew Timberlake-Newell
Demonstrates how to configure a DataGridView control to automatically store edits to bound datasets into the source database.
11 May 2007
In an attempt to open DotNetNuke to a wider audience, I have converted the original VB code into C#
27 Apr 2009
Aneesur Rehman Khan
Consume 32 bit COM DLL in x64 bit SQL Server 2005
14 Sep 2006
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.
29 Apr 2011
A sample application for beginner users who want to start the Linq implementation in ASP.NET
9 Dec 2010
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
26 Nov 2012
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
2 Jul 2004
Ashvil DCosta
See how Longhorn core pillars like WinFS changes the way applications are written, based on metadata relationships.
25 Oct 2007
Achieving the DataGrid functionality with paging using User control and Ajax
17 Oct 2007
Data builder that builds XML from a SQL query in hierarchical format.
6 Jan 2014
A tool that facilitates the truncation of SQL log file
15 Jun 2007
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)
17 Mar 2008
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.
25 Jul 2006
View and update any database table and metadata. Includes sample databases.
15 Apr 2011
Ayaz Awan
Generate 100,1000 lines of backend code and stored procedures by just one click on table name in SQL Server
6 Apr 2010
Ayman M. El-Hattab
Four reasons to directly query SharePoint logging database
22 Sep 2010
B. Verboven
Using Microsoft SQL Server or XML files as datastore
5 Oct 2007
Babak Ansari
A custom asynchronous setup with progress indicator.
26 Jan 2010
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
27 Jan 2006
Bahrudin Hrnjica
Putting and retrieving images files to and from a database, via ADO.
16 Apr 2007
Bassam Saoud
A Custom TreeView Control that supports auto binding from a single self referencing table
25 Mar 2009
Behrouz Rad
The most advanced things which you can do with GridView in ASP.NET 3.5
15 Feb 2007
Ben Allfree
Learn how to store data with a version history.
11 May 2006
Bernard Ho-Jim
Extending the Personal Web site Starter kit by implementing efficient data paging to the Photo Gallery.
7 Aug 2008
Inserting value of Collection into Database
26 May 2009
Bishoy Demian
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
31 Dec 2008
How to use a script component as a data source for multi-result set Stored Procedures.
31 Mar 2009
Explains how to do multi language reports in SSRS
20 Nov 2007
Describes a method for loading data objects using SQL Server 2005's new FOR XML PATH mode and XML serialization.
22 Aug 2007
Brady Kelly
An application that seeks to emulate the F4 object search function from Query Analyser
8 Mar 2006
Brian Bayless
A central key manager for multiple web server clients in a web farm.
18 Oct 2013
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.
18 Oct 2013
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!
21 Dec 2007
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.
16 Jan 2008
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.
19 Dec 2007
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.
30 Jan 2010
Bryan Thomas Weikel
LINQ to SQL, Entity Framework, and NHibernate used in a parallel fashion in a three-tier WinForms application.
3 Feb 2009
C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
16 Feb 2007
An article about converting ASCII/Multibyte to Unicode using C# and SQL/CLR integration.
1 Oct 2008
Casper Leon Nielsen
T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)
25 Oct 2004
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.
9 Jan 2007
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).
12 Mar 2014
Christian Graus
The second in my series digs in to some of the different things you can do within a select statement.
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
12 Jan 2014
Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
12 Jan 2014
Christian Graus
In which we talk of ways to pass an arbitrary list of values to SQL Server
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
14 Mar 2014
Christian Graus
In this installment, I talk about working with dates and date functions in SQL Server
22 Apr 2009
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...
10 Dec 2009
Christopher R Davis, Michael S Knight
Generate applications using Inversion of Control with the nHydrate code generator.
31 Dec 2009
Christopher R Davis, Michael S Knight
Extend nHydrate with your own custom generator templates.
26 Sep 2006
Provide a very simple set of instructions for creating your own media gallery and loading your images from SQL Server 2005.
12 Dec 2007
Simple bit of Transact SQL to help locate text in a database using cursors
23 Jan 2005
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.
7 Aug 2006
Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.
15 Dec 2007
Single-player game using GEOMETRY datatype and spatial functions in SQL Server.
23 May 2012
Cristhian Selah
Perform a conversion in a select, view, and Stored Procedure.
5 Mar 2008
Cristi Paraschiv
Custom XML file(s) named from a database fields (Sql Server 2005 DB)
2 Nov 2007
An exploration of how to use the EntitySpaces business object framework within a WPF application.
19 Jul 2006
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.
19 Mar 2008
Daniel Ch. Bloch (MCSD, MCAD, MCTS)
SQL 2005+ changes behaviour of order by in relation to Select top 100%
25 Apr 2007
Daniel Kuettel
This article shows a simply method of encrypting connection strings for windows applications
7 Nov 2006
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.
8 May 2008
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!
11 Dec 2007
Danilo Mendez
Describes how to generate NHibernate objects and ASPX pages using Smart Code
18 Feb 2008
Dannover Arroyave M.
Developing a catalog of DVDs
13 Nov 2005
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.
10 Sep 2008
Dave Elliott
How to sort tables so data can be retrieved for offline sychronization and not violate foreign key relationships.
19 Dec 2011
David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
11 Jan 2008
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.
24 Jul 2008
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!
5 Jul 2009
Developing and invoking RDLC reports without the Reporting Services Server.
23 Sep 2009
An approach to create a master-details grid and to show the parent column in the child table.
23 Sep 2009
This article consists of a data layer and forms for database tables editing.
11 Oct 2009
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
4 Sep 2006
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.
3 Mar 2006
Declan Brennan
Extending the RichTextBox to support form persistance and data binding.
2 Nov 2006
Declan Bright
A helper class to manage static data for dropdown lists with caching.
9 Jun 2008
This article describes on building a Database from scratch using Batch File from the existing Database
29 Dec 2006
Deepu M.I
Execute Access 2003 Macros in SSIS Package. How to call Access Macros in SSIS Package
25 Dec 2006
Deepu M.I
The concept of SSIS Logging is to capture log-enabled events that occurs at run time.
18 May 2008
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.
19 Oct 2008
defwebserver is a Open-Source ASP.NET framework that allows you to dynamically load Silverlight modules into resizable draggable windows.
5 Jul 2008
A DotNetNuke style framework that allows you to upload modules to enable an end-user to easily update and enhance a web application.
7 Jan 2011
Denis Strukachev
Create md5 hash-code using assemblies in SQL Server 2005
19 Mar 2008
Dennis Betten
Export all tables and data to an Excel file.
18 May 2007
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.
17 Dec 2005
Dewey Vozel
After uninstalling the SQL Server 2005 CTP, if you are unable to install the release version, here is what you should do.
18 May 2006
Dimitar Madjarov
How to use a WebService as a data source to build a report with Microsoft Reporting Services 2005.
11 Jan 2010
Divan van der Watt
Column search functionality that works as easy as sp_help.
30 Apr 2012
How SQL Server deletes records
28 May 2007
Dmitry Tsuranoff
Determining SQL Server performance for temporary tables and and table variables.
1 Nov 2005
Duncan Edwards Jones
Shows how you can use custom attributes to save .NET classes directly to an SQL Server table
14 Aug 2012
Duong Ba Hong Minh
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
5 Apr 2006
Dwight Johnson
Save hours of time by creating stored procedures and code from database metadata.
23 Jan 2012
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!
24 Feb 2017
Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
27 Feb 2008
Eddie Velasquez
MRU Manager for Visual Studio 2005/2088 and SQL Server 2005
10 Feb 2009
Eddy Vluggen
How to import a database-dump from into SQL Server
23 Oct 2013
Eduard Keilholz
A quick help for storing images in SQL Server and displaying them on a ASP.NET Website
2 Aug 2006
Codes to help to connect VS 2005 to SQL Express manualy
27 Feb 2009
How to use LINQ to SQL in N-Tier architectures.
19 Sep 2008
Emil Lerch
Command line tool to check validity of objects in SQL Server databases
4 Aug 2008
Lists all instances of SQL Server found on a local network.
13 Dec 2008
Enrique Albert
Console and GUI utility application that executes SQL scripts against SQL Servers (7, 2000, and 2005) - version is now available.
18 Dec 2010
Enrique Albert
In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.
5 Nov 2010
Enrique Albert
Introducing the RepositoryLocator pattern.
24 Oct 2012
Enrique Albert
WCF service response message patterns
24 Oct 2012
Enrique Albert
Generic transaction and exception manager for server side services
14 Oct 2011
Enrique Albert
How to use Spring.Net DI reducing coupling and enhancing automated testing.
14 Oct 2011
Enrique Albert
Unit of work pattern on NHibernate using repositories.
7 Jan 2011
Enrique Albert
Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.
25 Oct 2012
Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
23 Jan 2008
Erich Ledesma
1 alternative  
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.
29 Dec 2007
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.
19 Dec 2006
Eugene Mirotin (Guard)
Demonstrates the easiest way to use all the advantages of SqlDataSource and GridView, and to allow flexible DataSource configuration.
13 May 2007
Eugene Ochakovsky
A generic procedure to retrieve and delete duplicate records from MS SQL Server tables.
29 Feb 2008
Evaldas Jocys
How to create and compile SQL XML Documentation comments
8 Jun 2008
Evaldas Jocys
Provides required tables and data for multilanguage projects
5 Jun 2007
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.
15 Oct 2010
Sohail Maroof, Farrukh Hashmi
Exception handling in 3-Tier Architecture using Enterprise Library
11 Dec 2007
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).
2 May 2005
How to write multiple filters on a WHERE clause on a sql sentence
4 Apr 2007
Fitim Skenderi
Very Lightweight Data Access Layer in C# and .NET 2.0
19 Apr 2007
Frank Kerrigan
Using SQL Server to do paging of sql results.
27 Jun 2012
A small control to control paging in Windows Presentation Foundation.
3 Oct 2008
Make backups of SQL databases and upload them to FTP server
17 Apr 2005
Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
20 Apr 2008
An article on a SQL IDE for different type of RDBMS databases
21 Aug 2006
ganesan balachandar
The tool can generate the specified number of rows for any table. Can be used for stress testing the application
14 Oct 2010
Ganesan Krishnan
Data Synchronization in SQL Express
6 Jun 2007
Ganesan Sankaran
How to add values to a dropdown using AJAX.
25 May 2007
Ganesan Sankaran
How to populate a dropdown in another dropdown change
17 Sep 2007
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.
30 Jan 2009
An explanation of Views in SQL server 2000/2005 and the advantages of them
25 May 2005
Gaurang Desai
Tutorial for creating basic report using Reporting Service on Yukon
11 Oct 2009
This article details out the best practices of transaction management across application domains
23 Nov 2009
Configuration of .NET applications using database
17 Jun 2007
A free, mean and lean way to create data driven PDF on the fly by using SQL server reporting service (SSRS)
25 Sep 2009
George Oakes
This library allows a user to use functions in SQL Server to encrypt and decrypt text.
29 Jul 2008
George Zabanah
Take a look at two new patterns to help with database concurrency: SIP and SUP.
2 Oct 2013
George Ziady
This is an alternative for "Measurement Unit Conversion Library"
26 Jan 2009
Gil Shabat
Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.
30 Jul 2009
Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
29 Oct 2008
Giovanni Bejarasco
A walkthrough in UDT programming with primary focus on database concepts.
25 May 2010
A step by step explanation of how a recursive CTE actually works.
8 Dec 2009
Gordon Kushner
Utility program for generating SQL Server INSERT scripts
11 Oct 2011
This article explains how you can use IWA to improve your Users' experience and it also explains how it benefits your IT support team.
18 Jun 2006
Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005
8 Dec 2007
Automatically generates the required class and stored procedure to work with SQL databases
29 Dec 2006
Hari Prasad K
The DMVs; newly introduced in SQL Server 2005 gives database administrator information about the current state of the SQL Server machine.
14 Aug 2013
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.
14 Sep 2012
Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
6 Jan 2014
Hasan Habib Surzo
Class, Database Connection, Login Winform
14 Jan 2015
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.
25 Oct 2005
Himanshu Kumar Sinha
I will discuss the Try & catch error handling feature of the SQL SERVER 2005 (Yukon)
14 May 2008
Himanshu Thawait
This sample shows BizTalk 2006 consuming a Web Service, then publishing orchestration as a Web Service, and calling it from ASPX.
9 Jun 2006
How to truncate log file in SQL Server 2005
13 Oct 2006
Configure MS SQL Server 2005 Remote Access ( mixed mode )
26 May 2006
How to populate DataGridView, GridView with SQL statement in C#
9 Jun 2006
How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005
28 Apr 2006
How to use global variable in Microsoft SSIS (DTS) package
7 Feb 2006
Use stored procedures in your code - as simple as 1,2,3
26 Oct 2009
DEVELOPING SSIS to import oracle records to sql server
6 Jan 2010
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.
27 May 2016
How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database
2 Nov 2015
Easily create Business and Data Layers!
21 Sep 2007
Get or find Primary Key or ID column of Table in SQL Server 2000/2005
8 Sep 2007
SQL Script Generator generates the SQL Scripts to run on SQL query to analyze only insert and update queries
10 Sep 2007
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.
28 Feb 2009
Igor Krupitsky
This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).
6 May 2008
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.
11 May 2007
Igor Krupitsky
A complete VB.NET application to schedule DOS command tasks online
25 May 2007
Igor Krupitsky
SparkLine is a small, high resolution line chart. This article explains how to create and use SparkLines in your ASP.NET application.
25 May 2010
use date and time as separated components in SQL Server 2000 and above
5 Apr 2010
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.
7 Jan 2007
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.
13 Feb 2006
A handy command line tool that checks whether stored procedures, views and functions in a database compile
2 Feb 2007
István Kovács (HU)
Indexing Word, Excel and other types of documents is easy with SQL Server
7 Dec 2006
James Westgate
Use an agile managed database framework, and feel you've finally reached programming heaven.
23 Dec 2007
How to add a modified on column in SQL Server using triggers.
31 Jan 2007
How to check if your Microsoft SQL Server 2005 is ready for the new DST 2007
1 Aug 2008
An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.
24 Mar 2008
Do you want to know what your DB programmers are doing?
20 Nov 2005
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.
18 Mar 2008
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.
7 Aug 2017
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!
20 Aug 2007
Jatin Gupta MS
RDL Programming - some issues and their solutions
27 Oct 2007
Jatin Prajapati
Here I am showing, How to Create SQL Database and Run SQL Script File Using
8 Apr 2010
Hide the datagrid columns which are not intended to be displayed at runtime
1 May 2012
Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
18 Jul 2007
Jeff Bramlett
Helper classes for automation of stored procedures
25 May 2006
Jeff Modzel
Learn how to load and execute a SQL Server 2005 Integration Services package from C# code
22 May 2006
Jeff Modzel
How to create your own ASP.NET 2.0 custom resource provider to replace resource files (resx) with SQL Server.
25 Aug 2009
Jeremy Likness
Common table expressions (CTEs) are a powerful new construct for building advanced queries.
11 Jun 2008
Jimmy Zhang
Introduces a simple, efficient, human-readable XML index called VTD+XML.
11 Mar 2008
Joe Negron
The SQL MAX() function is a little tricky when trying to work with numeric data - Not quite the same in other languages.
20 Jul 2007
Johan Sassner
An addin to Sql Server Management studio that lets you configure keybindings
28 Jul 2008
John Kenedy S.Kom
This project enables developer to create a setup package that automatically installs SQL 2005 Express and restores database to it
10 Jul 2008
John Kenedy S.Kom
This is a .NET 3.5 library that acts as Data Access Layer with many automatic features
8 Nov 2007
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
26 Jun 2008
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
17 Sep 2009
SQL Server Integration Services (SSIS) best practices.
5 Oct 2006
Create database in sql server using with C# (VS2005)
27 Mar 2005
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.
16 Mar 2009
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.
12 Feb 2009
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.
30 Jun 2008
We will create a very simple web chat application using the latest ASP.Net 3.5 technologies from scratch.
24 Oct 2006
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.
20 Jun 2008
No need to create web service for SSIS package call
12 Aug 2008
Brief Intro of how out t-SQL is parsed and submitted to SQL Engine to retrive data
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
8 Nov 2011
Kanasz Robert
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
22 Sep 2010
Kannan K R
In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.
9 Apr 2011
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.
10 Feb 2011
Part 1 of a series of articles on SQL Server Integration Services - teaches the basics of SSIS and shows how to create packages
14 Jan 2011
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.
2 Nov 2006
An article on configuring an SSIS Package.
14 Nov 2004
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
19 Aug 2008
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.
28 Mar 2013
Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
11 Jun 2005
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.
14 Dec 2007
A C# class that uses the local file system to cache binary objects stored in a database.
2 May 2013
Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
11 Oct 2011
KP Lee
Specific example for improving some SQL performance problems
25 Aug 2005
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.
26 Nov 2007
Krisztian Batyai
Picture Cache & DAL (WebService & App cache(
23 Apr 2009
Tool developped to manage and analyse disk space on multiple fileserver in my company
1 Feb 2009
Kurush Rastkar
Using most of the recent technologies in one application
31 Dec 2008
A C# implementation of CHAID for MSSQL 2005 à la Cognos scenario.
11 May 2009
Ladislav Nevery
Native MySql Client not requiring any special driver or library
6 Mar 2007
A great AJAX Grid very customizable. In English & Spanish traduction
25 Apr 2010
Leo Koach
New functionalities for a web browser (for beginners).
4 Oct 2009
Overview of deployment techniques using example WSE 3 enabled solutions
4 Oct 2009
Generate Word documents by appling XSLT on XML data.
22 Jan 2013
Levente Kupás
Managing SQL backups can be more simple by using this FileRelay CLR
26 Feb 2009
Lindsey Lewis
An article about a tool for comparing SQL database schema versions
27 Aug 2008
Lino Barreca
Use T-SQL and system views/stored procedures to give consistent names to every relation in a database
19 Aug 2005
An easy way to truncate Transaction Log files to your desired size.
13 Jan 2013
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
21 Aug 2007
Lorenzo Consegni
This article extends Leonardo Salvatore's project using the Web Service Software Factory
7 Sep 2007
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
3 Apr 2006
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.
29 May 2008
Simple destination script to use do updates with a sub query.
15 Jul 2007
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.
15 Jul 2007
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.
15 Oct 2006
Malpani Amol
This article will drive you, how deploy and debug CLR store procedure
8 Oct 2006
Malpani Amol
Here is some cool stuff to call .NET assembly from SSIS
8 Oct 2006
Malpani Amol
This article will drive you, how to access and update properties and variable of SSIS package using .NET application
27 Mar 2016
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.
7 Aug 2012
This tip demonstrates how table data can be shared in two stored procedures.
4 Jul 2007
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.
15 Feb 2007
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
10 Sep 2004
Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
12 Jan 2007
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.
4 Mar 2007
Mark J. Miller
Understanding how the SQL Server and CLR security models work together to keep your database secure
3 Oct 2016
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.
17 Nov 2006
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.
6 Oct 2006
Master DJon
How to find if only one particular column has been modified in a trigger.
24 Mar 2009
Matt Bowman
How to change the angle of the first slice of a Pie chart in SSRS 2005.
17 Jul 2007
Matt Perdeck
Shows how to add a Crystal Reports report to an ASP.NET page, with grouping, filtering, and drill down.
25 Mar 2008
Matt Sollars
Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.
18 Sep 2007
An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding
18 Sep 2007
An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding
7 Nov 2009
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.
27 Nov 2009
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.