Click here to Skip to main content
15,907,281 members
Everything / Programming Languages / 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 Wendelius
A small function utilizing CTE to replace undesired characters from a string
by Mishael Ogo
A look at a simple SQL builder for Dapper
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 Score


20 Mar 2018 by Alex Pumpet
A simple program for comparing table data from two sources - SQL databases, Excel, CSV or XML-files
26 Aug 2019 by Thomas Weller
Demonstrates how to run Python scripts from C#
31 Oct 2014 by Christoph Buenger
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).
5 Dec 2015 by Daniel Miller
This article describes the C# implementation for a high-performance user/role security principal hierarchy.
27 Nov 2009 by Max Paulousky
This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.
11 Jun 2010 by Evoluteur
A generic Web User Interface for CRUD applications generating all screens at run-time based on external metadata. It comes with sample applications for address book, memo pad, to do list, restaurants list, wine cellar, and database structure documentation that are easily customizable.
5 Nov 2002 by Alexey
The alxBase classes for work with dbf files.
15 Jul 2014 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.
29 Dec 2015 by Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
6 Feb 2020 by Fred Song (Melbourne)
In this article, I want to show how to build a Single Page Application – MasterChef with ASP.NET Core MVC, Fluent Hibernate, and Angular JS.
6 Sep 2007 by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
17 Feb 2015 by DrABELL
Employment Tax computation and Payroll management app for Windows 8: contest entry
20 Jun 2014 by Debabrata_Das
This article will talk about how to update multiple records in a GridView on a single button click using JSON in ASP.NET
1 Jan 2021 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
13 Mar 2021 by Sergii Syrovatchenko
How to omit many restrictions on SQL Server Express Edition
17 Mar 2013 by Weidong Shen
This article describes the project setup of building a WPF sample application with Self-Tracking Entity Generator and Visual Studio 2012.
16 Mar 2017 by Robert_Dyball
Create a simple data grid that provides list, add, edit and delete and uses a simple 'parent/child' template to provide view, edit or add functionality
5 Nov 2018 by Jovan Popovic(MSFT)
Create powerful REST API with just few lines of C# code using MsSql.RestApi package
24 Aug 2010 by pinaldave
A Finale of Series discussing Computed Columns, Storage and Performance
7 Sep 2012 by Shivprasad koirala
This article will discuss about SQL Server governer.
22 Feb 2013 by Scott Burkow
An exercise in algorithm analysis and design.
21 Apr 2013 by Rob Culhane
How to dynamically add access database columns at runtime using VB.NET
12 Nov 2015 by Fred Song (Melbourne)
In this article, we started from Generate Inserts procedure, then go through how generates inserts SQL files with this procedure and runs these inserts SQL files to import data.
21 Jun 2016 by Marc Clifton
A deep dive into the $lookup aggregator with examples of one-to-one, one-to-many, many-to-many, and nested relational "queries"
5 Jul 2016 by Akhil Mittal
This article will focus on practical aspects of formatters and content negotiation in ASP.NET Web API
17 Jul 2017 by Vadim Loboda
Combine Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order
23 Mar 2021 by Espen Harlinn
Proven techniques for fast Oracle Database access using .NET 5.0 and native C++
15 Sep 2008 by Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
5 Jul 2021 by gggustafson
This article provides the code necessary to implement a website login mechanism without using third-party software.
31 Mar 2006 by Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
27 Mar 2012 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.
27 Oct 2016 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.
3 Feb 2013 by S. M. Ahasan Habib
Database script execution with testing
11 Jan 2015 by SarmadAsghar
Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5
29 Mar 2016 by wells cheung
Angular Single-Page Application, MEF, Privilege Control, WCF Restful Service, ui-router,
12 May 2017 by DaveDavidson
In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.
4 Apr 2021 by Yuancai (Charlie) Ye
Continuous SQL-stream Sending and Processing System
27 Feb 2018 by #realJSOP
Create and run jobs kinda like SQL Server Enterprise - Users Guide
24 Aug 2018 by Arthur V. Ratz
Create a Python web-app using Flask and PostgreSQL server, and run it in Docker
4 Nov 2016 by Wendelius
Few CLR procedure concepts to write into a file from SQL Server database
14 Mar 2000 by Tom Archer
A class to dynamically read data from any ODBC data source
9 Oct 2009 by Ferreri Gabriele (Megasoft78)
Automatic script SQL Server 2005 objects and commit under Subversion
9 Jun 2013 by Ravi Gadag
Azure based e-learning product.
26 Jul 2017 by Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
30 Jul 2019 by Don Hoang
This post describes implementing ASP.NET Gridview using Bootstrap 4.
18 Sep 2019 by Niemand25
Designing a simple yet functional database for financial accounting application.
13 Sep 2012 by Wendelius
This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
12 Mar 2003 by Alexander Wiseman
A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases
9 Mar 2005 by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
27 Jul 2009 by Paul Rony
Programmer's Guide to Starting a Software Company and Building an Enterprise Application
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.
21 Feb 2012 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.
16 Oct 2014 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.
5 Sep 2015 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
4 Nov 2015 by Fred Song (Melbourne)
Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
19 Aug 2017 by Afzaal Ahmad Zeeshan
.NET Core 2.0 brings a lot of improvements to the system, and it brings a lot of pain to the developers as well. I had a lot of problems upgrading .NET Core 1.x apps to .NET Core 2.0; I yet have to feel the promise it makes about performance and so, but let us see how to upgrade our existing applica
16 Apr 2024 by Mishael Ogo
A look at a simple SQL builder for Dapper
12 Jun 2012 by Miroslav Popovic
MSBuild database migrations/upgrades with backup and restore functionality
4 May 2004 by Daniel Aioanei, Adi Malinaru, Andrei Postolache
An article on how to persist permutations of items in relational databases.
19 Dec 2007 by Bryan Sachdeva
This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.
22 Mar 2013 by Terence Wallace
TexasQuest is a 2D side scroller platform game similiar to Super Mario
6 Dec 2016 by _Asif_
This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.
29 Feb 2016 by wells cheung
Privilege Control System based on MVC and WCF.
4 May 2016 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.
9 Jul 2016 by DataBytzAI
A simple and useful pattern when you need to allow user access to large volumes of data
2 Jun 2017 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
23 Mar 2019 by Minh Tuan Do
A considerable method to speed up query running time
28 Jul 2000 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!
19 Mar 2002 by Alex Mikunov
.NET Extensions that provide an infrastructure for enforcing database-like data integrity constraints
9 Jan 2010 by Niladri_Biswas
How to generate an Armstrong number between 0 and 999.
28 Jul 2014 by DiponRoy
How to manage Entity Framework Code First in Real Time Projects
28 Dec 2014 by Snesh Prajapati
In this article series, I am sharing how to create report using Report Builder by fetching data from Oracle DB.
27 Jan 2015 by Vaclav Naydenov
Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM.
18 Feb 2016 by Kuv Patel
Debug stored procedures in Visual Studio and SQL Server Management Studio.
3 Oct 2016 by Fred Song (Melbourne)
In this article I talk about how to use ASP.NET Core MVC, Fluent NHibernate and Angular JS to implement a CRUD SPA (Single Page Application).
8 Nov 2016 by mblataric
Instructions on how to migrate existing XAF security system to new permission policy.
27 Nov 2018 by Ajcek84
Using locality-sensitive hashing algorithm to improve performance of searching of musical incipits
30 Jul 2019 by Don Hoang
This post describes implementing ASP.NET Editable Gridview using Bootstrap 4
25 Jul 2021 by Sergii Syrovatchenko
Here's everything you need to know about high-performance JSON parsing for SQL Server
20 Mar 2023 by Bogdan Marian
Ensure your Docker Compose services start in the correct order
7 Jan 2022 by raddevus
Includes complete C# Web API which allows you to post your app data using simple method
23 Oct 2011 by jkrebsbach
A way to combine data from two different sources into one datasource for SSRS reporting
26 Nov 2011 by gmtzgtz
Import Data from a Text or CSV file into SQL Server
8 Apr 2013 by Shining Dragon
How to effectivley version your SQL Server databases using SQL Server Data Tools
20 Jun 2013 by Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
8 Oct 2015 by DrABELL
App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine
14 Oct 2013 by DataBytzAI
Using SQL job agent to backup databases in virtual machines to an Azure blob container, SQL, Cloud, SQL-Server, Azure
29 Aug 2018 by Micah Nikkel
SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.
27 May 2015 by syed shanu
MVC, AngularJS and WCF Rest Service for Master / Detail HTML Grid
31 May 2015 by Milan Matějka
Compare likenesses and differences between Temporary Tables and Temporary Variables
8 Oct 2015 by Anele 'Mashy' Mbanga
A look at a flexible Java MySQL CRUD PHP script generator
27 Oct 2016 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.
10 Apr 2017 by Robert_Dyball
Covering conversion from Angular 2.40 to Angular 4.0 + Publishing the ASP.Net Core / Angular 4 SPA to IIS using VS2017
19 Apr 2017 by Robert_Dyball
Publishing the ASP.Net Core 1.1 / Angular 4 SPA to Azure and external IIS hosts. Also covering code cleanup, optimization, bundling and minification. Gulp, Grunt, Webpack and some architecture and development philosophy.
21 Oct 2017 by mahmood kabi
extract overlapped polygons and calculate the overlapped area and write an API for it
30 May 2018 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.
12 Aug 2018 by Sarathlal Saseendran
We will create an Angular 6 application with Cosmos DB and Web API 2.0.
14 Sep 2019 by Arthur V. Ratz
How to create and export TensorFlow S&P 500 Index prediction model and serve it using TensorFlow Model Server
22 Nov 2021 by Michael Sydney Balloni
Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!