Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / database / SQL-Server
Submit your article

SQL-Server

SQL-Server

Great Reads

Auto Generate Code (CRUD) for 3 Layered architecture
by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 4
by Paul Rony
Programmer's Guide to Starting a Software Company and Building an Enterprise Application
"Column name Create Date contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault."
by Umair Feroze
To resolve the invalid chracter from FOR XML PATH clause
"Column name Create Date contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault."
by #realJSOP
You can also enclose your column name in brackets, like so: [Create Date]

Latest Articles

Auto Generate Code (CRUD) for 3 Layered architecture
by Suresh Dasari's
Auto Generate Code (CRUD) for 3 Layered architecture (Entity, Data Access & Business Layer) with Stored Procedures based on table design.
Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 4
by Paul Rony
Programmer's Guide to Starting a Software Company and Building an Enterprise Application
"Column name Create Date contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault."
by Umair Feroze
To resolve the invalid chracter from FOR XML PATH clause
"Column name Create Date contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault."
by #realJSOP
You can also enclose your column name in brackets, like so: [Create Date]

All Articles

top
Sort by Score
Title
Updated
Author
Score

SQL-Server 

Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 4
by Paul Rony
Programmer's Guide to Starting a Software Company and Building an Enterprise Application
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
by Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
.NET Installer that automatically installs MSDE
by John Kenedy S.Kom
This project enables developers to create a setup package that automatically installs MSDE and attaches database
.NET Installer that Automatically Installs SQL 2005 Express
by John Kenedy S.Kom
This project enables developer to create a setup package that automatically installs SQL 2005 Express and restores database to it
10 Steps to Creating a Windows Mobile Database Application Using .NET and SQL Anywhere 10
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#)
101 with the Interactive Feature of SQL Server Integration Services
by Keshav Singh
This demo session demonstrates a little POC as to how can you make your SSIS talk to you.
11 important database designing rules which I follow
by Shivprasad koirala
This article will discuss about 11 important database designing rules.
12 Important FAQ’s on VSTS Testing (Unit testing, load testing, automated testing, database testing and code coverage)
by Shivprasad koirala
This article has 12 important FAQ’s which covers unit testing, automated testing, data driven test, load/ performance test, code coverage , database testing and ordered testing.
13 disasters for production web sites and their solutions
by Omar Al Zabir
Learn about 13 production disasters that can bring down your business
3 Kinds of Comparison and Snchronization for SQL Server Database
by dingoishere
This article introduces you to 3 kinds of comparison and synchronization for SQL Server Database.
5 Tips for Accelerating Your Web Site Development in ASP.NET
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.
6 Steps to Enable Transactions in WCF
by Shivprasad koirala
6 steps to enable transactions in WCF
6 Steps to Implement DUAL Security on WCF using User name + SSL
by Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
7 Questions You Always Wanted to Ask about Content Management Systems
by Petr Palas
What is a content management system? Does it really work? Why should I use it? How does it help me? This article answers the most common questions developers ask about content management systems (CMS).
7 Simple Steps to Connect SQL Server using WCF from SilverLight
by Shivprasad koirala
In this article, we will look at how we can do database operations using SilverLight.
7 Simple Steps to Run Your First Azure Blob Program
by Shivprasad koirala
7 simple steps to run your first Azure Blob Program
99.99% available ASP.NET and SQL Server SaaS Production Architecture
by Omar Al Zabir
Production Architecture for a SaaS web application built using ASP.NET and SQL Server that guarantees 99.99% availability and super performance
A .NET Windows Application To Generate SQL Server Scripts
by Deepankar Malik
Generates SQL Server Stored Procedure and Table Defination Scripts
A Closer Look Inside RAISERROR - SQLServer 2005
by Abhijit Jana
This article describes how to use RAISERROR in SQL Server 2005
A Comparison on Data Access Methods - Part 3
by Dr. Song Li
This is the part 3 of a comparison on Data Access methods in the .NET environment.
A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET
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.
A Connection String Manager for Multi-Environment Ecosystems
by #realJSOP
This library is intended for use in a multi-environment system, but it certainly be used under less stringent environmental confines, even down to a single desktop machine taht needs to connect to a single database server.
A convenient DataGrid Pager Control
by zhengdong jin
It's very easy to use and the most conventient DataGrid pager control.
A conversion of the popular DotNetNuke web application to C#
by andrewcates
In an attempt to open DotNetNuke to a wider audience, I have converted the original VB code into C#
A Crontab Linux like Windows Service
by marcominas
A Windows Service that uses interface to work like the Linux Crontab service
A Customized Crosstab Report
by Nanaa
An approach on how to organize your data into tables that will help you generate large ‘Crosstab’ Reports using SQL Server.
A Fairly Capable Authorization Sub-System with Row-Level Security Capabilities (AFCAS)
by Kemal Erdogan
An implementation of role-based authorization control (RBAC) model with row-level access control capabilities at the database server level
A Fast and Lightweight Solution for CQRS and Event Sourcing
by Daniel Miller
Describes a fast, lightweight implementation of the CQRS+ES pattern using C#
A general-purpose service engine for unattended processing execution
by Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
A generic bulk insert using DataSets and OpenXML
by poodull76
Create T-SQL command text to update a table with OpenXML quickly and with minimal effort.
A generic loading of data in a DropDownList using caching mechanism
by santosh poojari
This article shows you how to make use of DataAccessLayer and caching.
A guide to using Paneled Forms, Multi-Splash Screens, SQL Express, and many more in Windows Application Development
by msalmank
A quick hands-on application to guide you in using paneled forms, multi-splash screens, SQL Express, and many more....
A helper object to migrate SQL Reporting Service items
by Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
A JSON Data Modeling Guide
by Eric Bishard
In this article, we hope to provide resources that will help you hit the ground running on your path to learning about document databases and Couchbase.
A lightweight AJAX.NET-enabled grid control
by Simon Gulliver
A lighweight approach to creating AJAX.NET-enabled grids, with advanced functionality built in.
A LINQ Tutorial: Adding/Updating/Deleting Data
by Abby Fichtner (Hacker Chick)
A tutorial that walks through adding/updating/deleting data in your database with LINQ to SQL while keeping your class relationships (M:M, 1:M, and M:1) synchronized.
A LINQ Tutorial: Mapping Tables to Objects
by Abby Fichtner (Hacker Chick)
A beginner's LINQ tutorial that walks you through mapping your SQL Server database tables and relationships to objects, and how to retrieve that data via simple LINQ queries.
A LINQ Tutorial: WPF Data Binding with LINQ to SQL
by Abby Fichtner (Hacker Chick)
A tutorial and application on using WPF Data Binding with LINQ to SQL classes. This is part 3 of a three-part tutorial on using LINQ to SQL.
A Master-Detail Solution Using Single Input Controls
by TofuBug24
Shows a solution for creating a Master-Detail relation using textboxes.
A method to migrate and automate exisitng DSTX SSIS package from SQL server 2005 to 2008 R2
by santosh poojari
This article will provide the first step towards migrating error free dtsx package to higher version of sql server ssis
A Model to Represent Directed Acyclic Graphs (DAG) on SQL Databases
by Kemal Erdogan
Addressing the general problem of representing directed acyclic graphs (DAGs) in SQL databases
A Naming Scheme for Database Tables and Fields
by Robert Pittenger, MCPD-EAD
This article presents a naming scheme for database tables and fields.
A Neat Solution to GridView Custom Paging
by Fadrian Sudaman
This article shows how to easily extend the GridView to support custom paging and remove the restriction of using ObjectDataSource as the data source.
A not so simple firewall.
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.
A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation
by Niladri_Biswas
This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.
A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses
by Jesus Carroll
SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.
A Practical Example Of Using The New Features Of ASP.NET 3.5
by Mike Borozdin
Tutorial on using LINQ, ListView, LinqDataSource, DataPager, ASP.NET AJAX
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 5
by Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
A propertymapping Extension for DataReaders
by Jörgen Andersson
A propertymapping extension for DataReaders
A Quick look at the new functoids in BizTalk Server 2006
by Naveen Karamchetti
This article describes the new functoids in BizTalk Server 2006.
A scheduler GUI for SQL Server Agent
by Alberto Venditti
An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs
A scripted SQL query generation framework with IDE: SQLpp (v1.4)
by Jonathan de Halleux
A helper framework for generation of SQL queries in C++ and Lua
A set of ADO classes - version 2.20
by Carlos Antollini
Simple database access using an ADO class.
A Set of ADOX Classes
by Carlos Antollini
Simple database catalog access using a set of ADOX classes
A Set of MFC Wrapper Classes for ADO - Version 2.20J
by Joffrey Brouillet
This is an alternative for "A set of ADO classes - version 2.20"
A set of ODBC Classes
by Carlos Antollini
Two classes that make easy to work with ODBC
A simple count() query class
by Paul S Ganney
A class to easily do count() queries.
A simple Database Viewer - DBViewer
by Uri Lavi
A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).
A simple example of SQL server admin tools.
by Md. Marufuzzaman
A simple example of SQL server admin tools.
A Simple GUI Tool for SQL 2005 Reports Deployment Without using BI Development Studio
by Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
A Simple RSS News Generating Tool
by Stephan Pilz
A tool to generate/manage news and provide news via RSS.
A Simple Use of SQL CASE Expression
by Md. Marufuzzaman
This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.
A Simplified SQL-CSV Import/Export Functionality
by codeajay
A simplified SQL-CSV import/export functionality.
A SQL Management Console for MSSQL 2000 & 2005, MySQL 5.0,...
by gan.gary
An article on a SQL IDE for different type of RDBMS databases
A SQLProcedure For MSSQL 2005 Of CustomPaging With RowNum And CustomPaging Without RowNum Both For MSSQL 2000 And MSSQL 2005
by qubing
WITH Clause AND EXEC sp_executesql Clause Used In MSSQL 2005
A Standard ETL Sample in SSIS
by Keshav Singh
This video demonstrates a standard extract-transform-load in SSIS
A strategy for implementing database source control
by Redgate Software
This article describes what was required of our database source control solution, the challenges we faced and how we approached them, and how using Redgate SQL Source Control as a template helped.
A Tool to Compare SQL Database Schema Versions
by Lindsey Lewis
An article about a tool for comparing SQL database schema versions
A T-SQL Regular Expression Library for SQL Server 2005
by Steve Abraham
This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.
A uniform interface for large texts for a C# SQL client
by AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
A very simple example for creating a media gallery using VS 2005, C#, and SQL Server 2005
by code-frog
Provide a very simple set of instructions for creating your own media gallery and loading your images from SQL Server 2005.
A web based application configuration wizard
by defwebserver
A wizard that allows you to FTP an application to a remote server and then launch the configuration wizard from the web browser to update the database connection.
ABCs of Pro*C
by vipulparmar
Basic understanding of Pro*C
About transaction log and its truncation in SQL Server
by Wendelius
Article describes basic information about transaction log behavior and truncation of the log.
Abstract Nonsense in Software Development. Databases
by Petr Ivankov
Application of abstract approach to database domain
Abstracting the ORM Framework
by JP van Mackelenbergh
Abstracting the ORM Framework via Repository/Unit Of Work patterns
Accelerate Web Site Development with Kentico CMS - Content Management System for ASP.NET
by Petr Palas
Do you spend days and nights developing dynamic web sites in ASP.NET? Do you need to simplify your job, get more sites done and gain more clients? Kentico CMS for .NET will help you.
Access .NET assembly through SSIS (Script Component)
by Malpani Amol
Here is some cool stuff to call .NET assembly from SSIS
Access SSIS package activities and variable through .NET application
by Malpani Amol
This article will drive you, how to access and update properties and variable of SSIS package using .NET application
Accessing dBase Files
by thomask
How to access a dBase file
Accessing MS SQL Server CE v1.0/v2.0 without ADO
by CT CHANG
Add, edit, and delete records/table/database in MS SQL Server CE v1.0/v2.0.
Accessing MSMQ from Microsoft SQL Server
by Wojtek Jeziorczak
How to send/receive MSMQ messages in SQL Server using CLR Integration
Accessing the Borland Database Engine (BDE) from Visual C++
by Robert Pittenger, MCPD-EAD
Accessing the SQL Server Virtual Device Interface via .NET (C#)
by Steve Abraham
This article is an introduction to the SQL Server Virtual Device Interface and how to access it via any .NET language
Active Directory change tracking
by Snorri Kristjansson
Active Directory change auditing solution. A Windows Service that stores selected AD change events from the Security log of all Domain Controllers to an SQL database.
Active Directory Query using CLR Stored Procedure
by Snorri Kristjansson
A SQL server CLR Stored Procedure that can query the Active Directory directly in T-SQL code
Active Directory Tool
by yairrose
Active directory tool - helps manage active directory oparations (query, update and delete) with easy to use GUI
AD, SQL Server, GMail synchronizer tool
by michael.neubrander
Multi account synchronizer for GMail, AD, and SQL Server.
Add "Select All" to parameter lists in SQL Reporting
by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
Add a user in SQL Server using Visual C++
by xiaojin
The article explains adding a user in SQL Server programmatically, using VC++
Add some AI to your combo box lookups
by hector [.j.] rivas
Helping the combo box autocomplete function with a frequency count.
Add/Drop LinkedServers using SMO
by arunpv
Add/drop Linked Servers using SQL Server 2005 SMO
Adding Custom Assemblies in SQL Server Reporting Services 2005
by Mohamed Abdelghani
How to add custom code and custom assemblies to reports in SQL Server Reporting Services 2005
Adding DOC, RTF, and OOXML Export Formats to the Microsoft Report Viewer Control
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.
Adding DOC, RTF, and OOXML Export Formats to the Microsoft Report Viewer Control: Implementing It Easier Using Private Reflection
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.
Adding EntityFrameworkCore Support to .NET Core Project
by Benktesh Sharma
Demonstrate how to add EF support in .NET Core project
Adding values to a dropdown using AJAX
by Ganesan Sankaran
How to add values to a dropdown using AJAX.
Address Book and Events Reminder
by SHRIDHAR TL
Allows to maintain and backup your contacts and also maintains a reminder. You can store data in any of the three different databases like Microsoft SQL Server, MySql, Microsoft Access
Administrate SQL Server2000 from Pocket PC
by rasheed1979
This article demonstrates administrating SQL Server 2000 from Pocket PC on the fly.
ADO at a Glance
by M. Shokuie Nia
A simple introduction to using ADO
ADO Connection Strings
by Carlos Antollini
A list of ODBC DSN Connection Strings.
ADO Data Bound Class Wizard
by Ly Nguyen
ADO Data Bound Class Wizard
ADO MFC Wrapper classes
by Tim Kohler
ADO classes that closely resemble CDatabase and CRecordset.
ADO.NET 101: SQL Connection
by mysorian
A tutorial on connecting to SQL 2000 Server.
ADO.NET and OPENXML to Perform Bulk Database Operations
by mfmaneef
Explains how to send bulk records to a database using OPENXML.
ADO.NET and Stored Procedures Code Generator
by Johnny Worker
A VB code generator that reads a SQL Server table and generates ADO.NET code and also Stored Procedures.
ADO.NET Asynchronous SQL Calls
by gbd77rc
How to use asynchronous calls to SQL to receive progress information
ADO.NET Data Access Component for SQL Server in C# and VB.NET
by AdamNThompson
A data access component for SQL Server in VB.NET.
ADO.NET DataTable as XML parameter to an Oracle/SQL Server Database Stored Procedure
by Bibhas Paul
ADO.NET DataTable as an XML parameter to an Oracle/SQL Server database Stored Procedure.
ADO.NET Interview Questions: Part 1
by Shivprasad koirala
Ado Dot Net Interview Question Part 1
ADO.NET Interview Questions: Part 2
by Shivprasad koirala
ADO.NET interview questions: Part 2.
ADO: 101-level Tutorial
by Kevin Wittmer
101-level tutorial on ActiveX Data Objects
Advanced SQL 2005 SQLNotificationRequest Functionality with C#
by Todd Wilder
Using the SQLNotificationRequest object and the Service Broker to get row and column change notifications, mimicking supposed SQLDependency capabilities
Advanced SQL Server Monitor with Performance Graph, Analysis and Version Control
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
Agile Development: Part 2
by Shivprasad koirala
A quick FAQ of Agile.
Agile software development methodologies and how to apply them
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.
agStoredProc
by Alexander German
With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.
AJAX DataGrid
by Andrew Golik
This article demonstrates the use of the AJAX technique in tandem with the JavaScript DataGrid from my previous article.
AJAX Event Calendar (Scheduler) for ASP.NET MVC in 80 Lines of Code
by Dan Letecky
How to build an AJAX Event Calendar (Scheduler) using the open-source DayPilot Lite for ASP.NET MVC library (Apache License 2.0).
AJAX grid with ASP.NET 2005
by LeleHalfon
A great AJAX Grid very customizable. In English & Spanish traduction
AJAX Stock Symbol Drop-down List
by Thanh Huu Nguyen (Tony)
Look up a huge list of stock symbols from MS SQL database
AJAX, WCF, LINQ to Entities demo application
by Kurush Rastkar
Using most of the recent technologies in one application
AJAX-enabled Name Selector User Control
by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
Alternate Rows Coloring in SQL Reporting
by Jay Kulaindevelu
To change the row colors in reports.
Always Encrypted Feature in SQL Server 2016
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
Amazon Web Services part 2 - Adding a database to your web site
by Matt Perdeck
Add a database to your web site on AWS with automatic fail over using RDS
An accurate, repeatable process for data migration
by Redgate Software
Using a combination of iScala, SQL Server and Red Gate's software tools to manage data processes.
An Alternative to Sync Data from SQL Server to MySQL
by scott_liu
It employs a dynamic trigger, a CLR Stored Procedure, and a Web Service to sync data from a MS SQL Server to MySQL.
An alternative way to the MSWord Render extension of SQL Reporting Services using XSLT and XML document mapping
by n_ahid
SQL Reporting Services doesn’t support exporting reports to MSWord yet. Using render extensions for exporting MSWord is not so easy. This article describes an alternative way of converting a SQL report to an MSWord file.
An Approach to Viewing the Structure of a Database Using VB 2005
by salysle
This article describes an easy approach to examining all of the tables, views, and columns in a database.
An Easy But Effective Way to Split a String using Transact-SQL
by Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
An Easy to Use Wrapper for SQLite3 (Totally Free Embedded Database Engine!)
by Daniel Cohen Gindi
I have created classes to wrap the SQLite3 library, to remove many headaches...
An Easy Way to Cache Static Data in ASP.NET
by ToddHileHoffer
Improve performance by caching an application's look up data
An Easy Way to Get a File Name or a File Extension from a User Defined File Path using Transact-SQL
by Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
An End-To-End LightSwitch HTML Example
by defwebserver
Step-by-step tutorial to create a HTML5 LightSwitch application
An Experimental Performance Comparison on the Methods to Pass Structured Data to SQL Server Stored Procedures from ADO.NET
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.
An indespensible SSIS transformation component - Script Component
by Niladri_Biswas
This article will demonstrate as how to work with SSIS Script component with two live example
An Intelligent Data Layer
by Ferhat Nutku
An article on communicating with a database and generating SQL queries on the fly
An Interactive SQL Console
by wizofaus
An interactive SQL console application written to improve upon the "osql" console application that comes with SQL server
An Introduction to Sql 11 (Code Name Denali) –Part I (SSMS Features in CTP 1)
by Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from a SSMS perspective
An Introduction to Sql 11 (Code Name Denali) –Part II (T-Sql Features in CTP 1)
by Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from a T-Sql perspective
An Introduction to Sql 11 (Code Name Denali) –Part III (SSIS Features in CTP 1)
by Niladri_Biswas
In this article we will explore on the new features that Denali has offer us from SSIS perspective
An Introduction to Sql 11 (Code Name Denali) -Part IV (Contained Database in CTP 1)
by Niladri_Biswas
In this article we will look into the basics of Contained Database that has been shipped with Sql 11 (Code Name: Denali) CTP 1
An Introduction to Sql 11 (Code Name Denali) –Part V (SSIS Features in CTP 3)
by Niladri_Biswas
In this article we will explore on the new features that Denali CTP3 has offer us from SSIS perspective
An Introduction to Sql 11 (Code Name Denali) –Part VI (T-Sql Features in CTP 3)
by Niladri_Biswas
In this article we will explore on the new features that Denali CTP 3 has offer us from a T-Sql perspective
An Introduction to Sql 11 (Code Name Denali) –Part VII (Column Store Index in CTP 3)
by Niladri_Biswas
In this article we will explore on the Column Store Index- A new feature in SSIS Denali CTP3
An Introduction to Sql 11 (Code Name Denali) –Part VIII (Data Quality Services(DQS) in CTP 3)
by Niladri_Biswas
In this article we will explore the Data Quality Services(DQS)- A new feature in SSIS Denali CTP3
An Introduction to SSIS Balanced Data Distributor Transformation Component
by Niladri_Biswas
In this tutorial, we will learn about SSIS Balanced Data Distributor (BDD)
An OLE-DB DLL that you can use in ANSI-C
by roboo
An OLE-DB DLL that you can use in ANSI-C
An Overview of Log Shipping in SQL Server 2005
by Abhijit Jana
Overview of Log Shipping in SQL Server 2005
Angular 2 Custom Controls with ASP.NET Core WebAPI
by Nesreen Maged
Angular 2 Type Script Custom Controls Integrated with ASP.NET Core web API
Anonymous Personalization Trick in Web Parts
by Daron Yndem
My favorite feature of ASP.NET 2.0 is Web Parts. But the anonymous users in ASP.NET cannot save personalization data and can't use Web Parts design options. This article describes how we can solve this problem in a tricky way.
Another C# SQL class
by formlesstree4
Another article on C# .NET SQL, but with smarts
Another Embedded Database For C++
by AnOldGreenHorn
A C++ wrapper to SQLite database
Another Simple ADO Class
by Christopher W. Backen
Another simple yet cool ADO class for your project - from zCoders.com
Ansychronous triggers and cursors
by h_wiedey
Asynchronous processing of triggers using cursors
AppFabric Installation Failed Because Installer MSI Returned with Error Code: 1603
by Melick
How to resolve the issue: AppFabric installation failed because installer MSI returned with error code: 1603
Application Generation Comes of Age
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.
Application to migrate data between different environments using the ADO.NET 2.0 SqlBulkCopy
by siva pinnaka
This article explains how to migrate data between different SQL Server environments.
APPLY Operator of SQL Server 2005
by Mohammed Ghouse Barq
APPLY operator is a new feature in SQL Server 2005 used in FROM clause of a query. It allows you to call a function-returning TABLE for each row of your outer TABLE. We can pass outer table’s columns as function arguments.
Applying Robustness Analysis on the Model–View–Controller (MVC) Architecture in ASP.NET Framework, using UML
by Shams Mukhtar
This article will enhance your vision on the usage of Robustness Analysis in conjunction with Model View Controller, using UML with application in ASP.NET. This article is a sequel to my articles on Architecture and Design with ASP.NET.
Arabic currency conversion from numbers to letters
by Wael R. Mansour
Convert numbers to characters for Arabic applications.
Architectural Best Practices - Automating SQL Parameter Creation and Assignment
by Anton Pious Alfred
Most systems that use Stored Procedures make use of SQL parameters to send and receive information from the database. The code to create these SQL parameters and then populating them is repeated throughout the system. This article describes how to automate this code.
Architecture Guide: Windows Forms, Generics, Auto-Mapper, Entity Framework, Framework Design, and many more..
by Nirosh
Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.
Archive all SQL Server backup (Full, Diff, Log) dynamically
by mparvez
How to archive all backup (Full, Diff, Log) in a single archive file using 7zip.
Are Using Bitwise Operators for Table Joins Really Taboo?
by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
Armadillo: Unit Testing of inline SQL with a little help from Attributes and Reflection
by Pedro J. Molina
This article provides a way for automatically testing SQL embedded in your Data Access Layer (DAL) before publishing a new release of your application.
Armstrong Number Generation Within a Range (In SQL Server)
by Niladri_Biswas
How to generate an Armstrong number between 0 and 999.
Array Parameter Handling in a Stored Procedure
by Srinath Gopinath
How to handle an array parameter in a Stored Procedure [SQL Server].
Artisan Way of Data Reply
by Vadim Loboda
A way to deliver more details about an error or exception from an SQL Server database through an ASP.NET web application to a web client.
Artisan.Orm or How to Reinvent the Wheel
by Vadim Loboda
ADO.NET Micro-ORM to SQL Server
ASCII/Multibyte to Unicode Conversion
by carlop()
An article about converting ASCII/Multibyte to Unicode using C# and SQL/CLR integration.
ASP.NET 2.0 Custom SQL Server ResourceProvider
by Jeff Modzel
How to create your own ASP.NET 2.0 custom resource provider to replace resource files (resx) with SQL Server.
ASP.NET and SQL 2000 Reporting Services
by mysorian
Walkthrough of generating a report from a SQL 2000 Server using the Reporting Services.
ASP.NET authentication and authorization
by Shivprasad koirala
ASP.NET authentication and authorization
ASP.NET Best Practices for High Performance Applications
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.
Asp.Net C# JQuery base Web Application for Rapid Web Presence
by tanvon malik
visinia can be used expand to create a website through module drag drop
ASP.NET Caching Interview Questions: Part 2
by Shivprasad koirala
ASP.NET Caching Interview Questions Part 2
ASP.NET configuration management: an alternative to web.config
by Alberto Venditti
An alternative and flexible way to manage config settings for multiple web applications.
ASP.NET Core 1.1 and Identity Adventures
by Vlad Neculai Vizitiu
ASP.NET Core 1.1 and Identity Adventures
ASP.NET Core and Blazor on Mac: Dockerizing Applications
by Vincent Maverick Durano
A step-by-step demo on how to build and dockerize ASP.NET Core and Blazor apps on MacOS
ASP.NET Custom Control + Crystal Report Dynamic Text Format
by Sachin Somanath Mumbare
Custom control for display client formatted text in Crystal report
ASP.NET MVC Flexigrid sample
by Todd Smith
How to create an ASP.NET MVC sample using LINQ to SQL, Flexigrid for JQuery, and JSON.
ASP.NET MVC-5 CRUD Using AngularJS
by Shashangka Shekhar
In this article we will get a short overview on AngularJS, then we will create a ASP.Net MVC-5 CRUD application using AngularJS(v1.4.8).
ASP.NET Report Kit Grasshoper (Race to Linux)
by osohare
Porting and deploying the report starter kit to Linux (RH7.3/Tomcat5.0.28/Grasshoper1.61)
ASP.NET Reports Starter Kits Porting from Windows to Linux (Race to Linux)
by Abi Bellamkonda
ASP.NET Reports Starter Kit Porting from Windows to Linux using Mainsoft's Grasshopper
ASP.NET session state store provider for MySQL
by Harry Kimpel
A brief description on how to set-up MySQL as session state store for ASP.NET.
ASP.NET Time Tracker Starter Kit Port to Linux using Mainsoft's Grasshopper
by Mark Cafazzo
Race To Linux - How to port a Visual Studio .NET web application to the J2EE Framework on Linux
ASP.NET TimeTracker Starter Kits Porting from Windows to Linux (Race to Linux)
by Abi Bellamkonda
ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper
ASP.NET using GridView Control as Lookup
by Amit K Bhagat
ASP.NET using GridView control as lookup
ASP.NET Web API - Keeping It Simple
by kannankeril
This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.
ASP.NET WebForms: Uploading and Importing CSV File to SQL Server
by Vincent Maverick Durano
A quick demo that highlights how to upload and import CSV file to SQL Server database in ASP.NET WebForms.
Asynchronous LINQ to SQL
by Rabb Moshe Plotkin
How to make a responsive application by not having to wait for your LINQ to SQL to return from the server
Asynchronous Query Execution
by Vachik Hovhannisyan
Two classes that provide support for asynchronous SQL execution.
Asynchronous Setup Grid
by Babak Ansari
A custom asynchronous setup with progress indicator.
Asynchronous T-SQL Execution Without Service Broker
by Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
ATL OLE DB Consumer Template Schemas
by João Paulo Figueira
Exploring SQL CE 2.0 schema information with the ATL OLE DB Consumer Templates.
Audit for DB programming
by jangtimjang
Do you want to know what your DB programmers are doing?
Audit Tables and Data Versioning on SQL Server
by Rick Drizin
Simple structure for keeping SQL Server Auditing Tables and Versioned Records in the same set of tables, using Audit Triggers and Entity Framework
Audit Trail – Tracing Data Changes in Database
by Petr Kozelek
Logging of data changes in relational databases
Audit Trail Generator for Microsoft SQL
by Cedric Baelemans
Discussion of audit trail techniques and a script to automate audit trail implementation on a Microsoft SQL database
Audits on MS SQL Server 2008
by Keshav Singh
An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.
Authenticate .NET Core Client of SQL Server with Integrated Security from Linux Docker Container
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.
Authorization Filters in ASP.NET Web API 2 & AngularJS
by Shashangka Shekhar
In this article, we are going to explore the security issue which will help us to prevent unauthorized access of web API access using custom Authorization Filter.
Auto Adjusting Date Ranges on Entry of a New Range using SQL
by acarpio1975
Given date ranged data, adjust existing ranges on entry of a new ranged data.
Auto Binding a TreeView control from a self referencing table
by Bassam Saoud
A Custom TreeView Control that supports auto binding from a single self referencing table
Auto-discover Oracle TNS service names with COSidHelper class
by li@agileinfollc.com
An article on how to discover Oracle TNS service names.
Autogenerate Unit Tests For Your Database Objects - Visual Studio 2019 & 2022 (amd64) Extension
by Bert O Neill
Features and functionalities associated with Autogenerate DB Unit Test app
Auto-Generating a Comprehensive C# Data Access Layer
by adamAFA46
Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.
Automate query execution by using xml and helper class
by ashishinfra
The generalized class has static functions that return dataset and datareader objects , It accepts string(name of xml tag that stores the query) and value to be supplied in case query accepts parameters
Automated Database Change Management Process
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.
Automated Salesforce Data Replication with SQL SSIS and BIML
by Jerod Johnson
This article demonstrates how to use Biml with custom SSIS components to dynamically build SSIS tasks (one for each Salesforce entity) to replicate Salesforce data to a Microsoft SQL Server database.
Automatic Code Generation from Database Model Diagram
by Abdullah Al-Muzahid
This is a RAD tool which can be used to generate codes for CRUD operation in ASP.NET and C# automatically based on Database Model Diagram.
Automatic Script SQL Server 2005 Objects and Commit under Subversion
by Ferreri Gabriele (Megasoft78)
Automatic script SQL Server 2005 objects and commit under Subversion
Automatic SQL Server Backup Utility using sqlserveragent
by Joshy_geo
Automatic SQL Server Backup Utility using sqlserveragent
Automatic Table Generation in any Database by NHibernate ORM and CodeDom for Code Generation
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.
Automating the SQL Database Mirroring Setup
by Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
Automation Helper for Stored Procedures in C#
by Jeff Bramlett
Helper classes for automation of stored procedures
AutoRefresh Entity Framework Data Using SQL Server Service Broker
by Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
Auto-SQL DataGrid component Part II: The full-featured version
by Sangra
ASQLDataGrid is a useful component when working with RDBMS applications. It is capable of automatically constructing and executing SQL statements based on its properties.
Auto-SQL DataGrid component. Part I: Non-editable version
by Sangra
ASQLDataGrid is a useful component when working with RDBMS applications. It is capable to automatically construct and execute SQL statements based on its properties.
Avoid single line comments in query to OLE DB Datasource
by db_developer
OLE DB Provider pack all query to single line, thus all query text after comment clause will be truncated
Avoiding Database Deployment Disasters – 7 Tips
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.
Azure FAQ Part 1
by Shivprasad koirala
Azure FAQ Part 1
Backup Microsoft SQL Database and Upload to FTP
by funklet
Make backups of SQL databases and upload them to FTP server
Backup SQL Server with Relative File Path and Progress
by theit8514
This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.
Backup System Databases in SQL Server
by Sujit Mandal
Backup System Databases in SQL Server
Basic CMS Framework in C#
by Raymund Macaalay
The basic foundation on how to build your own Content Management System.
Basic Handling and Types of Database Relationships in Entity Framework
by Ws Hu
This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.
Basics of Using a .NET Assembly in MS SQLServer - User Functions
by MrTimmins
Introduction to using CLR .NET assemblies in Microsoft SQL Server.
Beginners guide to a secure way of storing passwords
by StianSandberg
This article will explain how to securely store users passwords in a database.
Benchmarking the Performance of Embedded DB for .NET: SQL CE 4.0 vs SQLite
by Alexander Galkin
Provides a sample code for a simple test bench application and compares the performance of two most common embedded databases for .NET: Microsoft SQL CE 4.0 and SQLite.
Best Practice in File Storage while Building Applications - Database (Blob Storage) Vs File System
by Ziyad Mohammad
This article explains the best strategy to be followed while designing data storage applications by System Architects
Binary Copy files in T-SQL with helps of CLR
by Levente Kupás
Managing SQL backups can be more simple by using this FileRelay CLR
Bind Image from Database to DataGrid (web Application)
by Anandhi Swamy
Handles uploading /downloading images into/from database to DataGrid
Binding dropdowns using Ajax
by Ganesan Sankaran
How to populate a dropdown in another dropdown change
Binding to Database Key/Code Tables with Caching
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.
BizDraw framework for .NET
by Hayder Marzouk
A small framework to design and print documents containing shapes, text, images, bar codes...
BizTalk 2006 Consuming a Web Service and Publishing Orchestration as Web Service and Calling from ASPX
by Himanshu Thawait
This sample shows BizTalk 2006 consuming a Web Service, then publishing orchestration as a Web Service, and calling it from ASPX.
BooProd.Core - Context sensitive Connexion String
by Boo!
This article is to help you create context sensitive connexion string: choosen dynamically, depending on which server the application is running.
Brief about Triggers in SQL Server 2000
by SquaredRomi
A trigger is a database object that is bound to a table. In many aspects, it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure".
Bringing Control Back to Database Deployment with ReadyRoll and Entity Framework Code First Migrations
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.
Build a Silverlight 2 Web Chat Application
by junnark
We are going to build a simple web chat application using Silverlight 2 and the technologies surrounding it like, ASP.NET 3.5, C#, WCF, and LINQ-to-SQL. We will use MS SQL Server to store user details and messages from this chat room.
Build a Silverlight Web Chatroom with Multiple Rooms and Private Chat - Part 2
by junnark
In Part 1, we built a simple web chat using Silverlight 2. We are going to add functionalities so that users are able to choose from multiple chat rooms as well as chat privately with other users.
Build a Web Chat Application using ASP.Net 3.5, LINQ and AJAX (in C# 3.5 or VB 9.0)
by junnark
We will create a very simple web chat application using the latest ASP.Net 3.5 technologies from scratch.
Build Configurations for Publishing SQL Server Database Projects
by mohghaderi
Add Debug/Release deployments to SQL Server database projects using build events and powershell
Build SQL Server Stored Procedures From Information_Schema Tables
by Dwight Johnson
Save hours of time by creating stored procedures and code from database metadata.
Building a Basic Test Data Generator for Books in SQL
by Haroon Ashraf
This article helps beginners to generate over million records of random test data for a database object like books in SQL.
Building a Business Day and Holiday Database Subsystem
by Paul Reynolds
This is phase 1 of a 3 phase project. Phase 1 accesses a public holiday Web Service, and loads a SQL Server table that can drive dating and aging logic on large sets of data and assist in creating fast-performing queries and reports.
Building a Database Application using OLE DB
by Yulianto
An article on building a Database Application with OLE DB
Building a Framework - Part I (DAL)
by V.
First article on creating a reusable framework
Building a Hybrid Active Directory and SQL Table DataSource View
by noahhath
Building a hybrid Active Directory and SQL table DataSource view.
Building a Shared Code Library as a VS.NET Plug-in
by paul heap
A plug-in for VS.NET that stores code snippets in a database. From the plug-in you can add code, search the database for code snippets. Also includes examples on how to integrate with the IDE as a plug-in.
Building a Web Message Board using Visual Studio 2008, Part I - The Basic Message Board
by Rama Krishna Vavilala
This article builds a web based message board and uses several new technologies introduced with Visual Studio 2008 such as LINQ, WCF Web Programming, WCF Syndication, ASP.NET ListView, ASP.NET DataPager etc.
Building an N-Tier Application in VB.NET, in 8 Steps
by Vimalsoft(Pty) Ltd
This article will show you how to build an N-Tier application in VB.NET.
Building an SQL Logic Engine
by Steve Marsh
This article describes how to build a logic engine entirely in SQL. In the context of our example, a logic engine is a program that takes in a set of variables and corresponding values, evaluates a set of predefined conditions and builds a result set based on which conditions were found to be true.
Building ASP.NET Reporting OLAP-Based Application Part-2
by Ramy Mahrous
How to build Reporting ASP.NET Web application
Building Better Test Data with SQL Provision
by Redgate Software
This article presents a method that allows us to use SQL Provision to build consistent, compliant, useful databases, on demand, for development and test environments.
Building Blocks For ASP.NET Applicationa: Part 1
by Agha.net
This is a series of articles providing Building Blocks for any ASP.NET application.
Building Dynamic SQL In a Stored Procedure
by John-ph
This article explains about building and executing a Dynamic SQL in a stored procedure.
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
by Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
Building managed code using Common Language Runtime (CLR) Integration in SQL Server 2005
by Sekhar Lanka
This article talks about CLR integration and how to program database objects using managed code by using this cool feature of SQL Server 2005.
Building REST services with ASP.NET Core Web API and Azure SQL Database
by Jovan Popovic(MSFT)
How to build REST services with ASP.NET Core Web API and Azure SQL Database
Building robust middle tier
by rafael_p
One of the many solutions to build a quick and robust middle tier.
Building Your First Analysis Services Cube...
by Bhushan W. Juare
How to build you first analysis service cube
Bulk CRUD Operation using XQuery and Reflection in ASP.NET
by Shahriar Iqbal Chowdhury/Galib
Easy approach to implement bulk CRUD operation using Xquery, reflection in ASP.NET with example
Bulk INSERT / UPDATE / DELETE in LINQ to SQL
by Muhammad Shujaat Siddiqi
This article discusses SET based operations involving INSERT / UPDATE and DELETE using LINQ to SQL.
Business Logic with Entity Framework
by Bishoy Demian
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
Business Object Introduction
by derekliang
This article is going to be served as an introduction to Expert C# 2005 Business Object by RockFord Lhotka which was written for business application developer.
Business Objects for CodeSmith
by JR Hull
Save time when developing large applications, by using code generation for your business objects.
C# and Table Value Parameters
by gaurav_verma_mca
How to send bulk data using table value parameters from C#
C# Code Generator for Stored Procedures
by PaulMcKenzie
This stored procedure will generate all the C# code for calling any Stored Procedure
C# Coding Standards and Best Programming Practices
by T Manjaly
Anybody can write code! With a few months of programming experience, you can write "working applications." Making it work is easy, but doing it the most efficient way requires more work than just making it work!
C# Project on Database for Beginners
by Hasan Habib Surzo
Class, Database Connection, Login Winform
C++ Hibernate
by Edwig Huisman
A hibernate framework for C++
C++ Object Oriented Database Generator
by Robert Pittenger, MCPD-EAD
This project is a code generator to produce CObject-dervied data classes for Object-Oriented database management
C++ wrapper for Oracle's OCI Interface
by lihaijian
This article will provide a cross platform C++ wrapper for Oracle's OCI interface.
C++ wrapper for Sybase's OPENCLIENT Interface
by lihaijian
This article will provide a cross platform C++ wrapper for Sybase's OPENCLIENT interface.
Cache IQueryable for Better LINQ-to-SQL Performance
by Zimin Max Yang
An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.
Caching Interview Questions: Part 1
by Shivprasad koirala
Some caching interview questions: Part 1.
Calculate exponential function with Taylor series in SQL Server
by Mehdy Moini
Iteration without curser is one of database programmig arts, in this article i have tried to calculate exponential function with taylor series
Calculating simple running totals in SQL Server
by Wendelius
Some simple scenarios to calculate running totals in SQL Server.
Calculating Tree Cost in Microsoft SQL Server
by mihirj
This article explains database schema design for storing tree structure and an algorithm to compute its cost.
Calendar control in Data Grid in C#
by kokilaB
Trigerring a Calendar in a Datagrid
Call a Web Service using SSIS then Store and Query the Results
by Michael Lockwood
How to call a web service using SSIS, store XML results and then query XML using XQuery
Calling a Web Service from a SQL Integration Services package
by Simon Bonello
How to call a Web Service from a SQL Integration Services package.
Calling Stored procedures in ADO.NET
by sandeep@s
An introduction to executing SQL Server stored procedures and how to retrieve the return parameters
Cancellable SQL Server Query
by Scott G Blood
A Cancellable threaded query for SQL Server using .net 3.5
Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode
by Md. Marufuzzaman
Cannot alter Microsoft SQL Server 2008 Table Object in design mode
Capitalize the first character in SQL Server
by Erik Bartlow
This user-defined function will allow you to capitalize the first character of any string passed to it.
Capture of a Typical SQL Server Database Workload
by Tomáš Bauer
Capture of a Typical SQL Server Database Workload
Cascading Dropdonlist in ASP.NET
by Avinash Desai
Cascading dropdown list in asp.net using MYSQL database
Catharsis Tutorial 02 - Catharsis Example
by David O'Sullivan
See how Catharsis can help you rapidly develop robust enterprise level applications.
CByteArrayFile - storing objects in databases using DAO
by Daniel Kaminski
A class used to serialize object into a database field
CDC - Change Data Capture
by Donsw
Audit of SQL inserts, udpates, and deletes
Central Key Management
by Brian Bayless
A central key manager for multiple web server clients in a web farm.
Century Date Tables
by John Bevilaqua
SQL DDLs for creating table structures and inserting the data for a set of tables suitable for producing pick lists for validation of the Month Names, Month Numbers, Days in each Month and Years in the 20th Century
Change Data Capture (SQL Server 2008)
by Muhammad Shujaat Siddiqi
Change Data Capture in SQL Server 2008 (shujaatsiddiqi.blogspot.com)
Chapter Exerpt - SQL Server Integration Services
by Packt Publishing
This tutorial describes the details of copying a Table from Oracle 10G XE to an SQL Server 2005 database using a SSIS
Check Database Size with Summary
by Kuldip Rindani
This script calculates size of every user database with summary
Check that Sql Server exists prior to connection
by Greg Osborne
Validate existence of Sql Server
Check Validity of SQL Server Stored Procedures, Views and Functions
by IPC2000
A handy command line tool that checks whether stored procedures, views and functions in a database compile
Check Validity of SQL Server Stored Procedures/Views/Functions (updated)
by Emil Lerch
Command line tool to check validity of objects in SQL Server databases
Checking the New DST 2007 from a DBA Perspective
by jamesplewis
How to check if your Microsoft SQL Server 2005 is ready for the new DST 2007
Choosing between XML and SQL in .NET Content Management Systems
by Petr Palas
This article compares various approaches to storing, editing, and displaying structured content on the web. It shows the advantages and disadvantages of using XML and relational SQL databases.
Clear the transaction log
by Fernando Finelli
dump the transaction log
CLinq - LINQ support for the C++/CLI language
by Tomas Petricek
CLinq project is a library that makes it possible to use LINQ technologies from the C++/CLI language
Cloning rows in T-SQL with their foreign key constraints
by Christopher Liu
When you copy a row with a primary key, bring other tables that reference it along for the ride!
Cloud Service to Automate Windows Desktop Applications
by Won Dong
To utilize cloud service as an anonymous desktop environment in Amazon S3 and EC2 Windows instances
CLR Function for Persian Date Converter in Microsoft SQL Server
by Ali-DN
CLR Function for Persian Date Converter in Microsoft SQL Server
CLR Stored Procedure and Creating It Step by Step
by Virat Kothari
CLR Stored procedures are very simple and can be used in most complex scenarios when dealing with database.
CODBCAccess: a CDatabase and CRecordset Wrapper
by Alexander Wiseman
A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases
CODBCRecordset Class
by Stefan Chekanov
CODBCRecordset class is intended to be a full replacement of all ClassWizard generated CRecordset derived classes in MFC projects.
Code First Approach using Entity Framework 4.1, Inversion of Control, Unity Framework, Repository & Unit of Work Pattern and MVC3 Razor View
by Akhil Mittal
My effort in this article was to put some light on building a generic multilayered architecture using Entity Framework 4.1 and MVC3 razor view engine.
Code First Stored Procedures
by aureolin
Access Stored Procedures using Code First.
Code First with SQL CE
by Damijan Vodopivec
Sample Code First project with SQL CE 4.0 database
CodeSmith generated Audit Log Triggers
by RichardRoe
CodeSmith template for creating Audit Log Triggers on SQL tables.
Coding an N-Tier Application in C# without any Wizard - Part I
by Vimalsoft(Pty) Ltd
Beginner to intermediate in N-Tier
Coding an N-Tier Application in C# Without Any Wizard: Part II
by Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
Combination of Id-ParentId and HierarchyId Approaches to Hierarchical Data
by Vadim Loboda
Combine Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order
Combining External Data Sources with a MS SQL Server Database to Create Google Maps Using AJAX and ASP.NET
by MarkWei
To dynamically generate a Google Map with combined data sources from an external web service or API and from an internal MS SQL database, using AJAX and the ASP.NET environment.
Committable Transactions in C#/SQL
by skennedyny
Simple console app which shows how to use the .NET CommittableTransaction class
common functions oftenly used in projects
by Rohit Wadhwa(Devp)
Common Table Expressions(CTE) in SQL SERVER 2008
by Sunitha Sudheesh
Coding in SQL with Common Table Expressions (CTE)
Compare SQL Database Schema
by Paritor
Application to show differences between two SQL Server databases.
Comparing Rows in SQL Server and Azure SQL Database
by Jovan Popovic(MSFT)
How to easily compare two rows in SQL Server using new JSON functionalities
Comparison of Triggers in MS SQL and Oracle
by h_wiedey
The article treats the differences between triggers in Oracle and MS SQL and demonstrates the mutating table problem.
Complete Guide to Install SharePoint in a Three Server Farm using AutoSPInstaller
by Melick
This is a complete guide to install SharePoint in a three server farm using AutoSPInstaller
Complete Remote (Intra/Inter) SQL Server Manager
by Chaudhary
SQL Server manager for remote monitering and managing.
Complete SQL Server Mail Service
by SachinD@13
SQL Server Job Agent for SQL mail service with attachment of Excel file
Composable DML and Merge Statement in SQL Server 2008
by Robin_Roy
Simple example to show how Composable DML works in SQL Server 2008.
Composite Login Control
by vikas vohra
This article shows the implementation of Composite Server Control to provide Login features
Computed Column Specification in SQL Server
by Padoor Shiras
Computed Column Specification for populating nth column
Concatenate Field Values in One String Using CTE in SQL Server
by Navdeep Bhardwaj
Concatenate field values in one string using CTE in SQL Server.
Concurrent User Updates in ASP.NET and SQL Server
by Murali Pamidi
ASP.NET - Concurrent user updates using the Timestamp column in SQL Server.
Configure Database Mail, Operator and Notifications 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.
Configure MS SQL Server 2005 Remote Access ( mixed mode )
by hong_wei_li@yahoo.com
Configure MS SQL Server 2005 Remote Access ( mixed mode )
Configure Named Pipe and TCP/IP Settings of SQL Server
by Hardik.Sheth1717
How to configure Named Pipe and TCP/IP settings in SQL Server
Configuring Database Access for an ASP.NET Application
by Eugene Mirotin (Guard)
Demonstrates the easiest way to use all the advantages of SqlDataSource and GridView, and to allow flexible DataSource configuration.
Configuring Database Mail in SQL Server
by Kareem.S
This is an enterprise solution for sending mails from the SQL Server database engine to SMTP servers.
Configuring IIS, ASP.NET, and SQL Server
by Juan Davel
This article is an updated one discussing the configuration of IIS, ASP.NET and SQL Server.
Configuring Plastic SCM Database Backend
by parallelcoder
Configuring Plastic SCM database backend
Configuring SQL Server Accent-Insensitivity
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.
Connect to SQL Express 'User Instances'
by Patrick Spieler
Manage and profile SQL Express 'User Instances'.
Connecting to Database Express 2005 with VS 2005
by efero
Codes to help to connect VS 2005 to SQL Express manualy
Connecting to Database SQL Express 2005 with VS 2005
by efero
Connecting to SQL Express Manualy
Connecting to Database Using Custom Webpart in Sharepoint 2007
by Hithendra Reddy
Building Custom Webparts to interact with Database
Connecting to MySQL or SQL-Server from COBOL using ADO.NET
by alex turner
How about a .NET COBOL program which uses ADO.NET to connect to either MySQL or SQL Server?
Connecting to SQL Server
by User 4838655
This article explains how to connect to an SQL Server and pass a string.
Connecting to SQL Server using MVVM Pattern
by Ravindra T C
The Model-View-ViewModel (MVVM) design pattern, why MVVM has to be used, and how to work with SQL Server using the MVVM design pattern.
Connection Pooling in ASP.NET
by Muhusin Khan
Effective perfomance for database application uses database
Connection Pooling in multithreaded applications
by User-Rock
Approaches describing a design to handle connection objects and pools in C#.
Connection Scope for the Entity Framework
by Rainer Halanek
A Connection Scope for the Entity Framework that allows to execute commands in a single connection
Connectivity to SQL Azure in Microsoft SQL Server 2008 R2 November CTP
by Ramy Mahrous
Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1
Constructing Web Interfaces on the Fly
by Gil Shabat
Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.
Consume 32 bit COM DLL in x64 Bit SQL Server 2005
by Aneesur Rehman Khan
Consume 32 bit COM DLL in x64 bit SQL Server 2005
Consuming a Web Service created through Sql Server HTTP Endpoints via Web Service task in SSIS
by Niladri_Biswas
In this article we will see how we can consume a web service expose through HTTP Endpoint via Web Service Task of SSIS
Consuming Webservice using JQuery ASP.NET Application
by Rajendra Malav
Consuming webservice using JQuery ASP.NET application
Continuous Database Integration
by Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
Continuous Integration for Database Development
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.
Continuous Integration for Databases with Visual Studio
by Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
Control trigger logic based on user
by Wendelius
This article describes a mechanism how trigger actions bypassed based on database user information
Controlling IP traffic from Internet to DMZ or Intranet
by snp157
Controlling IP traffic from Internet to DMZ or Intranet
Controlling the XML output when using the FOR XML AUTO statement in SQL Server
by BackyardHackMechanic
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
Convert a Hexadecimal to int using Microsoft SQL
by topcatalpha
An article on how to convert a Hexadecimal to int using Microsoft SQL
Convert a Text File to a PDF File
by Florence FZ Li
This article shows how to convert a text file to PDF.
Convert DateTime To .NET Ticks Using T-SQL
by Eron Wright
Convert a datetime value to .NET-compatible Ticks using a T-SQL User-Defined Function. Useful for interoperation between .NET and unmanaged environments such as ASP and VB6
Convert Query Result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report
by Wiltek Ghozali
This utility is used for convert query result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report, supported SQL Server and ODBC connection.
Convert SQL Server DB to SQLite DB
by liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
Converting a Windows 7 desktop application to Windows 8 and Azure
by DThrasher
Converting a Windows 7 desktop application to Windows 8 and Azure.
Converting Strings to DateTimes for Use in ADO.NET Parameterized Queries using the Data Access Applications Block 3.0
by ritzcoder
This article shows you how to take a date string and use it in a parameterized sql server query
Cool DVD Movie Catalog
by Dannover Arroyave M.
Developing a catalog of DVDs
Copy Data from a DataTable to a SQLServer Database using SQLServer Management Objects and SqlBulkCopy
by Aaron VanWieren
How to copy data from a modified dataset into a SQL Server Database
Copy Database Wizard (MS SQL Server 2005 and later)
by Keshav Singh
How the Copy Database Wizard can be helpful to users working on upgrades and migration projects.
Copy Files from One Location to Another and Rename Them after Putting Time Stamp
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
Correct Column Ordinals of an ADOX Table Object
by Ferdie
Getting the correct column ordinals of an ADOX Table object.
CppSQLite - C++ Wrapper for SQLite
by Rob Groves
A C++ wrapper around the SQLite embedded database library.
Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table
by Syeda Anila Nusrat
Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.
Create a Custom Settings Provider to Share Settings Between Applications
by Antony Highsky
This article describes how to leverage .NET Application Settings architecture to give distributed applications access to shared settings.
Create a Database during the installation of a .NET application - Version 1
by Mukund Pujari
This application can be used to create databases, tables, stored procedures during the installation of .NET applications.
Create a Modified On Column in SQL Server
by james.wren
How to add a modified on column in SQL Server using triggers.
Create a SQL Database Programmatically
by Moustafa Refaat
In this article, I will explain how to use Microsoft SQL Management Objects (SMO) to create a Microsoft SQL database from C# code.
Create a Web Based Non-Typed Crystal Reports Application
by junyaoxu
This article explains how to build a generic and data bound Web based Crystal Reports server.
Create an SQL Server Database Using C#
by Phuong Thanh Nguyen
Create a SQL Server database using C#.
Create and Populate Date Dimension for Data Warehouse
by Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
Create and Populate Treeviews Dynamically
by Nagasai Mattegunta
An article on Database Driven Dynamic multiple Treeviews
Create CLR Stored Procedure with Visual Studio Express Edition
by Manar Ezzadeen
Create CLR Stored Procedure with Visual Studio Express edition
Create custom transformation component(Email Validator) in SSIS- Step by step
by Niladri_Biswas
In this article we will look into how we can make a custom SSIS transformation component.The custom component is a simple
Create data driven PDF on the fly by using SQL server reporting service (SSRS)
by simonp_ca
A free, mean and lean way to create data driven PDF on the fly by using SQL server reporting service (SSRS)
Create database during installation of a .NET application - Version 2
by Mukund Pujari
This application can be used to create database, tables, and stored procedures during the installation of a .NET application.
Create database in sql server using asp.net with C# (VS2005)
by Joshy_geo
Create database in sql server using asp.net with C# (VS2005)
Create Drill-Through Reports using ReportViewer in ASP.NET 2.0
by ShirleySW
This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0.
Create Drill-Through Reports using ReportViewer in ASP.NET 2.0
by ShirleySW
This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0.
Create Drill-Through Reports using ReportViewer in ASP.NET 2.0
by ShirleySW
This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0.
Create First OLAP Cube in SQL Server Analysis Services
by Mubin M. Shaikh
Learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data Warehouse
Create First SSRS Report with SQL Server Analysis Services OLAP Cube
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
Create INSERT batch files easily with ScriptBuilder
by Gordon Kushner
Utility program for generating SQL Server INSERT scripts
Create md5 Hash-code using Assemblies in SQL Server 2005
by Denis Strukachev
Create md5 hash-code using assemblies in SQL Server 2005
Create Primary Key using Entity Framework Code First
by Dukhabandhu Sahoo
Explore the Entity Framework Code First convention and configuration for creating primary key
Create Sample Application Using Entity Objects In C#.Net
by justindhas
Create Sample Application Using Entity Objects Using C#.Net
Create SQL Server Database Unit Tests
by Bert O Neill
Create unit tests for your stored procedures\triggers\functions and integrate into TFS continuous integration cycle
Create SQL Server Database using asp.net
by Jatin Prajapati
Here I am showing, How to Create SQL Database and Run SQL Script File Using asp.net.
Create SQL Server Management Studio 12 Addin
by Bert O Neill
Develop your own SSMS ObjectExplorer\CommandBar menus, within SQL Server 12
Create View To Get All Constraints For Any Tables
by Rami Said Abd Alhalim
Create View To Get Constraints
Create Your Own SQL Server Management Studio 17 (SSMS) Extension
by Stefan Timovski
A short tutorial on how to get started with creating SSMS extensions
Creating 3DBarChart using ASP.NET 2.0
by Ravikumar Commuri
How to Create 3DBarChart with Graphics, Bitmap Objects in ASP.NET 2.0
Creating a DAL with SubSonic
by Michael Ceranski
Creating a DAL with SubSonic.
Creating a Database-Driven Google Gadget
by Bryan Sachdeva
This article demonstrates how to create an auto-refreshing Google Desktop Gadget that pulls data from a database.
Creating a Date Process Library and WCF Service for Date and Age Processing
by Paul Reynolds
This is phase 2 of a 3 phase project. This phase accesses the database created and loaded in phase one to expose an API of common business date functions.
Creating a Domain Service Factory to Host POCO Entities
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.
Creating a DotNetNuke Module with Custom Permissions
by Frauke
Tutorial on how to add custom permissions to a module's settings.
Creating a Private Installation for SQL Compact
by David Veeneman
This article discusses how to create a private installation for SQL Compact
Creating a Simple Help Desk Application
by Ben Demes
A demonstration of how you can quickly create a simple help desk application using modern development tools with little to no hand coding required.
Creating an OLE DB Data Provider
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.
Creating and Deploying Reporting Services using Custom Assembly
by alifaraze
Custom assembly and reporting services
Creating Auto-Suggest Textbox Using ASP.NET 2.0 Client Callbacks
by azamsharp
Implementing an auto-completion feature using ASP.NET 2.0 client callbacks
Creating CRUD operations using the SqlNetFramework and CodeSmith
by Luis Ramirez
This article shows you how to generate SQL code for CRUD operations using the SqlNetFramework and CodeSmith.
Creating CSV from SQL Database table attaching it to MS word as datasource and then creating mailmerge document
by Member 3209760
Creating CSV from SQL Database table attaching it to MS word as datasource and then creating mailmerge document
Creating DAL Components Using Custom ASP.NET Build Providers And Compiler Techniques
by Jürgen Bäurle
This article describes how to create Data Access Layer Components (DALC) using ASP.NET build providers and a self-defined description language in C#, including an easy scanner, parser, and CodeDOM generator.
Creating Date dimension from scratch in Microsoft SSAS
by Miljan Radovic
Script to generate DimDate for specified date range
Creating Excel Sheets using ODBC
by Alexander Mikula
Writing to Excel spreadsheets using only ODBC
Creating Log file for Stored Procedure
by sarvesh.upadhyay
In this articleI am going to show how to create log file for stored Procedure
Creating Managed Objects in SQL Server 2005
by Nishith Pathak
Creating managed objects in SQL Server 2005.
Creating Pocket PC Application Setup Packages Using the CAB Wizard - 2
by Girish Nurani Sankaranarayanan
An article describing the implementing of Custom actions in Pocket PC application Setup packages.
Creating Simple API in Node.js
by Saineshwar Bageri
How to create a simple API in Node.js and use MS SQL as a data source to perform CRUD operation
Creating Simple Audit Trail With Entity Framework Core
by DiponRoy
Store all data change history in a table using Entity Framework Core
Creating Time Dimension in Microsoft Analysis Services
by Igor Krupitsky
Unlike Date Dimension (with Year, Month, Date), Time Dimension (with Hour, Minutes, and Seconds) is not automatically created by SSAS (Microsoft SQL Server Analysis Services). This article explains how to create and use Time Dimension in Microsoft SQL Server Analysis Services.
Creating User-Defined Data Types in SQL Server 2005
by subai
An article on how to create user defined data types using .NET languages for SQL Server 2005.
CRM Customization - Import Leads from Excel via Email into MS CRM
by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
Cross Domain/Platform Authentication and Data Transfer
by Tomz_KV
Introduces a methodology for authenticating user in cross domain/platform and transferring user data from one site to another during the authentication process.
CRUD Operation in ASP.NET Web Applications Using HTTP Handler and jQuery
by Jigar Bagadai
Easy approach to implement AJAX in ASP.NET without using an AJAX control
Crystal and Reporting Services FAQ Part 1
by Shivprasad koirala
Crystal and Reporting Services FAQ Part 1
Crystal Reports with Dynamic Number of Columns with Typed Dataset
by Abdul Quadir Saifee
Creating Crystal reports with dynamic number of Columns with Typed dataset with SQL Server 2005
CrystalReports Push Model with .NET
by Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet
by Yap Chun Wei
A Class to Read and Write to Excel and Text Delimited Spreadsheet
CSV to SQL Server
by Igor Krupitsky
This application lets you copy tables from folder with CSV files to SQL Server
CTE In SQL Server
by Keshav Singh
CTE In SQL Server
Custom Aggregates in SQL Server
by Wendelius
SQL Server not having the aggregates you need? Why not build your own.
Custom Assemblies in SQL Server 2005 Reporting Services
by Krishna Prasad V.R.
This article focuses on the problems you might face and the probable solution when using .NET custom assemblies. This article also gives in-depth details of modifying .NET assemblies for which you do not have the source code.
Custom Code-Generator Using ASP.NET Core
by Shashangka Shekhar
In this post, we will get an overview and generate a basic level code using our database table column that will help in development.
Custom Membership Providers - Task Manager
by Karthik. A
This article extends what was built in the previous article. This is a task manager application that uses the custom provider designed in the last part.
Custom MembershipProvider and RoleProvider Implementations that use Web Services
by Shaun Wilde
Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.
Custom MSBuild Tasks: Automated Report and DB Deployment
by Thiago Silva
Automate your Reporting Services report deployment and scripting and database tasks by using these custom MSBuild tasks.
Custom paging with ASP.NET GridView
by tanweer
Easy way to implement ASP.NET GridView paging .
Custom print procedure in MS SQL 2000/7/6.5
by Abhay Dubey
This procedure can be called in another Stored procedure or function and quite handy in debugging and development
Custom Resource Reader
by Palwinder Singh
Implementing custom resource reader with database
Custom Roles Based Access Control (RBAC) in ASP.NET MVC Applications - Part 2 (Role Based Reporting)
by Stefan Wloch
An introduction to Custom Roles Based Reporting for ASP.NET MVC applications using the Entity Framework. Protecting confidential information is a business requirement and in many cases also an ethical and legal requirement.
Custom Rule Engine in WPF - MVVM
by Renil Joy, Bangalore
Custom Rule Engine approach which can evaluate complex combinations of business rules. A sample application is provided in WPF following the MVVM pattern.
Custom SSIS Control Flow Component
by Ray Gorski
Create a custom control flow component for SQLServer 2005 Integration Service
Custom String Split Function with Few Enhancements
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.
Custom Web Visitor Tracking using C#
by Haja
When the IIS log is not sufficient for your web analytics , you can use this simple technique to track the extra data about visitors of your web page
Custom XML file(s) named from a database fields
by Cristi Paraschiv
Custom XML file(s) named from a database fields (Sql Server 2005 DB)
Customary Functions of GridView in ASP.NET 3.5
by Behrouz Rad
The most advanced things which you can do with GridView in ASP.NET 3.5
Customer Order Mapping
by rodney128
A windows Azure development to showcase online geocoding and mapping.
Customize Entity Framework Core Migration History Table
by DiponRoy
Options to customize EF Core migration table
Customize the built-in Outlook Select Names dialog (or any other)
by Helmut Obertanner
In this article, you will learn how to customize the built-in Select Names dialog and use different external data sources for your own dialog.
DACBuilder – Data Access objects generation tool based on XML and XSL templates transformation
by Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
DAL Class and Transact-SQL Generator for C# and VB.NET
by Hamidreza-Ghasemkhah
Automatically generates the required class and stored procedure to work with SQL databases
DALC4NET: A Generic Data Access Layer for .NET
by Ashish Tripathi
DALC4NET is an Open Source data access layer built for Microsoft .NET projects. It enables us to access data from databases including SQL Server, Oracle, MySQL, MS Access, and MS Excel.
Danger Dodger
by Brian Legg
Danger Dodger will keep track of the amount of danger you're in at any given point in time and help you to avoid it.
DAO library extension
by Kevin Smith
My added DAO functionality makes database reading and writing easier
DarkSide SQL Mini Version 1, The embedded database
by AnOldGreenHorn
An embedded database library in C++.
Dashboards Are For Driving
by Steven A. Lowe
Dashboards are immensely useful not only for business data but also for business applications, but only if they display metrics that can be used to "drive" (or "steer") in real-time.
Data Access Application Block .NET 2.0: Get Return Values, Output Values
by rperetz
Using SqlHelper in .NET 2.0 and getting return values and output values.
Data Access Component
by zhongzf
An open source Data Access Component
Data Access Layer (DAL) with SqlWrapper library
by Andrey Shchurov
With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.
Data Archive
by Nikolai Serdiuk
This article describes creating indexed search systems using relational databases
Data Auditing Tool (Audit Trigger Generator)
by J.Jash
Data Auditing Trigger Generator
Data binding a ListView
by theoutlander
An overview on inheriting a ListView and implementing design-time data binding capability.
Data Driven Subscriptions in SQL RS 2000 Standard
by Jason Selburg
How to implement data driven subscriptions in SQL RS 2000, Standard edition.
Data Driven Unit Testing for a DotNetNuke Private Assembly Module
by Bruce Chapman DNN
Using data driven unit tests with SQL Server CE for DotNetNuke private module development.
Data Encryption/Decryption using RSACryptoServiceProvider and X509Certificate2
by ranajitbiswal
Data Encryption/Decryption using RSACryptoServiceProvider and X509Certificate2
Data Entry application with PIVOT processing in GridView
by Ole Oren
Describes building a WorkGroup TimeSheet with GridView
Data Generator for SQL SERVER 2000,2005 and MSDE
by ganesan balachandar
The tool can generate the specified number of rows for any table. Can be used for stress testing the application
Data Manipulation from SQL Server Source Through Controls and LINQ
by Emiliano Musso
How to access, display, modify SQL Server data (tables, etc.) through Windows Forms controls and LINQ instructions, using DataSets and TableAdapters
Data Mining with SQL Server 2005 without Analysis Services
by kvlcek
A C# implementation of CHAID for MSSQL 2005 à la Cognos scenario.
Data Mining: An Introduction to Neural Networks in SQL Server
by Harinder Saluja
Implement Neural Network in SQL Server
Data Structure Implementation to Query Binary Tree for Upline / Downline Node without using Recursion
by AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
Data Synchronization in SQL Express
by Ganesan Krishnan
Data Synchronization in SQL Express
Data Transformation from Rows to Columns Using Dynamic SQL
by Tomz_KV
A custom solution to transform data from rows to columns using dynamic SQL.
Data Transformation Services Package Progress Dialog
by Rashid Thadha
Show a progress dialog when you execute your DTS Package at runtime.
Data Version Control on MS SQL Server (using a generic trigger)
by Martin Lachman
How to create a system on MS SQL Server for detection of actual changed records in a database table.
Data Versioning in SQL Server using Snapshot a.k.a. Row Versions
by Wendelius
Enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems using Snapshots
Data Visualization in WPF with LINQ to SQL and Data Binding
by Bruno Sonnino
This article will show how to use data binding and styles to show data coming from a Microsoft SQL database using the new object-relational model introduced in Visual Studio 2008, LINQ to SQL, allowing grouping, sorting and filtering of data with almost no code.
Database Build Tool
by Duncan Edwards Jones
An extensible tool to package and deploy database schema objects
Database Class ADODB Command Recordset VB6 ADO FILE HANDLING OPEN
by M Saqib Ali
It is an object of database where we connect the data SQL Server and do working in sqlserver.
Database Comparator
by Amir Mehrabi-Jorshari
With this tool, you can compare two databases and generate a difference report.
Database Concurrency Patterns - SIP and SUP
by George Zabanah
Take a look at two new patterns to help with database concurrency: SIP and SUP.
Database Deadlocks for Dummies
by Andrew J Dixon
Explaining Database deadlocking to non-technical people
Database Development using Visual C++ and OLE DB: Establishing the connection
by emadns
How to start a connection using ATL OLE DB consumer classes and how to obtain a session so that you can use it to query or edit the database.
Database Documentation - Microsoft SQL Server 2005/2008
by pavan k vadlamudi
Creates database documentation table(s) schema
Database Driven Banner Rotator Control
by hussain.attiya
A database-driven banner rotator control rotating based on a specific time (and not on page refresh). Each banner will have a display time (in seconds) to move to the next one.
Database Export Wizard for ASP.NET and SQL Server
by Olivier_Giulieri
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
Database fields merge for any Office product, just with XML
by mc_kappa
Using this simple, yet elegant and powerful code, you can provide to your users efficient Office document merging; simply exploiting XML technology and basic string manipulation.
Database Helper Class Library to Ease Database Operation
by falconsoon
Database Helper Class Library to Ease Database Operation
Database Image Viewer
by Zoodio
This application will permit the user to create tables in SQL 2000. It will also permit the user to save and view images from the database
Database info tool
by Massimo Colurcio
Explore the structure of tables (and views)
Database local cache
by konamiman.MSX
A C# class that uses the local file system to cache binary objects stored in a database.
Database Mirroring In MS SQL Server - Part I
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.
Database Mirroring In MS SQL Server - Part II
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.
Database Mirrors with Differing Vendors
by Dr Bob
SQL Server ISS can simplify database mirrors across multiple vendors
Database performance optimization part 1 (Indexing strategies)
by Kanasz Robert
In this first part of series of articles about database performance optimization I will discuss about indexing strategies and index maintenance.
Database performance optimization part 2 (Index maintenance)
by Kanasz Robert
In this second part of series of articles about database performance optimization I will discuss about index maintenance.
Database Resetter
by Michiel de Rond
A little tool to make life while developing with databases a little easier.
Database Scale-Out Strategies for Web Apps
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.
Database Schema Comparison Utility
by Sean Goodpasture
An article describing a way to find the differences between two database instances
Database Schema Versioning Management 101
by Peter Weissbrod
An introductory approach to synchronizing database schema versions
Database script execution with test
by S. M. Ahasan Habib
Database script execution with testing
Database Snapshot in MS SQL Server
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.
Database table editor framework
by db_developer
This article consists of a data layer and forms for database tables editing.
Database to XML Exporter
by Orkun GEDiK
Learn how to export database fields to XML document
Database Utilities for C#
by Redskin9
A series of Database utilities for lookup and data manipulation written in C#
Database Viewer and Updater for any Database
by avronp
View and update any database table and metadata. Includes sample databases.
Database Visualization
by VGirish
This article aims to create a simple tool for visualizing database tables and relations, a database map to refer to.
Database Worst Practices – New Town and New Job and New Disasters
by pinaldave
5 Database Worst Practices which can be fatal to any business
Database-Driven Business Layer Templates
by dakeefer
A introduction to the flexibilities provided by the use of SQL extended properties in business layer code templates.
Databinding .NET Schedule Controls
by DBI Technologies Inc.
What’s the best method for binding schedule controls to a database? A response is normally focused on the needed implementation; however, business rules can be used to define strategic implementations. This Showcase uses Warehouse Shipments and Dock Scheduling as a metaphor for exploring the topic
DataBinding in WPF Browser Application using SQL Server Compact
by RameshSengamalai
DataBinding in WPF Browser Application using SQL Server Compact
DataGrid & Paging using Ajax
by asithangae
Achieving the DataGrid functionality with paging using User control and Ajax
Datagrid Cell Tooltip
by Thiru Sagadevan
Showing Tooltip for each cell with data of a table in a Datagrid
DataGrid Cell Tooltip
by Y. Shahabudeen
Simple datagrid tooltip of each cell values and header tooltip
DataGrid Paging - C# Windows Forms
by Manoh
DataGrid paging using C# Windows Forms - Select only the required (page size) records from the table.
DataGrid Paging Using DataReader - C# Windows Forms
by Manoh
DataGrid paging using DataReader.
DataGrid View with "CRUD operations" using Dojo DataGrid, JsonRest Store, Entity Framework, SQL Server, ASP.NET MVC Web API
by Nikfazan
DataGrid View with "CRUD operations" using Dojo DataGrid, JsonRest Store, Entity Framework, SQL Server, ASP.NET MVC Web API
DataLayer - Freeware ODBC Library
by darkoman
An article on a simple ODBC SDK wrapper library.
DataStore - A template class for creating sequential access record files
by AnOldGreenHorn
A template class for creating sequential access record files
DataTable with SelectDistinct in C#
by vacen2
Allows you to perform a Distinct query against a Datatable
DataTable with SelectDistinct in VB
by vacen2
Allows you to perform a Distinct query against a DataTable.
Date and Time as Separated Types
by iMuhamad
use date and time as separated components in SQL Server 2000 and above
DayPilot - AJAX Monthly Event Calendar for ASP.NET MVC in 10 Minutes
by Dan Letecky
Create an AJAX monthly event calendar (with drag and drop support) displaying data from SQL Server database in just 10 minutes (including a coffee break).
DayPilot Gantt Chart for ASP.NET
by Dan Letecky
How to display AJAX Gantt Chart in ASP.NET application.
Dazzling Dashboards and Business Intelligence with Azure Synapse Analytics Part 1: Overview
by Raphael Mun
In this article, we explore how Azure Synapse Analytics combines all the tools business intelligence specialists and data scientists need to analyze data and create visualizations.
Dazzling Dashboards and Business Intelligence with Azure Synapse Analytics Part 2: Importing and Analyzing Business Intelligence Data
by Raphael Mun
In this article we learn how to import and analyze business intelligence data.
DB Manual Copy Visual Studio 2005 Add-In
by Tommi G
Add-in for copying SQL Server 2005 Express data files between project main folder and output folders.
DB2 Access Classes
by nickadams
A set of classes to encapsulate DB2 CLI APIs in ADO style.
DBA Skills for developers
by DataBytzAI
Useful things to know for developers put in charge of an MS database server
DbExpressions - A Step Towards Independency
by seesharper
An abstract syntax tree implementation for SQL
DBF to SQL Server
by Igor Krupitsky
Application lets you copy tables from folder with DBF files to SQL Server
DBInspector - Making the case for code generation
by Mark Williamson
DBInspector is a swiss army knife for database developers. DBInspector helps you generate all types of code based on your database schema.
DBMapper - A New ORM Tool
by Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
DbProvider profiler using WCF and DbProviderFactory Injection: Part I of 4
by Pieter Van Parys
Explains the principles of profiling a DbProvider using proxy classes.
DbProvider Profiler using WCF and DbProviderFactory Injection: Part II of IV
by Pieter Van Parys
Creating profiling information in our ProxyDbxxx classes
DbToolbox: Utilities for data access and management
by Gregory Gadow
Database access and management can be a chore in .Net. This toolbox can make it easier.
DBTree
by MH2538
A DB Base Tree that load it's nodes from a table
Dealing with DataTables
by Star_Friend
All you want to know about how to deal with DataTables.
Decoding OpenGL Textures in Targa Format from an SQLite Database
by Michael Mangelsdorf
Framework for loading TGA image data from an SQLite table, decoding this data and binding it to OpenGL textures
Decrypt SQL Server Objects
by Kuv Patel
Decrypt Stored Procedures, Views, Functions, and Triggers in SQL Server
Defining Indexes with SQL Server 2005
by Indrajeet Sutar
All about SQL Indexes - Query Optimizer, Index, Unique Index, Clustered Index, Full Text Index, XML Index and SQL commands to create, delete, and rename SQL indexes.
Delete and Constraint Handling Stored Procedure Using SQL Server 2000
by Jeremy Mullinax-Hill
A generalized stored procedure that performs constraint checks before performing deletes.
Delete duplicate entries from a data store while leaving a single copy
by Tarek Najem
How to delete duplicate entries from a data store, while leaving a single copy.
Delete Functionality in GridView with Confirmation Using jQuery UI Dialog
by junnark
You're using a GridView web control to list records from a particular data source and you want a delete functionality for each row of data. A dialog must be presented to the user to confirm deletion. You also want to show a dialog to the user when an error occurs during deletion.
Delete mechanism.
by Tadas Budvytis
Explains a mechanism of deleting a record when the selected record has related records in other tables.
Delta Derivation With the Merge Keyword in SQL Server
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.
Deploy Analysis Services 2000 single Cubes
by Manuel C
This script permits to deploy single cubes from one server to another
Deploy and Debug CLR store procedure
by Malpani Amol
This article will drive you, how deploy and debug CLR store procedure
Deploy SQL Server databases easily with an Installer class
by Stefan Prodan
Deploy MS SQL Server databases using System.Configuration.Install and a VS.NET Setup Project.
Deploying Reports in Reporting Services Programmatically
by Ramy Mahrous
How to deploy your reports programmatically in away like BIDS
Deployment Of Web Application Executing SSIS Package In Web Server.
by santosh poojari
This article describes the prerequisite needed for .Net And SSIS integrated deployment.
Depth-wise Ordering for Trees in SQL
by Adam Hurwitz
Using a modified Adjacency List model in SQL, can you retrieve a depth-wise ordered subtree?
Design of a .NET brain dump for the forgetful software engineer
by User 1575800
Capture, storage, query, and transformation of quick notes and drawings before any actual design or programming.
Detailed SQL Server data audit through a .NET (CLR) trigger
by David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
Determine Holes in IDENTITY Columns
by DejaVudew
An article on an efficient method to determine missing values in an IDENTITY() sequence.
Determining Stored Procedure Parameters with SQL 2005
by gtamir
Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005
Develop high performance distributed applications with batching, asynchrony, and parallel computation
by Yuancai (Charlie) Ye
Performance comparison between SocketPro and .NET remoting.
Developing a Large Scale Application with a Single Page Application (SPA) using AngularJS
by Mark J. Caplin
AngularJS and the MVC/MVVM design patterns
Developing a SSIS Package
by karun123
An article on configuring an SSIS Package.
Developing a wireless workflow automation client on Pocket PC/PDAs with a Web Service
by Zenab_Zenab
This article focuses on developing a workflow client device application for Pocket PC in C# 2003.
Developing Facebook Application with .NET - part 2
by aleksisa
Developing Facebook Application with .NET - part 2 - FBML tabs, setFBML, FB:multi-friend-selector, setRefHandle, PublishAction and much more...
Developing Next Generation Smart Clients using .NET 2.0 working with Existing .NET 1.1 SOA-based XML Web Services
by Omar Al Zabir
Comprehensive guide to development of .NET 2.0 Smart Clients working with existing Service Oriented Architecture based XML web services, fully utilizing the Enterprise Library
Developing Office SharePoint 2007 application
by Moim Hossain
Describes how to develop custom business portal application using WSS 3.0 and Office SharePoint Server 2007
DEVELOPING SSIS in Visual Studio 2005
by hussain.attiya
DEVELOPING SSIS to import oracle records to sql server
Developing Web Report using Crystal Report in .NET 2005.
by Suranjan Nandi
The report is build on XML Schema and the data and binded the report at runtime.
Development Inline Comment while working in team
by Jigar Mehta
Inline Development Comments Automation
DevShot - Database Snapshots for Developers
by Tommi G
How to create runtime backups from SQL Server 2005 and restore them.
dexleapFTC, a full text engine made of pure Stored Procedures
by simonp_ca
Implement a full text engine by using Stored Procedures for all MS SQL Server editions.
Dictionary for Google Suggest like Dictionary
by smiling4ever
To make a dictionary that will work with Google Suggest like Dictionary.
Difference between And clause along with on and Where clause when used with left join in SQL Server
by Hafiz Muhammad Suleman
This article clears the differences between the On cluase and Where clause when used with left join.
Digging SSIS object model
by Moim Hossain
Describes SQL server 2005 Integration Service object model and different data flow components
DimDate Revisited (The Power of a View and Nested Whiles)
by Steven L. Wentworth (12896862)
Straightforward generation of and ensuring accuracy for DimDate values
Direct access to C++ native code from C++/CLI MSSQL Stored Procedure
by Peter Kovalchuk
Reading hardware information in Stored Procedure
Disaster Recovery Plan In MOSS 2007
by Tariq Younas
Article describes how to make backup and recovery plan of MOSS 2007.
Discover SQL: Dynamically recomputing columns
by Adrian Bacaianu
How to perform different computations for each row of a certain table, with each computation involving several columns.
Displaying , Exporting and Printing Crystal Reports in ASP.NET
by patelsachin
Displaying , exporting and printing crystal reports in ASP.NET with source code.
Displaying Data in Gridview
by Shining Legend
An article on how to display data in gridview
Distribute your site's contents with RSS 2.0
by AdamNThompson
Distribute your site's contents with RSS 2.0 using ASP.NET/VB.NET/MS SQL Server 2005.
Distributed Transaction between Microsoft SQL Server and MariaDB - A Myth
by BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
Document SQL Server 2000/2005 Database
by Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
Document SQL Server Databases with CatFactory.UI
by HHerzl
Document SQL Server Databases with CatFactory.UI
DotNetNuke Module Packager
by perlmunger
This article describes the DotNetNuke Module Packager application and source code. The application enables the user to generate DotNetNuke private assemblies that are useable out of the box from a custom module defined in the programmer's development environment.
Download file(s) from FTP Server using Command through SQL Server
by saddam_msp
Download files using T-SQL server which is very much faster then any other option.
Download SharePoint Zipped List Items
by Mohamed Zaki
This custom UI Action for SharePoint extends the lists action menu to allow users to zip document library items and download all of them with or without version.
Drag & Drop Shopping Cart Using ASP.NET MVC and JQuery
by Jigar Bagadai
Add interactivity to Shopping Cart Using JQuery and ASP.NET MVC
DTS Export
by KRISHNA PRASAD.N
Article to export MS DTS packages from one server to another.
Duplicate Rows/XML-Nodes Identification and Clean-up from Database
by S. M. Ahasan Habib
In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.
Dynamic Binding Of Hierarchy Data Structure To Treeview Control
by santosh poojari
The article provides a code base for implementing dynamic hierarchical data structure with ASP.NET Treeview control
Dynamic Creation of DTS-packages in VB
by Andrey Chuvahin
Example dynamic configuration of DTS-packages for transferring DBF files to SQL Server with VB
Dynamic Cross Tabs and Pivots, A Different Approach
by Kannan K R
In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.
Dynamic Cursor with sp_executesql and OpenXML
by Tina83
A cursor for dynamic query.
Dynamic Data Grouping Using Microsoft Reporting Services
by Asif Sayed
Generate multiple outputs from a single physical report template using dynamic data grouping.
Dynamic Document ID’s without maintaining Counters!
by Asif Sayed
An article to demonstrate the creating of business document ids without using stored counters.
Dynamic Excel file loading with SSIS
by Kuthuparakkal
SSIS and Excel Automation
Dynamic Generate Stored Procedures
by Rami Said Abd Alhalim
Create Stored Procedure to insert command on any tables
Dynamic Management Views [DMV] – A SQL Server 2005 Feature
by Hari Prasad K
The DMVs; newly introduced in SQL Server 2005 gives database administrator information about the current state of the SQL Server machine.
Dynamic Pivoting with Cubes and eventhandlers in SQL Server
by Herman.Instance
In this article, the creation of dynamic pivots are explained. This works on SQL Server from version 2005 and above!
Dynamic 'Sales by Week' Procedure in SQL Server
by Mike Ellison
An approach to creating an aggregate report with a set of dynamic columns based on dates.
Dynamically Create ASP Form from SQL Stored Procedure
by Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
Dynamically creating Excel File, ExcelSheets and Exporting Data from SQL Server using SSIS 2005
by Venkat Chaitanya Kanumukula
Export SQL Server Tables to Excel Files Dynamically
Dynamically Generating Html/Excel/Word Document Files with SQL Server data using SSIS 2005
by Venkat Chaitanya Kanumukula
Export SQL Server tables to HTML/Excel/Word Document files dynamically.
Dynamically restore full and all transaction log backup
by mparvez
Dynamically restore full and all transaction log backup.
DynamicParser: How to parse Delegates and Dynamic Lambda Expressions and convert them into Expression Trees
by mbarbac
Describes how to use C# dynamics to convert a delegate into an expression tree
Dynamics AX Data Maintenance & Migration Tips
by Venkat Chaitanya Kanumukula
Maintenance of Definition's in multiple Dynamics AX Environments
Easier Database Access with Diamond Binding (Part 1)
by Matty22
An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding
Easier Database Access with Diamond Binding (Part 2)
by Matty22
An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding
Easier Database Transactions - Extending the Using Statement to Perform Automatic Database Transactions
by Chad Z. Hower aka Kudzu
Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.
Easy application to detect and recognize faces with EmugCV
by Emanuel Santos
In this article i will show how to create a basic application to detect and recognize faces using EmugCV.
Easy Data Access
by Igor Tkachev
Run-time data accessor generation
Easy SQL Server Tool Using C#
by syed shanu
In this article, we will see how to create an easy SQL Server Tool.
Easy SQL-CE Access Utility in C#
by Bart-Jan Verhoeff
Access data in any SQL server compact edition datatable using only one line of code in C#
Easy way to create your Join queries
by Emad Al-Ashi
An easy graphical way to create complex nested SQL Join queries.
EasyODBC
by AnOldGreenHorn
An easy to use C++ wrapper class for ODBC.
EasySqlCe: easy access to SQL CE in C#
by Bart-Jan Verhoeff
An easy way to access your SQL compact edition database in C#
Editable GridView in ASP.NET 2.0
by Ashrafur Rahaman
This article will give you an overview of how to use an ASP.NET GridView completely, and how to use RowEditing, RowUpdating, RowDeleting, RowCommand, RowDataBound, RowCancelingEdit, and Pagination in a DataGrid. From this article, you will have a clear view of GridView data inserting, deleting, and
Editable GridView without ObjectDataSource Concepts
by Sasha Risner
A C# sample for binding a GridView to a DataTable with sorting, filtering, updating, deleting, and inserting allowed.
EF Core 5 Data Migration in .NET 5: in a Separate Library and Automatic Deployment
by kusnaditjung
How to create Entity Framework Core 5 data migration in .NET 5
EF Data Annotations and Code Fluent
by Nadege Rouelle
Shows how to configure Entity Framework Code First with Data Annotations and Code Fluent.
Effective paging with List View control in ASP.NET
by Abdul Quader Mamun
To develop scalable applications, effective paging is essential. Devoid of smart and effective paging and sorting to handle thousands of thousand data takes extra time and system resources.
Efficient Paging with Repeater and SQL Server 2005 / 2008
by perels
An efficient implementation of paging using a Repeater and the OVER() keyword in SQL Server 2005.
Eight steps to enable Windows authentication on WCF BasicHttpBinding
by Shivprasad koirala
Eight basic steps by which we can enable Windows authentication security on BasicHttpBinding.
Emoji and web application
by Tharaka MTR
Emoji; is the Japanese term for the ideograms or smileys used mostly in Japanese electronic messages and webpages.
Encrypting windows application connection strings
by Daniel Kuettel
This article shows a simply method of encrypting connection strings for windows applications
End-to-End Real World BlackBerry Application, Part 6
by MiamiCoder
How to create a real-world BlackBerry application.
Enhanced Document workflow approval v2
by Refky Wahib
This Article supporting these features: Logging to file, TransactionScopeActivity, WorkflowCommitBatchService, SqlTrackingService, fault Handler Activity and Bi-Directional communication using custom services
Enterprise Application Architecture with LINQ to SQL
by Rohit Gadagkar
A discussion about architectural patterns for using LINQ to SQL in enterprise applications, along with performance implications
Enterprise Application Architecture: Designing Applications and Services in .NET - Part I
by venugopalm
A guided tour of the distributed enterprise application design in .NET
Enterprise Application Architecture: Designing Applications and Services in .NET - Part II
by venugopalm
Database and Library Design for Customer Order Management System
Enterprise ASP.NET Suite
by David Hoyt
Easy to use ASP.NET suite that gives you everything you need to get started and makes it all pathetically easy to use - Windows services (with UAC), localization (webpage and e-mail), e-mail templating, configuration, and much, much more!
Enterprise Configuration Management
by gaurav_verma_mca
Configuration of .NET applications using database
Entity Factory - Get Your ORM-less Freak On!
by #realJSOP
A tool to generate model and viewmodel classes directly from your selected database
Entity Framework 4 EDMX Modifier - Correct Default Values in SQL Server
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
Entity Framework Performance
by Not Active
A comparison of performance between ADO.NET and Entity Framework.
Entity Framework with nHydrate
by Christopher R Davis, Michael S Knight
Generate an Entity Framework data access layer using an nHydrate model.
Entity Framework: Storing Complex Properties as JSON Text in Database
by Jovan Popovic(MSFT)
Mapping properties in EF model to database columns that contain JSON
Enumerate SQL Server Instances in C#, Using ODBC
by earmitage
An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on SQLDMO. Based on the C++ article by Santosh Rao.
Enumerate SQL Server using SQL DMO
by Rashid Thadha
Get a list of SQL Servers to which you can connect.
EpOraLibrary - A lightweight C++ wrapper over Oracle's OCI library
by Chris La
This is an alternative project of "OraLib - a lightweight C++ wrapper over Oracle's OCI library"
ERP INFRASTRUCTURE
by databaseobjectmodel
A sample infrastructure project such as erp, mrp, crm, admin panel.
Establishing an Existent Connection with a Sample: XML/A Script Execution Tracing
by db_developer
Establishing of an existent connection to SQL Server with a sample: XML/A script execution tracing.
ETL Testing, If Only An Automation Rule Testing Engine was Possible …
by Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
EvaLayout, Lay It Be!
by Alejandro Xalabarder
An efficient and flexible layout manager
Evaluating SQL Server Data Tools
by Torsten Tiedt
Database development with Server Data Tools
Event-Driven Architecture in the Clouds with Windows Azure
by John Mokkosian-Kane, Daniel Hsu
To demonstrate Azure and EDA, this article will show you how to build a flight delay management system for all US airports in clouds with Windows Azure.
Everything you wanted to know about State Management in ASP.NET
by chintu222
This article will emphasize on the mechanisms of State Management that are available with ASP.NET and the steps to learn and understand their implications for usability, performance and scalability.
Excecute SSIS package (DTSX) from ASP.Net
by santosh poojari
This article demonstrate the step by step procedure to create SSIS Package and Execute the same using ASP.net
Excel Report Generation Using XMLSS
by Sujith John Thomas
This article explores the concepts of XMLSS and its transformation to XL.
Exception Handling in 3-Tier Architecture
by Sohail Maroof, Farrukh Hashmi
Exception handling in 3-Tier Architecture using Enterprise Library
Exception Handling in SQL Server
by Erode Senthilkumar
How to handle the errors effectively in SQL Server?
Execute Access 2003 Macros in SSIS Package
by Deepu M.I
Execute Access 2003 Macros in SSIS Package. How to call Access Macros in SSIS Package
Execute DTS Through VB.NET
by Suresh Suthar
How to execute DTS packages through VB.NET and use global variables.
Execute SQL Server 2005 Integration Services package from C#
by Jeff Modzel
Learn how to load and execute a SQL Server 2005 Integration Services package from C# code
Executing a Web Service in a CLR Based Table Valued Function and Representing its IEnumerable Type Output as a Table in SQL Server
by Akbar Ali Bhatti
Executing a web service in a CLR based Table Valued Function resolving the problems faced during its execution and finally representing the IEnumerable output as a table in SQL Server.
Executing multiple SQL statements as one against SQL Server
by Wendelius
This article describes a few techniques for how multiple SQL statements can be executed with one SqlCommand.
Executing Raw SQL Queries using Entity Framework Core 6
by DiponRoy
Run Raw SQL Query - Entity Framework Core 6
Exploring Database Schemas on SQL Server
by Theo Spears
How to find out the schema details of any database quickly and easily, both from the GUI and using the SQL INFORMATION_SCHEMA features
Export a complete database to an Excel file
by Dennis Betten
Export all tables and data to an Excel file.
Export All Tables from Microsoft SQL Server Database in Flat File format (csv, txt) at one Go !!
by Mubin M. Shaikh
Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format
Export large data from a GridView and DataReader to an Excel file using C#
by Fuad Bin Omar
An article on exporting large data to excel file
Exporting Stored Procedure Results into Tables Dynamically with T-SQL
by Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
Exposing tabular data from your COM object - Part 1
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!
Exposing tabular data from your COM object - Part 2
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!
Exposing tabular data from your COM object - Part 3
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.
Extending Central Silverlight Business Rules to Client and Server Side Field-Level Validation
by Richard Waddell
ViewModel provides both IDataErrorInfo and collection binding for field-level errors and exceptions on client and server.
Extending IDbConnection and getting help from Dapper for tedious tasks
by Darek Danielewski
With a little help from C# Extensions and Dapper, it is easy to streamline coded database interaction, even with encrypted columns
Extending Kerosene ORM for WCF support
by mbarbac
Kerosene ORM support for complete database-alike WCF services and connections
Facade to disparate databases
by G3Coder
Details using an ORM model to provide a common facade to multiple disparate databases.
Facebook Application Development with FBML, FBJS, ASP.NET and C#
by aleksisa
Build simple and sophisticated Facebook Apps with FBML, ASP.NET
Faceted Search with dtSearch – Not Your Average Search Filter
by Jeffrey T. Fritz
In this article, I’m going to show you how to set up dtSearch with an Entity Framework dataset and then use faceted search navigation to add multiple filters to the result set.
Fast declarative typesafety with DynamicMethods for SQL
by tcassisi
Generating typed field accessors and applying them to object mapping and SQL Stored Procedures
Fast GridView
by Dav Zen
A fast and optimized GridView.
Features of Yukon (SQL Server 2005)
by Vidya Vrat
This article talks about SQL Server 2005
Fetching Data from Microsoft Excel using SQL
by Rashutosh Paul
How to fetch data from Microsoft Excel using SQL
Few Step(s) to Remove SQL Server Database User(s)
by Md. Marufuzzaman
Few step(s) to remove SQL Server database user(s) when you are facing error like “The database principal owns a database role and cannot be dropped.” for dropping a user.
Figure Out the Default Values of Stored Procedure Parameters
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.
File Synchronization using a NAnt Task
by Shuqian Ying
Codes for file synchronization between local and local/remote target directory trees that can be run under the NAnt or a console are provided.
Find "Leaked" Database Connections in ASP.NET Web Applications
by Todd Denlinger
Presents a method for monitoring the amount of time database connections stay open in ASP.NET applications.
Find multiple strings in selected columns
by akhil khare
Find multiple strings (delimenated by space) in all selected columns.
Find Primary Key or ID column of Table in SQL Server 2000/2005
by idreeskhan
Get or find Primary Key or ID column of Table in SQL Server 2000/2005
Find Stored Procedures called within a procedure
by brip
Sometimes its tedious to find all calls made to different stored procedures within a stored procedure and generate reports in case we have large databases. This tool is aimed to script all SPs and extract SP calls made with additional information such as author name and description.
Find Week in Given Date in SQL Server
by Rajaraman.net05
This sql function is used to find the week in Given Date.
Finding performance bottlenecks and their resolutions in windows services
by Sajid.Majeed
This article will address tools and technologies to identify bottlenecks and key consideration points for performance improvement.
Finding the nth day of the nth week
by harry_kochhar
This SQL Server function helps to get the nth day of the nth week.
Fingerprint Reader Integration using the M2SYS SDK
by Friedrich Brunzema
An article exploring integrating a fingerprint reader into a user's application
FIPS Encryption Algorithms and Implementation of AES in C# and SQL Server 2008
by Dnyaneshwar Pawar
Implementation of AES in C# and SQL Server 2008.
Five reasons for using an O/R mapping tool
by Iqbal M. Khan
An O/R mapping tool generates persistence objects for your .NET application.
Five steps to using a logging utility in your projects using Application Blocks
by Shivprasad koirala
Steps to use a logging utility in your projects using Application Blocks.
Flash and .NET with FlashRemoting
by daniel_nilsson
Testing FlashRemoting with .NET.
Flash ASP.NET AdRotator using Database
by Pramod S Kumar
Implement a Flash ASP.NET AdRotator to fetch ads from a database.
Flexible and Plug-in-based .NET Application using Provider Pattern
by Shahed.Khan, David.Grinberg
This paper demonstrates creating a flexible, extensible, plug-in-based .NET application (JOM - Smart Job Manager). JOM is an asynchronous job processing engine built using the MS Provider design pattern and the .NET technology available today.
Flexible numbering sequences in T-SQL
by Michael Abramovitch
A flexible way to generate unique numbers for things like invoice numbers
Fluent Migrator for Database Migration
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.
FOR XML Basics (RAW Mode): 1 of 4
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
Form Authentication for MOSS 2007 Site
by NagendraGunaga
The purpose of this document is to provide the step by step information about enabling the Form Based Authentication (FBA) for MOSS 2007 site.
Format Excel Sheet from DTS when Excel is Not Installed on SQL Server
by s_arun_kumar
Format Excel Sheet from DTS when Excel is not installed on SQL Server
Format Number to 2 Decimals in MS SQL without Rounding
by ashishnaik1
Format any Number to 2 decimal Number without Rounding
Free SQL Server Schema Comparison Tool in Visual Studio 2013
by Sreekanth Mothukuru
A look at the free SQL Server Schema Comparison Tool in VS2013
Friday the 13th - JSON is Coming to SQL Server
by Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
From SQL-Server to Web Service
by Eric Lapouge
An other way to export data from a SQL-Server to use them to call a web service
Full-Text Indexing Files with Microsoft SQL Server
by István Kovács (HU)
Indexing Word, Excel and other types of documents is easy with SQL Server
Full-text searching with IFilter's
by Klaus Salchner (Canada)
Indexing Server, SQL Server, Windows SharePoint Services, SharePoint Portal Server, Exchange Server and Windows Desktop Search provide full-text search capabilities. Each utilizes the so called IFilter components to index the content and then allows clients to search the index.
Fully Customized Reusable ASP+ Vertical/Horizontal Marquee Consuming XML/MS SQL
by Ameen AboDabash
Vertical/horizontal Marquee Web Custom Control consuming SQL Server DB/XML, with great design time attributes.
FUSE(file system in userspace) for Microsoft-SQL using C#
by martin.nedopil
Map your database table as network disk
Fuzzy Ontology Framework
by Václav Slavíček
Integration of fuzzy OWL ontology modelling with .NET
Gallery Server Pro - An ASP.NET Gallery for Sharing Photos, Video, Audio and Other Media
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.
General purpose class to fill DataTable(s) from DataBase and to save DataTable(s) to DataBase using reflection
by ProEnggSoft
General purpose class to fill some or all of the DataTables of strongly typed DataSet from DataBase and to save some or all of the DataTables to DataBase by creating TableAdapters using reflection.
Generate Classes and CRUD Procedures
by ColinBashBash
Generate classes / CRUD procedures.
Generate Complete .NET Applications in Minutes!
by carl.b.anderson
This article gives you an overview of how you can quickly develop .NET applications using the pragmatic CodeFluent Entities software factory. This tool generates ready-to-use components from a simple model and provides you multiple out-of-the box architecture options.
Generate Insertion Scripts Using .NET 2.0
by Benedict Chan
Using .NET 2.0 to get the SQL Server schema and generate insertion statements.
Generate Script Task of SQL Server
by Keshav Singh
This video describes how to generate table scripts with/without data in SQL Server 2008.
Generate SQL INSERT commands programmatically
by Ian Semmel
A class for automatically generating SQL INSERT for Typed Datasets.
Generate SQL Script Programmatically
by Md. Marufuzzaman
How to generate SQL object script using C#.NET
Generate SQL Select, Insert, Update and Delete
by samitcom
This will generate a SQL Select Query, Insert Query, Update Query and Delete Query by selecting SQL Database Connection and Choose a table to generate the script for using in class or DataCommand.
Generate XML from SQL Server 2008 and update the database from XML
by CrinaT
How to generate XML from SQL Server 2008 DB and update DB from XML.
Generating Class Representations Of SQL Tables
by lampiclobe
Automatically parses SQL tables into C# classes with functions like insert, select, etc.
Generating Insert or Update statements from table data using SQL Server
by Bruce Chapman DNN
Writing a SQL script to generate insert or update scripts for a table full of data.
Generating INSERT statements in SQL Server
by Sumit Amar .
Stored procedure to generate INSERT..VALUES statements in SQL Server.
Generating INSERT statements in SQL Server
by ilorgat
This is an alternative for "Generating INSERT statements in SQL Server"
Generating menu from database according to user privilege
by _Amy
Dynamic menu generation according to user privileges from database.
Generating osql Batch Scripts
by Michael Erasmus
This article is on a tool I wrote to generate executable osql deployment batch scripts.
Generating PDF reports programmatically using SQL Server Reporting Services 2005, in C#
by Sivakumar Mahalingam
An article on how to generate PDF reports programmatically using SQL Server Reporting Services 2005, in C#.
Generating SQL Server CLR Assemblies report
by Manar Ezzadeen
PowerShell script that generates an HTML report displaying different information about the SQL Server databases, their CLR assemblies and owners.
Generating Word Reports / Documents
by lepipele
Generate Word documents by appling XSLT on XML data.
Generator-less! C# wrapper for SQL Stored Procedures
by Brian Perrin
Eliminate the pain of calling SQL stored procedures from C#.
Generic Architecture For Rapid Software Development Project Cycle - Part 1
by Md. Marufuzzaman
Generic Architecture For Rapid Software Development Project Cycle
Generic Data Manager for Entity Framework
by Mercede
Generic data manager provides thread specific IUnitOfWork repository tailored for your entities and takes care of all the plumbing and cleaning in a thread safe way.
Generic Database Access
by Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
Generic Database Class Using ADO to Execute Stored Procedures
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!
Generic Database Frontend– Filtering, Free Text Search, Sorting & Paging
by Relly Rivlin
This article describes a server and client side code including explanations of a generic database frontend web application.
Generic grid search and data paging
by KevGUID
Generic grid search and data paging explained.
Generic Login Control
by Barathan
Generic Customizable login control for VB.NET Windows Forms.
Generic Repository Pattern in ASP.NET MVC
by Sharad Chandra Pyakurel
Generic repository application of employee with documents
Geocoding with SQL-Server
by gstolarov
Geocoding with SQL-Server
Get a table with all dates in a month
by TDunk
This SQL Server 2005 Table values function returns a table with all dates of a month for a provided date.
Get comma separated result
by Sun Rays
Create command for getting comma seperated value
Get DataSource Information from CSession Object
by Ferdie
A HowTo on getting DataSource information from CSession object
Get List of Extended storedProcedures that are Allowed to you for Common Use
by Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
Get SQL Table Information
by Md. Marufuzzaman
Get SQL Table Information
Getting Started with Entity Framework Core: Database-First Development
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.
Getting Started With SSIS Script transforms
by Daniel_Wheeler
Using a script transform with C# to convert Julian (ordinal?) dates for a date dimension.
Getting Started with the Genesis Smart Client Framework on Visual Studio 2010
by Stephan Johnson
Read this article if you are new to developing with the Genesis Smart Client Framework. It will guide you through the process of setting up your development environment and executing your first Genesis Hosted Application.
Getting the Changed DataTable
by RamMajeti
Consider a situation in which you have a datagrid with all or most of its rows in editable mode.
Getting the Place Name that Goes with a Zip Code
by Eddy Vluggen
How to import a database-dump from GeoNames.org into SQL Server
Global Filters for MVC Exception and Trace Logging
by Thomas Yee
How to implement exception logging and trace logging using global MVC filters
Global Variables in SQL Server
by Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
Globalization Resources for Multilanguage Development
by Evaldas Jocys
Provides required tables and data for multilanguage projects
Good Performance: Three Developers’ Behaviors that Prevent It!
by Android on Intel
In this article, I will talk about applications’ good performance and three developers’ behaviors that prevent it.
Google Suggest like Dictionary
by Gavi Narra
An implementation of Google suggest using remote scripting.
Govern and control your server ressources Using SQL Server
by Christian Luketa Kanyinda
This article will allow you to govern your resources and to control them to optimize your server
GPS Tracer Extension: storing the path on SQL2005 via Web Services
by Lorenzo Consegni
This article extends Leonardo Salvatore's project "A GPS tracer application for Windows Mobile CE 5" using the Web Service Software Factory. It shows how to create a robust solution for storing the path on a DB server, using Web Services and SQL
GPS Tracer Extension: Storing the Path on SQL2005 via Web Services
by Lorenzo Consegni
This article extends Leonardo Salvatore's project using the Web Service Software Factory
Grant Execute on all procedures to a user
by Sumit Amar .
This stored procedure grants execute privilege on all procedures to specified user
Graphical Representation of Data in ASP.NET Web Page
by Khaled Abdelhamid
Drawing on a web page on the fly using GDI+ and Flood-Fill Technique
Gridview inside Gridview in ASP.NET C#
by Prasanta_Prince
Gridview inside Gridview in ASP.NET C# or Nested Gridview and Update, Delete from Gridview
GridView Order Page Shopping Cart Page ASP.NET SQL
by T.Ashraf
GridView Image order page shopping cart page
GridView to a DataTable
by ZeroDev
Convert the current Gridview to a datatable
GridView with Fixed Header and Scroll Bar
by John Bhatt
Let's learn how to make a scrollable GridView and Fix headers with simple steps.
Gridview with SQL Paging
by Tom Bauto
A simple and detailed ASP.NET program using Gridview with paging in SQL 2005
Gridview, ObjectDataSource Making life easy
by Tapan Dantre
This Article will give some briefing on sorting, searching, paging in gridview with ObjectDataSource.
GroupedGridview - A Customized GridView Control
by sudhanvag
Grouping repeated data in a GridView control.
Grouping Sets in MS SQL Server 2008
by Robin_Roy
New feature - SQL Server 2008 Grouping Sets.
Grouping Sets in T-SQL (SQL Server 2008)
by Muhammad Shujaat Siddiqi
Grouping Sets, a new feature in T-SQL in SQL Server 2008.
GUIDs as fast primary keys under multiple databases
by Jeremy Todd
Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.
Handle Sql server and Foxpro database with .NET
by Gaurav K Singh
This article aids in rapid application development for database handling, for desktop and web applications
Handling BULK Data insert from CSV to SQL Server
by Ashrafur Rahaman
From this article, developers will get some useful guidelines on bulk data insertion in SQL Server.
Handling Keyboard Events of DataGrid Cells
by Asher Syed
Handling Key-Down and similar events for DataGridCells in a DataGrid
Handling SOAP Exceptions in WCF Based Applications
by Nandha V
Using a custom exception handler component
Hands on how to configure the Microsoft MSDE
by Lars-Inge Tønnessen
An article on how to setup and configure the MSFT MSDE 2000.
Having Not ONE But TWO Identities in Single SQL Server Table
by Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table
Having the CheckBoxList support many-to-many relationships
by _JERKER_
Example of implementing many-to-many multiple choice functionality the declarative way.
Hebb neural network
by Mohammad Mehdi Norian
implementation of ocr by hebb algorithm
Hello World Angular 2+ Data Sample Using JavaScriptServices .Net Core and PrimeNG
by defwebserver
You can create database driven .Net Core applications using JavaScriptServices, and PrimeNG.
HeMoSiBi™ WPF App
by DrABELL
Her Most Significant Bit™ NY-2013, All-in-One/Win8 (AIC-2013 FINALIST app)
Hide the Datagrid Columns Which are Not Intended to be Displayed at Runtime
by Jatin.Prajapati.ER
Hide the datagrid columns which are not intended to be displayed at runtime
Hierarchical Tree Represented by Modified Preorder Tree Traversal Technique using C# 3.0 and SQL 2005
by Wael Alghool
Gathering of various algorithms into one library to transform Hierarchical trees between various formats, and allows them to be represented into SQL 2005, the formats supported are TreeView, Textual, Tabular, Modified Preorder Tree Traversal and Graphical.
Hierarchical XML Data Builder
by asithangae
Data builder that builds XML from a SQL query in hierarchical format.
HierarchyID Data Type in SQL Server 2008
by Robin_Roy
MS SQL Server 2008 new feature, the HierarchyID data type.
High fidelity printing through the SSRS Report Viewer control
by tcassisi
Discusses the limitations and undocumented high DPI printing capabilities of the local WinForms Report Viewer control.
High Level Data Profiler Script
by Gene R. Browning
Get a quick look at your data characteristics using this tool.
High Performance OLE DB library : Ease of ADO, power of OLE DB
by Ghanshyam Naik
Introduction to OLE DB extended classes
Highlighting Important Dates in Calendar
by azamsharp
Highlighting important dates in the Calendar control.
HoopDream
by Terence Wallace
A brief article on how to utilize NBA Stats API in a WinForm application
How design patterns can help you in developing unit testing-enabled applications
by Marcelo Ricardo de Oliveira
This article shows how you can mix together Model-View-Presenter, Domain Model, Services, ActiveRecord, and Repository patterns to create a testable application.
How Do I Protect My Stored Procedure Code
by Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
How Do I: Use SQL File Stream
by gaurav_verma_mca
An end to end article describing how to use file stream data type in SQL Server. This article discusses both SQL Server and .NET side of things.
How Longhorn Transforms Applications
by Ashvil DCosta
See how Longhorn core pillars like WinFS changes the way applications are written, based on metadata relationships.
How Many Records Are There in your Database?
by Md. Marufuzzaman
How many records are there in your database?
How SQL Server deletes records
by DLM@TD
How SQL Server deletes records
How to access SQL database from an iPhone app Via RESTful WCF service hosted on IIS 7.5
by Samer M. Abdallah
Access SQL database from iPhone Via WCF and JSON hosted on IIS 7.5
How To Automatically restart MySQL on Windows
by Emmanuel Kartmann
This article provides a small executable (36K) which configures MySQL (or another Windows Service) to automatically restart whenever it fails/crashes.
How to Build C# code based on DB Script
by Xavier Cruz
These Alpha App is a tool used to create C# classes based on SQL Server Express DB script
How to call an Oracle Stored Procedure that returns one or more REF CURSORS, using ADO from C++
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!
How to Call SSIS Package from the Stored Procedure
by JustChiragPatel
No need to create web service for SSIS package call
How to change ConnectionString easily
by Ali Marzban
Changing ConnectionString like an attribute in C#
How to conduct an SMS survey using a cell phone connected SMS gateway and MS Access
by Adam Page
Setting up an SMS gateway to conduct an SMS survey and storing the survey results in an MS Access database, from which you can generate/print out reports.
How to Config Linked Servers in a Minute
by Kamran Hazari
How to create Linked servers in a minute in an easy way
How to convert DataGrid into Data Entry Form
by Jimmy M Joy
This article explains how to convert DataGrid into a data entry form for same kind of data.
How to correlate IIS, Application and SQL Server Audit logs to achieve full stack audit.
by Z Kavtaskin
How to Create a Logger in SSIS
by Deepu M.I
The concept of SSIS Logging is to capture log-enabled events that occurs at run time.
How to create Dynamic draggable and droppable TreeView with checkbox in MVC(for beginner)
by VINEET MISHRA 086
This article explains how to use data source for representation of data in TreeView structure using ASP.NET MVC and Gijgo treeview JQuery plug-in, The TreeView control can display a hierarchical (or nested, or recursive) collection of data in a tree of expandable nodes.
How to Create your First SQL Server Integration Services (SSIS) Package - Part 1
by Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
How to Exactly Enumerate SQL Server from LAN by using SQLDMO
by Wang Xuemin
An article on how to use SQLDMO to enumerate SQL Server instances.
How To Exactly Enumerate SQL Server From LAN By Using SQLDMO
by Wang Xuemin
An article on introducing how to use SQLDMO
How to execute multiple long running SQL Statements Asynchronously in small chunks
by Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
How to export data from database tables to an XML file using SSIS
by Maxim Rudoi
A simple way to create an XML file from SQL Server tables using SSIS
How to find if only one particular column has been modified in a trigger
by Master DJon
How to find if only one particular column has been modified in a trigger.
How to Get a Reference to Parent Form from a Component
by David Catherman
Components don't have a .Parent property like controls do. Getting a reference to the instance of the parent form the component was on is very difficult.
How to Get Geolocation Address by Using Google geolocation API in ASP.NET Web API
by Shamim Uddin
In this article, we are going to learn how to get geolocation address by using Google geolocation API in ASP.NET Web API.
How To Handle Concurrency in LINQ to SQL?
by Shivprasad koirala
How to handle concurrency in LINQ to SQL?
How to Hide GridView Cloumn Cell and how retrive value of a hidden cell
by T.Ashraf
Hide and Retrive value of cloumn of a GridView
How to identify worst performing queries & improve their performance
by Rajesh Kumar
This article is all about how to identify the worst performing queries in the running application or some specific module of the aplication.
How to Implement a NavigationPanel Using AJAX
by Mohammad Akbarizadegan
This article demonstrates how to implement web applications based on AJAX and ClientScriptCallBack as it presents a simple example. Also, the article tries to point at the key features of working with ASP.NET ClientCallback and AJAX.
How to implement an incremental search using a grid column (UltraWinGrid)
by CQüeb
This article pretends to show how to implement an incremental search doing double click in a UltraWinGrid column.
How to import data into MS SQL server from CSV and XML
by DataBytzAI
How to bring CSV and XML data into MS SQL server
How to improve your LINQ query performance by 5 X times?
by Shivprasad koirala
Tips to improve your LINQ query performance.
How to Install and Configure SharePoint Server 2010 RTM
by Syed Adnan Ahmed
This article describes step by step details of how to install and configure SharePoint Server 2010 RTM
How to Integrate an OLE Object with SQL Server
by Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
How to Integrate an OLE Object with SQL Server v2
by Md. Marufuzzaman
This article will give you an idea about how to integrate an OLE Object that is a COM+ API with SQL Server and write a message into a Windows event log.
How to link different data sources together
by Klaus Salchner (Canada)
Describes how you can link SQL Server with many different data sources like a directory as Active Directory Application Mode, a Microsoft Indexing Server catalog, a Microsoft Access database and a Microsoft Excel spreadsheet. Also explains how to query linked servers using the OPENQUERY command.
How To LINQ To SQL: Part III
by Muigai Mwaura
How to LINQ To SQL: The Executor.
How to make an online conversion from code page to Unicode in your SQL scripts.
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.
How to make your app secure
by Salil Khedkar
If you are into development or quality assurance of enterprise solutions, you must be aware of the security aspect of your application. This article provides a checklist for the same...
How to manage product options with different prices in a catalog
by Paolo Costa
This article provides a simple solution for managing product options in a catalog. This solution is valid for any number of options.
How to migrate DevExpress XAF SecuritySystemUser to PermissionPolicyUser
by mblataric
Instructions on how to migrate existing XAF security system to new permission policy.
How to Migrate SQL Database to Azure SQL Database using SSMS Deploy
by Vivek Johari
This post discusses how to migrate SQL database to Azure SQL database using SSMS deploy.
How to Migrate SQL Database to Azure SQL Database using SSMS Export/Import
by Vivek Johari
Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents
How to Non-alphabetically Sort GridView Columns with Text Data
by Christopher Geyer
Creating a sortable GridView is easy. But, what if you want to perform a nonalphabetic sort on a column that is alphabetical? Answer below...
How to Organize Clean Architecture to Modular Patterns in 10 Minutes
by thangchung
Learn to organize clean architecture to modular patterns
How to pass multiple records to a Stored Procedure
by Wendelius
How to pass multiple records to a Stored Procedure in a single roundtrip.
How to Pass Parameters to Crystal Reports at Runtime
by Malik Usman
An article on how to pass parameters to Crystal reports from Windows Form at runtime
How To Pass Value from User Web Control to Parent ASPX Page
by T.Ashraf
How to pass values between user control and ASPX page without JavaScript
How to populate DataGridView, GridView with SQL statement in C#
by hong_wei_li@yahoo.com
How to populate DataGridView, GridView with SQL statement in C#
How to Prevent When a Transaction Accidentally Overwrites Modified Data
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.
How to Restore SQL Server 2005 Suspect Database
by Suvendu Banik
How to Restore SQL Server 2005 Suspect Database
How to retrieve SqlConnection statistics for executed T-SQL commands
by Ali Ozgur
Sample code describing how to retreive statistical information about the T-SQL commands executed.
How to Return Disconnected ADO Recordset from COM
by Siau Tan Long
An article on how to return disconnected ADO Recordset from COM using VC
How to Rotate a Pie Chart in SSRS 2005
by Matt Bowman
How to change the angle of the first slice of a Pie chart in SSRS 2005.
How to Run Grid-based Web Applications and Databases at Scale in the Cloud
by Bruno Terkaly
This post will cover the whole spectrum of downloading data from a government site, loading it into an on premise SQL Server database, migrating this on premise SQL Server database to SQL database in Windows Azure.
How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005
by hong_wei_li@yahoo.com
How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005
How to Script Out SQL Server Objects
by ozkary
A VBScript script which allows to script out all the SQL Server objects in each independent file
How to search for related query inside the Database using ASP.NET
by Afzaal Ahmad Zeeshan
This article explains how you can use ASP.NET (C#) and search for related queries in your Database.
How to Select What Fields to Display on a Report from a Multi-value
by pengyi
How to select what fields to display on a report from a multi-value
How To Send Mail Using SQL Server: Part 2
by Manish kumar choudhary
In this article, you will learn how to select data from a table and send that data to an email using SQL Server 2008.
How to Set Up SQL Server Integrated Security For Using With SMS
by Ahmed_EL Sayed
How to set up SQL Server Integrated Security for using with SMS.
How to Sort Alphanumeric Data in SQL
by Ravi Kallamadi
Sort alphanumeric data in SQL.
How to store and fetch binary data into a file stream column
by Wendelius
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File
by Vimalsoft(Pty) Ltd
How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File
How To Store Any File into SQL Database
by Md. Marufuzzaman
An easy technique to store any file into SQL database
How to Truncate Log File in SQL Server 2005
by hong_wei_li@yahoo.com
How to truncate log file in SQL Server 2005
How to Use a Multi-Result Set Stored Procedure in SSIS
by Ponytail Bob
How to use a script component as a data source for multi-result set Stored Procedures.
How to use CodeProject Grid in MS Access to view multiple intermediate results
by rkdev
This article is about using MFC CodeProject Grid, ATL and MS Access together.
How to use data caching in a .NET Windows Forms application
by Simon Steed (SimonAntony)
This article explains how using caching within your Windows Forms application can speed up data access for frequently used data and avoid performance bottlenecks over the network.
How to use global variable in Microsoft SSIS (DTS) package
by hong_wei_li@yahoo.com
How to use global variable in Microsoft SSIS (DTS) package
How to use OLAP cubes for reporting, and get your business users the data they need today.
by InterScape, Inc.
Creating reports today has become a nightmare for a lot of developers. I can contest to the late nights and many lines of code in order to build custom reports, then have a user never use a report because it was slow or did not contain the data they wanted to see.
How to use RecordSets without using the AppWizard at the creation of your project.
by Braulio Dez
How to Use SQL Server to Select Records for a Scheduled Date
by Vilhelms
Retrieving appointments without having to store all future occurrences
How to Use Stored Procedures in VB6
by Sujith C Jose
Describes how to use a simple stored procedure in Visual Basic 6.0
How To Validate Credit Card Numbers
by dizzybuzy
Beginners
How to version control a database using GitHub and SQL Source Control
by Redgate Software
This article explains some simple steps to create a GitHub database repository and get your database code in there, using SQL Source Control.
How To: LINQ To SQL Transformation
by Muigai Mwaura
An article on LINQ To SQL Transformations.
How To: LINQ To SQL Transformations - Part II
by Muigai Mwaura
An article on LINQ To SQL Transformations.
How Toad DevOps Toolkit can help with the DevOps process
by Quest Software
If you wanted to ramp up database DevOps, which development tasks would be most important for you?
How-To: Automatically Rename Foreign Keys on a DB
by Lino Barreca
Use T-SQL and system views/stored procedures to give consistent names to every relation in a database
HowTo: Install the Northwind and Pubs Sample Databases
by Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express.
HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express
by Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
HTML Parser In SQL SERVER 2005 (Set Based Approach)
by Niladri_Biswas
An HTML parser for parsing only the HTML body content
HTTP Push from SQL Server — Comet SQL
by CoperNick
This article provides an example solution for presenting data in "real-time" from Microsoft SQL Server in an HTML browser. The article presents how to implement Comet functionality in ASP.NET and how to connect Comet with Query Notification from SQL Server.
IDataReader implementation + SqlBulkCopy
by cesar_boucas
IDataReader implementation illustrated with SqlBulkCopy class usage
Identifying NHibernate-Related Bottlenecks through Performance Monitoring
by Peter Weissbrod
A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues
IGotMessage - Send a Video Message
by PAPAYA
IGotMesasge is an open source Web-based application that allows individuals to easily record and send video messages to others. The software is free to download, install and use, and is easy to integrate with any website.
Impersonation using Code
by Chirag R Darji
Impersonation using Code
Implement Phonetic ("Sounds-like") Name Searches with Double Metaphone Part IV: SQL Server and Advanced Database Topics
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.
Implementation of a B-Tree Database Class
by _oti
An article and source code regarding the implmentation of B-Trees in C++.
Implementation of a Message Broker on BizTalk
by Steinar Moen from Norway
This article describes an implementation on BizTalk 2006/R2/BizTalk 2009 where a received message is split and sent to many different destinations.
Implementation of Database Assertions
by h_wiedey
An approach using updatable views with check option and deferred constraint checking.
Implementation of Unicode in SQL Server
by josekonoor
Information about Unicode implementation in SQL Server.
Implementing a CLR Stored Procedure in a LINQ based n-tier architecture
by Virat Kothari
CLR Stored Procedures can be efficiently implemented in an n-tier architecture.
Implementing a Data Processing Extension
by Bryan Avery
I will take you through how to deploy your own Custom Data Process Extension for SQL Server Reporting Server 2005, both on the server and for use within your development environment.
Implementing a Tree Structure with Database
by Amir Mahfoozi
This article describes implementing and manipulating a tree structure by means of SQL
Implementing a TreeSize-like application with C#, SQL and Analysis Service, part 1
by krysstof
Tool developped to manage and analyse disk space on multiple fileserver in my company
Implementing an Ugly Tab Structure in Reporting Services
by akjoshi
Implementing a tab control like structure in SQL Server 2005 reporting services report using tables and text boxes
Implementing Audit Trail using Entity Framework - Part 1
by Morshed Anwar
Implementing Audit Trail using Entity Framework's caching entries
Implementing Audit Trail using Trigger
by Shivprasad koirala
Implementing Audit trail using trigger
Implementing Cumulative total and Select All functionality with Events in ASP.NET GridView
by AshishChaudha
There are many scenarios in which the data can be bound in a Gridview, in which various operation other than provided by default by gridview needs to be implemented. In this article we will try to bind such operations with some more features.
Implementing Database Versioning
by Ezhilan Muniswaran
This database script provides a template for properly maintaining multiple versions of a database.
Implementing Dynamic WHERE-Clause in Static SQL
by John-ph
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
Implementing Efficient Data Paging with the Datalist Control in ASP.NET 2.0
by Bernard Ho-Jim
Extending the Personal Web site Starter kit by implementing efficient data paging to the Photo Gallery.
Implementing Logging & Transaction for NHibernate through Configuration Files using Aspect Oriented Programming via Unity
by Niraj Bhatt
Applying AOP using Unity on NHibernate
Implementing multi-level trees in MS SQL Server
by Duong Ba Hong Minh
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
Implementing Triggers in 4D
by Manjushree Das
The target audience of the article are novice 4D developers. It aims at explaining the usage of Triggers in 4D databases.
Implementing Triggers in SQL Server 2000
by smileyfrnd
Implementing Triggers in SQL Server 2000.
Implementing WS-SecureConversation in Microsoft IssueVision
by Weidong Shen
Adding secure communications to the Microsoft IssueVision sample application using WSE 2.0.
Import CSV Files to SQL Server Process and Common Error
by sajidur rahman
This article describes about CSV/Excel File import in SQL Server with common problems.
Import Data from Excel into SQL Server Using SSIS
by Keshav Singh
In this video article
Import Data from Excel to SQL Server
by Vivekananda Swamy.M
This article mainly describes how to import data from Excel sheet to SQL Server, Viewing the data from SQL Server using the Gridview Control, Deleting the Data. In case the Excel sheet does not contain data (null values), those values are replaced by zero.........
Import Data to SQL Server from Excel or Access using TSQL Script
by Waynes World
An article on importing data from external data sources to SQL server without using wizards
Import Excel files to SQL Server dynamically
by Mohammad Al Hoss
This article shows how to import Excel files to SQL Server dynamically.
Importing CSV Data and saving it in database
by Mukund Pujari
This article shows how to import CSV data and store it in database.
Importing data with the SSIS Object model
by Moim Hossain
Describes how to use the SSIS object model for importing data to SQL server 2005
Improve Application Performance by Using Indexes on Microsoft SQL Server 2000
by Jim Murphy, RSCD
This article shows you how to develop applications with better performance out of the gate, even if you don’t have a DBA.
Improve hierarchy performance using nested sets
by James Simpson
This article describes how to use nested sets to improve performance of hierarchies within SQL Server and other relational databases
Improve performace with Sessions using Cache
by Albert Pascual
I wrote this short article to improve your ASP.NET application Sessions using Cache.
Improve Productivity by Redesigning DataBase Schema
by Riccardo Cervelli
Redraw database structure to improve productivity
Improved Versions of CCommand and CDynamicAccessor
by Jörgen Sigvardsson
This article shows one way to extend CCommand and CDynamicAccessor to make OLEDB in C++ easier
Improving the performance of queries using SQL Server: Part 1
by Pete O'Hanlon
The first in a series of articles on prioritizing and improving query performance in SQL Server.
Improving the performance of queries using SQL Server: Part 2
by Pete O'Hanlon
These articles are on prioritizing and improving query performance in SQL Server.
In SSIS how to continue a for each loop container even if its inner tasks fails (Usage of Propogate Property in SSIS)
by Smitha_Kalakoduvath
How can we configure our foreach loop container, even when the task inside it failed
Independent Data Access Layer (Ddocumentation in Progress)
by Salvatore Vetro
The art of swap from a database to another changing a flag
Indexed Views and How It Can Help in Improving Query Performance
by Minh Tuan Do
A considerable method to speed up query running time
Indexes in MS SQL Server
by Keshav Singh
This article focuses on how MS SQL Server uses indexes to read and write data.
Insert and retrieve data through stored procedure
by Tariqaziz
All about stored procedure
Insert Data into SQL 2000 Using OpenXML & ADO.NET
by S. Vijaya Raghavan
An example of inserting data into SQL Server using OpenXML + ADO.NET
Insert Field (not append) Using ADOX
by Ferdie
Using ADOX to insert field into a MS Access table.
Inserting Bulk Data in SQL Server from Text file
by S.Vinothkumar
Inserting Bulk Data in SQL Server from Text file
Inserting Value of Collection into Database
by bhadeliaimran
Inserting value of Collection into Database
Inserting XML formatted data into SQL Server 2000
by faisal abdul aziz
This article explains Parent-Child insertion into SQL Server 2000 using XML Support provided by SQL Server 2000 and Visual Studio.NET
Inside Recursive CTEs
by gjvdkamp
A step by step explanation of how a recursive CTE actually works.
Install and Configure SQL Server for SQLCE replication
by Garth Tissington
After pulling my hair out for several days I finally figured out how to install and configure SQLCE with SQL Server for replication to a Windows CE device. I hope this saves you some pain
Installing MSDE with .NET Application
by Mukund Pujari
This article shows how to distribute or install MSDE with a .NET application.
Installing multiple SQL scripts using a single PowerShell script
by Arjan Douwes
Installing multiple SQL scripts using a single PowerShell script.
Instant Low Code Database Web App - ASP.NET Core 3.1 Single Page Application(SPA).
by Kalvin Lawrence Ernst
A sample application code which is an alternative to using libraries such as AngularJS, React, Vue, etc. Only jQuery and bootstrap are used in conjunction with vanilla JavaScript, HTML and CSS.
INT to BINARY string in SQL Server
by AlexCode
Converting INTs to BINARY in SQL Server
Integer Arrays Using T-SQL
by Chris_Martinez
How to pass an array of integers to SQL Server
Integrate Reporting Services with VS.NET pages and VS.NET controls
by Frank Kerrigan
Integrate reporting services with VS.NET pages and VS.NET controls.
Integrated College Management System[Credit Hours Sys.] --Part 1-- Class Library & Database
by Ameen AboDabash
This project is established for helping students to make registration easily. It also simplifies this process for both students and employees and prevent usual problems the Credit Hours System faces.
Integrating Database Development in Visual Studio
by venugopalm
Integrating database development into Visual Studio to collaborate application development team and the database designers
Integrating Microsoft Access DB, SQL Reporting Services and Visual Studio .NET
by Anand Santhanam
In this article, I would like to demonstrate how we can leverage the SQL Reporting Services feature on to a Microsoft Access database, using the Visual Studio .NET as IDE.
Integrating Reporting Services 2005 Into a Web Application
by DDarren
This article provides step-by-step instructions on how to integrate a MS Reporting Services report into an ASP.NET web application using the ReportViewer control. It also includes an HTML template than can be used for the layout and tackles a couple of known problems with the ReportViewer control.
Integrating SQL Server 2008 with Metatrader 5
by Kanhar Munshi
Invoking an External ADO.NET DLL to connect and execute queries on a SQL Server database from within the Meta Trader Platform
Integration of .Net Application With SAP
by Jayawant
Connecting .Net & SAP
Integration of SSRS and .NET using Iframe and URL Command Approach
by santosh poojari
This article will illustrate the approach to open SSRS report in ASP.NET UI using URL command and IFrame Method.
Intelligent Combobox for MySQL/SQL Server Database Applications using VB.NET/C#
by Ralf Meier, Shah Samiur Rashid
Codeless Combobox for VB.NET/C# platform with MySQL/SQL Server database applications
Interactive SQL Tool (using ADO)
by George Poulose
A tool that allows you to query OLE DB sources
Interactive SQL Tool (using ODBC)
by George Poulose
A tool that allows you to query ODBC sources
Intermeadiate OLE DB Consumer in C++
by Anthony Roach
This article expands on my previous article and introduces recordset operations and database entry operations.
Intro to Postulate ORM
by Adam O'Neil (Travelers Rest, SC)
Introduction to Postulate, a code-first ORM for SQL Server made with Dapper
Introducing Distributed Messaging using Service Broker in SQL Server 2005
by Akram Hussein
An article on distributed messaging using Service Broker in SQL Server 2005.
Introducing SilverlightDesktop.net
by defwebserver
SilverlightDesktop.net is a Open-Source ASP.NET framework that allows you to dynamically load Silverlight modules into resizable draggable windows.
Introducing the Boomerang Framework
by psined
Introduction to Boomerang Framework
Introducing WF4.0: Building Distributed Apps with WF 4.0 and WF 4.0 Services
by mohamad halabi
Shows how to build new-design distributed applications with WF 4.0 and Data Services.
Introduction to Model Driven Development with Sculpture – Part 1
by Ahmed Negm
This article introduces how to create and manage .NET enterprise applications using your favorite technology (Data Access Application Block, LINQ, NHibernate, ASMX, and WCF) with the Model Driven Development approach by Sculpture.
Introduction to NoSqlOnSql Implementing NOSQL on SQL
by Jose Segarra
Implementing NOSQL on SQL
Introduction to Percolator Analysis Services LINQ to MDX ORM
by Suffyan Asad
Percolator Analysis Services is a LINQ to MDX ORM that enables writing MDX Queries in LINQ instead of using hard-coded strings of MDX code, resulting in cleaner, easier to read and easier to maintain code.
Introduction to SQL Injection
by Vimalsoft(Pty) Ltd
A reason why we have to write Stored Procedures and remove SQL code from web pages and forms.
Introduction to SQL Server Domain Modeling with the "M" Language
by Frank Kerrigan
SQL Server domain modeling with Oslo CTP and the "M" language.
Introduction to SQL Unit Testing using TSQLT
by Rooney (Deepak Bisht)
How to use tSQLt for writing unit test cases in SQL (for stored procedures & functions)? This article can be treated as a tutorial as well.
Introduction to using jQuery with Web Services
by Andy Marshall
Basic Introduction to jQuery using SQL Server, Web Services
Introduction to WTL OLE DB Database Applications
by Ed Gadziemski
How to create a basic WTL database application using an ATL wizard-generated OLE DB consumer and WTL's version of Dynamic Data Exchange (DDX)
Introductory Mobile Tracker Application for SmartPhones
by Santosh Ingawale
Register a reference mobile number, and receive a reference message on SIM change.
Inversion of Control with nHydrate
by Christopher R Davis, Michael S Knight
Generate applications using Inversion of Control with the nHydrate code generator.
Invoke .Net Assembly using SSIS:Email Framework
by santosh poojari
This article demonstrate use of SSIS package that helps in invoking .Net Assembly having email component in it.
Invoking a WCF Service from a CLR Trigger
by Sam Shiles
A step by step guide to communicating with WCF from a CLR Trigger in SQL Server 2005
IoT Makes the Perfect Microwave Burrito
by Todd Christell, Canin Christell
Creating a Microwave Oven IoT Application
IP Logger
by Igor Krupitsky
This program keeps track of your changing IP number.
Is SQL Server killing your application’s performance?
by Ben Emmett
When an application suffers from performance problems, it’s common to assume the database is at fault. Ben Emmett examines why this often isn’t the case, and shows how you can dig into a .NET application’s use of SQL Server with ANTS Performance Profiler.
Is Your Data Valuable To You?
by Ujwal Watgule
The article discusses threats to application in the absence of proper validation procedure.
Iserver Cyber Cafe
by goodtime68
Cyber café software to keep track of buisness.
Job Match
by apmyhr
Job Match helps job seekers find employment with the right company
JohnKenedy Data Access Layer Library
by John Kenedy S.Kom
This is a .NET 3.5 library that acts as Data Access Layer with many automatic features
Joining Tables in SQL
by Pierre Kellerman
Explaining different ways to join tables
Joining XML fields with different XML namespaces within a one table in T-SQL
by Aleksei Tuiman
Data extraction from XML fields with different namespaces
Jotdown
by Mohan Mallampalli
A HTML5 note taking app capable of capturing Video notes.
jQuery Mobile AutoComplete in ASP.NET with SQL Server Database Connection
by Mehmet Murat TANDOĞAN
How to use jQuery mobile autocomplete in ASP.NET using generic handler(.ashx) file with database connection.
JSON for SQL Server. Part 1
by Jose Segarra
Support routines for handling JSON in SQL Server
Junk Drawer
by dale.newman
Importing Excel & Delimited Files into a Junk Database
Keep everyone away from breaking your database object naming convention with SQL Server Policy Based Management.
by Khorshed Alam, Dhaka
Standardization database object name with SQL Server Policy Based Management.
Keeping Admins and clients happy with Cache usage
by hurddar
Optimization considerations for your code management
Kerosene Dynamic Data Services
by mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
Kerosene ORM Dynamic Records In Depth
by mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
Kerosene ORM Maps In Depth
by mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
Kerosene ORM: a dynamic, configuration-less and self-adaptive ORM for POCO objects supporting a SQL-like syntax from C#
by mbarbac
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
kissIT!: Rapid Agile Development, a practical approach to hybrid development in SQL, C# & VB.NET
by rapidagiledevelopment
The Software Development process can be time consuming and stressful. Outlined here are some practical tips on how to ease the strain with kissIT!® applications within the context of Prototyping / Agile methods for SQL, C# & VB.NET.
KS Technologies Crystal Report
by | Muhammad Waqas Butt |
Show Crystal Report On Selection Base
Leaderboard for Windows Phone 7 XNA Game
by BillLange1968
Solution for creating a Leaderboard for a Windows Phone 7 (WP7) XNA game
LEADTOOLS Recognition Imaging SDK: Create Imaging Apps Easily
by Dirk_Strauss
LEADTOOLS Recognition Imaging SDK - I had the pleasure of taking the SDK for a spin, and let me tell you it was well worth it.
Lean and extensible mySQL C++ wrapper
by Richard Lin
An article on a lean (2 header files) C++ template class that provides mySQL query
Lean and Mean Blogging Revisited
by Mustafa Ismail Mustafa
An alternative approach to blogging engines
Learn to Write Custom MDX Query First Time
by Mubin M. Shaikh
Learn Custom MDX Query Step by Step
Learning Entity Framework (Day 2): Code First Approach and Migrations in Microsoft .NET Entity Framework
by Akhil Mittal
Code First Approach and Migrations in Microsoft .NET Entity Framework
Learning Entity Framework (Day 4): Understanding Entity Framework Core and Code First Migrations in EF Core
by Akhil Mittal
Entity framework core, code first migrations and data annotations in EF Core
Library for scripting SQL Server database objects with examples
by Kanasz Robert
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
Light ORM Library for .NET
by Sergey Busel
This article is about the Light Object-Relational Mapping library.
LightBox Connected to Microsoft SQL DB
by Orane Cole
The lightbox control reads data from your backend SQL Server
Lightswitch: Working with Views
by Ankita Biswas Bhattacharya
Here, I will explain how you can work with SQL views in lightswitch and how you can save data on screens which are created on Views.
Limitations of the View Many and Many
by pinaldave
Limitations of the View Many and Many
Line of Business Application, the New Way
by Weifen Luo
The new way to develop LOB applications
LINQ and Deploying SQL Server CE 3.5
by Matt Sollars
How to deploy SQL Server CE 3.5 with an application that uses LINQ for data access.
LINQ and WF Based Custom Profile Provider for ASP.NET 3.5
by Anas Karkoukli
A new implementation of the Custom Profile Provider for ASP.NET 3.5, using LINQ, Workflow Foundation, and the Responsibility-Centric-Singleton DataContexts pattern.
LINQ Challenges and SQL Server Compact Edition
by Matt Sollars
Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.
LINQ Code generator
by Sree Nivas
This generates Basic linq codes just by giving necessary inputs
LINQ Demo with ASP.NET Web Application
by anrorathod
A sample application for beginner users who want to start the Linq implementation in ASP.NET
LINQ FAQ: Part 2
by Shivprasad koirala
This FAQ article is dedicated to LINQ to SQL.
LINQ FAQ: Part 3
by Shivprasad koirala
Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.



Privacy
Cookies
Terms of Use
Last Updated 22 Nov 2024
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-10-20:1