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

SQL

SQL

Great Reads

ASP.NET C# Tutorial - Development with Nido Framework for Dummies
by Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
Learning MVC - Part 5 Repository Pattern in MVC3 Application with Entity Framework
by Akhil Mittal
Repository pattern in MVC3 application with entity framework
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 4.0 MemoryCache with SqlChangeMonitor
by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.

Latest Articles

ASP.NET C# Tutorial - Development with Nido Framework for Dummies
by Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
Learning MVC - Part 5 Repository Pattern in MVC3 Application with Entity Framework
by Akhil Mittal
Repository pattern in MVC3 application with entity framework
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 4.0 MemoryCache with SqlChangeMonitor
by Rick Bassham
How to use the SqlChangeMonitor with the new MemoryCache class in .NET 4.0.

All Articles

top
Sort by Score
Title
Updated
Author
Score

SQL 

ASP.NET C# Tutorial - Development with Nido Framework for Dummies
by Nirosh
This tutorial is designed for .NET programmers who need to understand ‘Nido’ framework and its application.
Learning MVC - Part 5 Repository Pattern in MVC3 Application with Entity Framework
by Akhil Mittal
Repository pattern in MVC3 application with entity framework
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 Code or SQL – Where’s the Performance Problem?
by Redgate Software
Identifying an application’s performance bottlenecks is all about understanding how the application is spending its time. Only with the most complete understanding of how an application is operating is it possible to understand what it is doing wrong, as this article describes.
.NET Dynamic Control (Label, Text Box and Drop Down) Creation
by Shrilata Ellaboina
.NET Dynamic Control Creation
.NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language
by Shemeer NS
CultureInfo, DateFormat, Number Format, Currency Format, Percent Format, Infinity Format, etc. in .NET Framework Cultures
.NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language-Utility
by Shemeer NS
Utility for .NET Framework Cultures with Culture Specific Formats and Mapping with SQL Server Language. CultureInfo, DateFormat, Number Format, Currency Format, Percent Format, Infinity Format, etc.
.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$
by Mark Pelf
NET8/EF8 Breaking Change. Old servers/databases might not understand queries from EF8.
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#)
10 Steps to Creating a Windows Mobile Database Application Using .NET and UltraLite 10
by Liam Cavanagh
The purpose of this article is to help get a user started in building a mobile database application using Visual Studio .NET (C#).
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.
4db: A Dynamic File-based NoSQL Database for C++
by Michael Sydney Balloni
Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!
5 Steps to Adding Data Replication to a Windows Mobile Application
by Liam Cavanagh
The purpose of this article is to show how to add data replication to a mobile application through the use of .NET (C#).
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 Beginner's Guide to NoSQL
by Software Developer's Journal
This article aims to explore the basic ideas and principles about noSQL databases. noSQL caters to database admins, programmers, coders, web devs, etc.
A Case Study on How to use Joins, Subqueries, and Unions to Combine Data in SQL
by essentialSQL
This is a case study on how to use Joins, Subqueries, and Unions to combine data in SQL.
A Cloudy Approach – SQL Data Services
by Denis Vasilik
Overview of Microsoft's cloud platform
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 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 CRUD Form using SharpDevelop and PostgreSQL
by Juan Fajardo
This article is a tutorial on how to create a CRUD (Create, Retrieve, Update and Delete) Form using SharpDevelop and PostgreSQL, implementing a BindingNavigator to explore the table used in the application.
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 Free Website Management System - Nukedit
by RichardEastes
Realtime page editing, simple, "on-the-fly" menu construction, modifiable permissions for users and groups, built-in search engine optimisation
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 Interval Range Table to Generate Permutations
by bobleith
A generic interval range table to generate permutations
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 Helpful Database Library
by lost in transition
This article illustrates a helpful database library.
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 Master-Detail Solution Using Single Input Controls
by TofuBug24
Shows a solution for creating a Master-Detail relation using textboxes.
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 New Web Programming Language
by Atle Solbakken
Are the programming languages we use for web design today really adapted well enough to fit our needs?
A News Article List in an ASP.NET GridView Control With Custom Paging
by mikvos
A list of news articles in an ASP.NET GridView control with custom paging.
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 Note on Hibernate - Many to Many
by Dr. Song Li
This is a note on Hibernate many to many mappings.
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 Performance Meter Used In Call Center Software
by Voicent Support
How to make a performance meter that looks like the one in Windows Task Manager
A Pluggable Architecture for Building Silverlight Applications with MVVM
by Weidong Shen
This article describes building a sample Silverlight application with the MVVM Light toolkit, WCF RIA Services, and a pluggable application architecture using MEF.
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 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 Query Builder Class For Visual Basic 2005 Hand Coders
by Elizalde G. Baguinon
Most programmers prefer hand-coding database queries. This is a class that automates query building, while the code is as readable as the program logic.
A Reusable Framework for Connecting Both WebHelp and Compiled Help RoboHelp Projects to Relational Databases Through the Use of JavaScript Object...
by UV2003
This article will describe how to hook up RoboHelp projects to a database to provide data to pages for both WebHelp and Compiled Help using a single architecture. The implementation will rely on the JavaScript interpreter built into almost all web browsers and that is available in Compiled Help too.
A Sample Silverlight 4 Application Using MEF, MVVM, and WCF RIA Services - Part 1
by Weidong Shen
Part 1 of a series describing the creation of a Silverlight business application using MEF, MVVM Light, and WCF RIA Services.
A Sample Silverlight 4 Application Using MEF, MVVM, and WCF RIA Services - Part 2
by Weidong Shen
Part 2 of a series describing the creation of a Silverlight business application using MEF, MVVM Light, and WCF RIA Services. In this second part, we will go through various topics on how MVVM Light Toolkit is used in our sample application.
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 Silverlight Sample Built with Self-Tracking Entities and WCF Services - Part 4
by Weidong Shen
Part 4 of a series describing creation of a Silverlight business application using Self-tracking Entities, WCF Services, WIF, MVVM Light toolkit, MEF, and T4 Templates.
A Simple Application to Record Current Geographic Location and Display in Web
by Amit Kumar Dutta
Discusses a technique to record current geographic location from mobile and display in web pages (with Location History Browsing)
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 MVC Application using LINQ to SQL
by Sandeep Singh Shekhawat
This article introduces how to create an MVC application using LINQ to SQL. You will create a simple MVC application for Book registration with a Publisher where the Publisher and Book have one-to-many relationships.
A simple POC using ASP.NET Web API, Entity Framework, Autofac, Cross Domain Support
by Anand Ranjan Pandey
The purpose of this article is to create a proof of concept to demonstrate the feasibility of ASP.NET Web API Beta Version.
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 simple VB.NET stress utility for SQL Server 2000
by Alberto Venditti
This article describes a VB.NET tool to test the performances of a Microsoft SQL Server 2000 user database.
A Simplified SQL-CSV Import/Export Functionality
by codeajay
A simplified SQL-CSV import/export functionality.
A Small Utility to Generate Cascading Delete SQL Script in Oracle
by ronald.cao@gmail.com
The article is to introduce a utility to generate cascading delete script for an Oracle table.
A sorting and paging DataGrid loading data on-demand, saving changes in bulk from and to an Oracle database, in ASP.NET
by Patrice Borne
This article demonstrates how to implement a paging DataGrid with an Oracle database. It also demonstrates how to limit the volume of data to exchange between the Web Server and the browser by retrieving only the rows necessary and updating changes in bulk.
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 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 Transact Sql version of C strtok() using a table valued function
by Faustino Dina
Publishes a Transact-SQL function for parsing a string containing a delimited list, similar to the ANSI C languaje strtok() function.
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 Visual SQL Query Designer
by Bernardo Castilho
This article describes the implementation of a QueryDesignerDialog class that allows users to create SQL queries based on a given OLEDB connection string.
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.
Absolute Beginner's Tutorial on Understanding and Using Dapper ORM
by Rahul Rajat Singh
This article introduces Dapper to absolute beginners.
Abstract Data Access Layer Design
by Anwar Ibáñez O'Kamell
The present document tries to describe the architecture of a specific layer of access to data for relational databases. This document tries to present/display a form to automate tasks of access to data.
Abstract Nonsense in Software Development. Databases
by Petr Ivankov
Application of abstract approach to database domain
Abstract Simplified Stored Procedure Execution using .NET Interfaces
by Oleg Vorkunov
Abstract simplified stored procedure execution using .NET interfaces without dealing with ADO.NET classes
Accelerate database performance using In Memory CSQL Cache
by praba_tuty
CSQL Cache is an open-source high performance, bi-directional updateable data-caching infrastructure that sits between the clustered application process and back-end data sources to provide unprecedented high throughput to your application
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 data using Language Integrated Query (LINQ) in ASP.NET web pages – Part 1
by Balamurali Balaji
Access various types of data using the LinqDataSource control in ASP.NET.
Accessing Data using Language Integrated Query (LINQ) in ASP.NET WebPages – Part 2
by Balamurali Balaji
Access various types of data using LinqDataSource control ASP.NET
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 SQL Server over Network .NET Application
by ASP.NET Community
1) Install SQL Server on Window Server 2003/2008 on Network (Select Network option when installing SQL Server)2) Configure Windows Server as a domain
Accessing the Borland Database Engine (BDE) from Visual C++
by Robert Pittenger, MCPD-EAD
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
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 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 EntityFrameworkCore Support to .NET Core Project
by Benktesh Sharma
Demonstrate how to add EF support in .NET Core project
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 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 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 Implementation of Google API IDataStore
by freedeveloper
Simple Implementation of Google API IDataStore that use MS-SQL server to store your token file
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 Microsoft Content Management Server Development: Chapter 5: Searching MCMS with SharePoint
by Mohan Raphel
In this chapter, we discuss a few of the options available to MCMS developers for adding search functionality to their sites. We also take an in-depth look at the searching features built into SharePoint Portal Server and how they can be leveraged as a back-end search workhorse for an MCMS site.
Advanced WPF TreeViews in C#/VB.Net Part 4 of n
by Dirk Bahle
Tips & Tricks on loading and saving WPF Tree View based content.
Aggregation in MongoDB
by Vikas Sharma
In this article, we will focus on aggregation pipeline. I'll try to cover each major section of it using simple examples. We will be writing mongo shell commands to perform aggregation.
Agile BI: Move Beyond SharePoint Dashboards & MSRS Reports
by David Abramson
Discover how quickly and easily you can create BI apps, deploy scalable dashboards and reports, and embed analytics into existing apps. You can then deploy your apps to any number of users on any platform, including mobile - all without per-user fees.
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.
AI-Enhanced Data Science with Azure Synapse Analytics Part 3: Training and Using Models and Enriching Data
by MehreenTahir
In this article we explore how to enrich our data using a pre-trained model and trigger an Auto ML experiment from a Spark table.
Airclaims uses SQL Toolkit applet to save money, open new revenue streams
by Redgate Software
Using SQL Toolkit to remotely update customers' databases on the fly.
Ajax
by ashishparihar1310
The objective behind writing this article is to make use of Ajax Control Toolkit in implementation.
AJAX and PHP: Building Responsive Web Applications: Chapter 5: AJAX chat and JSON
by Mohan Raphel
In this chapter, we'll implement our own online chat application. We'll use this occasion to learn about JSON (JavaScript Object Notation), which represents an alternative to XML for representing data exchanged between the web browser and the web server.
AJAX Demystified - Part Two - The AJAX DataGrid
by DreamInHex
Create an AJAX DataGrid that binds, sorts and pages with no post-backs
AJAX grid with ASP.NET 2005
by LeleHalfon
A great AJAX Grid very customizable. In English & Spanish traduction
AJAX Slider Control and GridView Rolodex
by Steve Krile
Create a Rolodex type control for viewing contacts using the SliderExtender control and the GridView.
Alibaba Cloud MaxCompute vs. AWS Redshift vs. Azure SQL Data Warehouse
by Twain Taylor
This post explains how to use data warehouses in the cloud, and compares popular options on major public cloud platforms.
Alternate Rows Coloring in SQL Reporting
by Jay Kulaindevelu
To change the row colors in reports.
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 Adventure in Creating a SOLID DAL
by Dave Elliott
An attempt to create a flexible and re-usable Data Access Layer
An Approach to Viewing the Structure of a Database Using VB 2005
by salysle
This article describes an easy approach to examining all of the tables, views, and columns in a database.
An Easy But Effective Way to Split a String using Transact-SQL
by Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
An Easy Way to Get a File Name or a File Extension from a User Defined File Path using Transact-SQL
by Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
An Example ASP.NET MVC Web Project to Upload and Download Files
by Dr. Song Li
This article introduces an example ASP.NET MVC web project to upload and download files.
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 Implementation of Dynamic Connection String and Cursor Handling using Enterprise Library 2.0 in an ASP.NET 2.0 Application with an Oracle Database
by Yunyou Yao
This article will explore some solutions for dynamic connection string and cursor handling using Enterprise Library 2.0 in an ASP.NET 2.0 applications with an Oracle database.
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 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 Embedded Databases for IoT Developers
by Wayne Applebaum
Actian Zen provides the embedded systems developer with an ACID compliant database that is capable of seamlessly networking across a wide variety of environments, speeding up development, and decreasing maintenance costs.
An Introduction to Serverless Functions on Azure
by Ryan Peden
Get up and running with serverless by creating a geocoding function on Azure
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 SQL Server Notification Services
by Jason R. Hall
This article will provide you with enough information to peak your interest in one of Microsoft’s newest services designed to run under SQL Server 2000, and to take advantage of the .NET initiative.
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 Open Source RDL Engine
by Mike Emerson
An Open Source RDL engine for rendering reports to WinForms or ASP.NET
An SQL execution engine for DataSets
by Lachlan Keown
Describes a crude method of executing an SQL statement against an in-memory DataSet and returning a new DataSet containing the result table(s).
Analysing Big Data in Real Time #1
by CatchExAs
How Formula 1 is beginning to use StreamInsight to broadcast data analytics to your screen in real time
Analysing Big Data in Real Time #2
by CatchExAs
StreamInsight: A simple demonstration
Analyze Live Salesforce Data in Infragistics Reveal by Connecting through CData Cloud Hub or CData API Server
by Jerod Johnson
In this article, we walk through connecting to Salesforce from CData Cloud Hub & CData API server and connecting to either product from Infragistics Reveal to create a simple dashboard.
Analyzing 200 years of climate data using SAP HANA and Amazon SageMaker
by Allister Beharry
Using data from the Global Historical Climatology Network project we can crunch, analyze, and make predictions using gigabytes of numeric climate data collected over two centuries with the SAP HANA in-memory database and Amazon SageMaker hosted Jupyter notebooks.
Angular 2 & .NET Core Developing Web App From Scratch Part 1: Implementing Restful Web Server
by O.Nasri
Great article to learn how you can create web application from scratch using Angular2 & .NET Core Web API
Angular 6 Application with Cosmos DB and Web API 2
by Sarathlal Saseendran
We will create an Angular 6 application with Cosmos DB and Web API 2.0.
Angular JS Dynamic Menu Creation using MVC and WCF Rest
by syed shanu
This article shows how to create a menu dynamically from a database using AngularJS, MVC and WCF Rest service.
Angular JS Filter, Sorting and Animation using MVC and WCF Rest
by syed shanu
How to use AngularJs Filter, AngularJs Sort, AngularJs Animation, Image Mouse Over and Mouse Out Event
Angular JS Shopping Cart using MVC and WCF Rest
by syed shanu
Use AngularJS and WCF Rest Service to create a simple Online Shopping Cart
Angular Shopping Cart for Affiliate Marketing - Angular 5
by Bill SerGio, The Infomercial King
Angular Shopping Cart for Affiliate Marketing in Angular 5 that Is Responsive with TV Commercials with Powerful Features that Drive Real Sales like Unlimited Distributor IDs for Commissions with Editor
Angular Single-Page Applications - Cool Privilege Control System
by wells cheung
Angular Single-Page Application, MEF, Privilege Control, WCF Restful Service, ui-router,
Angular UI-Grid Pagination Server Side
by Shashangka Shekhar
In this post I am going to demonstrate how to use Angular UI Grid with server side pagination in ASP.Net MVC application.
Angular5, ASP.NET Core CRUD for Inventory Management using EF and WEB API
by syed shanu
In this article lets see in deep on how to work with WEB API, EF for performing a Inventory Management priority based Reorder level system CRUD operation using Angular5 and ASP.NET Core application
AngularJS and REST API
by charles922
AngularJS and REST API Tutorial
AngularJS and REST API - Part 2
by charles922
AngularJS and REST API Tutorial - Part 2
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 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
Antivirus Part--2
by VISWESWARAN1998
An opensource antivirus engine which uses Yara, Locality Sensitive Hashing to detect malware
API Authorization NodeJS
by Shashangka Shekhar
In this post we are going to secure our NodeJS API’s with customized security token generated by logged user and HTTP actions.
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 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.
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?
Arkitech Platform Framework
by Terence Wallace
The primary purpose of this article is to provide quality sample source code for VB.NET developers interested in building data-centric applications using the .NET Framework.
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].
ASCII/Multibyte to Unicode Conversion
by carlop()
An article about converting ASCII/Multibyte to Unicode using C# and SQL/CLR integration.
ASP .Net Web Page Optimization Checklist
by Paladugu Sai Krishna
This article gives a simple checklist that can be simply run on any ASP .Net Web Page to optimize it.
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 2.0 Illustrated - Chapter 2: Is It Really This Easy?
by Addison-Wesley
This chapter presents a scenario-based demonstration focused on a day in the life of a developer who is in the process of fulfilling the requirements of a fictional customer.
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 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 2.0 & Angular 4: Build from Scratch a Web Application for Vehicles Management
by O.Nasri
ASP.NET Core 2.0 & Angular 4: through this tutorial, you will learn how to build from scratch a web application for vehicles management
ASP.NET Core 2.0 User Role Base Dynamic Menu Management Using Dependency Injection
by syed shanu
In this article, we will see in detail how to display role-based dynamic menu after a user logs in. For this, we will create a Menu Master table and insert a few records to display the menu and link the URL to the menu based on the logged in user's role.
ASP.NET Core Blazor and EF Core Raw SQL Queries for Stored Procedure
by syed shanu
Creating an SP to search and bind Customer details in Blazor application
ASP.NET Core Blazor CRUD using Entity Framework and Web API
by syed shanu
In this article, we will see how to create a simple CRUD application for ASP.NET Core Blazor using Entity Framework and Web API.
ASP.NET Core Blazor Filtering and Sorting using Entity Framework and Web API
by syed shanu
This article will explain in detail about, how to create an ASP.NET Core Blazor Filter and Sorting for HTML Table using Entity Framework and Web API.
ASP.NET Core Blazor Master Detail Grid with Filtering and Sorting using EF and Web API
by syed shanu
In this article, let’s see how to create our own ASP.NET Core Blazor Master Detail HTML Grid with Sorting and Filtering using Entity Framework, and Web API. We also use the Dynamic Content features of Blazor to create our Master Detail Grid.
ASP.NET Core Microservices With Angular 11 Front End
by Yaseer Mumtaz
ASP.NET Core Microservices With Angular 11 Front End, API Gateway, Redis and SQL Server
ASP.NET Core, Angular2 Shopping Cart Using Web API And EF 1.0.1
by syed shanu
In this article let’s see how to create a shopping cart using ASP.NET Core, Angular 2, Entity Framework 1.0.1 and Web API with Template pack .
ASP.NET Core,Angular2 CRUD with Animation using Template Pack, WEB API and EF 1.0.1
by syed shanu
In this article, let’s see how to create a ASP.NET Core CRUD web application with Angular2 Animation using Template Pack, WEB API and EF 1.0.1
ASP.NET Core1.0 Insert/Select to Database Using Angular2 and WEB API
by syed shanu
In this article you will learn about Insert/Select to database using Angular2 and WEB API in ASP.NET Core1.0.
ASP.Net Core2.0, Angular6 - SPA
by Shashangka Shekhar
In this post, we are going to explore how a Single Page Application (SPA) sample can be put together using ASP.Net Core & Angular from scratch.
ASP.NET e-Commerce GridView with Product Comparisons
by Mike Barreyre
Demonstrates an e-commerce style grid with product comparison checkboxes, sorting, images in a database, expandible/collapsible product summary, selectable row display, and product comparison page.
ASP.NET Gridview Editable in Web Forms using Bootstrap 4
by Don Hoang
This post describes implementing ASP.NET Editable Gridview using Bootstrap 4
ASP.NET Gridview in Web Forms using Bootstrap 4
by Don Hoang
This post describes implementing ASP.NET Gridview using Bootstrap 4.
ASP.NET Issue Tracker Starter Kit in PHP and PostgreSQL (Race to Linux)
by Brian Hendrickson
How to setup and install the PHP issue tracker starter kit on a Linux server.
ASP.NET MVC Edit Primary Key Values for Composite Keys
by Matthew Katakam
ASP.NET MVC Edit Primary Key Values for Composite Keys
ASP.NET MVC Hotel Booking System Using AngularJS
by syed shanu
Tutorial for creating a simple web based Hotel Room Booking System using MVC, AngularJS, and WebAPI
ASP.NET MVC User Role Base Menu Management Using WEB API And AngularJS
by syed shanu
In this article, we will see how to create and manage a User Role based menu using ASP.NET MVC, WEB API and AngularJS.
ASP.NET MVC Web App on 3-Tier for Beginners – Part 1
by Mohd Manzoor Ahmed
ASP.NET MVC Web App on 3-Tier for Beginners – Part 1
ASP.NET MVC-5 CRUD Application with drop down list
by R M Shahidul Islam Shahed
ASP.NET MVC 5 applications
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 Pagination
by Srinivasu Pemma
This is most common but very important part of every developer's life, Taken from my technical blog http://www.srinetinfo.com
ASP.NET Providers for the ADO.NET Entity Framework
by Michael Ulmann
The introduction of the ADO.NET Entity Framework implicitly created the need for ASP.NET providers such as membership, role and profile that leverage this new technology.
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 Simple Survey Application
by Srinivasu Pemma
This kind of requirement is useful in many applications originally posted on http://www.srinetinfo.com/search/label/Survey%20Application
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 Web Component for editing SQL tables
by RovenetBill
ASP.NET c# component for editing SQL tables with plug-in column format adapter architecture.
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.
Aspect Oriented Programming Using C# and PostSharp
by Reza Ahmadi
This article discusses basic concepts in AOP and uses PostSharp to implement AOP concepts in a C# application.
Asynchronous HTTP Handler for Asynchronous BLOB DataReader
by Leon Segal
Includes description of an asynchronous HTTP handler (vs. alternative WebHandler) implementations that uses an asynchronous DB read operation to render a BLOB DB column as an image to any client browser.
Asynchronous Query Execution
by Vachik Hovhannisyan
Two classes that provide support for asynchronous SQL execution.
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 and Data Versioning with C# and MVC
by DataBytzAI
Method for implementing an audit-trail
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
Audit Trail using XML column in SQL Server 2005
by Sagar Sengupta
Implement audit trail technique using XML column in SQL Server 2005
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.
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 complete text box using AJAX (Using Atlas)
by rperetz
How simple it is to have your own auto-complete text in ASP.NET 2.0.
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-Generated visual basic source code from SQL
by Mr. xieguigang 谢桂纲
You see, this small utility tool save much of your time, this is another happy day! I hope you can enjoyed this code.
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
Automate the Generation and Distribution of Feature-Rich Excel Reports from a Server with SoftWidgets Spread Server
by SoftWidgets
In just a few minutes, predefined templates, containing formatted sheets and charts, can be generated from any database using simple SQL statements, macros and/or custom C# or VB.NET snap-ins. Generated files can be distributed to a file server or as an email attachment. Usually, no coding is needed
Automated dynamic report reconciliation process for SSRS using C#.NET and Nunit(.NET)
by Asanka Perera
This process can be set up to run on a daily basis to make sure that reports which are interrelated does reconcile with each other, in order to make sure the consistency in report quality.
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 Compilation and Distribution of Reports and Analyses
by JBartlau
This article demonstrates how Report Server offers a distribution of reports that save time, increase efficiency, and reduce potential errors.
Automatic Event Logging in LINQ
by David H. Smith
An event logging class, and an auto-logging LINQ DataContext descendant built around it.
Automatic Script SQL Server 2005 Objects and Commit under Subversion
by Ferreri Gabriele (Megasoft78)
Automatic script SQL Server 2005 objects and commit under Subversion
Automatically Create Data Access Layers and Business Layers From Microsoft Access or SQL Server Databases
by icemanind
How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database
Automatically Define the State of All Entities in the Graph in EntityFramework
by Farhad Jabiyev
One of the most popular questions is whether there exists a method which will automatically decide whether to insert, update or delete entity in the Entity-Framework. Now it is possible with EntityGraphOperations library.
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
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 Max Open Cursor Error In .NET
by Vivek Shaurya
Handling Oracle Max Open cursor error when fetching multiple rows in .NET.
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 - Learn materials
by ASP.NET Community
Abstract: Here we listthe materials which can help you know more about Azure and start itquickly. Welcome anyone add more if you have
Azure AD Managed Identities: Java Apps on Azure App Service
by Rahul__Sharma
How Managed Identities enable a Spring Boot web app running in Azure App service
Azure AD Managed Identities: Java Apps on Azure Kubernetes Service
by Rahul__Sharma
How Managed Identities enable a containerized Spring Boot web app running on Azure Kubernetes Service
Azure AD Managed Identities: Using Managed Identities to Obtain Key Store Credentials
by Rahul__Sharma
How Managed Identities enable a Spring web app to obtain credentials from Azure Key Store and use them to access both Azure APIs and external APIs
Azure Cosmos DB + Functions Cookbook— static client
by Matías Quaranta
Azure Cosmos DB is Microsoft’s globally distributed multi-model database, when we team it up with Azure Functions, Azure’s serverless compute service, the result is the ideal database for the serverless era.
AZURE Data Factory – Copy with Stored Procedure Data from One Database to Another on AZURE SQL
by Venkatesh Subbarao
How to copy tables with Stored procedure data from one database to another in AZURE SQL.
Azure Function as Output Job Topology of an Azure Stream Analytics Job
by Sibeesh Passion
In this article, we are going to see how we can set up an Azure Function as an Output job topology of an Azure Stream Analytics job. Doesn’t that sound interesting?
Azure Knowledge Base
by MartinDGut
An Azure Database to hold a Knowledge Base
Azure Synapse Analytics for SQL Server Gurus Part One: Overview
by David Norton
In this article we outline the problem: our fictional CEO wants to predict taxi use to ensure taxis are available where and when customers need them.
Azure Synapse Analytics for SQL Server Gurus Part Three: Analyzing and Using the Results
by David Norton
In this article we explore how to view and access model data.
Azure Synapse Analytics for SQL Server Gurus Part Two: Bringing in Data and Creating an ML Model
by David Norton
In this article we explore how to get data into Azure Synapse Analytics and build a machine learning model.
Azure: SQL Azure
by Sacha Barber
SQL Azure
Backup of MS SQL Database with Disk Space Check
by DataBytzAI
How to ensure there is sufficient disk-space for SQL backup before you run a backup!
Backup SQL Diagrams In Less Than 5 Minutes
by Yovav
Import, export and move your SQL diagram around using sysdiagrams
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 SSRS
by Bangla Gopal Surya Prakash
Basics of SSRS (Microsoft SQL Server Reporting Services)
Basics of Using a .NET Assembly in MS SQLServer - User Functions
by MrTimmins
Introduction to using CLR .NET assemblies in Microsoft SQL Server.
Batch Update on a very huge table
by Himanshu Kumar Sinha
Updating a huge table in Production , without locking the whole table .
Beginner’s Tutorial on Using the Firebird ADO.NET Client 2.5
by mbyamukama
In this article, I will show you how to interface your simple C# applications to the FirebirdSQL Server using the Firebird ADO.NET Client 2.5.
Best Practices for Database Schema Design
by Dean Pepper
Iron Speed Designer relies on the table relationships in order to determine how best to provide the quickest and most efficient experience.
Big O Algorithm Analyzer for .NET
by dawright, ProtoBytes
A heurisitc graphing tool to help discover 'Big O Notation' function thru infinite asymptotic's and instrumentation.
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
Binding dropdowns using Ajax
by Ganesan Sankaran
How to populate a dropdown in another dropdown change
Binding Several Data Sources to One Reporting Tool
by JBartlau
This article sheds light on why it is useful to combine different data sources in a report.
BizDraw framework for .NET
by Hayder Marzouk
A small framework to design and print documents containing shapes, text, images, bar codes...
BizTalk Server 2006 / R2 Throttling Mechanisms
by Nilay Parikh
BizTalk Server 2006 / R2 Throttling Mechanisms, BizTalk 2006 / R2 comes with good relief in terms of performance and throttling mechanism, if you work close to administrating and performance tuning job for BizTalk environment or any messaging system then you can visualize the complexity of pick proc
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.
Breaking the Law: Primary Keys in SQL Server
by Bryan Kowalchuk
Proper Key Column Design
Breaking Through the Analytic Limitations of Access and SQL
by John_Joseph
Breaking Through the Analytic Limitations of Access and SQL.
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".
Brief Introduction of a Continuous SQL-stream Sending and Processing System (Part 1: SQLite)
by Yuancai (Charlie) Ye
Application of SocketPro onto various databases for continuous inline request/result batching and real-time stream processing with bi-directional asynchronous data transferring
Brief Introduction of a Continuous SQL-stream Sending and Processing System (Part 2: MySQL)
by Yuancai (Charlie) Ye
Continuous SQL-stream Sending and Processing System
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.
Broadcast Real-time Updates from Azure Cosmos DB with SignalR Service and Azure Functions
by Anthony_Chu
In this article, we'll look at how we can use Azure Functions and SignalR Service to broadcast real-time document changes in Azure Cosmos DB to clients over WebSockets.
Bubble Wrap App: Put Your Scores to the Cloud
by Evgeny Vinnik
A simple workaround for Windows Phone 7 apps to work with SQL Azure directly.
Build a .NET Core console app to manage data in Azure Cosmos DB SQL API account (SDK Version 3 Preview)
by Microsoft
In this tutorial, you learn how to build a .NET Core app to manage Azure Cosmos DB SQL API data.
Build a .NET web app with Azure Cosmos DB using the SQL API and the Azure portal
by Microsoft
This quick start demonstrates how to create an Azure Cosmos DB SQL API account, document database, and collection using the Azure portal. You'll then build and deploy a todo list web app built on the SQL .NET API, as shown in the following screenshot.
Build a customized report using Oracle APEX
by nguyenannhon
This article introduces the steps to create a report with a custom search area.
Build a Node.js console app with the JavaScript SDK to manage Azure Cosmos DB SQL API data
by Microsoft
This tutorial shows you how to build a Node.js console application to create Azure Cosmos DB resources and query them.
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 based Chat using ASP.NET Ajax
by Jorge Bay Gondra
Build a GMail like web based chat using ASP.NET Ajax that can handle several requests and simultaneous users
Build a Web Chat Application using ASP.Net 3.5, LINQ and AJAX (in C# 3.5 or VB 9.0)
by junnark
We will create a very simple web chat application using the latest ASP.Net 3.5 technologies from scratch.
Build SQL Server Stored Procedures From Information_Schema Tables
by Dwight Johnson
Save hours of time by creating stored procedures and code from database metadata.
Building a 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 Chat App Using Weavy and KendoReact Conversational UI for React
by Klas Jersevi
This tutorial demonstrates how you can use the KendoReact UI framework to work with data that is being served from and persisted in Weavy.
Building a Database Application using OLE DB
by Yulianto
An article on building a Database Application with OLE DB
Building a Hybrid Active Directory and SQL Table DataSource View
by noahhath
Building a hybrid Active Directory and SQL table DataSource view.
Building a prediction model using SaaS-based AutoML tool R2 Learn
by Afzaal Ahmad Zeeshan
R2 Learn, a SaaS-based end-to-end automated machine learning (AutoML) tool, makes it easy for data scientists or data engineers to get from importing a dataset, to training models and getting predictions in just a few steps.
Building A Recommendation Engine - Machine Learning Using Azure, Hadoop And Mahout
by Anoop Pillai
Doing some 'Big Data' and building a Recommendation Engine with Azure, Hadoop and Mahout
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 a website using twitter bootstrap
by Heiko Mohr
Create a simple cms project starting with bootstrap based layout
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 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 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 Serialization into Classes
by mcondon013
Code that adds built-in serialization functionality to your classes in C#
Building Websites with VB.NET - Chapter 7: Creating Custom Modules
by Mohan Raphel
In this chapter, we are going to walk you through creating a custom module for the CoffeeConnections portal.
Building WPF Applications with Self-Tracking Entity Generator - Data Validation
by Weidong Shen
This article describes how to do data validation with Self-Tracking Entity Generator for WPF/Silverlight.
Building WPF Applications with Self-Tracking Entity Generator and Visual Studio 2012 - Enum Support
by Weidong Shen
This article describes how to use the enum type with Self-Tracking Entity Generator and Visual Studio 2012.
Building WPF Applications with Self-Tracking Entity Generator and Visual Studio 2012 - IClientChangeTracking Interface
by Weidong Shen
This article describes the IClientChangeTracking interface generated by Self-Tracking Entity Generator and Visual Studio 2012.
Building WPF Applications with Self-Tracking Entity Generator and Visual Studio 2012 - Project Setup
by Weidong Shen
This article describes the project setup of building a WPF sample application with Self-Tracking Entity Generator and Visual Studio 2012.
BuildQuery - A Simple SQL Query Tool
by mbielski
A custom class that creates SQL queries without long and potentially confusing string concatenation
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.
Bulk Insert a .NET List to Database
by Praveen P R
This article presents a simple and efficient way to bulk insert any .NET list to the database.
Bulk Insert using ODP.NET
by viswaInfotech
Bulk Insert using ODP.NET
BulkInsert with the Entity Framework
by Måns Tånneryd
How to extend the Entity Framework with bulk insert functionality, using DbContext
Business Objects for CodeSmith
by JR Hull
Save time when developing large applications, by using code generation for your business objects.
C# & SQLite - Storing Images
by kribo
How to insert images / binary data into a database.
C# & SQLite 1007000
by kribo
.NET project with a SQLite embedded database
C# and Table Value Parameters
by gaurav_verma_mca
How to send bulk data using table value parameters from C#
C# class that creates 'INSERT INTO' SQL queries
by Adam Klobukowski
Class that creates INSERT INTO SQL queries.
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# Source for SQL Formatting
by Mitchell Vines
Source code for SQL formatting (now with formatting options)--as opposed to a utility, web service or plug-in/add-on...
C# WPF Dependency Injection Data Demo
by Baxter P
Dependency Injection Data Demo with Lazy Loading and Data Mocking
C#: Avoiding Performance Issues with Inserts in SQLite
by John Atten
If you are new to SQLite, you may well run across one of the most confounding of its implementation details the moment you attempt to do some sort of bulk or batch processing of inserts or updates. What you will discover is that unless properly implemented, inserting or updating multiple records
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.
Caching Interview Questions: Part 1
by Shivprasad koirala
Some caching interview questions: Part 1.
Calculating simple running totals in SQL Server
by Wendelius
Some simple scenarios to calculate running totals in SQL Server.
Call SSRS Reports by using C#
by Sandeep Kumar Tripathi
Call/Run SSRS Reports by using C#
Campus Classifieds using Windows Azure
by Tim Corey
Learn how to get started in Windows Azure by following the progress of an actual web application as it is constructed.
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
Capturing and Analyzing Deadlocks in SQL Server
by Manjuke Fernando
How to capture and analyze deadlocks in SQL Server
Cardar™, credit cards metadata organizer
by DrABELL
Store securely credit cards' structured meta-data, like contact info, PIN, APR on balance transfer/purchase/cash advance, and other terms/conditions
Cascading Deletes in LINQ to SQL
by salysle
This article will discuss alternative methods for performing cascading deletes using LINQ to SQL.
Cascading Deletes in LINQ to SQL with Visual Basic
by salysle
This article will discuss alternative methods for performing cascading deletes using LINQ to SQL.
Case Sensitive search with SQL
by koolprasad2003
his article explains you how to deal with Case Sensitive search with SQL
Case-Insensitive Sort of UTF8 Data Using System.Data.SQLite
by Dimitri Witkowski
SQLite lacks case-insensitive sort of UTF8 data. In this article, you will see how to get rid of this limitation in .NET.
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 Crystal Report Connection at Runtime in Visual studio 2005
by Imran A Momin
This project help you to change ur database at the runtime
Change Data Capture (SQL Server 2008)
by Muhammad Shujaat Siddiqi
Change Data Capture in SQL Server 2008 (shujaatsiddiqi.blogspot.com)
Change The Default CommandTimeout of LINQ DataContext
by S. M. SOHAN
An article that shows a simple way of changing the default value of the DataContext CommandTimeout
Check Database Size with Summary
by Kuldip Rindani
This script calculates size of every user database with summary
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
Checksum Verification
by smoore4
Loop through all files in a folder/subfolders and run a checksum that is stored in a database. E-mail descrepancies and results.
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.
Classic ASP and MVC
by Emmet M
MVC-like for classic ASP.
Clear the transaction log
by Fernando Finelli
dump the transaction log
Client Side Multi-Column Dynamic Pivot
by Jesús López Méndez
This article introduces you to client side multi-column dynamic pivot, a cleaner, simpler and elegant alternative to the complex and convoluted dynamic server side pivot.
Client Side Web Application Primer
by Super Lloyd
Sample Web Application using TypeScript, KnockoutJS, WebAPI, and T4 Templates.
CLOB Comparison Line by Line in PL/SQL
by Manuel Vidigal
An implementation of the Longest Common Subsequence (LCS) diff algorithm in PL/SQL.
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!
CLR Function for Persian Date Converter in Microsoft SQL Server
by Ali-DN
CLR Function for Persian Date Converter in Microsoft SQL Server
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 Generator for Business Data Objects
by Vinayaka Krishna Shenoy
This utility will help to generate the DataAccess Objects based on the Connection strring provided at the config file
Code Your Own PHP MVC Framework in 1 Hour
by Chris_Yu
To code our own MVC framework from scratch
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
Column Store Indexes in SQL Server 2012
by Vijendra(VJ)
This article explains the internals of column store index and the pros and cons of it.
Columnstore Index
by Santosh P Umarani
Columnstore Index
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.
Comics Subscription Tracker
by mf81
This will be a lightweight site that helps the user track their weekly comics subscriptions.
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)
Comparator - Data Sources Comparer
by Alex Pumpet
A simple program for comparing table data from two sources - SQL databases, Excel, CSV or XML-files
Compare SQL Database Schema
by Paritor
Application to show differences between two SQL Server databases.
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.
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
Computed Columns - Index and Performance
by pinaldave
A Finale of Series discussing Computed Columns, Storage and Performance
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 model in ADO.NET, ways that allow to negotiate disconnected model restrictions for Oracle databases
by Michael Milonov
Using ADO.NET conrurrent model in Oracle databases.
Concurrent User Updates in ASP.NET and SQL Server
by Murali Pamidi
ASP.NET - Concurrent user updates using the Timestamp column in SQL Server.
Conditional filtering in SQLAlchemy and Python
by DiponRoy
Conditional filter query example in SQLAlchemy and Python
Configure MS SQL Server 2005 Remote Access ( mixed mode )
by hong_wei_li@yahoo.com
Configure MS SQL Server 2005 Remote Access ( mixed mode )
Configuring Database 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 SQL Server
by ASP.NET Community
Most ASP.NET sites talk to SQL Server or a backend SQL Database and there's a number of ways to manage that configuration.I always start with the
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.
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 MySQL from Visual C#
by Lizandro Campbell
Using Visual C# 2008 to establish connection to a MySQL 5.1 database with MySQL Connector/NET 5.1.7
Connecting to SQL Server
by User 4838655
This article explains how to connect to an SQL Server and pass a string.
Connecting your Android app to your WAMP server
by henry sentio kauta
Android at figure tips
Connection String
by ASP.NET Community
The connection string specifies information about how to initialize a connection to a data store.It contains keyword/value pairs. the first pair is
Connection to DB2 from .NET
by Lukas_J
How to connect to IBM DB2 from .NET on Windows
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.
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
Contains like Search in SQL Server 2005
by ASP.NET Community
Contains Like search in SQL Server 2005 This is my first post to wiki. Here I have to show how to contains like search into sql server 2005.There is
Continue With Learning Indexes in MongoDB
by Sibeesh Passion
Continue with learning indexes in MongoDB
Continuous Database Integration
by Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
Continuous Integration for Databases with Visual Studio
by Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
Control a model car track with Azure and Arduino
by Freek Kootstra
This is a project to control the modelcars on a vintage toy car track using an Arduino and a Windows Azure service.
Control trigger logic based on user
by Wendelius
This article describes a mechanism how trigger actions bypassed based on database user information
Controlling Service Startup Order in Docker Compose
by Bogdan Marian
Ensure your Docker Compose services start in the correct order
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.
Conversion of Reporting Starter Kit to use Mono/MySQL
by StylezHouse
A porting of the ASP.NET reporting starter kit to use Mono, MySQL and Apache on a Linux system.
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 System.Type to SqlDbType
by Girish Chandra
Convert any compatible System.Type to SqlDbType.
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
Cool Privilege Control System Part 1 -- ASP.NET MVC
by wells cheung
Standalone Privilege Control, Single Sign-On Solution
Cool Privilege Control System Part 2 -- asp.net MVC with WCF
by wells cheung
Privilege Control System based on MVC and WCF.
Copy Database Schema and Data Using SQL Server Management Objects (SMO)
by Ameet Parse
How to use SMO to copy database schema and data using C#.
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.
Correlated Sub-Query vs. Case Statement
by Andy_L_J
A simple case study to compare the efficiency of using a Sub-Query vs a Case statement to perform data aggregation.
CourseLearner: Azure based E-Learning product
by Ravi Gadag
Azure based e-learning product.
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 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 Azure Database and use it via C#
by Emiliano Musso
In this short article we will see how to create a SQL database using the services provided by Microsoft Azure cloud platform, and then connect to it via C # code, to perform the normal data insertion and retrieval operations
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 in sql server using asp.net with C# (VS2005)
by Joshy_geo
Create database in sql server using asp.net with C# (VS2005)
Create data-driven applications with the Hera Application Framework
by 2sky
A brief overview of how the Hera Application Framework aids you in the development of data-driven applications.
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 Easy and Efficient Real-time Reporting with Open-source SPL
by Jerry Cruise
SPL can greatly simplify complex computing logics in real-time queries and speed up development with its Agile syntax and procedural programming.
Create First Data WareHouse
by Mubin M. Shaikh
In this article, I am going to show you the importance of 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 many-to-many relationships in LINQ for SQL
by Galin Iliev [Galcho]
Creating many-to-many relationships in LINQ for SQL.
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 Management Studio 12 Addin
by Bert O Neill
Develop your own SSMS ObjectExplorer\CommandBar menus, within SQL Server 12
Create SSRS Report in SQL Server
by pritik889
In this article, we will learn how to create a SSRS report, how to configure the reporting server and how to deploy the report.
Create View To Get All Constraints For Any Tables
by Rami Said Abd Alhalim
Create View To Get Constraints
Create Your Own Googlebot
by TeapotDev
In this article, I explain how to create an application like Googlebot - it finds and indexes websites throught hyperlinks.
Creating a Database Project with Visual Studio
by Nadege Rouelle
This article shows how to create a database project to manage database scripts in Visual Studio
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 Database-Driven Vista Gadget
by Bryan Sachdeva
his article demonstrates how to create an auto-refreshing Vista SideBar 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 Full Text Service and Searching items from Code behind
by ASP.NET Community
Open SQL Server and open a database (Already created) . On the Storage section find the Full Text Catalog. Right click and create a New
Creating a Mobile AJAX Process Using SQL Anywhere Web Services
by LeanneStuive
This article explains the basic AJAX technique, and explains the HTML, JavaScript, and SQL needed to use AJAX to access SQL Anywhere web services. It also covers how to use the AJAX process with a Windows Mobile 6 Device and the SQL Anywhere HTTP Server.
Creating a Private Installation for SQL Compact
by David Veeneman
This article discusses how to create a private installation for SQL Compact
Creating a REST Server for a CRUD Web Application from a very Light Stack
by DaveDbViewSharp
Using lightweight server and database components, the article builds a REST server that returns serialised JSON objects to a single-page web application written in JQuery or AngularJS.
Creating a shop website in ASP.NET
by Afzaal Ahmad Zeeshan
This articles describes how to kick start a shop website using ASP.NET and the software Microsft WebMatrix
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 and populating MS Access files from other databases, using DTS
by Malik Nasir
An article on creating and populating an automated MS Access file from other databases.
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 Charts Dynamically from Database, using VB.NET
by Malik Nasir
An article on generating an Excel sheet with different charts, based on the data in the sheet, and then emailing it.
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 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 Report using Report Builder and Oracle DB - Part 1
by Snesh Prajapati
In this article series (consist of two parts), I am sharing how to create report using Report Builder by fetching data from Oracle DB. As per requirement, before getting the data we need to run a stored procedure which will get data from table based on given parameter and then we need
Creating Report using Report Builder and Oracle DB - Part 2
by Snesh Prajapati
In this article series, I am sharing how to create report using Report Builder by fetching data from Oracle DB.
Creating Self Hosted ASP.NET WebAPI with CRUD operations in Visual Studio 2010
by Akhil Mittal
In this article I’ll explain how we can host aWebAPI in another process independent of IIS.
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.
Creating Web Based Music Player System Using MVC and AngularJs
by syed shanu
In this article, we will learn how to create a simple web based music player system using MVC, AngularJS and Web API.
Creation of Dynamic Charts in Report Builder
by AnnuAbraham
A single report can be used to display different sets of data.
Creation of XML for Microsoft Tree View Control from SQL Server 2000 Database
by SquaredRomi
Tree is used for hierarchical display of data and permits you to create effective user interfaces while easing development and maintenance time.
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 Generator - (Stored Procedure Generation)
by ColinBashBash
Simple code that can be updated. This generates CRUD procedures.
CRUD in ASP.NETCore MVC with Angular 2 and Web API
by O.Nasri
A good example of how to build a CRUD web application using ASP.NET CORE with Angular2 and WebApi
CRUD Opearations using AutoMapper in an MVC Application
by Akhil Mittal
How to do custom mapping and entity to entity mapping with the help of AutoMapper.
CRUD Operations in NancyFx using ASP.NET and FluentNHibernate Using Repository Pattern
by Gaurav Aroraa
Introduction In these days RAD (Rapid Application Development) is growing at its large. There are numerous framework available to develop Web Applications or Web Projects. We can use either ASP.Net or ASP.Net MVC from Microsoft or any other framework. Although, NancyFx is having its own support for
CRUD Operations in Python with SQL Database
by MukeshKumarTech
This practical demonstration will help you to understand how to implement CRUD (CREATE, READ, UPDATE and DELETE) operations functionality in Python with SQL database.
CRUD Operations with ASP.NET Web API using FluentNHibernate, Repository Pattern
by Gaurav Aroraa
In this step-by-step article, we will discuss all about CRUD (Create Read Update Delete) operations with Web API using Repository pattern.
CRUD USING .NET CORE 1.0, ANGULAR V2, WEBAPI
by Shashangka Shekhar
In our previous article we have seen how to startup with .Net Core. In this article we will take a look on database operation according to previous sample application based previous concept.
CRUD Using Scaffolding And Entity Framework
by syed shanu
In this article, we will see in detail how to create a simple Student Master CRUD (Create/Read/Update and Delete) using scaffolding.
Crystal Reports To PDF converter Without Crystal Report Viewer
by satalaj
Here You Can Convert Crystal Report To PDF
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
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
CTE In SQL Server
by Keshav Singh
CTE In SQL Server
Custom Aggregates in Oracle
by Wendelius
How to create custom aggregates in Oracle using PL/SQL
Custom Aggregates in SQL Server
by Wendelius
SQL Server not having the aggregates you need? Why not build your own.
Custom API using .NET SDK for SQL API at Azure Cosmos DB
by Srinivasa Dinesh Parupalli
Custom APIs using .NET SDK for SQL API
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 pagination and cascaded filtering with rad grid
by Nagaraj Muthuchamy
Design and implementation of custom pagination and cascaded filtering with rad grid.
Custom Paging and the GridView in ASP.NET 2.0 - You'll thank me for this!
by Erwin@Attentia
How to programmatically bind a GridView to a DataSource and let it show a pager.
Custom paging control
by RepliCrux
A paging control framework which can be reused.
Custom Paging Stored Procedure
by Mohan H Prajapati
It shows how to write custom paging procedure
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 Roles Based Access Control (RBAC) in ASP.NET MVC Applications - Part 1 (Framework Introduction)
by Stefan Wloch
An introduction to custom roles based access control in an ASP.NET MVC application using the Entity Framework.
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 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 Tokenization Database First
by Member 11896794
This custom database first approach token authentication will enable you to apply token-based authentication in your application in a simple way with no hassle.
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
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
CustomIdentity
by Anandhi Swamy
Customize Identity, Custom Principal with ADS
D.O.T.S. - Distributed Obfuscated Transmission of Status
by Henry Sheldon
A study in communication across multiple technologies using Azure cloud services, all based on a centralized informational domain
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.
DAO library extension
by Kevin Smith
My added DAO functionality makes database reading and writing easier
Dapper - The Pocket Rocket Mapper
by George Swan
An introduction to employing Dapper in an ASP.NET 7 application
DarkSide SQL Mini Version 1, The embedded database
by AnOldGreenHorn
An embedded database library in C++.
Data Access
by ASP.NET Community
There's a lot of great information on the net about accessing data in common data access patterns with ASP.NET 2.0. VideosSQL Server Videos  -
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 Access with .NET Platform
by Soufiane Rabhi
What you have to know about ADO.NET and Entity Framework
Data Archive
by Nikolai Serdiuk
This article describes creating indexed search systems using relational databases
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 Insertion from Flat file into SQL through BCP Utility
by Vishnu Prasad C
Data insertion from flat file into SQL through BCP utility
Data Mining with SQL Server 2005 without Analysis Services
by kvlcek
A C# implementation of CHAID for MSSQL 2005 à la Cognos scenario.
Data paging in the database (an ASP.NET approach)
by Horatiu CRISTEA
This article presents a data paging solution in the database. The paging operation was moved on the data layer.
Data Parsing SQL to JSON
by Abhishek Jaiswall
Data parsing SQL to JSON
Data Science - Journey through Life Cycles. Part 1
by @Abdul Azeez Thekkekandy
This article explores Data Science lifecycles - Business Understanding, Data Understanding and Data Preparation
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.
Database Build Tool
by Duncan Edwards Jones
An extensible tool to package and deploy database schema objects
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 Design and Naming Conventions
by Alaric Dailey
Design for data integrity, simplified SQL, and programming ease.
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 for Financial Accounting Application I: Basic Requirements
by Niemand25
Designing a simple yet functional database for financial accounting application
Database for Financial Accounting Application II: Infrastructure
by Niemand25
Designing simple yet functional database for financial accounting application
Database for Financial Accounting Application III: Completing Infrastructure
by Niemand25
Designing a simple yet functional database for financial accounting application
Database for financial accounting application IV: General Purpose Documents & Fixed assets
by Niemand25
Designing a simple yet functional database for financial accounting application.
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 Independent Access
by Jaryl Sim
Use different database providers without tying implementation to one.
Database info tool
by Massimo Colurcio
Explore the structure of tables (and views)
Database Integration With SQL Azure
by nitinnigam21
This article will allow you to move your database from SQL Server to SQL Azure to enhance the performance of your application that has been deployed on the Azure Cloud.
Database Programming With MySQL
by pseudonym67
Getting MySQL running and programming it with KDevelop.
Database Resetter
by Michiel de Rond
A little tool to make life while developing with databases a little easier.
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 Script Generator
by Ajey Dudhe
This utility can be used to compare two MS Access databases for changes in the data. You have the option of generating the SQL scripts and\or a summary XML
Database Security Testing In the Light of SQL Injection Attack
by HARISHCHOWDHARY
This article explains how to secure database against the SQL injection attack
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 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
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.
DataGridView CRUD With Saving Image to SQL Server using C#
by syed shanu
In this article, you will learn how to perform DataGridView CRUD with saving image to SQL Server using C#.
DataGridView Gantt Style Chart Using C# WinForm
by syed shanu
In this article, we will learn about DataGridView Gantt Style Chart Using C# WinForm.
DataLayer - Freeware ODBC Library
by darkoman
An article on a simple ODBC SDK wrapper library.
DataLoaders - Unified Data to Object Binding
by David Wulff
A framework to completely separate objects from their data source - allowing any data source to be used without prior consideration in your code or designs. Databases, text files, web services and potentially anything else can all be used or swapped transparently.
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 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.
DB to Browser - Easy Silverlight Overview
by J van Rooyen
A simple article: From DB to Browser using Silverlight
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
DbForge SQL Complete helps SQL developers become first class IDE citizens
by g00p3k
Coding in SQL Server Management Studio doesn't have to be relegated to a second class citizen with the proper tools...
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.
dbObject - Database code generation using attributes
by wduros1
A poor man's OR tool for generating VB.NET database code against a MySQL database.
DbProvider Profiler using WCF and DbProviderFactory Injection: Part II of IV
by Pieter Van Parys
Creating profiling information in our ProxyDbxxx classes
DbReaderGenerator Library
by Paulo Zemek
Generate DataReaders at run-time and get the best performance by avoiding repetitive code and by using the database's most appropriate Get methods.
DbSharpApplication (DAL Generator Tool on .NET6, and released new version on .NET8)
by Higty
A DAL generator that generates StoredProcedure client class and creates Table and Record classes
Dealing with DataTables
by Star_Friend
All you want to know about how to deal with DataTables.
Debug Stored Procedures in Visual Studio and SSMS
by Kuv Patel
Debug stored procedures in Visual Studio and SQL Server Management Studio.
Debug your stored procedure
by koolprasad2003
This article will help you to know how to Debug your stored procedure
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.
Dependency Injection : How Exactly Inversion of Control Takes Place
by Rasik Bihari Tiwari
Dependency injection, DI containers, IoC containers and Inversion of control are a world of confusion. Let's take them head-on.
Dependency Injection and Unit Of Work using Castle Windsor and NHibernate
by Halil ibrahim Kalkan
An implementation of dependency injection, repository and unit of work patterns using Castle Windsor and NHibernate.
Dependency Injection using Unity Framework with ASP.NET MVC
by Saineshwar Bageri
In this article, we are going to have a look on how touse Unity framework with MVC to remove hard code dependencies from Application.
Dependency Inversion Principle - What you always knew about DIP wasn't that accurate. Let's keep it simple
by Rasik Bihari Tiwari
Let's understand exactly what is Dependency Inversion principle and what it is not. How people confuse it to be dependency injection which is it NOT.
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.
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 and Develop a website using ASP.NET MVC 4, EF, Knockoutjs and Bootstrap : Part - 2
by Anand Ranjan Pandey
Design a website architecture that must be simple, easily understandable by any web designer using asp.net MVC, EF, Knockoutjs and Bootstrap
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.
Designing SSAS Cube
by Ajit Kumar Thakur Microsoft
This article explain step by step approach to implement SSAS Cube.
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.
Detect Changes To A Database Table
by Pradeep Fernandes
This article sorts to illustrate one of the ways by which data table changes can be detected through the use of available aggregate functions like BINARY_CHECKSUM and CHECKSUM_AGG.
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
DeveelDB - A Brief Introduction
by Antonello Provenzano
A description of the base functionalities and usage of a full-featured open-source pure .NET/Mono embedded RDBMS
Develop high performance distributed applications with batching, asynchrony, and parallel computation
by Yuancai (Charlie) Ye
Performance comparison between SocketPro and .NET remoting.
Developers ensure database accuracy
by Redgate Software
SQL Data Compare and SQL Packager help iCOMCept ensure customer’s database accuracy
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 Automated Data Purge Solution
by DaveAuld
Too much data is breaking the system, we need a fix!
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 Fully Functional Data Grids with Jquery DataTable and ASP.Net Generic Handler
by Muhammad Shoaib Raja
Fully functional web data grids with multi column sorting, filtering and pagination using JQuery based data table plugin and .Net generic handlers
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 Reports Using Microsoft Reporting Add-In control.
by satish.phadke
Tutorial for Developing Reports Using Microsoft Reporting Add-In control.
DEVELOPING SSIS in Visual Studio 2005
by hussain.attiya
DEVELOPING SSIS to import oracle records to sql server
Development Inline Comment while working in team
by Jigar Mehta
Inline Development Comments Automation
DevOps in 2015 – Beyond Basic Metrics
by Jeffrey T. Fritz
How IT operations can engage more with a customer’s experience and assist software development in isolating problems in a production environment with no code changes needed from the development engineers.
Dev's User Guide To SqlLocalDb (Sql Express)
by raddevus
Learn the basics (and challenges) of using LocalDb to make your SQL dev easier and localized using tools like SqlLocalDb, sqlcmd and built-in Visual Studio server explorer. Now, also includes SqlCmd scripting.
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 @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT
by Samrat Banerjee
Difference between SQL @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT functions
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.
Differences Between Various Joins in MS SQL Server
by DiponRoy
Here, we will see the basic differences or similarities between various joins of MS SQL Server.
Different Forms to Select Data using SQL and .NET
by Luis Ramirez
This article gives a brief introduction to development tools available that help you to select data using SQL and .NET
Different Ways to Maintain Audit Information for DML in SQL
by Avinash A. Dhumal
Implement an audit mechanism for your DML objects
Digging SSIS object model
by Moim Hossain
Describes SQL server 2005 Integration Service object model and different data flow components
Dimension loading with executing SQL tasks in SSIS for SCD type 1 and type 2
by Gyanendra Jaiswal
Dimension loading using SQL task gives better performance than SCD transformation.
Direct access to C++ native code from C++/CLI MSSQL Stored Procedure
by Peter Kovalchuk
Reading hardware information in Stored Procedure
Directory Monitor Service controls SSIS Package Execution
by Kuthuparakkal
WMI based DirectoryMonitor triggers SSIS Package execution.
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.
Discretionary ACL Authorization Security Model in Web Applications with NHibernate
by dB.
A practical object-level security approach.
Display/Store and Retrieve Image Data from Database to Gridview, and also on Mouse Over
by Al Moje
How to Display/Store and Retrieve Image Data from Database to Gridview, and also on mouse over
Displaying , Exporting and Printing Crystal Reports in ASP.NET
by patelsachin
Displaying , exporting and printing crystal reports in ASP.NET with source code.
Displaying Images from a Database in a GridView
by Abhijit Jana
A simple guide for beginners, explaining one method of displaying images taken from a database on a GridView inside an ASP.NET web page
Displaying multiple dynamic images in a WebForm
by gayansm
An article on using dynamic images in web pages.
Dissecting LINQ to SQL
by Zeeshan Jafar Hirani
Where LINQ to SQL shines as compared to other ORM tools in the market is the fact that it abstracts away the database structure behind our business objects, it also supports a query language called LINQ.
Distance between locations using latitude and longitude
by Gary Dryden
Calculate the distance between two locations given their latitude and longitude.
Dockerize A Simple Web-Application Created By Using Python, Flask and PostgreSQL
by Arthur V. Ratz
Create a Python web-app using Flask and PostgreSQL server, and run it in Docker
Document approval workflow system
by Refky Wahib
Generic, full cycle of document approval workflow system, using Windows Workflow Foundation (WF).
Document SQL Server 2000/2005 Database
by Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
Documenting MS SQL Server Databases
by Evgeniy Gribkov
The examples of SQL Server database documentation using both the extended properties and a third-party utility.
Dotnet eXtended framework
by Hugo Pais Batista
Extend the .NET framework power with DotNetX - free libraries that allow you to generate code, cache database objects, etc.
DotnetCore and Angular2: Create a Users Management Interface
by O.Nasri
You will learn how you can build a management user interface using DotnetCore, Angular2, typescript and web API.
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.
Downgrade SQL Server 2008R2 from Enterprise to Standard Edition
by KASQLDBA
Downgrading from Enterprise to standard edition (SQL server) for those servers which are not using any of enterprise features.
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.
Drag and Drop on a Windows Form
by Sigurd Johansen
How to insert an image on a form in runtime mode, dragging it to the right position and by using a database retrieve the position and shape when starting the application up again
Drag and Drop Products to the Shopping Basket Using JavaScript
by azamsharp
Create draggable objects and drop them in a shopping cart
Drag and Drop Sortable Lists using jQueryUI, jQuery AJAX, ASP.NET Web Methods and a Detachable Entity Framework Data Repository
by Wes Grant
Sortable list with jQuery persistance.
Drawing shapes on spatial tiles with SQL CLR
by Den367
Short glance at drawing on geographical tiles by using of Microsoft.SqlServer.Types assembly.
DRY Database Interactions (.NET 2.0)
by Mark Ericksen
Don't Repeat Yourself (DRY) when working with your database. Simple and easy code that makes it harder to make common mistakes.
DSL and SQL Server Modeling CTP
by Hossein Ghahvei Araghi
This article is about DSL and SQL Server Modeling
DTS Export
by KRISHNA PRASAD.N
Article to export MS DTS packages from one server to another.
Dumping SQL Data in Pivoted Format
by bobleith
How to dump SQL data in pivoted format
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.
Duplicate songs detector via audio fingerprinting
by Ciumac Sergiu
Explains sound fingerprinting algorithm, with a practical example of detecting duplicate files on the user's local drive.
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 Cursor with sp_executesql and OpenXML
by Tina83
A cursor for dynamic query.
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 Generate Stored Procedures
by Rami Said Abd Alhalim
Create Stored Procedure to insert command on any tables
Dynamic High Performance Query Builder using DataTables and LinqKit for Over a Million Records
by Syed Hasan Hyder
Provides plausible and high performing data display, for very large data (over a million records)
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 Pivot Grid Using MVC, AngularJS and WEB API 2
by syed shanu
Simple MVC Pivot HTML Grid using AngularJS and Web API 2
Dynamic Project Scheduling Using MVC and AngularJS
by syed shanu
In this article, we will create a simple dynamic project scheduling from a database using a Stored Procedure using MVC and AngularJS.
Dynamic Query Builder for Dapper
by Rick Drizin
Dapper Query Builder using String Interpolation and Fluent API
Dynamic Querying with LINQ-to-Entities and Expressions
by Todd Sprang
This article explains how to create a general-purpose data-access library for creating dynamic queries using LINQ-to-Entities.
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 Add Access Database Columns at Runtime using VB.NET
by Rob Culhane
How to dynamically add access database columns at runtime using VB.NET
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 Pointing to Shared Data Sources on SQL Reporting Services using a Report Definition Customization Extension (RDCE)
by Carlos Alberto Cabrera Gonzalez
This article shows a detailed approach on how to dynamically point to a given shared data source reference by setting up an RDCE and using a couple of tips and tricks.
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
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.
Easily use ADO in DataGrids, DropDown Lists
by Frank Kerrigan
An article on easily binding ADO data to control using reusable code.
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 Form Design at Run Time C# Winform
by syed shanu
Design your Winform at Runtime.Perform CRUD operation to your Form at Runtime with out writting any code using Stored Procedure.
Easy SQL Server Tool Using C#
by syed shanu
In this article, we will see how to create an easy SQL Server Tool.
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.
E-Commerce Product Management Database Model with Coder's and DBA Perspective
by Abhinav Kumar singh (Aman)
Learn an interesting way to design database with coder's perspective
EF Core Contexts Sharing Transaction
by Rudi Breedenraedt
How to share a transaction across multiple Entity Framework contexts
EF Feature CTP5: Raw SQL Query/Command Support
by Gil Fink
EF Feature CTP5: Raw SQL Query/Command Support
Effective Paging with GridView Control in ASP.NET
by Abdul Quader Mamun
Paging must be effective for large scaleable applications. Without smart and effective paging and sorting for huge amount of data, user request takes more time and uses more resources.
Effective paging with List View control in ASP.NET
by Abdul Quader Mamun
To develop scalable applications, effective paging is essential. Devoid of smart and effective paging and sorting to handle thousands of thousand data takes extra time and system resources.
Efficient data processing with ADO in C++: Method GetRows
by Vitaly Tomilov
Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.
Efficient Paging with Repeater and SQL Server 2005 / 2008
by perels
An efficient implementation of paging using a Repeater and the OVER() keyword in SQL Server 2005.
Efficient Representation of a Semigroup in C++
by Vadim Stadnik
Generality and efficiency of a semigroup in C++ are achieved by using an augmented B+ tree. Basic and advanced applications of such a semigroup are discussed.
Email Search Engine
by SarmadAsghar
Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5
Embedded Firebird: Full-Featured Embedded Database with 2 MB Runtime
by Dan Letecky
An example that shows how Firebird database excels in embedding.
Embedded IoT Databases with Actian Zen and Python
by Ryan Peden
We’re going to look at how to use an embedded database – Actian Zen – to store and process data on a Raspberry Pi.
Employee Info Starter Kit - Getting Started
by ASP.NET Community
Employee Info Starter Kit is an open source ASP.NET project template that is intended to address different types of real world challenges faced
Enable Cross-origin Resource Sharing (CORS) in ASP.NET Core
by Shashangka Shekhar
In this article, we will focus on how to enable CORS in ASP.NET Core application, get knowledge about CORS policy how we can share resource through different origin.
Encrypted columns and SQL Server performance
by Dmitry Tsuranoff
Examining the effects of column encryption on SQL Server performance
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: Designing Applications and Services in .NET - Part I
by venugopalm
A guided tour of the distributed enterprise application design in .NET
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 CRUD Operations Using Stored Procedures
by demouser743
How to implement CRUD operations using Stored Procedures in Entity Framework.
Entity Framework Dynamic Report
by Maxim Kurayan
EF Dynamic Report is a small open source project which allows you to use Entity Framework mapping between types and tables as a dynamic report data source
Entity Framework with nHydrate
by Christopher R Davis, Michael S Knight
Generate an Entity Framework data access layer using an nHydrate model.
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.
ETL Testing, If Only An Automation Rule Testing Engine was Possible …
by Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
Evaluating SQL Server Data Tools
by Torsten Tiedt
Database development with Server Data Tools
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.
Examples for Creating Oracle Functions
by Wendelius
The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.
Excel to SQL without JET or OLE
by Kelvin Armstrong
Import an Excel ".xls" into SQL without the use of JET or OLE
Excel to SQL without JET or OLE (Version 2)
by Kelvin Armstrong
Import an Excel Workbook ".xls" or ."xlsx" into SQL without the use of JET or OLE
Excel user defined functions unlimited
by HerbD
Describes how to return tables of values as the result of user defined functions (UDF) in Excel.
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 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.
Expandable Rows in GridView
by phil2415
Add expandable rows to a GridView for master/detail view.
Expanding SQL Hierarchies: The Dualistic Approach
by Sergey Sorokin
This article discusses a method for retrieveing hierarchical data from a relational database
Experimenting Custom Build Providers
by Cristian Odea
A simple OR Mapper built with custom build providers, which reads data from XML files.
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 output of SQL Server script to Excel (SSIS)
by Peter Elzinga
This is a generic solution for converting the output of any SQL server script to an Excel file (using SSIS).
Export/Import an Oracle database with date range without constraint issues
by J Chandra Sekhar Achary
Useful tips for Oracle import/export to address constraint issues.
Exposing a Stored Procedure in WCF Data Service
by Gil Fink
How to expose a stored procedure in WCF data service
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 C# to Support SQL Syntax at Compile Time
by Chad Z. Hower aka Kudzu
Ever wished you could truly embed SQL functionality in your C# code without using strings or late binding? Imagine being able to write complex Where clauses purely in C#.
Extending Kerosene ORM for WCF support
by mbarbac
Kerosene ORM support for complete database-alike WCF services and connections
Extending Modern Apps to the Web: Slot Machine
by jluhman
How to take an existing Windows 8 and Windows Phone 8 Modern app and extend it to the web.
Extreme Designing
by RedSunBeer
test the apps design
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
Fast GridView
by Dav Zen
A fast and optimized GridView.
Fast Typo-Insensitive String Matching in a Program and a Database
by David Wincelberg
Strings that differ by typos can be matched.
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.
Filtering LINQ Queries Using Business Rules Engine
by Code Effects
This article discusses the use of one such new feature, namely, rule-based filtering of LINQ queries using Web Rule, the XML-based super-fast rules engine, implementable as an ASP.NET or MVC component.
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 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.
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.
Flash and .NET with FlashRemoting
by daniel_nilsson
Testing FlashRemoting with .NET.
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 (AUTO Mode): 2 of 4
by AhsanAhmed
A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format
FOR XML Basics (EXPLICIT Mode): 3 of 4
by AhsanAhmed
A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format
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
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
Formatters and Content Negotiation in ASP.NET Web API 2
by Akhil Mittal
This article will focus on practical aspects of formatters and content negotiation in ASP.NET Web API
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
FreeCal - GPIB Instrument Automation for Metrology Test and Measurement
by Scott Page
FreeCal is a free 100% .NET suite of utilities and instrument drivers for controlling multiple instruments in a Test and Measurement environment.
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 to Linq
by Ronnie Mukherjee
From SQL to Linq
From SQL to SOQL
by Dan Appleman
What are the differences from a software developer’s perspective of .NET/SQL as compared to Force.com/SOQL? What do you need to know to make that transition?
FTP directly in SQL (Using SQL CLR)
by Justin Porteous
Using FTP via CLR in SQL
Full text search with Oracle Text
by fstrahberger
How to do full text search with Oracle Text
Full Tutorial on using Always Encrypted with Azure Key Vault in ASP.NET and ASP.NET Core
by Gelu Vac
How to use Always Encrypted using MSSQL Encrypt Columns feature with encryption keys stored in Azure Key Vault
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
Fulltext Search for Firebird SQL
by Dan Letecky
How to search data stored in a Firebird SQL database using a fulltext index.
Full-Text Search with dtSearch and AWS Aurora
by Mike V Baker
In this article, we’ll extend the dtSearch Engine-based example to use Amazon’s Aurora storage service, which is a hosted MySQL solution available through AWS.
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.
Fun With Physics
by Sacha Barber, Fredrik Bornander
WPF: A Beginner's Guide series, end exemplar and fun with Physics.
FUSE(file system in userspace) for Microsoft-SQL using C#
by martin.nedopil
Map your database table as network disk
Gain Coding Speed with Nido (FREE) Framework .NET/ C#
by Nirosh
Nido Framework with .Net 4.0 and Entity Framework help you standardize your Business Logic Layer (BLL).
Generate Date Table in SQL Server
by WPKF
Generate Date Table in SQL Server
Generate Multiple Insert Command from a .NET DataSet to MySql
by ezekielen
Dynamically generate SQL INSERT commands programmatically and run then in batches of hundreds to bulk load data from a .NET DataSet with multiple DataTables to MySql
Generate SQL Azure Databases
by carl.b.anderson
Industrialize your application developments using CodeFluent Entities
Generate SQL Database Schema from XML - Part 1 (File Format and XSD)
by Stephen Boissiere
Part 1 of 3 in a series of articles about generating SQL from an XML file format. This part describes the background to the project and talks about the development of the file format and an XSD schema.
Generate SQL Database Schema from XML - Part 2 (Code Model)
by Stephen Boissiere
Part 2 of 3 in a series of articles about generating SQL from an XML file format. This part describes the development of a code model for the new file format.
Generate SQL INSERT commands programmatically
by Ian Semmel
A class for automatically generating SQL INSERT for Typed Datasets.
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.
Generating a Pie Chart with Grafana and MS SQL
by harleydk
How to generate a pie chart with Grafana and MS SQL
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 Keys for a Custom Sort Order
by peterchen
ORDER BY what-the-user-said
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 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 Class to Perform Insert/Update/Get/Delete in LINQ to SQL Generated Classes
by Vinod Kumar 83
To create a Generic class for BLL or middle layer to perform all the basic CRUD operations on the LINQ to SQL generated classes.
Generic Database Access
by Mario Stopfer
Generic database access model which generalizes the interactions with any particular database system.
Generic DataBase Browser
by Phil_Pearl
This article presents a database browser that can be used for multiple different databases
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 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
Generic Solution Framework to Saving History of Records Using MSSQL Server 2005 Xml Column
by yincekara
An article about How to Save Old Versions of Records Using MSSQL Server 2005 Xml Column
Generic way to do primarykey & foreign key validation from frontend
by SudhirKankal
Generic way to do primarykey & foreign key validation from frontend
Genius Open HTML Generator - How To Easily Create an Amazing Report
by APIReport
Generate an HTML table in 4 lines of code either from a SQL query or a DataTable. Highlighting, sorting, all is customizable
Geocoding with SQL-Server
by gstolarov
Geocoding with SQL-Server
GeoLocation by Radius Using Google Maps and .NET
by xbadenx
This article shows you how to geocode existing addresses, then run distance calculations for geolocation within a given radius.
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 Ready to Learn SQL Server: 15. Learn to use Union, Intersect, and Except Clauses
by essentialSQL
Learn to use Union, Intersect, and Except clauses
Get SQL Table Information
by Md. Marufuzzaman
Get SQL Table Information
Getting Started with Data Analysis in Azure Synapse Analytics Part 1: Overview
by DaveNoderer
In this article, we learn how Azure Synapse Analytics helps you analyze, understand, and report your big data to drive business insights.
Getting Started with Data Analysis in Azure Synapse Analytics Part 2: SQL Pool
by DaveNoderer
In this article, we explore how to set up one component, an SQL pool.
Getting Started with Data Analysis in Azure Synapse Analytics Part 3: Apache Spark
by DaveNoderer
In this article we learn how to set up Apache Spark.
Getting Started with ReactJS Using MVC And WCF REST
by syed shanu
MVC using ReactJS and WCF Rest
Getting Started with SQL Server Compact 4.0 and ASP.NET 4
by ASP.NET Community
While professional developers are waiting for the Visual Studio Tools and Designers for SQL Server Compact 4.0, I will show how impatient developers
Getting started with SQL Server Everywhere
by TomDK
How to start using SQL Server Everywhere in C# programs.
Getting Started With SSIS Script transforms
by Daniel_Wheeler
Using a script transform with C# to convert Julian (ordinal?) dates for a date dimension.
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 SQL Error Handling in Stored Procedure
by Nicolas Brassard
Good SQL error handling in stored procedure
Google Suggest like Dictionary
by Gavi Narra
An implementation of Google suggest using remote scripting.
Goto definition Add-In but for SQL Stored Procedures !!
by alaac#
This add-in lets you navigate to the specified SQL stored procedure if you refer to it in your code,
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
Grant Execute on all procedures to a user
by Sumit Amar .
This stored procedure grants execute privilege on all procedures to specified user
Grid View with AJAX based CRUD Operations in ASP.NET MVC 5
by Ehsan Sajjad
In this post, I will be addressing this problem and we will learn that how can implement CRUD using JQuery DataTables in one page without any full page reloads.
GridView Custom Paging
by azamsharp
This article demonstrates how you can use custom paging to improve the performance of GridView paging.
GridView inline Master/Detail record display
by Gary Dryden
How to view detail records inline with the master records, using the GridView control.
GridView to a DataTable
by ZeroDev
Convert the current Gridview to a datatable
Gridview with SQL Paging
by Tom Bauto
A simple and detailed ASP.NET program using Gridview with paging in SQL 2005
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.
Hadoop For .Net & AngularJS Developers
by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
Handle NULL in SQL Server
by Math08avan
The important things to understand, how missing values are treated in SQL Server
Handling database connections more easily
by Alaric Dailey
Building an O/R Mapper: step 3.
Handling Keyboard Events of DataGrid Cells
by Asher Syed
Handling Key-Down and similar events for DataGridCells in a DataGrid
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
Hello B4J: Creating the Bible.Show WebApp with ABMaterial
by Anele 'Mashy' Mbanga
Create Google Material based HTML5 apps using B4J ABMaterial
Help Thomas Get Started with SAP HANA
by Vitaliy Rudnytskiy, Lucia Subatin (Google)
Use SAP HANA to help Thomas get started with help from other developers in the community using text analytics, graph and geospatial.
Hibernate - Many to Many Mapping via Join-Table
by Han Bo Sun
Detailed description of how many-to-many association works with Hibernate, using MySQL and Spring
Hidden Gems of DEFAULT TRACE in SQL Server
by Sergii Syrovatchenko
Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...
HierarchyID Data Type in SQL Server 2008
by Robin_Roy
MS SQL Server 2008 new feature, the HierarchyID data type.
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.
How ANTS Performance Profiler Saved my Hide
by Redgate Software
G.Russon tells the tale of when his most mission-critical app collapsed, what this meant for him and his team and how they solved the problem with the help of ANTS Performance Profiler.
How Do I Protect My Stored Procedure Code
by Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
How Longhorn Transforms Applications
by Ashvil DCosta
See how Longhorn core pillars like WinFS changes the way applications are written, based on metadata relationships.
How Many Records Are There in your Database?
by Md. Marufuzzaman
How many records are there in your database?
How Much Can Sqlite Handle? Multiple Threads Concurrently Inserting Into Sqlite
by raddevus
An informal study of the Sqlite database and how many concurrent inserts it can handle. Will help you decide if you want to use Sqlite in your projects.
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 Access web-server MySQL Database in Java?
by rohit7209
Use AccessRemoteMySQLDB-API in your project to access web-server MySQL database
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 a Room Booking Calendar with dhtmlxScheduler
by Stas Wolski
This article describes how to implement a meeting room booking system in an ASP.NET MVC project with dhtmlxScheduler.
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 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 Connect SQL Database to your C# Program - Beginner's Tutorial
by Afzaal Ahmad Zeeshan
This article tells the beginners the basic concepts about connecting to the SQL Server database using C#.
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 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 a Relevance Based Search Query for SQL
by Manan J
Arrange Results to get the most relevant result first...
How to Create a Simple Windows Forms C++ Database Application
by Software_Developer
How to create a simple Windows Forms C++ Database Application
How to Create T-SQL CASE Statements With LINQ To SQL
by merlin981
How to create T-SQL CASE statements with LINQ to SQL
How to create Umbraco database on shared hosting.
by ASP.NET Community
I had to create Umbraco database on my shared hosting (I am using Winhost at the moment) couple of days ago.After checking few examples on
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 estimate a software project in man-hours?
by RedSunBeer
Some thoughts on estimating before having a design in place.
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 extract overlapped polygons and calculate the overlapped area and write an API for it?
by mahmood kabi
extract overlapped polygons and calculate the overlapped area and write an API for it
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 find the active SQL connections and kill them
by Gautam Sharma
Code that will show you the active connections to a database.
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 get the Menus Based on Role in XML Format and Bind them to the Menu Control in ASP.NET
by abhijit.dalvi29
This article describes how to get the Menus Based on Role in XML Format and Bind them to the Menu Control in ASP.NET
How to Handle Recursive Relationship in ASP.NET with SQL Server Database
by Thomas Yan
Build web component based on recursive data
How to Hash Your Binary Data that Exceed the Limit (8000bytes) of Input Parameter of HASHBYTES in SQL Server
by markkang
This is about how to hash your binary data that exceed the limit (8000bytes) of allowed input values of HASHBYTES in SQL Server.
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 implement Paging in ASP.NET at SQL Query Level
by Aqeeel
Though GridView provides a way to implement paging however when the record count in very big we need to optimize it at the query level.
How to implement Two basics uses for the Asp.net Login control 2.0 (login and RememberMe)
by Britney S. Morales
This article will show you how to implement two basics uses of the ASP.NET Login control (2.0), The login task itself to validate the users who’s trying to access your web site. In addition i will show how to implement the REMEMBERME process using cookies to save the user name inside the user PC
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 Import MDF File to Microsoft Access
by Gouri Sancroj
An article that lists the steps to import MDF files to Microsoft Access
How to Insert a DateTime Value into an Oracle Table
by Database Star
This article explains how to insert a DATE with or without a time into an Oracle table using the INSERT statement.
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 invoke a Web Service from a Stored Procedure
by Omar Frometa
Learning how to make a call to a Web Service from a Stored Procedure.
How to invoke Stored Procedures with the FOR XML clause using BizTalk Adapter Pack 2.0 if the Stored Procedures are not in the default schema?
by Sarmak.M.C
How to invoke Stored Procedures with the FOR XML clause using BizTalk Adapter Pack 2.0 if the Stored Procedures are not in the default schema?
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 a random selection from an SQL table
by Ach1lles
A simple technique for selecting random records from a table.
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 Manipulate Hierarchical Information in Flat Relational Database Tables
by Akshay Srinivasan2
This article describes a technique to quickly retrieve and present hierarchical information from a flat relational database table with only one table scan.
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 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 Print a Document from SQL Stored Procedure
by aleksisa
Print a document from a stored procedure using a SQL OLE and VB DLL
How to Repair Corrupt SQL Database using DBCC CHECKDB Command?
by Stellar Data Recovery
Discover step-by-step instructions to repair SQL databases with DBCC CHECKDB, plus explore advanced tools for a quick and secure repair.
How to Restore SQL Server 2005 Suspect Database
by Suvendu Banik
How to Restore SQL Server 2005 Suspect Database
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 save data from a DataSet into a T-SQL table
by Sandeep Aparajit
This article tells you how to save data from a DataSet into T-SQL tables.
How to Save Object Graph in Master-Detail Relationship with One Stored Procedure
by Vadim Loboda
A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters
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 scroll and view millions of records
by DataBytzAI
A simple and useful pattern when you need to allow user access to large volumes of data
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 Send Mail Using SQL Server: Part 3
by Manish kumar choudhary
In this article, I will explain how to schedule a daily mail from 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 stop creating the aspnetdb.mdf database
by ASP.NET Community
If you use the asp.net membership providers, having visual studio keep this sql database file around for deployment can sometimes be convenient.
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 train your Pokerbot
by CatchExAs
Using evolutionary techniques to deduce an optimal poker strategy
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 Oracle 11g ODP.NET UDT in an Oracle Stored Procedure's Where clause
by kamran anwar (Software Engineer)
Passing a VARRAY custom type from .NET and using it in a Where clause in an Oracle Stored Procedure.
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 Write Code to Solve a Problem, A Beginner's Guide Part 2: Syntax Errors
by OriginalGriff
By the time you have read this, you will have no problem with compiling your programs ever again. Well, probably you won't. OK - maybe a little. Depends on the compiler.
How to write once, and test encrypted data storage for Windows, Mac, Linux, Solaris, Android and iOS
by Stephen_Ball
How to write once, and test encrypted data storage for Windows, Mac, Linux, Solaris, Android and iOS
How to write PL/pgSQL functions (for PostgreSQL 8.3)
by MrTimmins
A general overview and introduction to the basics of writing PL/pgSQL functions in PostgreSQL.
How To: LINQ To SQL Transformations - Part II
by Muigai Mwaura
An article on LINQ To SQL Transformations.
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.
HTTP Request Query String Protection
by Riad MS Afyouni
Add one layer of security to your Web application
HTTP Sweet HTTP (with Gastona)
by Alejandro Xalabarder
HTTP for everybody
Identifying NHibernate-Related Bottlenecks through Performance Monitoring
by Peter Weissbrod
A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues
Image Preview using MVC, AngularJs and Web API 2
by syed shanu
Create a simple Image Slideshow with MVC, AngularJS using Web API 2
Impersonation using Code
by Chirag R Darji
Impersonation using Code
Implement ORM using C#
by saddam abu ghaida
Creating Object relation mapping from scratch
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 Example of Ranked Search in ASP.NET
by Jon Larborn
Description how to get started with your own search engine using full text search and SQL-Server 2012.
Implementation of a B-Tree Database Class
by _oti
An article and source code regarding the implmentation of B-Trees in C++.
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 Audit Trail using Trigger
by Shivprasad koirala
Implementing Audit trail using trigger
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 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 One-To-Many Relationship in ASP.NET
by Debabrata_Das
In this article we will create a project to see how one-to-many relationship can be implemented in ASP.NET
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 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 a Text or CSV file into SQL Server
by gmtzgtz
Import Data from a Text or CSV file into SQL Server
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 Fixed Length File Data into Database Table with SSIS
by Baliram Suryawanshi
This article helps with step by step detailed information to import fixed length file data into SQL server’s database table.



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

Web01 2.8:2024-10-19:1