Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / DBA

DBA

DBA

Great Reads

by Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
by Chai_Pot
How to use MySQL as database in VB.NET applications.
by Igor Krupitsky
A script that lets you run many XMLA files against a SSAS 2005 database.

Latest Articles

by Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
by Chai_Pot
How to use MySQL as database in VB.NET applications.
by Igor Krupitsky
A script that lets you run many XMLA files against a SSAS 2005 database.

All Articles

Sort by Score

DBA 

by Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
by Igor Krupitsky
A script that lets you run many XMLA files against a SSAS 2005 database.
by Rabeeh Abla
Design patterns are recurring sequences, built-in .NET patterns are scattered over the framework.
by Refky Wahib
Database library for rapid development.
by Trenton Moss
Web developers often make the same errors as each other when implementing accessibility - find out what these are and how to avoid making these mistakes.
by Liam Cavanagh
The purpose of this article is to help get a user started in building a mobile database application using SQL Anywhere and Visual Studio .NET (C#)
by Liam Cavanagh
The purpose of this article is to help get a user started in building a mobile database application using Visual Studio .NET (C#).
by Keshav Singh
This demo session demonstrates a little POC as to how can you make your SSIS talk to you.
by Shivprasad koirala
This article will discuss about 11 important database designing rules.
by Omar Al Zabir
Learn about 13 production disasters that can bring down your business
by Tomasz Naumowicz
Take a closer look at scenarios where working with GUID and UUID in a MongoDB environment becomes tricky. We will make you aware of those configurations and provide a set of best practices to follow.
by dingoishere
This article introduces you to 3 kinds of comparison and synchronization for SQL Server Database.
by Petr Palas
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.
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).
by Nairooz Nilafdeen
A .NET implementation for the Knuth-Moris-Pratt (KMP) algorithm.
by Chris Stefano
Generate loader classes for faster operation using Reflection.Emit
by Kunal Chowdhury «IN»
This is a brief discussion on the top features of Visual Studio 2010.
by Abhijit Jana
This article describes how to use RAISERROR in SQL Server 2005
by Dr. Song Li
This is part 2 of a comparison on Data Access methods in the .NET environment.
by Dr. Song Li
This is the part 1 of a comparison on Data Access methods in the .NET environment.
by Gurdeep Singh Toor
A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.
by zhengdong jin
It's very easy to use and the most conventient DataGrid pager control.
by andrewcates
In an attempt to open DotNetNuke to a wider audience, I have converted the original VB code into C#
by adargel
This article shows how to construct a custom business object helper that will populate business objects from a datareader using generics, reflection, and custom attributes
by Chapooki
An article on implementing a customized business transaction class based on LLBLGen Pro.
by Nanaa
An approach on how to organize your data into tables that will help you generate large ‘Crosstab’ Reports using SQL Server.
by xicoloko
Persistance to business objects through attributes and reflection
by xicoloko
Persistance to business objects through attributes and reflection
by xicoloko
Persistance to business objects through attributes and reflection
by Satnam B Singh
Setting up Transactional Replications in SQL Server 2005.
by jebarson
New features of Visual Studio 2010 discussed
by Kemal Erdogan
An implementation of role-based authorization control (RBAC) model with row-level access control capabilities at the database server level
by Sebastien Lorion
A reader that provides fast, non-cached, forward-only access to CSV data.
by Mike Gledhill
How to easily add an "export to Excel" feature to your app
by RichardEastes
Realtime page editing, simple, "on-the-fly" menu construction, modifiable permissions for users and groups, built-in search engine optimisation
by Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
by poodull76
Create T-SQL command text to update a table with OpenXML quickly and with minimal effort.
by Henri G Demers
Generating a delegate at runtime that reads from a DataReader. By reflection, it’s possible to bind directly a simple query to a list of objects.
by V. Thieme
Frequencies, descriptive statistics and normality testing
by santosh poojari
This article shows you how to make use of DataAccessLayer and caching.
by msalmank
A quick hands-on application to guide you in using paneled forms, multi-splash screens, SQL Express, and many more....
by MeraMBA.com
Purely object oriented ADO code component to get your project running, no matter what database you are using at the backend. Specialised for SQL Server.
by Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
by lost in transition
This article illustrates a helpful database library.
by Sacha Barber
A journey into Expressions
by graham the programmmer
A method to get an overview of the SQL servers in a Domain
by santosh poojari
This article will provide the first step towards migrating error free dtsx package to higher version of sql server ssis
by Kemal Erdogan
Addressing the general problem of representing directed acyclic graphs (DAGs) in SQL databases
by matrix_resident
Modification to the nettiers code generator template to make the generated stored procedure for search more powerful(supports the like operator of Transact-sql) and searching the datetime/smalldatetime datatyped columns more smartly
by Robert Pittenger, MCPD-EAD
This article presents a naming scheme for database tables and fields.
by mikvos
A list of news articles in an ASP.NET GridView control with custom paging.
by gamitech
A not so simple firewall if I can call it so. This application will ask you if you want a certain program to start.
by Andrew Rissing
GenericParser is a C# implementation of a parser for delimited and fixed width format files.
by Nirosh
This article gives an introduction to system designing and architecture. It introduces a new concept that allows beginners to easily break and design complex software systems. It uses a modular based development approach with a pattern that we all practice in our day to day life.
by Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
by Jörgen Andersson
A propertymapping extension for DataReaders
by Naveen Karamchetti
This article describes the new functoids in BizTalk Server 2006.
by UV2003
This article will describe how to hook up RoboHelp projects to a database to provide data to pages for both WebHelp and Compiled Help using a single architecture. The implementation will rely on the JavaScript interpreter built into almost all web browsers and that is available in Compiled Help too.
by Alberto Venditti
An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs
by Jonathan de Halleux
A helper framework for generation of SQL queries in C++ and Lua
by Carlos Antollini
Simple database access using an ADO class.
by Carlos Antollini
Simple database catalog access using a set of ADOX classes
by Joffrey Brouillet
This is an alternative for "A set of ADO classes - version 2.20"
by Carlos Antollini
Two classes that make easy to work with ODBC
by Sriram Chitturi
This article gives a simple architecture of using StreamReaders and DataSets together to read data from arbitrarily formatted flat files into DataSets, using ini files as an example
by Andy Edinborough
Learn how to create classes that automatically save and retrieve their data (), and how to quickly query that data with LINQ. The sample implementation of my class Saveable shows just how easy it is to create a blog.
by Paul S Ganney
A class to easily do count() queries.
by Uri Lavi
A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).
by Md. Marufuzzaman
A simple example of SQL server admin tools.
by RajuBhupathi
A Simple Geo fencing using polygon method
by Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
by Stephan Pilz
A tool to generate/manage news and provide news via RSS.
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.
by Alberto Venditti
This article describes a VB.NET tool to test the performances of a Microsoft SQL Server 2000 user database.
by codeajay
A simplified SQL-CSV import/export functionality.
by Patrice Borne
This article demonstrates how to implement a paging DataGrid with an Oracle database. It also demonstrates how to limit the volume of data to exchange between the Web Server and the browser by retrieving only the rows necessary and updating changes in bulk.
by gan.gary
An article on a SQL IDE for different type of RDBMS databases
by Daniel Cohen Gindi
Implementing server/client architecture for the great SQLite!
by Keshav Singh
This video demonstrates a standard extract-transform-load in SSIS
by steinard
An implementation that wraps DateTime to allow for keeping track of TimeZone state
by Dimitris Iliopoulos
The article demonstrates a tool for editing tables with two fields
by Lindsey Lewis
An article about a tool for comparing SQL database schema versions
by RB Starkey
How to create a tree-view control using an Access table and form.
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.
by code-frog
Provide a very simple set of instructions for creating your own media gallery and loading your images from SQL Server 2005.
by Bernardo Castilho
This article describes the implementation of a QueryDesignerDialog class that allows users to create SQL queries based on a given OLEDB connection string.
by vipulparmar
Basic understanding of Pro*C
by Wendelius
Article describes basic information about transaction log behavior and truncation of the log.
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.
by Malpani Amol
Here is some cool stuff to call .NET assembly from SSIS
by Anthony Roach
This project presents an Access Database Editor written in C#
by mbruchet
MongoDB, everyone talks about it, here article guides you step in its integration with Microsoft.NET.
by fstrahberger
How to access Oracle without tnsnames.ora.
by Malpani Amol
This article will drive you, how to access and update properties and variable of SSIS package using .NET application
by fstrahberger
Access to Oracle without tnsnames.ora
by Android on Intel
The objective of this article is to show a method for accessing a REST based database backend from an Android* app using MongoDB* and Spring IO*.
by Dominick Marciano
When iPhone SMS messages are backed up to your computer using iTunes, the messages are stored in a SQLite database. This article will show the layout of this database file and how to access all saved message information.
by PIEBALDconsult
Describes adding public properties to a TableAdapter to access the CommandTimeouts of the private DataAdapter
by thomask
How to access a dBase file
by Matt Scarpino
Obtaining financial records from the Electronic Data Gathering, Analysis, and Retrieval (EDGAR) system
by CT CHANG
Add, edit, and delete records/table/database in MS SQL Server CE v1.0/v2.0.
by Wojtek Jeziorczak
How to send/receive MSMQ messages in SQL Server using CLR Integration
by Ennis Ray Lynch, Jr.
Methods for accessing row based data in C# (.NET)
by Steve Abraham
This article is an introduction to the SQL Server Virtual Device Interface and how to access it via any .NET language
by Snorri Kristjansson
A SQL server CLR Stored Procedure that can query the Active Directory directly in T-SQL code
by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
by xiaojin
The article explains adding a user in SQL Server programmatically, using VC++
by Karthik Krishnaswami
This article describes how to add custom validation to a data column in ADO.NET.
by hector [.j.] rivas
Helping the combo box autocomplete function with a frequency count.
by arunpv
Add/drop Linked Servers using SQL Server 2005 SMO
by mdv113
Demonstrates: Accessing a SourceSafe database through program code, Filling and using treeview and listview, Using the backgroundworker for UI backgroundwork, Embed icon in application through imagelist
by Ali Ozgur
In this article, we will try to add AJAX support to a Cuyahoga website.
by Bangla Gopal Surya Prakash
How to add chart control to reports defined in SSRS
by Anton Ponomarev
By following steps outlined in this article, you will be able to get Report Viewer to generate reports in Microsoft Word formats (DOC, RTF, WordprocessingML, and OOXML) when working in the local mode.
by Anton Ponomarev
By following the steps outlined in this article, you will be able to get Report Viewer to generate reports in Microsoft Word formats (DOC, RTF, WordprocessingML, and OOXML) when working in the local mode.
by Anele 'Mashy' Mbanga
Provide functionality to Sign In and Sign Up to enable security for our NoteKeeper JQuery Mobile App.
by Himanshu_Jain
Address Book Grabber
by S.S. Ahmed
Create a component to administer SQL server remotely, create tasks that remove themselves from the scheduler after performing the assigned job.
by rasheed1979
This article demonstrates administrating SQL Server 2000 from Pocket PC on the fly.
by M. Shokuie Nia
A simple introduction to using ADO
by Carlos Antollini
A list of ODBC DSN Connection Strings.
by Ly Nguyen
ADO Data Bound Class Wizard
by Tim Kohler
ADO classes that closely resemble CDatabase and CRecordset.
by mysorian
A tutorial on connecting to SQL 2000 Server.
by mfmaneef
Explains how to send bulk records to a database using OPENXML.
by Johnny Worker
A VB code generator that reads a SQL Server table and generates ADO.NET code and also Stored Procedures.
by LockonFlamingCliffs
Shows the basics of working with ADO.NET disconnected data.
by Michael Ceranski
This generic function will allow you to copy data between any two ADO.NET providers with one simple method call
by Kevin Wittmer
101-level tutorial on ActiveX Data Objects
by MEmerson
This code replaces the buggy ADOMD.NET DataAdapter and DataReader.
by Mohan Raphel
In this chapter, we discuss a few of the options available to MCMS developers for adding search functionality to their sites. We also take an in-depth look at the searching features built into SharePoint Portal Server and how they can be leveraged as a back-end search workhorse for an MCMS site.
by Todd Wilder
Using the SQLNotificationRequest object and the Service Broker to get row and column change notifications, mimicking supposed SQLDependency capabilities
by Huisheng Chen
monitor sql server processes and jobs, analyse performance, object version control, view executing sql query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach etc
by Salman Jamali
This article discusses the paradigm shift in the way we model our information systems
by Bryan O'Connell, rcarlson-cayen, Cayen Systems
Information and observations from an Agile transformation at a small software company in Milwaukee, WI.
by Liam McLennan
The purpose of this article is to define a set of ideal practices for an agile software development project.
by Monjurul Habib
Introduction to Agile software development methodologies and how to apply them. It is about how to work together to achieve a common goal. This article focus on how technology team work together well to plan, build and deliver software.
by Alexander German
With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.
by Redgate Software
Using SQL Toolkit to remotely update customers' databases on the fly.
by Andrew Golik
This article demonstrates the use of the AJAX technique in tandem with the JavaScript DataGrid from my previous article.
by DreamInHex
Create an AJAX DataGrid that binds, sorts and pages with no post-backs
by LeleHalfon
A great AJAX Grid very customizable. In English & Spanish traduction
by Thanh Huu Nguyen (Tony)
Look up a huge list of stock symbols from MS SQL database
by Jay Kulaindevelu
To change the row colors in reports.
by hevesir
Alternative tnsping for Oracle Instant Client.
by Sreekanth Mothukuru
The idea is to implement the latest and first of its kind “Always Encrypted” feature provided by Microsoft SQL Server 2016 designed to encrypt/decrypt sensitive data on back-end database engine
by Matt Perdeck
Add a database to your web site on AWS with automatic fail over using RDS
by Redgate Software
Using a combination of iScala, SQL Server and Red Gate's software tools to manage data processes.
by Jochen Jonckheere
A view of how ADO.NET can be used in a multi-database, multi-tier environment.
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.
by salysle
This article describes an easy approach to examining all of the tables, views, and columns in a database.
by Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
by Daniel Cohen Gindi
I have created classes to wrap the SQLite3 library, to remove many headaches...
by Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
by Dr. Song Li
This article makes an experimental comparison on the performance of the different methods to pass structured data to SQL Server Stored Procedure parameters from ADO.NET.
by PowerAdmin
Top 5 reasons you want a server monitoring software solution
by Yunyou Yao
This article will explore some solutions for dynamic connection string and cursor handling using Enterprise Library 2.0 in an ASP.NET 2.0 applications with an Oracle database.
by Ferhat Nutku
An article on communicating with a database and generating SQL queries on the fly
by Handpeople
An article introducing Oracle's Berkeley XML Database and the command shell
by Jason R. Hall
This article will provide you with enough information to peak your interest in one of Microsoft’s newest services designed to run under SQL Server 2000, and to take advantage of the .NET initiative.
by Fact Pandit
ODBC Manager class that retrieves System and User DSNs and driver list.
by roboo
An OLE-DB DLL that you can use in ANSI-C
by Eunge
The component is designed to save the effort on developing file-required systems through its easy APIs and integration with ASP.NET web development, e.g. a product requires attachments and thumbnails in a product management system.
by Danilo Corallo
An Oracle query tool with syntax highlighting and a tabbed MDI interface.
by Abhijit Jana
Overview of Log Shipping in SQL Server 2005
by Lachlan Keown
Describes a crude method of executing an SQL statement against an in-memory DataSet and returning a new DataSet containing the result table(s).
by Marc Clifton
View and edit your XML database schema and data
by danielbromley
this is a quick simple bit of code in a project that can convert an XML file to a csv file
by Allister Beharry
Using data from the Global Historical Climatology Network project we can crunch, analyze, and make predictions using gigabytes of numeric climate data collected over two centuries with the SAP HANA in-memory database and Amazon SageMaker hosted Jupyter notebooks.
by tranthanhtu.vn
In this article, we will see how to use multi-languages(i18n) in angular2
by tranthanhtu.vn
In this article, we will why and why not using DI & IoC from my real situation.I did not tell you that DI is not good. From my view, each tech has it own pros and cons. So It is better if we know when we can use which techs for our business.
by tranthanhtu.vn
In this article, We will have a look to unserstand how RESTful/WebApi was applied in my code
by tranthanhtu.vn
In this article, We will learn why do we need to manage the stages of our application.
by tranthanhtu.vn
In this article, we will learn how to build and deploy the code
by tranthanhtu.vn
This tip explains how we should structure our project folder
by Jerod Johnson
Use the CData Software API Server to create an OData service for your databases and build a dynamic Web app based on the database data.
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.
by AnOldGreenHorn
A C++ wrapper to SQLite database
by Christopher W. Backen
Another simple yet cool ADO class for your project - from zCoders.com
by Praba Prakash
Apache Hadoop 2.3 for Big Data Analytics
by IronSpeed Inc.
Taking full advantage of the built-in infrastructure services of the Microsoft .NET Framework - without taking months to learn new languages, APIs and protocols - is one of the most pressing challenges faced by enterprise application developers today.
by siva pinnaka
This article explains how to migrate data between different SQL Server environments.
by Asif Sayed
An applied approach to get you started with MS Reporting Services using Smart Client host
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.
by Shams Mukhtar
This article will enhance your vision on the usage of Robustness Analysis in conjunction with Model View Controller, using UML with application in ASP.NET. This article is a sequel to my articles on Architecture and Design with ASP.NET.
by Serioja Sidorov
The focus is on how one can test the content of a database to see if it adheres to certain assumptions
by Wael R. Mansour
Convert numbers to characters for Arabic applications.
by Anton Pious Alfred
Most systems that use Stored Procedures make use of SQL parameters to send and receive information from the database. The code to create these SQL parameters and then populating them is repeated throughout the system. This article describes how to automate this code.
by mparvez
How to archive all backup (Full, Diff, Log) in a single archive file using 7zip.
by Pedro J. Molina
This article provides a way for automatically testing SQL embedded in your Data Access Layer (DAL) before publishing a new release of your application.
by Vadim Loboda
ADO.NET Micro-ORM to SQL Server
by Member 96
Convert delimited text files to XML file or DataSet object
by carlop()
An article about converting ASCII/Multibyte to Unicode using C# and SQL/CLR integration.
by Paladugu Sai Krishna
This article gives a simple checklist that can be simply run on any ASP .Net Web Page to optimize it.
by Jeff Modzel
How to create your own ASP.NET 2.0 custom resource provider to replace resource files (resx) with SQL Server.
by Addison-Wesley
This chapter presents a scenario-based demonstration focused on a day in the life of a developer who is in the process of fulfilling the requirements of a fictional customer.
by mysorian
Walkthrough of generating a report from a SQL 2000 Server using the Reporting Services.
by Ali Khan (OKC)
This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.
by Alberto Venditti
An alternative and flexible way to manage config settings for multiple web applications.
by Brian Hendrickson
How to setup and install the PHP issue tracker starter kit on a Linux server.
by Amimpat
This article explains approaches to determine if an HTTP request is coming from a mobile phone and then redirecting the request to a page optimized for a mobile browser.
by J.Jash
ASP.NET page partial rendering using the Response.Flush() method.
by Srinivasu Pemma
This is most common but very important part of every developer's life, Taken from my technical blog http://www.srinetinfo.com
by osohare
Porting and deploying the report starter kit to Linux (RH7.3/Tomcat5.0.28/Grasshoper1.61)
by Abi Bellamkonda
ASP.NET Reports Starter Kit Porting from Windows to Linux using Mainsoft's Grasshopper
by Harry Kimpel
A brief description on how to set-up MySQL as session state store for ASP.NET.
by Srinivasu Pemma
This kind of requirement is useful in many applications originally posted on http://www.srinetinfo.com/search/label/Survey%20Application
by Mark Cafazzo
Race To Linux - How to port a Visual Studio .NET web application to the J2EE Framework on Linux
by Abi Bellamkonda
ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper
by Amit K Bhagat
ASP.NET using GridView control as lookup
by Luke Foust
Creating ASP.NET wrappers for YUI Javascript controls
by Teo
Managing portability of your source code among different RDBMS, reducing developing time and maintenance.
by Leon Segal
Includes description of an asynchronous HTTP handler (vs. alternative WebHandler) implementations that uses an asynchronous DB read operation to render a BLOB DB column as an image to any client browser.
by Vachik Hovhannisyan
Two classes that provide support for asynchronous SQL execution.
by Babak Ansari
A custom asynchronous setup with progress indicator.
by Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
by João Paulo Figueira
Exploring SQL CE 2.0 schema information with the ATL OLE DB Consumer Templates.
by jangtimjang
Do you want to know what your DB programmers are doing?
by Petr Kozelek
Logging of data changes in relational databases
by Donsw
Discussion of audit trail implementation for the Postrgres database
by Cedric Baelemans
Discussion of audit trail techniques and a script to automate audit trail implementation on a Microsoft SQL database
by Sagar Sengupta
Implement audit trail technique using XML column in SQL Server 2005
by Keshav Singh
An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.
by Andi Kleinbichler
Illustrates the implementation of a .NET Core app, running in a Linux container, connecting to a SQL Server database with integrated security.
by Khademul Basher
Authentication and Authorization using Asp.net Identity
by acarpio1975
Given date ranged data, adjust existing ranges on entry of a new ranged data.
by Bassam Saoud
A Custom TreeView Control that supports auto binding from a single self referencing table
by Peter Huber SG
Saving a changed row in the DataGridView automatically to the database seems to be a basic task, but is challenging to implement. Read here why the most intuitive approaches fail and how to get it working.
by li@agileinfollc.com
An article on how to discover Oracle TNS service names.
by Mr. xieguigang 谢桂纲
You see, this small utility tool save much of your time, this is another happy day! I hope you can enjoyed this code.
by adamAFA46
Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.
by Hariprasanth S
A CLI to automate database backups with customizable recurring schedules
by JamesFaix
.NET library to access to any running instance of Excel.
by ashishinfra
The generalized class has static functions that return dataset and datareader objects , It accepts string(name of xml tag that stores the query) and value to be supplied in case query accepts parameters
by Sohel_Rana
This article describes how a site template can be uploaded and a new site can be created with the SharePoint Object Model.
by SoftWidgets
In just a few minutes, predefined templates, containing formatted sheets and charts, can be generated from any database using simple SQL statements, macros and/or custom C# or VB.NET snap-ins. Generated files can be distributed to a file server or as an email attachment. Usually, no coding is needed
by Nirosh
This will create a set of classes that generate a set of C# class files which map into the database tables. They will have the class name same as the table name and they will have a set of properties that are same as the table attributes.
by Kevin Hurwitz
The uploaded .NET solution includes the implementation of a database change management process that, if applied correctly, can dramatically reduce the time you spend synchronizing various versions of application databases in development, staging, and production environments.
by Asanka Perera
This process can be set up to run on a daily basis to make sure that reports which are interrelated does reconcile with each other, in order to make sure the consistency in report quality.
by David H. Smith
An event logging class, and an auto-logging LINQ DataContext descendant built around it.
by Mohammad Ali Azam
An API to persist business entities without writing database centric code or mapping schema in an external XML File
by Ferreri Gabriele (Megasoft78)
Automatic script SQL Server 2005 objects and commit under Subversion
by Mahsa Hassankashi
This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.
by Jeff Bramlett
Helper classes for automation of stored procedures
by Wilfried Mestdagh
When you resize a form you don't want to have a horizontal scrollbar on a DBGrid. This code snippet resizes all the columns in a grid in an intelligent way.
by Sangra
ASQLDataGrid is a useful component when working with RDBMS applications. It is capable of automatically constructing and executing SQL statements based on its properties.
by Sangra
ASQLDataGrid is a useful component when working with RDBMS applications. It is capable to automatically construct and execute SQL statements based on its properties.
by Vivek Shaurya
Handling Oracle Max Open cursor error when fetching multiple rows in .NET.
by Redgate Software
If you’re thinking about adopting database source control, or have a system but aren’t using it consistently yet, here are seven tips to avoid deployment disasters.
by Matías Quaranta
Azure Cosmos DB is Microsoft’s globally distributed multi-model database, when we team it up with Azure Functions, Azure’s serverless compute service, the result is the ideal database for the serverless era.
by Microsoft
This tutorial covers: Creating and connecting to an Azure Cosmos DB account, Configuring your Visual Studio Solution, Creating an online database, and more!
by Sacha Barber, Richard E King, Fredrik Bornander
This is true code, what you say
by Al-Farooque Shubho
An effort to derive a basic Exception Management design guideline for N-Tier ASP.NET applications
by funklet
Make backups of SQL databases and upload them to FTP server
by Yovav
Import, export and move your SQL diagram around using sysdiagrams
by Sujit Mandal
Backup System Databases in SQL Server
by Darren G441
An effective solution for backing up a schema worth of tables on a Window installation of PostgreSQL database
by David Catriel
A simple and straightforward tool to monitor and report SourceSafe database changes.
by Raymund Macaalay
The basic foundation on how to build your own Content Management System.
by Himanshu Kumar Sinha
Updating a huge table in Production , without locking the whole table .
by mbyamukama
In this article, I will show you how to interface your simple C# applications to the FirebirdSQL Server using the Firebird ADO.NET Client 2.5.
by Matt Newman
A beginners guide to accessing a SQL or MSDE Server with C#
by Ziyad Mohammad
This article explains the best strategy to be followed while designing data storage applications by System Architects
by Kirpa Khemani
This article describes the best practices to be followed by technical writers while developing help systems.
by Levente Kupás
Managing SQL backups can be more simple by using this FileRelay CLR
by Anandhi Swamy
Handles uploading /downloading images into/from database to DataGrid
by Mihail Stefanov
Binding a two dimensional array to a DataGrid
by Ganesan Sankaran
How to populate a dropdown in another dropdown change
by Christopher Barlow
Library to manage and cache key/code tables typical in transactional sites. It provides a means to easily bind user-friendly descriptions in your presentation not only in lists like DropDownLists, but also to read-only keys in a detail table without using extensive JOINs.
by Marc Clifton
An investigation into different data entry modalities and the need for a transaction sandbox.
by pfeds
An overview of the concepts involved in bitemporal database design
by Hayder Marzouk
A small framework to design and print documents containing shapes, text, images, bar codes...
by Himanshu Thawait
This sample shows BizTalk 2006 consuming a Web Service, then publishing orchestration as a Web Service, and calling it from ASPX.
by Nilay Parikh
BizTalk Server 2006 / R2 Throttling Mechanisms, BizTalk 2006 / R2 comes with good relief in terms of performance and throttling mechanism, if you work close to administrating and performance tuning job for BizTalk environment or any messaging system then you can visualize the complexity of pick proc
by Shai Raiten
How I used Scrum as guide for gambling in Vegas
by BoneHead
BoneBoxes is a data access library that provides you with SQL statements and data validation based on the data set's properties
by Boo!
This article is to help you create context sensitive connexion string: choosen dynamically, depending on which server the application is running.
by Bryan Kowalchuk
Proper Key Column Design
by SquaredRomi
A trigger is a database object that is bound to a table. In many aspects, it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure".
by Redgate Software, Dan Nolan
In this article, I’m going to show you how you can continue using EF Code First to model your database, while also using ReadyRoll to do the actual deployment of T-SQL change scripts and overcome the challenges of the Code First approach.
by Anthony_Chu
In this article, we'll look at how we can use Azure Functions and SignalR Service to broadcast real-time document changes in Azure Cosmos DB to clients over WebSockets.
by oleg.vidovic
Browse MS SQL Server Information Schema Catalog
by Miles Gibson
Iron Speed Designer builds database, forms, and reporting applications for .NET – without hand-coding. Quickly create feature-complete custom applications that integrate Web pages, controls, data access, validation and security. Accelerate development and eliminate infrastructure programming.
by Miles Gibson
Iron Speed Designer builds database, forms, and reporting applications for .NET – without hand-coding. Quickly create feature-complete custom applications that integrate Web pages, controls, data access, validation and security. Accelerate development and eliminate infrastructure programming.
by Microsoft
In this tutorial, you learn how to build a .NET Core app to manage Azure Cosmos DB SQL API data.
by Microsoft
This quick start demonstrates how to create an Azure Cosmos DB SQL API account, document database, and collection using the Azure portal. You'll then build and deploy a todo list web app built on the SQL .NET API, as shown in the following screenshot.
by nguyenannhon
This article introduces the steps to create a report with a custom search area.
by Microsoft
This tutorial shows you how to build a Node.js console application to create Azure Cosmos DB resources and query them.
by fral
Write database independent ADO.NET applications
by Dwight Johnson
Save hours of time by creating stored procedures and code from database metadata.
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.
by Yulianto
An article on building a Database Application with OLE DB
by noahhath
Building a hybrid Active Directory and SQL table DataSource view.
by paul heap
A plug-in for VS.NET that stores code snippets in a database. From the plug-in you can add code, search the database for code snippets. Also includes examples on how to integrate with the IDE as a plug-in.
by Agha.net
This is a series of articles providing Building Blocks for any ASP.NET application.
by Yulianto.
An article on building database with ADO.NET application for a beginner.
by John-ph
This article explains about building and executing a Dynamic SQL in a stored procedure.
by Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
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.
by SarmadAsghar
This will provide opportunity to calculate aggregates, joins on the data retrieved from API’s which was never done.
by rafael_p
One of the many solutions to build a quick and robust middle tier.
by Mohan Raphel
In this chapter, we are going to walk you through creating a custom module for the CoffeeConnections portal.
by Muhammad Shujaat Siddiqi
This article discusses SET based operations involving INSERT / UPDATE and DELETE using LINQ to SQL.
by lost in transition
This article demonstrates how perform a bulk 'Insert' with MS Access.
by Bishoy Demian
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
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.
by JR Hull
Save time when developing large applications, by using code generation for your business objects.
by Mohan Raphel
In this chapter, we will get familiar with the Oracle BPEL Process Manager 10g Release 2, a server for deployment, execution, and management of business processes defined in BPEL.
by umar.techBOY
An API that reads OMR sheets from camera taken/ scanner scanned images.
by LamYongXian
This is an alternative for "C# - Optical Marks Recognition (OMR) Engine 1.0"
by kribo
How to insert images / binary data into a database.
by Steve Michelotti
An article on nullable data readers for .NET 2.0 nullable types.
by kribo
An article on how to connect to a MySQL database using the Connector/NET 5.2
by Adam Klobukowski
Class that creates INSERT INTO SQL queries.
by Renan Rodrigues Duarte
This article tries to explain how we could use a TextFile as a simple DataBase.
by PaulMcKenzie
This stored procedure will generate all the C# code for calling any Stored Procedure
by T Manjaly
Anybody can write code! With a few months of programming experience, you can write "working applications." Making it work is easy, but doing it the most efficient way requires more work than just making it work!
by Keith Fletcher
A simple base class to extract command line options
by SimonS
A generalised method for calling parameterized stored procedures
by Edacio
This is a MySQL based Profile Provider written in C# for .NET 2.0
by cellarjay
Accessing the MYSQL Database at your webspace from any remote computer
by Not Active
A C# Windows application to store and retrieve photos from a SQL Server database.
by Hasan Habib Surzo
Class, Database Connection, Login Winform
by Mitchell Vines
Source code for SQL formatting (now with formatting options)--as opposed to a utility, web service or plug-in/add-on...
by User 1556233
Comparison of Performance of C++ and C#
by Neil Barnwell
An article describing a simple way to provide transaction support to an application designed using the DataSet wizard, and avoiding the DTC requirement with using TransactionScope and SQL Server 2000.
by Michael Chourdakis
C++ 11 Threads
by Robert Pittenger, MCPD-EAD
This project is a code generator to produce CObject-dervied data classes for Object-Oriented database management
by lihaijian
This article will provide a cross platform C++ wrapper for Oracle's OCI interface.
by lihaijian
This article will provide a cross platform C++ wrapper for Sybase's OPENCLIENT interface.
by Dan Ionescu (USINESOFT)
More on data manipulation
by Wendelius
Some simple scenarios to calculate running totals in SQL Server.
by Alazar 9860585
Calculating the Probability of Related Events Based on Bayes' Theorem Using MongoDB Aggregation Framework in C#
by kokilaB
Trigerring a Calendar in a Datagrid
by sandeep@s
An introduction to executing SQL Server stored procedures and how to retrieve the return parameters
by Md. Marufuzzaman
Cannot alter Microsoft SQL Server 2008 Table Object in design mode
by Muhammad Amjad
Business process management and Quality improvement concepts
by Erik Bartlow
This user-defined function will allow you to capitalize the first character of any string passed to it.
by gledgard, zoeg
How to effectively target your audience and message through a traditional resume
by David O'Sullivan
Detailed guide to installing Catharsis and setting up a Catharsis solution
by Daniel Kaminski
A class used to serialize object into a database field
by thund3rstruck
Solution for Archiving & Managing Optical Media
by Brian Bayless
A central key manager for multiple web server clients in a web farm.
by John Bevilaqua
SQL DDLs for creating table structures and inserting the data for a set of tables suitable for producing pick lists for validation of the Month Names, Month Numbers, Days in each Month and Years in the 20th Century
by Imran A Momin
This project help you to change ur database at the runtime
by Raghuwanshi.G.S
This article shows how to improve Server / System performance by changing the FILE DESCRIPTOR limit and TIME_WAIT in Windows 2003, XP and Vista.
by Kuldip Rindani
This script calculates size of every user database with summary
by IPC2000
A handy command line tool that checks whether stored procedures, views and functions in a database compile
by jamesplewis
How to check if your Microsoft SQL Server 2005 is ready for the new DST 2007
by smoore4
Loop through all files in a folder/subfolders and run a checksum that is stored in a database. E-mail descrepancies and results.
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.
by Fernando Finelli
dump the transaction log
by olden69
A CStatic derived digital LED screen with transparency. Based on "CStaticTime class" of Jason Hattingh.
by Tomas Petricek
CLinq project is a library that makes it possible to use LINQ technologies from the C++/CLI language
by Christopher Liu
When you copy a row with a primary key, bring other tables that reference it along for the ride!
by Ali-DN
CLR Function for Persian Date Converter in Microsoft SQL Server
by Virat Kothari
CLR Stored procedures are very simple and can be used in most complex scenarios when dealing with database.
by Alexander Wiseman
A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases
by Stefan Chekanov
CODBCRecordset class is intended to be a full replacement of all ClassWizard generated CRecordset derived classes in MFC projects.
by Santx - Santosh
Code First with Entity Framework 5 using MVC4 and MVC Scaffold
by Vinayaka Krishna Shenoy
This utility will help to generate the DataAccess Objects based on the Connection strring provided at the config file
by emad_awad
Used to convert Text Files to a different code-page
by RichardRoe
CodeSmith template for creating Audit Log Triggers on SQL tables.
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.
by larryjf
Describes symmetric and asymmetric encryption, then shows how to combine them.
by skennedyny
Simple console app which shows how to use the .NET CommittableTransaction class
by Luigi Grilli, Michela Carriero - Lyra
Vista: what to do when storing common data is needed?
by Alexander Yumashev
The code compacts and repairs an MS Access database from C# code using a JRO.JetEngine COM-object. Binding occurs at runtime, no references, no interops. Pure System.Reflection.
by Jeremy T. Fuller
A simple method that compacts and repairs a Microsoft Access database file using the Microsoft Jet library and C# COM interop. The example code is meant to be integrated into an ASP.NET web site.
by Alejandro Barrada
How to use an XML file to read and write aplication settings in a Window Mobile development
by Paritor
Application to show differences between two SQL Server databases.
by Amalorpavanathan Yagulasamy(AMAL)
This article explains about advantages, differences and new features of VB.NET and C#.
by Chaudhary
SQL Server manager for remote monitering and managing.
by SachinD@13
SQL Server Job Agent for SQL mail service with attachment of Excel file
by Robin_Roy
Simple example to show how Composable DML works in SQL Server 2008.
by vikas vohra
This article shows the implementation of Composite Server Control to provide Login features
by Padoor Shiras
Computed Column Specification for populating nth column
by Navdeep Bhardwaj
Concatenate field values in one string using CTE in SQL Server.
by Marc Clifton
An overview of Microsoft's Parallel FX initiative, including the Task Parallel Library and PLINQ.
by Murali Pamidi
ASP.NET - Concurrent user updates using the Timestamp column in SQL Server.
by Keshav Singh
This video explores how we can setup a system to detect issues when, my replication fails or SQL Job fails or there is an alert fired.
by hong_wei_li@yahoo.com
Configure MS SQL Server 2005 Remote Access ( mixed mode )
by Kareem.S
This is an enterprise solution for sending mails from the SQL Server database engine to SMTP servers.
by ambatisreedhar
An article on how to configure Joomla in a step by step manner
by parallelcoder
Configuring Plastic SCM database backend
by Daniel Miller
This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.
by brucedkyle
In this lab, you use drag and drop functionality to add controls to a Word 2007 template, build logic into those controls, protect the content of the controls from editing and deleting, and add simple data binding to a local database. Then, you’ll add a Fluent Ribbon to Word to browse the data.
by efero
Codes to help to connect VS 2005 to SQL Express manualy
by efero
Connecting to SQL Express Manualy
by Lizandro Campbell
Using Visual C# 2008 to establish connection to a MySQL 5.1 database with MySQL Connector/NET 5.1.7
by User 4838655
This article explains how to connect to an SQL Server and pass a string.
by Lukas_J
How to connect to IBM DB2 from .NET on Windows
by Ramy Mahrous
Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1
by Gil Shabat
Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.
by Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
by Redgate Software
Continuous integration makes development more efficient – allowing bugs to be caught earlier, and providing rapid validation. But for too long, it hasn’t been standard practice for databases. This is an overview of implementing CI so you can bring database code in line with application development.
by Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
by Wendelius
This article describes a mechanism how trigger actions bypassed based on database user information
by The ANZAC
Shows the basics of controlling input on a controls key press event
by StylezHouse
A porting of the ASP.NET reporting starter kit to use Mono, MySQL and Apache on a Linux system.
by topcatalpha
An article on how to convert a Hexadecimal to int using Microsoft SQL
by Florence FZ Li
This article shows how to convert a text file to PDF.
by Eron Wright
Convert a datetime value to .NET-compatible Ticks using a T-SQL User-Defined Function. Useful for interoperation between .NET and unmanaged environments such as ASP and VB6
by Ritesh Poojara
SQL function to convert GMT datetime to Local datetime
by Wiltek Ghozali
This utility is used for convert query result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report, supported SQL Server and ODBC connection.
by liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
by Girish Chandra
Convert any compatible System.Type to SqlDbType.
by ritzcoder
This article shows you how to take a date string and use it in a parameterized sql server query
by Sacha Barber
Cool database tool
by Aaron VanWieren
How to copy data from a modified dataset into a SQL Server Database
by Keshav Singh
How the Copy Database Wizard can be helpful to users working on upgrades and migration projects.
by Niladri_Biswas
A program to demonstrate the copy files from one location to another and rename them after putting time stamp by using Sequence Container, Foreach Loop Container, File System Task and Script task
by Ferdie
Getting the correct column ordinals of an ADOX Table object.
by Rob Groves
A C++ wrapper around the SQLite embedded database library.
by Omar Al Zabir
CPUAlert monitors CPU and Memory consumption of processes and alerts you when they are taking too much consistently and gives you an option to recycle or terminate
by Sainath Sherigar
Cracking the ITIL V3 Foundation exam requires 1 week of dedicated focus.
by Sainath Sherigar
This article provides a detailed approach to crack the PMP exam based on the author’s practical experience and common pitfalls one should avoid.
by Anele 'Mashy' Mbanga
Using IndexedDB as a backend for your JQuery Mobile App
by Anele 'Mashy' Mbanga
Demonstrates creating, updating, deleting single file json records in a web server using jQuery Mobile and Php.
by Anele 'Mashy' Mbanga
Demonstrates how to use SQLite database for mobile development
by Anele 'Mashy' Mbanga
Demonstrate how you can create a JQuery Mobile app and use XML as a backend - single XML record approach by using xml2json.js and json2xml.js.
by Mukund Pujari
This application can be used to create databases, tables, stored procedures during the installation of .NET applications.
by C Rotell
Developed a Mailing List collection with Opt Out
by james.wren
How to add a modified on column in SQL Server using triggers.
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.
by junyaoxu
This article explains how to build a generic and data bound Web based Crystal Reports server.
by Phuong Thanh Nguyen
Create a SQL Server database using C#.
by Nagasai Mattegunta
An article on Database Driven Dynamic multiple Treeviews
by simonp_ca
A free, mean and lean way to create data driven PDF on the fly by using SQL server reporting service (SSRS)
by Mukund Pujari
This application can be used to create database, tables, and stored procedures during the installation of a .NET application.
by Joshy_geo
Create database in sql server using asp.net with C# (VS2005)
by 2sky
A brief overview of how the Hera Application Framework aids you in the development of data-driven applications.
by MESCIUS
ComponentOne InputPanel for WinForms is a new paradigm to create and maintain data-entry forms. It is a panel that is placed on a form to help create powerful data input applications. Simply connect C1InputPanel to any data source and an input control for each field is automatically created for you.
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.
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.
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.
by Mubin M. Shaikh
This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube
by Galin Iliev [Galcho]
Creating many-to-many relationships in LINQ for SQL.
by aleksisa
Create an Open File Dialog for a Windows Mobile 6 (SmartPhone) devices.
by justindhas
Create Sample Application Using Entity Objects Using C#.Net
by Bert O Neill
Create unit tests for your stored procedures\triggers\functions and integrate into TFS continuous integration cycle
by Jatin Prajapati
Here I am showing, How to Create SQL Database and Run SQL Script File Using asp.net.
by Bert O Neill
Develop your own SSMS ObjectExplorer\CommandBar menus, within SQL Server 12
by Rami Said Abd Alhalim
Create View To Get Constraints
by Michael Ceranski
Creating a DAL with SubSonic.
by Nadege Rouelle
This article shows how to create a database project to manage database scripts in Visual Studio
by Bryan Sachdeva
This article demonstrates how to create an auto-refreshing Google Desktop Gadget that pulls data from a database.
by Bryan Sachdeva
his article demonstrates how to create an auto-refreshing Vista SideBar Gadget that pulls data from a database.
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.
by Beavis Killer
This article demonstrates how to write a domain service factory to host plain old class object (POCO) entities and use them through RIA Services in Silverlight version 4.
by LeanneStuive
This article explains the basic AJAX technique, and explains the HTML, JavaScript, and SQL needed to use AJAX to access SQL Anywhere web services. It also covers how to use the AJAX process with a Windows Mobile 6 Device and the SQL Anywhere HTTP Server.
by David Veeneman
This article discusses how to create a private installation for SQL Compact
by Scott Bentley
How to create a proxy that downloads PDF reports from SRS and then stream them back to the client browser
by David Utz
This article shows how to create an OLE DB Data Provider that wraps both a C struct and C++ class containing data that is to be made accessible by a SQL query.
by alifaraze
Custom assembly and reporting services
by Malik Nasir
An article on creating and populating an automated MS Access file from other databases.
by Pritam Zope
In this Article we will create an Auto Completion/Code Completion Window using C# that automatically shows popup of the list of words or keywords and inserting those into a RichTextBox
by azamsharp
Implementing an auto-completion feature using ASP.NET 2.0 client callbacks
by Luis Ramirez
This article shows you how to generate SQL code for CRUD operations using the SqlNetFramework and CodeSmith.
by Member 3209760
Creating CSV from SQL Database table attaching it to MS word as datasource and then creating mailmerge document
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.
by Malik Nasir
An article on generating an Excel sheet with different charts, based on the data in the sheet, and then emailing it.
by Alexander Mikula
Writing to Excel spreadsheets using only ODBC
by Anele 'Mashy' Mbanga
Create JQuery Mobile Apps with JQM.Show on your PC with these tools.
by sarvesh.upadhyay
In this articleI am going to show how to create log file for stored Procedure
by Nishith Pathak
Creating managed objects in SQL Server 2005.
by Girish Nurani Sankaranarayanan
An article describing the implementing of Custom actions in Pocket PC application Setup packages.
by Snesh Prajapati
In this article series (consist of two parts), I am sharing how to create report using Report Builder by fetching data from Oracle DB. As per requirement, before getting the data we need to run a stored procedure which will get data from table based on given parameter and then we need
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.
by subai
An article on how to create user defined data types using .NET languages for SQL Server 2005.
by SquaredRomi
Tree is used for hierarchical display of data and permits you to create effective user interfaces while easing development and maintenance time.
by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
by apna
Article describing how to work of girds which needs to add columns dynamically at run time.
by satalaj
Here You Can Convert Crystal Report To PDF
by Yap Chun Wei
A Class to Read and Write to Excel and Text Delimited Spreadsheet
by teknas
An article on Cubes, MDX, Analysis Services and ADOMD in .NET
by Paul Brower
Manage SuspendBindings and ResumeBindings for all CurrencyManagers in your app.
by Wendelius
How to create custom aggregates in Oracle using PL/SQL
by Wendelius
SQL Server not having the aggregates you need? Why not build your own.
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.
by Anas Karkoukli
Auto incrementing and custom versioning of assemblies with Visual Studio 2010 and MSBUILD using MSBUILD Tasks
by Emmanuel71
An article about Custom Businessobjects in conjunction with the DataSet to Retrieve Data
by Shaun Wilde
Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.
by Thiago Silva
Automate your Reporting Services report deployment and scripting and database tasks by using these custom MSBuild tasks.
by Abhay Dubey
This procedure can be called in another Stored procedure or function and quite handy in debugging and development
by Palwinder Singh
Implementing custom resource reader with database
by Ray Gorski
Create a custom control flow component for SQLServer 2005 Integration Service
by Wendelius
This article shows a custom SQL Server function to split a string delimited by a character or a set of characters. The function also contains a few handy enhancements.
by Haja
When the IIS log is not sufficient for your web analytics , you can use this simple technique to track the extra data about visitors of your web page
by Anandhi Swamy
Customize Identity, Custom Principal with ADS
by Trenton Moss
ustomisable websites have recently become more and more popular - get the lowdown on when and why you should and shouldn't allow users to change pages on your website.
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.
by Marc Clifton
Build a Metadata Designer for the CX Dynamic Composition Framework.
by Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
by Hamidreza-Ghasemkhah
Automatically generates the required class and stored procedure to work with SQL databases
by Justin Bozonier
Shows how to create a data bindable strongly typed collection via a DAL to replace a DataSet.
by Kevin Smith
My added DAO functionality makes database reading and writing easier
by AnOldGreenHorn
An embedded database library in C++.
by Deyan Petrov
Generic data access component for different datasources, sprocs/SQL, implicitly propagated transactions, explicitly managed transaction contexts etc.
by rperetz
Using SqlHelper in .NET 2.0 and getting return values and output values.
by Deyan Petrov
Data Access Component - thin wrapper of ADO.NET eliminating the need for the transactional support provided by COM+, supplying a uniform interface to different data sources thus allowing for easy switching to another data source eventually
by Waleed Al Tamimi
A generic Data Access Component implementation written in C# that supports SQL, Oracle, OLEDB and ODBC data providers. Using the Factory design pattern for instantiating the data provider correct and specific objects determined at run time.
by stephanpeters4000
Data access components to interact with any database.
by Radim_Hampel
This class helps with connecting to DB engine and with returning of resultsets.
by Andrey Shchurov
With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.
by Xela220
Data Application Block for Firebird SQL intended to speed the development of applications
by Nikolai Serdiuk
This article describes creating indexed search systems using relational databases
by theoutlander
An overview on inheriting a ListView and implementing design-time data binding capability.
by Jason Selburg
How to implement data driven subscriptions in SQL RS 2000, Standard edition.
by Bruce Chapman DNN
Using data driven unit tests with SQL Server CE for DotNetNuke private module development.
by ranajitbiswal
Data Encryption/Decryption using RSACryptoServiceProvider and X509Certificate2
by Ole Oren
Describes building a WorkGroup TimeSheet with GridView
by lost in transition
Extracts data from database, manipulates extracted data, and then updates the database
by ganesan balachandar
The tool can generate the specified number of rows for any table. Can be used for stress testing the application
by Shahriar Iqbal Chowdhury/Galib
An article presenting a small application that export data from datagrid to Excel Spreadsheet
by Vishnu Prasad C
Data insertion from flat file into SQL through BCP utility
by Emiliano Musso
How to access, display, modify SQL Server data (tables, etc.) through Windows Forms controls and LINQ instructions, using DataSets and TableAdapters
by Horatiu CRISTEA
This article presents a data paging solution in the database. The paging operation was moved on the data layer.
by DataBytzAI
An overview of what developers need to know about data protection and privacy
by AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
by Ganesan Krishnan
Data Synchronization in SQL Express
by Tomz_KV
A custom solution to transform data from rows to columns using dynamic SQL.
by Rashid Thadha
Show a progress dialog when you execute your DTS Package at runtime.
by Wendelius
Enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems using Snapshots
by Duncan Edwards Jones
An extensible tool to package and deploy database schema objects
by M Saqib Ali
It is an object of database where we connect the data SQL Server and do working in sqlserver.
by Amir Mehrabi-Jorshari
With this tool, you can compare two databases and generate a difference report.
by George Zabanah
Take a look at two new patterns to help with database concurrency: SIP and SUP.
by PIEBALDconsult
A system of plug-ins that provide very simple database access
by Andrew Tweddle
A demonstration of using XSLT to create SQL error reports in a daily build process.
by Andrew J Dixon
Explaining Database deadlocking to non-technical people
by Alaric Dailey
Design for data integrity, simplified SQL, and programming ease.
by emadns
How to start a connection using ATL OLE DB consumer classes and how to obtain a session so that you can use it to query or edit the database.
by pavan k vadlamudi
Creates database documentation table(s) schema
by Olivier_Giulieri
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
by Niemand25
Designing a simple yet functional database for financial accounting application
by Niemand25
Designing simple yet functional database for financial accounting application
by Niemand25
Designing a simple yet functional database for financial accounting application
by Niemand25
Designing a simple yet functional database for financial accounting application.
by falconsoon
Database Helper Class Library to Ease Database Operation
by Zoodio
This application will permit the user to create tables in SQL 2000. It will also permit the user to save and view images from the database
by Jaryl Sim
Use different database providers without tying implementation to one.
by Massimo Colurcio
Explore the structure of tables (and views)
by nitinnigam21
This article will allow you to move your database from SQL Server to SQL Azure to enhance the performance of your application that has been deployed on the Azure Cloud.
by NaNg15241
A usefull tool to control the database, easy to use and easy to control.
by Huseyin Altindag
Personal address book using ADO.NET and C#
by Keshav Singh
Mirroring is the best database fail over option used by the SQL Server DBAs today. I hope this contribution adds little value to the beginner level DBAs.
by Keshav Singh
Mirroring is the best database fail over option used by the SQL Server DBAs today. I hope this contribution adds little value to the beginner level DBAs.
by Dr Bob
SQL Server ISS can simplify database mirrors across multiple vendors
by Michiel de Rond
A little tool to make life while developing with databases a little easier.
by Gil Shabat
Scaling web applications and databases can be quite complex depending on the requirements, but the good news is that for the majority of web applications, it can be done with little impact on a project’s timeline or budget provided it’s taken into account at the beginning of the design cycle.
by Peter Weissbrod
An introductory approach to synchronizing database schema versions
by S. M. Ahasan Habib
Database script execution with testing
by Ajey Dudhe
This utility can be used to compare two MS Access databases for changes in the data. You have the option of generating the SQL scripts and\or a summary XML
by HARISHCHOWDHARY
This article explains how to secure database against the SQL injection attack
by Keshav Singh
An introduction to the database snapshot functionality in MS SQL Server. It is one of the important tools used for generating data for reporting purposes.
by Orkun GEDiK
Learn how to export database fields to XML document
by Arturs Solomencevs
About database transactions and using Spring Framework
by Redskin9
A series of Database utilities for lookup and data manipulation written in C#
by avronp
View and update any database table and metadata. Includes sample databases.
by VGirish
This article aims to create a simple tool for visualizing database tables and relations, a database map to refer to.
by PIEBALDconsult
A simple base class that encapsulates basic database access functionality
by dakeefer
A introduction to the flexibilities provided by the use of SQL extended properties in business layer code templates.
by Dan Glass
Databinding the SqlTypes using the PropertyDescriptor class and the ITypedList Interface
by darkoman
C# implementation of the serverless OLAP engine
by asithangae
Achieving the DataGrid functionality with paging using User control and Ajax
by Thiru Sagadevan
Showing Tooltip for each cell with data of a table in a Datagrid
by Y. Shahabudeen
Simple datagrid tooltip of each cell values and header tooltip
by Arash Javadi
A customized column for datagridview to pick a color from a drop down within datagridview
by darkoman
An article on a simple ODBC SDK wrapper library.
by David Wulff
A framework to completely separate objects from their data source - allowing any data source to be used without prior consideration in your code or designs. Databases, text files, web services and potentially anything else can all be used or swapped transparently.
by Thomas Maierhofer (Tom)
Introduction into the ORM Framework DataObjects.Net from x-tensive
by Juraj Borza
Integer and string indexing of System.Data.DataRow columns - head to head
by AnOldGreenHorn
A template class for creating sequential access record files
by Michael 'Tex' Hex
This article demonstrates the first version of a DataTable Generator. This generator uses information found in custom attributes on any class and transforms the class, or several instances of it, to a System.Data.DataTable.
by Marc Clifton
Adds synchronization to the DataTable Transaction Logger.
by Marc Clifton
Undo/Redo DataTable transactions by logging row changes (insert/delete) and field changes.
by vacen2
Allows you to perform a Distinct query against a Datatable
by Marc Clifton
Creating a website in Ruby on Rails for dynamically displaying and navigating a SQL Server database
by Tommi G
Add-in for copying SQL Server 2005 Express data files between project main folder and output folders.
by nickadams
A set of classes to encapsulate DB2 CLI APIs in ADO style.
by Ross White
C++ class wrapper for ADO
by Donsw
An article on database create using PostgreSQL
by seesharper
An abstract syntax tree implementation for SQL
by canozurdo
An article for converting DBF files to dataset XML files
by Mark Williamson
DBInspector is a swiss army knife for database developers. DBInspector helps you generate all types of code based on your database schema.
by voloda2
An article describing a simple .NET library which simply keeps your database schema up-to-date.
by Wael Amer, Hossam Barakat_
DBLayer Wizard is a code generator that generates Data Layer classes in C# using ADO.NET and SQL Server 2000.
by wduros1
A poor man's OR tool for generating VB.NET database code against a MySQL database.
by Pieter Van Parys
Explains the principles of profiling a DbProvider using proxy classes.
by Pieter Van Parys
Creating profiling information in our ProxyDbxxx classes
by Higty
A DAL generator that generates StoredProcedure client class and creates Table and Record classes
by rkapl
Excel based solution for modifying Database data
by Alex Kolesnichenko
Article describes design, development and testing of a home-grown tool for database schema updates using TDD approach.
by Espen Harlinn
A reflection based wrapper for the Oracle Data Provider for .NET – allows your application to dynamically load the Oracle.DataAccess.dll assembly installed on your client’s computer.
by MH2538
A DB Base Tree that load it's nodes from a table
by Star_Friend
All you want to know about how to deal with DataTables.
by Igal Tabachnik
Why you should use OzCode to debug your C# code in Visual Studio
by Michael Mangelsdorf
Framework for loading TGA image data from an SQLite table, decoding this data and binding it to OpenGL textures
by Kuv Patel
Decrypt Stored Procedures, Views, Functions, and Triggers in SQL Server
by Jeremy Mullinax-Hill
A generalized stored procedure that performs constraint checks before performing deletes.
by Tarek Najem
How to delete duplicate entries from a data store, while leaving a single copy.
by Tadas Budvytis
Explains a mechanism of deleting a record when the selected record has related records in other tables.
by Keshav Singh
This article is nothing but a very critical real time scenario that I have faced for a Delta Derivation warehousing project where I found the newly incorporated Merge keyword in SQL Server of immense importance.
by Manuel C
This script permits to deploy single cubes from one server to another
by Malpani Amol
This article will drive you, how deploy and debug CLR store procedure
by Stefan Prodan
Deploy MS SQL Server databases using System.Configuration.Install and a VS.NET Setup Project.
by Dima Statz
Describes how to add custom script to install project
by santosh poojari
This article describes the prerequisite needed for .Net And SSIS integrated deployment.
by Adam Hurwitz
Using a modified Adjacency List model in SQL, can you retrieve a depth-wise ordered subtree?
by User 1575800
Capture, storage, query, and transformation of quick notes and drawings before any actual design or programming.
by Trenton Moss
Customisable websites have recently become more and more popular - get the lowdown on when and why you should and shouldn't allow users to change pages on your website.
by Ajit Kumar Thakur Microsoft
This article explain step by step approach to implement SSAS Cube.
by Morteza Naeiamabadi
Singleton design pattern helps create just object from a class and direct that object only.
by David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
by Pradeep Fernandes
This article sorts to illustrate one of the ways by which data table changes can be detected through the use of available aggregate functions like BINARY_CHECKSUM and CHECKSUM_AGG.
by DejaVudew
An article on an efficient method to determine missing values in an IDENTITY() sequence.
by gtamir
Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005
by Antonello Provenzano
A description of the base functionalities and usage of a full-featured open-source pure .NET/Mono embedded RDBMS
by Yuancai (Charlie) Ye
Performance comparison between SocketPro and .NET remoting.
by Yunyou Yao
A simple example which connects to an Oracle database to retrieve data with a DataSet, and then show a web report using CrystalReportViewer
by Redgate Software
SQL Data Compare and SQL Packager help iCOMCept ensure customer’s database accuracy
by karun123
An article on configuring an SSIS Package.
by aleksisa
Developing Facebook Application with .NET - part 2 - FBML tabs, setFBML, FB:multi-friend-selector, setRefHandle, PublishAction and much more...
by Omar Al Zabir
Comprehensive guide to development of .NET 2.0 Smart Clients working with existing Service Oriented Architecture based XML web services, fully utilizing the Enterprise Library
by Moim Hossain
Describes how to develop custom business portal application using WSS 3.0 and Office SharePoint Server 2007
by satish.phadke
Tutorial for Developing Reports Using Microsoft Reporting Add-In control.
by hussain.attiya
DEVELOPING SSIS to import oracle records to sql server
by Suranjan Nandi
The report is build on XML Schema and the data and binded the report at runtime.
by Jigar Mehta
Inline Development Comments Automation
by WillianBR
How to develop programs using MSVC++ and Qt for Windows, Linux and MacOS
by Jeffrey T. Fritz
How IT operations can engage more with a customer’s experience and assist software development in isolating problems in a production environment with no code changes needed from the development engineers.
by Tommi G
How to create runtime backups from SQL Server 2005 and restore them.
by simonp_ca
Implement a full text engine by using Stored Procedures for all MS SQL Server editions.
by Marc Clifton, Tony Lewis
Build an n-tier client/server application - Preface.
by Marc Clifton, Tony Lewis
Decisions in creating a flexible architecture.
by Marc Clifton, Tony Lewis
Communication, skillsets and task assignment issues.
by Marc Clifton, Tony Lewis
Prototyping, some false starts, and further architecting.
by smiling4ever
To make a dictionary that will work with Google Suggest like Dictionary.
by Hafiz Muhammad Suleman
This article clears the differences between the On cluase and Where clause when used with left join.
by Luis Ramirez
This article gives a brief introduction to development tools available that help you to select data using SQL and .NET
by Moim Hossain
Describes SQL server 2005 Integration Service object model and different data flow components
by Mayank Pal Singh
Know you digital presence / cyber presence / internet presence using DFMAP
by Steven L. Wentworth (12896862)
Straightforward generation of and ensuring accuracy for DimDate values
by Peter Kovalchuk
Reading hardware information in Stored Procedure
by Kuthuparakkal
WMI based DirectoryMonitor triggers SSIS Package execution.
by Tariq Younas
Article describes how to make backup and recovery plan of MOSS 2007.
by Galin Iliev [Galcho]
How to build a business object with the option to discard changes
by Adrian Bacaianu
How to perform different computations for each row of a certain table, with each computation involving several columns.
by patelsachin
Displaying , exporting and printing crystal reports in ASP.NET with source code.
by Abhijit Jana
A simple guide for beginners, explaining one method of displaying images taken from a database on a GridView inside an ASP.NET web page
by gayansm
An article on using dynamic images in web pages.
by Neeraj Jain
Displaying vertical rows in a datagrid by flipping the tables horizontally
by Gary Dryden
Calculate the distance between two locations given their latitude and longitude.
by Yang Yu
Build distributed programs without worrying about distribution implementation
by BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
by William L. Bain, ScaleOut Software
The era of “big data” is upon us, and the need for fast analysis has never been more pressing.
by Maruf Maniruzzaman
Start using DLinq in easy steps
by Dan Radu
This article explains how to generate DLinq entities mapped on SQL Server database objects, using an Add-In application on VS.NET.
by Marc Clifton
A walk on the wild side using Relationship Oriented Programming.
by Refky Wahib
Generic, full cycle of document approval workflow system, using Windows Workflow Foundation (WF).
by Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
by Hugo Pais Batista
Extend the .NET framework power with DotNetX - free libraries that allow you to generate code, cache database objects, etc.
by perlmunger
This article describes the DotNetNuke Module Packager application and source code. The application enables the user to generate DotNetNuke private assemblies that are useable out of the box from a custom module defined in the programmer's development environment.
by KASQLDBA
Downgrading from Enterprise to standard edition (SQL server) for those servers which are not using any of enterprise features.
by azamsharp
Create draggable objects and drop them in a shopping cart
by KRISHNA PRASAD.N
Article to export MS DTS packages from one server to another.
by Chad Z. Hower aka Kudzu
Over the years we have moved from desktop, to client server, to 3-tier, to n-tier, to service orientation. In the process though many things have changed, but many habits have remained. This article discusses what we are doing wrong, and the possible solutions.
by Kourosh K Tari
How to duplicate a record in MySQL table with auto increment key
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.
by Tharindu Nishad Patikirikorala
Creating Dynamic assemblies in C#
by Kannan K R
In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.
by Tina83
A cursor for dynamic query.
by Asif Sayed
Generate multiple outputs from a single physical report template using dynamic data grouping.
by Asif Sayed
An article to demonstrate the creating of business document ids without using stored counters.
by Greg Osborne
Create an assembly containing enumerations defined in your database
by Rami Said Abd Alhalim
Create Stored Procedure to insert command on any tables
by Sacha Barber
Demonstrates a method of dynamic query across WCF Service boundaries.
by Derek Bartram
An article demonstrating quite how easy dynamic loading it (and why you should use it).
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.
by Toufiqur Rahman Chowdhury (TRC)
This article is about an application that parses a XML Configuration File and creates Menus and ToolBar dynamically.
by Herman.Instance
In this article, the creation of dynamic pivots are explained. This works on SQL Server from version 2005 and above!
by Dave Elliott
This article describes how to create a data structure that will allow a user at runtime to add additional data points in a manner that is easy to administer while allowing data to be inserted and validated.
by Pakorn Indhatep
Dynamic report by using the PrintDocument component with SQL queries.
by Mike Ellison
An approach to creating an aggregate report with a set of dynamic columns based on dates.
by Bas Goedemans
A simple class to dynamically add DSN-names to your system.
by Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
by mattraffel
With this tool, dynamically generate C# data layer code (CRUD functions) for Microsoft SQL and other databases
by Sam Lombardo
Dynamically map a DataTable to type-safe business objects using reflection and generics
by mparvez
Dynamically restore full and all transaction log backup.
by Fiwel
Dynamically set TextBox.MaxLength based on the SQL column size.
by interface Mirror
The easier way of accessing data using intermidiate classes between basic ADO.NET classes and your own application.
by Matty22
An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding
by Matty22
An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding
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.
by Syed Rafey Husain
Dot Scrum is a structured though a lightweight way to manage software development projects
by Frank Kerrigan
An article on easily binding ADO data to control using reusable code.
by Igor Tkachev
Run-time data accessor generation
by Emad Al-Ashi
An easy graphical way to create complex nested SQL Join queries.
by AnOldGreenHorn
An easy to use C++ wrapper class for ODBC.
by eyeseetee
An article explaining how to edit and display database values in a DropDownList in a GridView column
by mc_kappa
Describes the theory of how software development can be simplified even for mission critical applications
by Suchit R. Khunt
What is Elmah and how to use Elmah in MVC ?
by Mykola Dobrochynskyy
This article discusses the topic of validation of an Email address with regular expressions, and finally presents a C# working example project.
by SarmadAsghar
Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5
by Dan Letecky
An example that shows how Firebird database excels in embedding.
by C Yang
Program to track employee work time
by Koenraad
This class lib allows encrypting DataSets to XML files and reading them back. A Win Form app is included as a showcase.
by Adnan Samuel
Encrypt and sign data using PKCS #12 certificates.
by Dmitry Tsuranoff
Examining the effects of column encryption on SQL Server performance
by Daniel Kuettel
This article shows a simply method of encrypting connection strings for windows applications
by cctuan
Extends DataGrid Functionalities
by Refky Wahib
This Article supporting these features: Logging to file, TransactionScopeActivity, WorkflowCommitBatchService, SqlTrackingService, fault Handler Activity and Bi-Directional communication using custom services
by satisharveti
Application on accessing database objects in Oracle
by Nishith Pathak
Enhancements done for storing connection strings in Visual Studio 2005.
by Ehsan Golkar
This component is used for forms that have too many textboxes which change their focus with Enter key.
by Rohit Gadagkar
A discussion about architectural patterns for using LINQ to SQL in enterprise applications, along with performance implications
by venugopalm
Database and Library Design for Customer Order Management System
by #realJSOP
A tool to generate model and viewmodel classes directly from your selected database
by Jason Sobell
This article describes a utility that modifies EF4 edmx files so that they support SQL Server's 'Default Value or Binding' property
by Emiliano Musso
In this article, we will see how to use entity framework in our Applications, developed through the various languages that Visual Studio allows us to use. The examples in this article and probably in the next, will be C # used under WinForms, but - as mentioned - this choice is not going to affect a
by Vincent-Philippe Lauzon
Introduce different patterns in Entity Framework around selecting a list of entities.
by Not Active
A comparison of performance between ADO.NET and Entity Framework.
by Christopher R Davis, Michael S Knight
Generate an Entity Framework data access layer using an nHydrate model.
by Saravanan Lakshmanan
Utility to convert data from ID and CODE columns in a look up table into an enum type in C# (or VB.NET).
by earmitage
An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on SQLDMO. Based on the C++ article by Santosh Rao.
by Rashid Thadha
Get a list of SQL Servers to which you can connect.
by Chris La
This is an alternative project of "OraLib - a lightweight C++ wrapper over Oracle's OCI library"
by Kishore Kumar.N
Logging the error in the database and sending email to the respective person
by Paul Brower
Use the ErrorProvider to display friendly 'Value Required' warnings.
by Alex Marbus
Ethernet connections
by Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
by Alejandro Xalabarder
An efficient and flexible layout manager
by Torsten Tiedt
Database development with Server Data Tools
by Miloslav Beno
Simply implement events and CacheDependency with the database
by Bruno Terkaly
Recently, the team at DiscountASP.NET launched a new cloud hosting solution called EVERLEAP. Because EVERLEAP makes use of some Microsoft Azure technology I thought I’d take a look at it.
by chintu222
This article will emphasize on the mechanisms of State Management that are available with ASP.NET and the steps to learn and understand their implications for usability, performance and scalability.
by Wendelius
The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.
by HamidMoghadam
This application dynamically gets the Excel database and converts it to SQL Server
by Amalorpavanathan Yagulasamy(AMAL)
This article demonstrates Excel report generation in ASP.NET using C# and DataGrid.
by HerbD
Describes how to return tables of values as the result of user defined functions (UDF) in Excel.
by rkapl
DBFuncs is an Excel-addin for database querying by user defined functions
by Nilay Parikh
Exception handling with Ports in BizTalk
by Kamal Singh Kharayat
Article describes all the problems and constraints defined to use managed code under SQL Server 2005.
by Deepu M.I
Execute Access 2003 Macros in SSIS Package. How to call Access Macros in SSIS Package
by Suresh Suthar
How to execute DTS packages through VB.NET and use global variables.
by Jeff Modzel
Learn how to load and execute a SQL Server 2005 Integration Services package from C# code
by Wendelius
This article describes a few techniques for how multiple SQL statements can be executed with one SqlCommand.
by Sergey Sorokin
This article discusses a method for retrieveing hierarchical data from a relational database
by Cristian Odea
A simple OR Mapper built with custom build providers, which reads data from XML files.
by ediazc
This article shows how the MD5 collisions can be used to tamper software distribution schemas.
by Mubin M. Shaikh
Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format
by Fuad Bin Omar
An article on exporting large data to Excel files
by Peter Elzinga
This is a generic solution for converting the output of any SQL server script to an Excel file (using SSIS).
by jalal khodabandeh
export sql server or other database query in to excel or word by using c# programming
by J Chandra Sekhar Achary
Useful tips for Oracle import/export to address constraint issues.
by Len Holgate
ADO seems to be the ideal way to expose tabular data from your own COM objects and the ATL OLE DB Provider templates can help!
by Len Holgate
The ATL OLE DB Provider templates appear to rely on the fact that your data is kept in a simple array, but that's not really the case at all!
by Len Holgate
Adding bookmark functionality is relatively easy and it enables our ADO recordset to be used with a greater number of data bound controls.
by Darek Danielewski
With a little help from C# Extensions and Dapper, it is easy to streamline coded database interaction, even with encrypted columns
by mbarbac
Kerosene ORM support for complete database-alike WCF services and connections
by Artour Bakiev
A short overview of the Extensible Storage Engine technology.
by Ali Ozgur
Describes making of an external tools add-in using ProcessStartInfo and Process classes in System.Diagnostics
by RedSunBeer
test the apps design
by Afzaal Ahmad Zeeshan
In this post, I am going to walk you through creating your own central hub to allow your connected devices to authenticate people using facial recognition system.
by PeterMoon
A fast method for exporting large amounts of data from a DataSet to Excel
by Andras Belokosztolszki
SQL Refactor tool is designed to help SQL Server developers and DBAs work much more productively and quickly with legacy code, help them improve the design and maintainability of database code, and to greatly reduce the time and effort involved in performing more complex database refactorings.
by Christopher R Davis, Micheal Knight
This article details how to use nHydrate to add an auditing framework to the nHydrate DAL and Entity Framework DAL.
by Vidya Vrat
This article talks about SQL Server 2005
by Rashutosh Paul
How to fetch data from Microsoft Excel using SQL
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.
by Rafael Mizrahi, Laurence Moroney
When working with Microsoft SQL JDBC driver, you cannot invoke a stored procedure without specifying all the parameters, including the optional parameters that have default values. Learn how to fix that problem here.
by Indrajeet Valera
File Cleaner - Zip & delete old files
by dmihailescu
A windows explorer extension for easy binary/text file comparisons and calculating the MD5, SHA1, SHA256 hashes.
by C Yang
Program to inventory files in directory
by Shuqian Ying
Codes for file synchronization between local and local/remote target directory trees that can be run under the NAnt or a console are provided.
by Marcos Meli
An easy to use .NET library to read/write strong typed data from files with fixed length or delimited records (CSV). Also has support to import/export data from different data storages (Excel, Acces, SqlServer, MySql)
by CoderForRent
Explains how to fill a dataset with the information stored in a delimited text file
by rickwright2000
Avoid the pesky table adapter load error failed to enable constraints.
by Todd Denlinger
Presents a method for monitoring the amount of time database connections stay open in ASP.NET applications.
by idreeskhan
Get or find Primary Key or ID column of Table in SQL Server 2000/2005
by brip
Sometimes its tedious to find all calls made to different stored procedures within a stored procedure and generate reports in case we have large databases. This tool is aimed to script all SPs and extract SP calls made with additional information such as author name and description.
by Rajaraman.net05
This sql function is used to find the week in Given Date.
by Michael Potter
Locating MS SQL Servers by using ODBC through C# PInvoke calls.
by harry_kochhar
This SQL Server function helps to get the nth day of the nth week.
by Steve Brailsford
An article showing how to display the sp_who info and sort on a column.
by Rafey
A FireBird .NET data access block completely written in C#. Supports Embedded SQL, INI File SQL and Stored Procedure
by Iqbal M. Khan
An O/R mapping tool generates persistence objects for your .NET application.
by daniel_nilsson
Testing FlashRemoting with .NET.
by Shahed.Khan, David.Grinberg
This paper demonstrates creating a flexible, extensible, plug-in-based .NET application (JOM - Smart Job Manager). JOM is an asynchronous job processing engine built using the MS Provider design pattern and the .NET technology available today.
by Michael Abramovitch
A flexible way to generate unique numbers for things like invoice numbers
by ringphone
Flicker free drawing without using double buffer
by Jörgen Andersson
Fluent database access
by Sumit Tech Brain
Fluent Migrator makes the database migration very easy. It is a database migration framework for .NET and uses fluent interface to manipulate database.
by Samer Aburabie
Fluent NHibernate Automapping for Unidirectional ManyToMany relationship
by AhsanAhmed
A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format
by AhsanAhmed
A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format
by AhsanAhmed
A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format
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.
by s_arun_kumar
Format Excel Sheet from DTS when Excel is not installed on SQL Server
by ashishnaik1
Format any Number to 2 decimal Number without Rounding
by Akhil Mittal
This article will focus on practical aspects of formatters and content negotiation in ASP.NET Web API
by hooshang Karami
Mixed Mode Of Windows authentication And Forms authentication
by Madanu Ujjwal Kumar
MakeLogic Tail is a freeware similar to " tail -f " of Linux. It is Tail for Windows, Tail for Linux and Tail for Mac
by Sreekanth Mothukuru
A look at the free SQL Server Schema Comparison Tool in VS2013
by Scott Page
FreeCal is a free 100% .NET suite of utilities and instrument drivers for controlling multiple instruments in a Test and Measurement environment.
by Justin Porteous
Using FTP via CLR in SQL
by Jonathan de Halleux
Yet another DAL generator with SQL generation, multi database support, C# code generation, etc...
by Dan Letecky
How to search data stored in a Firebird SQL database using a fulltext index.
by Klaus Salchner (Canada)
Indexing Server, SQL Server, Windows SharePoint Services, SharePoint Portal Server, Exchange Server and Windows Desktop Search provide full-text search capabilities. Each utilizes the so called IFilter components to index the content and then allows clients to search the index.
by Ameen AboDabash
Vertical/horizontal Marquee Web Custom Control consuming SQL Server DB/XML, with great design time attributes.
by Al-Farooque Shubho
Playing with some of the cutting edge stuff to develop a live drawing white board on a web page where multiple people can collaborate and each person has the same view at the same time without any page refresh.
by Pakorn Indhatep
Function for clear null and set default value in DataTable
by Nirosh
Nido Framework with .Net 4.0 and Entity Framework help you standardize your Business Logic Layer (BLL).
by Roger Martin
Gallery Server Pro is a complete, stable ASP.NET gallery for sharing photos, video, audio and other media. This article presents the overall architecture and major features.
by tumbledDown2earth
Browse your Google Drive and integrate your windows explorer with a Google's storage Cloud
by Daniel Aioanei, Adi Malinaru
Persisting general trees in relational databases with fast path-finding capabilities.
by Benedict Chan
Using .NET 2.0 to get the SQL Server schema and generate insertion statements.
by ezekielen
Dynamically generate SQL INSERT commands programmatically and run then in batches of hundreds to bulk load data from a .NET DataSet with multiple DataTables to MySql
by Ian Semmel
A class for automatically generating SQL INSERT for Typed Datasets.
by Md. Marufuzzaman
How to generate SQL object script using C#.NET
by samitcom
This will generate a SQL Select Query, Insert Query, Update Query and Delete Query by selecting SQL Database Connection and Choose a table to generate the script for using in class or DataCommand.
by Valentin Billotte
The proxy generated by the ADO.NET Data
by Bruce Chapman DNN
Writing a SQL script to generate insert or update scripts for a table full of data.
by Sumit Amar .
Stored procedure to generate INSERT..VALUES statements in SQL Server.
by ilorgat
This is an alternative for "Generating INSERT statements in SQL Server"
by Michael Erasmus
This article is on a tool I wrote to generate executable osql deployment batch scripts.
by Sivakumar Mahalingam
An article on how to generate PDF reports programmatically using SQL Server Reporting Services 2005, in C#.
by Manar Ezzadeen
PowerShell script that generates an HTML report displaying different information about the SQL Server databases, their CLR assemblies and owners.
by lepipele
Generate Word documents by appling XSLT on XML data.
by Brian Perrin
Eliminate the pain of calling SQL stored procedures from C#.
by Amir Samdani
Use this class to separate all database calls hidden to the callers. Nobody has to take care of how database retrieval is going on!
by Barathan
Generic Customizable login control for VB.NET Windows Forms.
by owen654321
This article presents a simple and flexible way to sort strongly-typed lists of business objects using multiple properties or fields.
by Jason Witty
A concept of building a tree and allowing each branch of the tree to associate to any object.
by Leszek Koc
Generic Repository Framework (Generic Unit of Work)
by yincekara
An article about How to Save Old Versions of Records Using MSSQL Server 2005 Xml Column
by SudhirKankal
Generic way to do primarykey & foreign key validation from frontend
by Stephan Johnson
This is part VII of a VII part series. This article covers the source code in a breakdown of each project's function.
by Stephan Johnson
This is part VI of a VII part series. This article covers how to manage the hosted applications, user interface and security using the Genesis Management System
by gstolarov
Geocoding with SQL-Server
by Sun Rays
Create command for getting comma seperated value
by Ferdie
A HowTo on getting DataSource information from CSession object
by Malpani Amol
This article will drive you, how to get list of SSIS packages and executing them using .NET assemblies
by essentialSQL
Learn to use Union, Intersect, and Except clauses
by Md. Marufuzzaman
Get SQL Table Information
by Mihail Mateev
Cloudant is a NoSQL database as a service (DBaaS) built from the ground up to scale globally, running non-stop, and handling a wide variety of data types.
by Vincent Maverick Durano
This article is the first part of the series on Getting Started with Entity Framework Core. In this post, we will build an ASP.NET Core MVC application that performs basic data access using Entity Framework Core.
by stodgey
Install and build your first Sandcastle Help Document easily
by xmlbuddy
The fastest way to get started with Schematron and Altova's XMLSpy®
by TomDK
How to start using SQL Server Everywhere in C# programs.
by Daniel_Wheeler
Using a script transform with C# to convert Julian (ordinal?) dates for a date dimension.
by Eddy Vluggen
How to import a database-dump from GeoNames.org into SQL Server
by Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
by ediazc
The cracking of MD5 is making it useless?
by Ted Neward
Google Cloud Platform - Part 5: Google Cloud SQL
by Gavi Narra
An implementation of Google suggest using remote scripting.
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
by Lorenzo Consegni
This article extends Leonardo Salvatore's project using the Web Service Software Factory
by Sumit Amar .
This stored procedure grants execute privilege on all procedures to specified user
by Henry Tan Setiawan
A DataGrid that stores its last state in XML file and loads the last state of the columns' width the next time the application is loaded.
by azamsharp
This article demonstrates how you can use custom paging to improve the performance of GridView paging.
by Gary Dryden
How to view detail records inline with the master records, using the GridView control.
by Brian Rush
In this brief article, the author mentions two techniques that he uses to allow for mapping GridViews to DataTables that are built upon existing middle tier objects.
by T.Ashraf
GridView Image order page shopping cart page
by ZeroDev
Convert the current Gridview to a datatable
by John Bhatt
Let's learn how to make a scrollable GridView and Fix headers with simple steps.
by Tom Bauto
A simple and detailed ASP.NET program using Gridview with paging in SQL 2005
by Tapan Dantre
This Article will give some briefing on sorting, searching, paging in gridview with ObjectDataSource.
by Robin_Roy
New feature - SQL Server 2008 Grouping Sets.
by Muhammad Shujaat Siddiqi
Grouping Sets, a new feature in T-SQL in SQL Server 2008.
by landws
for database project developer
by Jeremy Todd
Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.
by Gurux Ltd
Retrieve data from a physical device, process it, and visualize the results
by Sarvesh Kushwaha
This article describes what XSS is and how to prevent XSS attacks.
by Sarvesh Kushwaha
This article descirbes what SQL injection is and how to prevent from SQL injection.
by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
by Gaurav K Singh
This article aids in rapid application development for database handling, for desktop and web applications
by Alaric Dailey
Building an O/R Mapper: step 3.
by Asher Syed
Handling Key-Down and similar events for DataGridCells in a DataGrid
by Bhim B Thapa
Handling NULL in T-SQL
by Lars-Inge Tønnessen
An article on how to setup and configure the MSFT MSDE 2000.
by JoeSox
A ConceptNet .Net Utility Class Library.
by Mohammad Mehdi Norian
implementation of ocr by hebb algorithm
by Anele 'Mashy' Mbanga
Using Basic4Android, develop your first Android Native App
by Vitaliy Rudnytskiy, Lucia Subatin (Google)
Use SAP HANA to help Thomas get started with help from other developers in the community using text analytics, graph and geospatial.
by Sergii Syrovatchenko
Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...
by Jatin.Prajapati.ER
Hide the datagrid columns which are not intended to be displayed at runtime
by asithangae
Data builder that builds XML from a SQL query in hierarchical format.
by Robin_Roy
MS SQL Server 2008 new feature, the HierarchyID data type.
by Gene R. Browning
Get a quick look at your data characteristics using this tool.
by Ghanshyam Naik
Introduction to OLE DB extended classes
by Florence FZ Li
Hightlight a clicked row and display the information of the selected row on another page
by azamsharp
Highlighting important dates in the Calendar control.
by Chris A. Johnson
How to hire a Great Programmer
by Jennifer Reif
In this article we take a look at what a graph database can and cannot do and give you a few of the tools to help that decision.
by Nigel Shaw
I believe 50% of software process problems are traceable to bad documentation management tools.
by Ashvil DCosta
See how Longhorn core pillars like WinFS changes the way applications are written, based on metadata relationships.
by Md. Marufuzzaman
How many records are there in your database?
by DLM@TD
How SQL Server deletes records
by Emmanuel Kartmann
This article provides a small executable (36K) which configures MySQL (or another Windows Service) to automatically restart whenever it fails/crashes.
by Dejan Grujic
Automatic creation of SQL for CRUD operations when Strongly Typed DataSets are used.
by Koushik Biswas
How to call an Oracle Stored Procedure that returns one or more REF CURSORS, using ADO from C++? Think it should be easy to find on the internet or make it work with a little luck? Not before this article was posted!
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.
by Kamran Hazari
How to create Linked servers in a minute in an easy way
by Manjunath Matathamana
Setting up Node.js and MongoDB backend, and then getting an application up and running can be challenging. This tutorial helps you make the whole process easier.
by Emilio Reale
A useful sample of how to extend Generic List and convert it to a datatable
by Jimmy M Joy
This article explains how to convert DataGrid into a data entry form for same kind of data.
by le quang anh - leadershipqa
This is a sample that guides you to create reports with Crystal Reports using C# and MySQL RDBMS.
by Deepu M.I
The concept of SSIS Logging is to capture log-enabled events that occurs at run time.
by Oshri Cohen
How to Create a task in Microsoft CRM 3.0
by Malpani Amol
This article will drive you, how to create CLR store procedure
by Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
by Database Star
This article explains how to download and install Oracle Express and SQL Developer on your own computer, to get started with running SQL queries.
by Philipp Katscher
How to use barcodelib generated Barcodes in SSRS (consider Barcode fonts don't work in runtime)
by Wang Xuemin
An article on how to use SQLDMO to enumerate SQL Server instances.
by Wang Xuemin
An article on introducing how to use SQLDMO
by Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
by Master DJon
How to find if only one particular column has been modified in a trigger.
by David Catherman
Components don't have a .Parent property like controls do. Getting a reference to the instance of the parent form the component was on is very difficult.
by markkang
This is about how to hash your binary data that exceed the limit (8000bytes) of allowed input values of HASHBYTES in SQL Server.
by T.Ashraf
Hide and Retrive value of cloumn of a GridView
by Mohammad Akbarizadegan
This article demonstrates how to implement web applications based on AJAX and ClientScriptCallBack as it presents a simple example. Also, the article tries to point at the key features of working with ASP.NET ClientCallback and AJAX.
by CQüeb
This article pretends to show how to implement an incremental search doing double click in a UltraWinGrid column.
by Britney S. Morales
This article will show you how to implement two basics uses of the ASP.NET Login control (2.0), The login task itself to validate the users who’s trying to access your web site. In addition i will show how to implement the REMEMBERME process using cookies to save the user name inside the user PC
by Md. Marufuzzaman
This article will give you an idea about how to integrate an OLE Object that is a COM+ API with SQL Server and write a message into a Windows event log.
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.
by Ahmed jamil Kattan
An article explaining how to link your home database in your C# application.
by Ach1lles
A simple technique for selecting random records from a table.
by Adrian Bacaianu
This article shows how to use directly in your Microsoft SQL, an extended stored procedure that makes conversions between Unicode and code page data.
by Salil Khedkar
If you are into development or quality assurance of enterprise solutions, you must be aware of the security aspect of your application. This article provides a checklist for the same...
by Malik Usman
An article on how to pass parameters to Crystal reports from Windows Form at runtime
by hong_wei_li@yahoo.com
How to populate DataGridView, GridView with SQL statement in C#
by Sneha B Patel
This article contains code to prevent popping up "Enter Parameter Value" dialog for each SQL stored procedure parameter with dynamic database
by Wendelius
This article explains the problem, when another transaction (concurrent or not) accidentally overwrites previously modified data and how to prevent this from happening.
by aleksisa
Print a document from a stored procedure using a SQL OLE and VB DLL
by Mihadh
This article explains how to connect to Microsoft Excel 2007 using a connection string and populate DataGridView
by Michael Milonov
Refreshing current row in ADO.NET application using ODP.NET data provider
by Suvendu Banik
How to Restore SQL Server 2005 Suspect Database
by Ali Ozgur
Sample code describing how to retreive statistical information about the T-SQL commands executed.
by Siau Tan Long
An article on how to return disconnected ADO Recordset from COM using VC
by Matt Bowman
How to change the angle of the first slice of a Pie chart in SSRS 2005.
by Vadim Loboda
A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters
by William L. Bain, ScaleOut Software
Using an in-memory data grid can scale your application’s performance and provide fast data analysis.
by hong_wei_li@yahoo.com
How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005
by ozkary
A VBScript script which allows to script out all the SQL Server objects in each independent file
by Ahmed_EL Sayed
How to set up SQL Server Integrated Security for using with SMS.
by Wendelius
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
by Vimalsoft(Pty) Ltd
How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File
by Md. Marufuzzaman
An easy technique to store any file into SQL database
by hong_wei_li@yahoo.com
How to truncate log file in SQL Server 2005
by Ponytail Bob
How to use a script component as a data source for multi-result set Stored Procedures.
by rkdev
This article is about using MFC CodeProject Grid, ATL and MS Access together.
by Simon Steed (SimonAntony)
This article explains how using caching within your Windows Forms application can speed up data access for frequently used data and avoid performance bottlenecks over the network.
by hong_wei_li@yahoo.com
How to use global variable in Microsoft SSIS (DTS) package
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.
by Vilhelms
Retrieving appointments without having to store all future occurrences
by Sujith C Jose
Describes how to use a simple stored procedure in Visual Basic 6.0
by dizzybuzy
Beginners
by Stephen_Ball
How to write once, and test encrypted data storage for Windows, Mac, Linux, Solaris, Android and iOS
by MrTimmins
A general overview and introduction to the basics of writing PL/pgSQL functions in PostgreSQL.
by Lino Barreca
Use T-SQL and system views/stored procedures to give consistent names to every relation in a database
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.
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!
by M L Viñas Livschitz
HyperNetDatabase is a single process multithreading and blackout safe database
by René Paw Christensen
How to solve the error when assigning a DateTime to a IDbDataParameter.
by Peter Weissbrod
A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues
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.
by Darko@Ilumnis
C# MS SQL user / role / right manipulation
by Chirag R Darji
Impersonation using Code
by Adam Nelson
Presents a SQL Server Extended Stored Procedure wrapper around the author's C++ implementation, and discusses use of Double Metaphone with relational databases in general.
by _oti
An article and source code regarding the implmentation of B-Trees in C++.
by josekonoor
Information about Unicode implementation in SQL Server.
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.
by Shivprasad koirala
Implementing Audit trail using trigger
by Sascha Knopf
An article on implementing complex data binding (DataSource and DataMember) on a custom control.
by Ezhilan Muniswaran
This database script provides a template for properly maintaining multiple versions of a database.
by John-ph
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
by Bernard Ho-Jim
Extending the Personal Web site Starter kit by implementing efficient data paging to the Photo Gallery.
by Suffyan Asad
How to implement Joins in Hadoop Map-Reduce applications during Reduce and Map phases
by Suffyan Asad
Implementing joins in Hadoop Map-Reduce applications during Map-phase using MapFiles
by Manjushree Das
The target audience of the article are novice 4D developers. It aims at explaining the usage of Triggers in 4D databases.
by Weidong Shen
Adding secure communications to the Microsoft IssueVision sample application using WSE 2.0.
by Keshav Singh
In this video article
by Waynes World
An article on importing data from external data sources to SQL server without using wizards
by Mohammad Al Hoss
This article shows how to import Excel files to SQL Server dynamically.
by Baliram Suryawanshi
This article helps with step by step detailed information to import fixed length file data into SQL server’s database table.
by Mukund Pujari
This article shows how to import CSV data and store it in database.
by Moim Hossain
Describes how to use the SSIS object model for importing data to SQL server 2005
by James Simpson
This article describes how to use nested sets to improve performance of hierarchies within SQL Server and other relational databases
by Albert Pascual
I wrote this short article to improve your ASP.NET application Sessions using Cache.
by Jörgen Sigvardsson
This article shows one way to extend CCommand and CDynamicAccessor to make OLEDB in C++ easier
by Pete O'Hanlon
The first in a series of articles on prioritizing and improving query performance in SQL Server.