Click here to Skip to main content
15,881,380 members
Everything / Programming Languages / SQL

SQL

SQL

Great Reads

by Alex Pumpet
A simple program for comparing table data from two sources - SQL databases, Excel, CSV or XML-files
by Thomas Weller
Demonstrates how to run Python scripts from C#
by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse
by Christoph Buenger
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).

Latest Articles

by Mishael Ogo
A look at a simple SQL builder for Dapper
by GabrieleTronchin
In this project, I've implemented the Transactional Outbox Pattern using EF Core.
by GabrieleTronchin
A simple stored procedure to add at your database to keep it reactive
by GabrieleTronchin
Automatic creation of non clustered indexes using system SQL entities

All Articles

Sort by Title

SQL 

18 Oct 2011 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.
4 Jul 2011 by Shrilata Ellaboina
.NET Dynamic Control Creation
19 May 2013 by Shemeer NS
CultureInfo, DateFormat, Number Format, Currency Format, Percent Format, Infinity Format, etc. in .NET Framework Cultures
19 May 2013 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.
24 May 2007 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#)
18 May 2007 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#).
16 Mar 2011 by dingoishere
This article introduces you to 3 kinds of comparison and synchronization for SQL Server Database.
22 Nov 2021 by Michael Sydney Balloni
Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!
18 Apr 2007 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#).
11 Jun 2011 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
1 Aug 2013 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.
13 May 2015 by essentialSQL
This is a case study on how to use Joins, Subqueries, and Unions to combine data in SQL.
9 Nov 2008 by Denis Vasilik
Overview of Microsoft's cloud platform
12 Oct 2013 by Dr. Song Li
This is the part 3 of a comparison on Data Access methods in the .NET environment.
22 Aug 2014 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.
20 May 2005 by zhengdong jin
It's very easy to use and the most conventient DataGrid pager control.
11 May 2007 by andrewcates
In an attempt to open DotNetNuke to a wider audience, I have converted the original VB code into C#
30 Aug 2009 by marcominas
A Windows Service that uses interface to work like the Linux Crontab service
21 Oct 2009 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.
23 Feb 2008 by Nanaa
An approach on how to organize your data into tables that will help you generate large ‘Crosstab’ Reports using SQL Server.
12 Feb 2009 by Kemal Erdogan
An implementation of role-based authorization control (RBAC) model with row-level access control capabilities at the database server level
9 Sep 2010 by RichardEastes
Realtime page editing, simple, "on-the-fly" menu construction, modifiable permissions for users and groups, built-in search engine optimisation
23 Sep 2015 by Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
14 Apr 2005 by poodull76
Create T-SQL command text to update a table with OpenXML quickly and with minimal effort.
4 Aug 2009 by bobleith
A generic interval range table to generate permutations
6 Apr 2005 by santosh poojari
This article shows you how to make use of DataAccessLayer and caching.
19 Sep 2005 by msalmank
A quick hands-on application to guide you in using paneled forms, multi-splash screens, SQL Express, and many more....
10 Sep 2004 by Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
6 Dec 2006 by lost in transition
This article illustrates a helpful database library.
25 Nov 2005 by TofuBug24
Shows a solution for creating a Master-Detail relation using textboxes.
26 Jan 2021 by Kemal Erdogan
Addressing the general problem of representing directed acyclic graphs (DAGs) in SQL databases
16 Jan 2008 by Robert Pittenger, MCPD-EAD
This article presents a naming scheme for database tables and fields.
8 Oct 2014 by Atle Solbakken
Are the programming languages we use for web design today really adapted well enough to fit our needs?
26 Jul 2007 by mikvos
A list of news articles in an ASP.NET GridView control with custom paging.
21 Jun 2004 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.
3 Jan 2020 by Dr. Song Li
This is a note on Hibernate many to many mappings.
27 Apr 2011 by Niladri_Biswas
This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.
12 Mar 2012 by Voicent Support
How to make a performance meter that looks like the one in Windows Task Manager
6 Jul 2011 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.
10 Feb 2016 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.
19 Sep 2009 by Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
12 May 2011 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.
10 May 2005 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.
7 Jul 2011 by Weidong Shen
Part 1 of a series describing the creation of a Silverlight business application using MEF, MVVM Light, and WCF RIA Services.
8 Jul 2011 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.
12 Sep 2003 by Jonathan de Halleux
A helper framework for generation of SQL queries in C++ and Lua
6 Sep 2005 by Carlos Antollini
Simple database access using an ADO class.
19 Jun 2002 by Carlos Antollini
Simple database catalog access using a set of ADOX classes
16 May 2013 by Joffrey Brouillet
This is an alternative for "A set of ADO classes - version 2.20"
27 Aug 2001 by Carlos Antollini
Two classes that make easy to work with ODBC
12 Apr 2011 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.
18 Jun 2011 by Amit Kumar Dutta
Discusses a technique to record current geographic location from mobile and display in web pages (with Location History Browsing)
10 Jun 2005 by Paul S Ganney
A class to easily do count() queries.
18 Apr 2005 by Uri Lavi
A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).
13 Sep 2009 by Md. Marufuzzaman
A simple example of SQL server admin tools.
25 May 2008 by Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
8 Sep 2014 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.
27 Oct 2012 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.
28 Apr 2005 by Stephan Pilz
A tool to generate/manage news and provide news via RSS.
19 Aug 2009 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.
14 Apr 2004 by Alberto Venditti
This article describes a VB.NET tool to test the performances of a Microsoft SQL Server 2000 user database.
20 Oct 2005 by codeajay
A simplified SQL-CSV import/export functionality.
22 Feb 2011 by ronald.cao@gmail.com
The article is to introduce a utility to generate cascading delete script for an Oracle table.
22 Aug 2005 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.
20 Apr 2008 by gan.gary
An article on a SQL IDE for different type of RDBMS databases
13 Dec 2008 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.
26 Feb 2009 by Lindsey Lewis
An article about a tool for comparing SQL database schema versions
31 Aug 2014 by Faustino Dina
Publishes a Transact-SQL function for parsing a string containing a delimited list, similar to the ANSI C languaje strtok() function.
26 Jul 2009 by AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
26 Sep 2006 by code-frog
Provide a very simple set of instructions for creating your own media gallery and loading your images from SQL Server 2005.
23 Oct 2009 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.
18 May 2008 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.
23 May 2007 by vipulparmar
9 Aug 2012 by Wendelius
Article describes basic information about transaction log behavior and truncation of the log.
3 Aug 2018 by Rahul Rajat Singh
This article introduces Dapper to absolute beginners.
5 Sep 2009 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.
18 Jan 2014 by Petr Ivankov
Application of abstract approach to database domain
18 Aug 2010 by Oleg Vorkunov
Abstract simplified stored procedure execution using .NET interfaces without dealing with ADO.NET classes
3 Jun 2008 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
8 Oct 2006 by Malpani Amol
Here is some cool stuff to call .NET assembly from SSIS
8 Oct 2006 by Malpani Amol
This article will drive you, how to access and update properties and variable of SSIS package using .NET application
2 Feb 2008 by Balamurali Balaji
Access various types of data using the LinqDataSource control in ASP.NET.
7 Feb 2008 by Balamurali Balaji
Access various types of data using LinqDataSource control ASP.NET
1 Jul 2003 by thomask
2 Mar 2003 by CT CHANG
Add, edit, and delete records/table/database in MS SQL Server CE v1.0/v2.0.
26 Mar 2007 by Wojtek Jeziorczak
How to send/receive MSMQ messages in SQL Server using CLR Integration
11 Oct 2013 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
9 Jan 2016 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.
17 Sep 2016 by Snorri Kristjansson
A SQL server CLR Stored Procedure that can query the Active Directory directly in T-SQL code
9 Mar 2005 by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
2 Aug 2003 by xiaojin
The article explains adding a user in SQL Server programmatically, using VC++
15 Dec 2010 by hector [.j.] rivas
Helping the combo box autocomplete function with a frequency count.
31 Jan 2006 by arunpv
Add/drop Linked Servers using SQL Server 2005 SMO
31 Jul 2008 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.
13 Aug 2019 by Benktesh Sharma
Demonstrate how to add EF support in .NET Core project
13 Feb 2009 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
18 Feb 2005 by rasheed1979
This article demonstrates administrating SQL Server 2000 from Pocket PC on the fly.
10 Jun 2001 by M. Shokuie Nia
A simple introduction to using ADO