Click here to Skip to main content
14,878,480 members
Everything / Database Development / SQL Server / SQL Server 2000

SQL Server 2000

SQL-server-2000

Great Reads

by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
by Md. Marufuzzaman
How easy to read a file without using of the seven extended stored procedures.
by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.

Latest Articles

by Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
by BharatRamV
Finds the Best Table for a given set of columns
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.
by GhostHost
Automatic creation of non clustered indexes using system SQL entities

All Articles

Sort by Score

SQL Server 2000 

Please Sign up or sign in to vote.
6 Sep 2007
aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
Please Sign up or sign in to vote.
9 Mar 2005
Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
Please Sign up or sign in to vote.
4 May 2004
Daniel Aioanei, Adi Malinaru, Andrei Postolache
An article on how to persist permutations of items in relational databases.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
20 Apr 2009
András Slyuch
This class collects data rows in the memory and saves them into a Microsoft SQL database with SqlBulkCopy.
Please Sign up or sign in to vote.
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
Please Sign up or sign in to vote.
1 May 2012
Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
Please Sign up or sign in to vote.
7 Aug 2012
ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
Please Sign up or sign in to vote.
24 Jun 2009
Kuldip Rindani
Monitoring group of Linked SQL Servers from a SQL Server
Please Sign up or sign in to vote.
15 Oct 2007
Tijoy Tom
Deadlock analysis in SQL Server 2000.
Please Sign up or sign in to vote.
17 Dec 2007
mfmaneef
Explains how to send bulk records to a database using OPENXML.
Please Sign up or sign in to vote.
29 Apr 2009
Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
24 Jun 2004
Redgate Software
A simple solution to scripting when sysdepends are damaged
2 May 2006
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.
30 Jun 2006
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.
1 Nov 2006
Redgate Software
This article describes how you can use SQL Refactor to sharpen up your T-SQL.
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.
21 Dec 2006
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
Please Sign up or sign in to vote.
28 Apr 2005
emadns
How to start a connection using ATL OLE DB consumer classes and how to obtain a session so that you can use it to query or edit the database.
Please Sign up or sign in to vote.
11 Jul 2005
Chester Ragel
A tool which can be used to do common tasks which Microsoft Content Management Server API provides.
Please Sign up or sign in to vote.
22 Aug 2009
Md. Marufuzzaman
This article will give you an idea about how to integrate an OLE Object that is a COM+ API with SQL Server and write a message into a Windows event log.
Please Sign up or sign in to vote.
16 Aug 2005
Omar Al Zabir
Comprehensive guide to development of .NET 2.0 Smart Clients working with existing Service Oriented Architecture based XML web services, fully utilizing the Enterprise Library
Please Sign up or sign in to vote.
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
Please Sign up or sign in to vote.
11 Jun 2008
Billy McCafferty
This article describes best practices for leveraging the benefits of NHibernate 1.2, ASP.NET, generics and unit testing together.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
Please Sign up or sign in to vote.
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!
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
Please Sign up or sign in to vote.
26 Jun 2008
johnnycantcode
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
Please Sign up or sign in to vote.
28 Apr 2005
Thomas Kurek
Unsatisfied with the accuracy of code online that assumes the Earth is a sphere, I have implemented the oblate spheroid model used in GPS.
Please Sign up or sign in to vote.
30 Nov 2006
siva pinnaka
This article explains how to migrate data between different SQL Server environments.
Please Sign up or sign in to vote.
13 Jan 2013
liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
Please Sign up or sign in to vote.
7 Aug 2006
craigd
Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.
Please Sign up or sign in to vote.
22 Aug 2004
Shams Mukhtar
This article will enhance your vision on the usage of Robustness Analysis in conjunction with Model View Controller, using UML with application in ASP.NET. This article is a sequel to my articles on Architecture and Design with ASP.NET.
Please Sign up or sign in to vote.
20 May 2010
Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
Please Sign up or sign in to vote.
13 Jul 2010
Md. Marufuzzaman
Overview of SQL server stored procedure
Please Sign up or sign in to vote.
15 Jun 2009
Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
Please Sign up or sign in to vote.
4 Jan 2005
DGoins
This article explains a brief introduction to SOA and a Subscriber-Publisher model, along with how to implement one using WSE SOAP Receiver and WSE SOAP Sender classes inside a Windows .NET application.
Please Sign up or sign in to vote.
5 Aug 2004
Jasmin Muharemovic
An article about optimization and performance testing of MS SQL Server 2000 stored procedures used for paging of large resultsets in ASP.NET
Please Sign up or sign in to vote.
9 Dec 2010
AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
Please Sign up or sign in to vote.
23 Sep 2015
Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
Please Sign up or sign in to vote.
24 Feb 2017
Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
Please Sign up or sign in to vote.
6 Apr 2005
Stefan Prodan
Deploy MS SQL Server databases using System.Configuration.Install and a VS.NET Setup Project.
Please Sign up or sign in to vote.
26 Jan 2010
BackyardHackMechanic
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
Please Sign up or sign in to vote.
16 Jan 2005
Sumit Amar .
1 alternative  
Stored procedure to generate INSERT..VALUES statements in SQL Server.
Please Sign up or sign in to vote.
23 Aug 2010
Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
Please Sign up or sign in to vote.
15 Apr 2006
Raj Lal
A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.
Please Sign up or sign in to vote.
7 Sep 2009
Muhammad Akhtar Shiekh
An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.
Please Sign up or sign in to vote.
5 Jun 2005
smiling4ever
To make a dictionary that will work with Google Suggest like Dictionary.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
13 Sep 2009
Md. Marufuzzaman
A simple example of SQL server admin tools.
Please Sign up or sign in to vote.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
Please Sign up or sign in to vote.
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
Please Sign up or sign in to vote.
18 Apr 2005
earmitage
An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on SQLDMO. Based on the C++ article by Santosh Rao.
Please Sign up or sign in to vote.
14 May 2012
Shivprasad koirala
An introduction to stack, heap, value types, reference types, boxing, and unboxing.
Please Sign up or sign in to vote.
28 Mar 2013
Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
Please Sign up or sign in to vote.
27 Sep 2005
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.
Please Sign up or sign in to vote.
10 Sep 2004
mysorian
A step-by-step approach to creating a report from scratch using the SQl Server 2000 Reporting Services.
Please Sign up or sign in to vote.
29 Jan 2009
Nitesh Maharaj
1 alternative  
How to create simple and advanced pivot tables in C# and ASP.NET
Please Sign up or sign in to vote.
3 Jun 2006
Shabdar Ghata
Restore/backup selected objects in SQL Server.
Please Sign up or sign in to vote.
4 Sep 2013
Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
Please Sign up or sign in to vote.
11 Jan 2008
Rafik Robeal
Build occasionally connected applications using Microsoft Synchronization Services for ADO.NET
Please Sign up or sign in to vote.
8 Jul 2004
Simon Steed (SimonAntony)
This article explains how using caching within your Windows Forms application can speed up data access for frequently used data and avoid performance bottlenecks over the network.
Please Sign up or sign in to vote.
3 Mar 2008
Alex Baker
Change collation order for all text columns in a database
Please Sign up or sign in to vote.
4 Jun 2010
Syeda Anila Nusrat
Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.
Please Sign up or sign in to vote.
3 Sep 2008
pinaldave
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
Please Sign up or sign in to vote.
16 Mar 2005
Dan Farino
An Extended Stored Procedure to use regular expressions in T-SQL.
Please Sign up or sign in to vote.
2 Nov 2015
icemanind
Easily create Business and Data Layers!
Please Sign up or sign in to vote.
14 Nov 2004
Lars-Inge Tønnessen
An article on how to setup and configure the MSFT MSDE 2000.
Please Sign up or sign in to vote.
26 Dec 2004
Gavi Narra
An implementation of Google suggest using remote scripting.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
5 Jul 2009
Shivprasad koirala
Optimizing LINQ Queries using DataLoadOptions
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
Please Sign up or sign in to vote.
9 May 2007
Peter Weissbrod
This is the second part in a two-piece article focused on optimizing the efficiency of your NHibernate ORM layer.
Please Sign up or sign in to vote.
7 Mar 2008
Alexander Kojevnikov
sqlTunes is a small tool that exports iTunes library information to the SQL server.
Please Sign up or sign in to vote.
20 Apr 2008
gan.gary
An article on a SQL IDE for different type of RDBMS databases
Please Sign up or sign in to vote.
22 Dec 2009
Suresh Suthar
How to execute DTS packages through VB.NET and use global variables.
Please Sign up or sign in to vote.
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
Please Sign up or sign in to vote.
29 Jun 2011
michael.neubrander
Multi account synchronizer for GMail, AD, and SQL Server.
Please Sign up or sign in to vote.
4 Nov 2006
Uwe Keim
An application to manage support request with tickets and events
Please Sign up or sign in to vote.
5 Apr 2016
SQLMonger
SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.
Please Sign up or sign in to vote.
11 Jan 2012
Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
Please Sign up or sign in to vote.
7 Sep 2006
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.
Please Sign up or sign in to vote.
31 Jul 2005
_Asif_
Article that helps writing SQL in XML to provide better support
Please Sign up or sign in to vote.
26 Apr 2008
Sudipta Chaudhari
This article gives a brief introduction about Triggers in SQL Server 2000/2005.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
Please Sign up or sign in to vote.
4 Apr 2006
Salvatore Vetro
The art of swap from a database to another changing a flag
Please Sign up or sign in to vote.
9 Jan 2005
Kim Sheffield
The RDL Project is an open source (GPL) implementation of the RDL for the .NET environment created by fyiReporting Software. RDL is an XML based language created by Microsoft with the goal of promoting interoperability of reporting products. Project RDL is a compact implementation of RDL.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
1 Jun 2009
Dwayne Macadangdang
An article on creating a Hybrid Smart Client for Twitter using the Windows Presentation Foundation and the TwitterLib class library
Please Sign up or sign in to vote.
15 Aug 2004
Elvin Cheng
Solve the ViewState problems using the industry well-known pattern - Provider Model design pattern.
Please Sign up or sign in to vote.
17 Oct 2009
Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
Please Sign up or sign in to vote.
10 Oct 2005
Michael.Piccolo
How to add DataGrid columns dynamically with ITemplate, XML and templated controls.
Please Sign up or sign in to vote.
17 Aug 2009
P. Ganesh Kumar
Helps in assigning row numbers in the returned result of an SQL query
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
16 Aug 2010
Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
Please Sign up or sign in to vote.
23 Oct 2005
Phorozan
When you create a backup, you must be able to restore this backup into the same database and same location. But this code also helps you to restore a backup into a new database or existing database.
Please Sign up or sign in to vote.
5 Jan 2005
Teo Lachev
Introducing Microsoft Reporting Services.
Please Sign up or sign in to vote.
22 Nov 2004
Dave Handley
A library of template classes that enables the rapid production of client-side database code.
Please Sign up or sign in to vote.
1 Jul 2003
Saumendra Poddar
SQL Server Transactions and Error Handling
Please Sign up or sign in to vote.
24 Nov 2005
James Curran
An article on locating MS SQL Server instances on the local network, and retrieving information about them.
Please Sign up or sign in to vote.
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
Please Sign up or sign in to vote.
16 May 2013
Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
21 Feb 2005
Alon_Catz
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
Please Sign up or sign in to vote.
13 Feb 2007
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.
Please Sign up or sign in to vote.
18 May 2008
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.
Please Sign up or sign in to vote.
18 Apr 2005
Uri Lavi
A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).
Please Sign up or sign in to vote.
17 Mar 2008
Shabdar Ghata
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
Please Sign up or sign in to vote.
5 Jan 2013
Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
Please Sign up or sign in to vote.
28 Oct 2004
Alexandru Ghiondea
Describes how to upload and download pictures to and from a SQL Server database.
Please Sign up or sign in to vote.
11 Dec 2007
Danilo Mendez
Describes how to generate NHibernate objects and ASPX pages using Smart Code
Please Sign up or sign in to vote.
15 Apr 2008
Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
Please Sign up or sign in to vote.
6 Jul 2007
Nguyen-Thanh-Tung
Use SOAP to communicate with a remote DB Server (Here I use SQL Server) on the Internet and get information or interact with the database
Please Sign up or sign in to vote.
3 Jul 2007
Steve Abraham
This article is an introduction to the SQL Server Virtual Device Interface and how to access it via any .NET language
Please Sign up or sign in to vote.
22 Dec 2008
Neeraj Kr
Provides an insight into creating automated process for Backups and Restorations
Please Sign up or sign in to vote.
10 Feb 2009
ozkary
A VBScript script which allows to script out all the SQL Server objects in each independent file
Please Sign up or sign in to vote.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
Please Sign up or sign in to vote.
2 Oct 2008
Andrew J Dixon
Explaining Database deadlocking to non-technical people
Please Sign up or sign in to vote.
7 Jun 2007
hoquet
A utility program that allows you to enter SQL to select data from Oracle, the program will then create a table in SQL Server and copy the data using SQLBulkCopy.
Please Sign up or sign in to vote.
13 May 2005
Anand Santhanam
In this article, I would like to demonstrate how we can leverage the SQL Reporting Services feature on to a Microsoft Access database, using the Visual Studio .NET as IDE.
Please Sign up or sign in to vote.
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
Please Sign up or sign in to vote.
9 Nov 2006
Howard Richards
Techniques for using the XML data type for storing data.
Please Sign up or sign in to vote.
12 Jun 2005
Andrey Shchurov
With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.
Please Sign up or sign in to vote.
16 Oct 2006
Sean Goodpasture
An article describing a way to find the differences between two database instances
Please Sign up or sign in to vote.
27 Jan 2006
Bahrudin Hrnjica
Putting and retrieving images files to and from a database, via ADO.
Please Sign up or sign in to vote.
11 Mar 2007
Mohammad Akbarizadegan
This article demonstrates how to implement web applications based on AJAX and ClientScriptCallBack as it presents a simple example. Also, the article tries to point at the key features of working with ASP.NET ClientCallback and AJAX.
Please Sign up or sign in to vote.
17 Jul 2007
Matt Perdeck
Shows how to add a Crystal Reports report to an ASP.NET page, with grouping, filtering, and drill down.
Please Sign up or sign in to vote.
5 Sep 2004
Jose A. Gonzalvo
A small command prompt utility to help you document your SQL Server/MSDE database
Please Sign up or sign in to vote.
14 Sep 2008
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.
Please Sign up or sign in to vote.
30 Jul 2005
Klaus Salchner (Canada)
Indexing Server, SQL Server, Windows SharePoint Services, SharePoint Portal Server, Exchange Server and Windows Desktop Search provide full-text search capabilities. Each utilizes the so called IFilter components to index the content and then allows clients to search the index.
Please Sign up or sign in to vote.
13 Feb 2006
IPC2000
A handy command line tool that checks whether stored procedures, views and functions in a database compile
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
15 Oct 2007
Thanh Huu Nguyen (Tony)
Look up a huge list of stock symbols from MS SQL database
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
23 Jan 2008
Muigai Mwaura
LINQ to SQL Transformation: Open Source implementation of IQueryable, examples and source code
Please Sign up or sign in to vote.
15 Feb 2007
Ben Allfree
Learn how to store data with a version history.
Please Sign up or sign in to vote.
7 Aug 2009
Md. Marufuzzaman
Overview of SQL Server database Triggers
Please Sign up or sign in to vote.
2 Oct 2004
Alberto Venditti
A proposed class to simulate the ADODB.Recordset behavior in .NET.
Please Sign up or sign in to vote.
20 Feb 2006
PaulMcKenzie
This stored procedure will generate all the C# code for calling any Stored Procedure
Please Sign up or sign in to vote.
23 Sep 2005
Mike Ellison
An approach to creating an aggregate report with a set of dynamic columns based on dates.
Please Sign up or sign in to vote.
21 Jan 2008
Sajid.Majeed
This article will address tools and technologies to identify bottlenecks and key consideration points for performance improvement.
Please Sign up or sign in to vote.
4 Oct 2009
Shaun Wilde
Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.
Please Sign up or sign in to vote.
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
Please Sign up or sign in to vote.
19 Sep 2013
Shivprasad koirala
Software Architecture interview questions (Service Oriented Architecture interview questions: Part 1).
Please Sign up or sign in to vote.
3 Mar 2006
Declan Brennan
Extending the RichTextBox to support form persistance and data binding.
Please Sign up or sign in to vote.
8 Nov 2007
John-ph
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
Please Sign up or sign in to vote.
11 Jun 2008
Jimmy Zhang
Introduces a simple, efficient, human-readable XML index called VTD+XML.
Please Sign up or sign in to vote.
16 Mar 2009
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.
Please Sign up or sign in to vote.
10 Jun 2007
Peter Weissbrod
A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues
Please Sign up or sign in to vote.
22 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
Please Sign up or sign in to vote.
4 May 2009
Shivprasad koirala
4 steps to create free SSL certificate for development
Please Sign up or sign in to vote.
1 Dec 2005
Shahed.Khan, David.Grinberg
This paper demonstrates creating a flexible, extensible, plug-in-based .NET application (JOM - Smart Job Manager). JOM is an asynchronous job processing engine built using the MS Provider design pattern and the .NET technology available today.
Please Sign up or sign in to vote.
11 Oct 2004
Rajesh Pillai
This project is meant to provide a tool similar to query analyzer which can be used to execute queries, create tables, and do all other common database activities.
Please Sign up or sign in to vote.
21 Oct 2005
perlmunger
This article describes the DotNetNuke Module Packager application and source code. The application enables the user to generate DotNetNuke private assemblies that are useable out of the box from a custom module defined in the programmer's development environment.
Please Sign up or sign in to vote.
10 Sep 2004
Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
Please Sign up or sign in to vote.
5 Apr 2006
Dwight Johnson
Save hours of time by creating stored procedures and code from database metadata.
Please Sign up or sign in to vote.
20 Jul 2007
Johan Sassner
An addin to Sql Server Management studio that lets you configure keybindings
Please Sign up or sign in to vote.
3 May 2005
Stephen Huen
Review of MCMS Connector for SharePoint Technologies.
Please Sign up or sign in to vote.
10 Dec 2007
Le Sourcier
How to use LINQ to SQL
Please Sign up or sign in to vote.
16 Jul 2005
TylerBrinks
Geo-Locating C# Smart Client Application using the 2.0 Framework
Please Sign up or sign in to vote.
23 Nov 2007
adambl
Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors
Please Sign up or sign in to vote.
19 Aug 2009
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.
Please Sign up or sign in to vote.
28 Nov 2005
Pedro J. Molina
This article provides a way for automatically testing SQL embedded in your Data Access Layer (DAL) before publishing a new release of your application.
Please Sign up or sign in to vote.
28 Jun 2008
Simon Gulliver
A lighweight approach to creating AJAX.NET-enabled grids, with advanced functionality built in.
Please Sign up or sign in to vote.
11 Oct 2011
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.
Please Sign up or sign in to vote.
27 May 2016
icemanind
How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database
Please Sign up or sign in to vote.
12 Jun 2007
Psycho-*Coder*-Extreme
This article covers pitfalls found while doing a merge replication in SQL 2000
Please Sign up or sign in to vote.
20 Sep 2005
Brian Perrin
Eliminate the pain of calling SQL stored procedures from C#.
Please Sign up or sign in to vote.
9 Dec 2005
Todd Denlinger
Presents a method for monitoring the amount of time database connections stay open in ASP.NET applications.
Please Sign up or sign in to vote.
23 Jul 2007
Benedict Chan
Using .NET 2.0 to get the SQL Server schema and generate insertion statements.
Please Sign up or sign in to vote.
30 Jun 2009
mohamad halabi
Shows how to build new-design distributed applications with WF 4.0 and Data Services.
Please Sign up or sign in to vote.
15 Nov 2007
Marcelo Ricardo de Oliveira
This article shows how you can mix together Model-View-Presenter, Domain Model, Services, ActiveRecord, and Repository patterns to create a testable application.
Please Sign up or sign in to vote.
13 Oct 2006
Ewout Stortenbeker
This tool (ScriptDB4Svn) enables you to add your SQL Server databases to Subversion (SVN) source control.
Please Sign up or sign in to vote.
27 Sep 2005
Weidong Shen
Adding secure communications to the Microsoft IssueVision sample application using WSE 2.0.
Please Sign up or sign in to vote.
9 Apr 2005
theoutlander
An overview on inheriting a ListView and implementing design-time data binding capability.
Please Sign up or sign in to vote.
8 Jan 2006
Michael Erasmus
This article is on a tool I wrote to generate executable osql deployment batch scripts.
Please Sign up or sign in to vote.
28 Nov 2005
Mukund Pujari
This article shows how to distribute or install MSDE with a .NET application.
Please Sign up or sign in to vote.
3 May 2007
Pete O'Hanlon
These articles are on prioritizing and improving query performance in SQL Server.
Please Sign up or sign in to vote.
29 Feb 2008
Evaldas Jocys
How to create and compile SQL XML Documentation comments
Please Sign up or sign in to vote.
23 May 2005
Ameen AboDabash
Vertical/horizontal Marquee Web Custom Control consuming SQL Server DB/XML, with great design time attributes.
Please Sign up or sign in to vote.
24 Jan 2006
Evoluteur
Just 200 lines of VB.NET to document your SQL Server databases.
Please Sign up or sign in to vote.
26 Feb 2014
Shivprasad koirala
7 simple steps to run your first Azure Blob Program
Please Sign up or sign in to vote.
20 Oct 2005
codeajay
A simplified SQL-CSV import/export functionality.
Please Sign up or sign in to vote.
27 Mar 2007
Sujith C Jose
Describes how to use a simple stored procedure in Visual Basic 6.0
Please Sign up or sign in to vote.
15 Jun 2007
azamsharp
Implementing an auto-completion feature using ASP.NET 2.0 client callbacks
Please Sign up or sign in to vote.
14 Mar 2014
Christian Graus
In this installment, I talk about working with dates and date functions in SQL Server
Please Sign up or sign in to vote.
20 Jun 2007
RepliCrux
This utility creates basic Select, Insert, Update and Delete Stored procedure for the selected Tables.
Please Sign up or sign in to vote.
1 Jun 2005
Alexander Shirshov
Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.
Please Sign up or sign in to vote.
10 Mar 2005
Todd Davis
An installation program for the popular DotNetNuke ASP.NET portal.
Please Sign up or sign in to vote.
29 Sep 2007
DejaVudew
An article discussing how to accomplish paging and sorting in Microsoft SQL Server 2000 without using concatenated SQL.
Please Sign up or sign in to vote.
24 Feb 2005
vivekthangaswamy
How to upload files to Web pages in ASP.NET? How to read an image from a database using ADO.NET and display it in a Web page?
Please Sign up or sign in to vote.
19 Sep 2004
Sriram Chitturi
Tool to generate script for Linked Servers in SQL Server 2000, using C# and SQLDMO.
Please Sign up or sign in to vote.
14 Sep 2006
salysle
This article describes an easy approach to examining all of the tables, views, and columns in a database.
Please Sign up or sign in to vote.
2 Jul 2004
TomKat
Simple ODBC Wrapper + Connection classes for several database types.
Please Sign up or sign in to vote.
8 Jul 2004
Simon Segal
An MVC meets FuseBox Hybrid pattern for .NET, implmented in C# with the the Northwind database.
Please Sign up or sign in to vote.
6 Apr 2005
goodtime68
Cyber café software to keep track of buisness.
Please Sign up or sign in to vote.
26 Apr 2006
Emad Al-Ashi
An easy graphical way to create complex nested SQL Join queries.
Please Sign up or sign in to vote.
26 Feb 2009
Lindsey Lewis
An article about a tool for comparing SQL database schema versions
Please Sign up or sign in to vote.
5 Oct 2005
Zeeshan Muhammad
Introduction to themes and skins in ASP.NET 2.0.
Please Sign up or sign in to vote.
14 Oct 2002
Mehdi Mousavi
Discusses the SQL's SELECT statement in details.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
16 Dec 2004
D J Nagendra
Merge replication step by step procedure for SQL Server 2000.
Please Sign up or sign in to vote.
9 Oct 2007
John-ph
This article explains about building and executing a Dynamic SQL in a stored procedure.
Please Sign up or sign in to vote.
15 Oct 2004
David Salter
Writing extended stored procedures in C++ for SQL Server.
Please Sign up or sign in to vote.
20 Jun 2008
JustChiragPatel
No need to create web service for SSIS package call
Please Sign up or sign in to vote.
18 Feb 2005
rasheed1979
This article demonstrates administrating SQL Server 2000 from Pocket PC on the fly.
Please Sign up or sign in to vote.
17 May 2006
Stephen Huen
Provides a start page for search engines to crawl a Content Management Server (MCMS) web site.
Please Sign up or sign in to vote.
23 Aug 2008
Muhammad Shujaat Siddiqi
Defining SQL Server Alerts (shujaatsiddiqi.blogspot.com)
Please Sign up or sign in to vote.
19 May 2012
ilorgat
This is an alternative for "Generating INSERT statements in SQL Server"
Please Sign up or sign in to vote.
18 Jun 2006
gtamir
Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005
Please Sign up or sign in to vote.
10 Mar 2005
Wytek Szymanski
An article about template based code generation and a demonstration of how to quickly generate a wrapper class for stored procedures.
Please Sign up or sign in to vote.
8 Dec 2007
Hamidreza-Ghasemkhah
Automatically generates the required class and stored procedure to work with SQL databases