Click here to Skip to main content
14,542,771 members


Great Reads

by Evoluteur
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
by Rob Culhane
Dynamically add access database columns at runtime using
by Paul D. Sheriff
As more and more users interact with web applications on their mobile devices, it is becoming increasingly important for software developers to allow them to work offline; PouchDB can help.
by Nikola M. Živković
Introduction to NoSQL and Polyglot Persistence

Latest Articles

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.
by Jeremy Likness
Some ah-hah moments about Kusto
by Arthur V. Ratz
A Simple Web Application User Authentication Project Using Passport.js And JSON Web Tokens (JWT) explained.

All Articles

Sort by Updated


21 May 2020U
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.
2 Feb 2020
Arthur V. Ratz
A Simple Web Application User Authentication Project Using Passport.js And JSON Web Tokens (JWT) explained.
13 Jan 2020
New features of SQL 2019
30 Dec 2019
Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
5 Dec 2019
Renz Ladroma
A tutorial on how to setup Keepalived for MySQL Auto Failover
1 Dec 2019
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
20 Oct 2019
Ravi K. Acharya
The complete step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus.
19 Sep 2019
This article describes different ways of setting up generated (computed) columns in different versions of PostgreSQL.
7 Sep 2019
This article describes a way to create a Facade Database to provide restricted access to specific tables in your databases to specific users without granting direct access to any of the underlying databases/tables.
21 Aug 2019
David Cuelogic
GraphQL: Evolution of Modern Age Database Management System
18 Aug 2019
SQL 2017 new features
9 Jul 2019
Evgeniy Gribkov
The examples of SQL Server database documentation using both the extended properties and a third-party utility
6 Jun 2019
Kintone Developer Program
This article introduces how to capture Google Form responses into a Kintone Database, instead of capturing them in a spreadsheet.
24 Apr 2019
QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)
16 Apr 2019
Dan Ionescu (USINESOFT)
LINQ extensions that allow to describe and to safely query cached data
23 Mar 2019
Minh Tuan Do
A considerable method to speed up query running time
21 Jan 2019
Paul D. Sheriff
In this article, the 3rd in a multi-part series, you are going to learn how to query data within a PouchDB database.
20 Jan 2019
Paul D. Sheriff
In this 2nd part of my series on PouchDB, you learn how to perform multi-document inserts and reads.
15 Jan 2019
Paul D. Sheriff
As more and more users interact with web applications on their mobile devices, it is becoming increasingly important for software developers to allow them to work offline; PouchDB can help.
13 Aug 2018
Member 13935194
In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.
1 Jul 2018
DotNet.Core.SQLite - A lightweight performance wrapper library for working with SQLite including usage examples in C# & VB
27 May 2018
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 Apr 2018
Alaa Ben Fatma
In this article, we will walk through the basic concepts of de/serialization and how to create a very basic de/serializer.
2 Feb 2018
Private Dobbs
How to initialise a database and then automatically keep it up to date with version releases
31 Jan 2018
Praveen P R
This article presents a simple and efficient way to bulk insert any .NET list to the database.
10 Jan 2018
A simple yet powerful tool to analyse SQL object dependencies in quite fast and reliable manner.
21 Dec 2017
Miguel Diaz Kusztrich
A database tool for search text in procedures, views and tables using regular expressions
7 Nov 2017
Bruce Yang CL
A distributed system architecture, mobile devices around the world, free charge to construct your global application.
24 Oct 2017
Sreekanth Mothukuru
Create a Data-Tier Application Package (DacPac) to easily manage, deploy and deliver chronological database changes onto multiple environments
18 Oct 2017
Mauricio David
1 alternative  
A simple, fast and free embedded .NET NoSQL Document Store in a single data file. Inspired on MongoDB, supports collections, POCO classes, Bson Documents, indexes, stream data and LINQ expressions.
12 Sep 2017
Mahsa Hassankashi
This article is the most complete essay about big data from scratch to practical.
12 Sep 2017
Bruce Yang CL
Develop an ASP.NET Core NES Game website on Linux with cross platform Database, and deploy to Ubuntu & Windows which have no .NET Core runtime installed.
14 Aug 2017
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.
26 Jul 2017
Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
3 Jul 2017
Christian Del Bianco
SqlTableDependency is a component used to receive database notifications containing the record values inserted, deleted or update on a database table.
7 Feb 2017
Learn how to implement a real stream file based dataset descendant with blob support and much more.
28 Nov 2016
Neal Pandey
This article is a tutorial on creating a basic OData (Open Data Protocol) endpoint for a MongoDB database using MEAN stack.
1 Nov 2016
Bob Crowley
In this article, I will explain the sometimes surprising behavior of  the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.
22 Sep 2016
Alexandros Pappas
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
21 Sep 2016
Use SQL Server to manage completely databases backups, network copy and deletion using only stored procedures
23 Aug 2016
Suvendu Shekhar Giri
Introduction of new useful features in SSMS 2016
15 Aug 2016
Suvendu Shekhar Giri
We'll see how sensitive data in SQL Server 2016 can be masked from outer world using Dynamic Data Masking.
27 Jul 2016
Werner Stoop
A Java implement of Datalog, a subset of the Prolog programming language that is used as a query language in deductive databases
11 Jul 2016
Jesus Carroll
Despite the references of several sources of unattended installation of Microsoft SQL Server Database Engine, in this article describes a script tested in real production environments and it can be used with minimal or - perhaps - no modifications.
10 Jul 2016
This article will surely give an idea how to develop a self-controlled, self-connected smart home/building.
21 May 2016
MongoDB Tutorial Day 4 :- Aggregation
6 May 2016
Riccardo Cervelli
Sample for custom entity data model and jSon query with SqlServer 2016
18 Apr 2016
Mongo DB Tutorial and Mapping of SQL and Mongo DB Query
18 Apr 2016
MongoDB Tutorial - Day 3 (Performance - Indexing)
11 Apr 2016
MongoDB Tutorial - MongoDB specific queries
21 Mar 2016
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...
13 Mar 2016
Zohaib Sibte Hassan
A more detailed look into Iterators and Snapshots in LevelDB UWP
26 Feb 2016
Pavel Sinkevich
How to programmatically change schema name in database project before deployment
23 Feb 2016
Sreekanth Mothukuru
In this article, we are going to look at one of the most useful features in Visual Studio that is often ignored or to be frank, many people don’t even know about its existence. We are going to look at Free SQL Server Schema Comparison Tool in Visual Studio 2013.
21 Feb 2016
NoSQL: MongoDB for beginners
10 Feb 2016
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 Jan 2016
Avron Polakow
This article presents a client-side, JavaScript Relational Database Simulator in the browser, using SQL commands to Create, Read, Insert, Update and Delete in-browser table data, as well as formatting the output as HTML objects in a Webpage.
8 Dec 2015
Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
7 Nov 2015
Syed Hasan Hyder
Provides plausible and high performing data display, for very large data ( over a million records ).
14 Oct 2015
Terence Wallace
This is an alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"
14 Sep 2015
Build your own database class library with C#
14 May 2015
Using SIML, a language designed for Digital Assistants, to create a Natural Language Interface to an SQL Database.
14 Apr 2015
Menci Lucio
I wrote a class to have an access to all databases in the simplest and smartest way
10 Apr 2015
Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
1 Mar 2015
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
1 Mar 2015
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
1 Mar 2015
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
11 Feb 2015
Aydin Homay
In the software implementing business synchronizing structures/templates of the database entities with Data Access Layer SQL (commands/Transactions) is the most expensive thinks because you need to re-implement when you have change/s in your entities structure's such as Data-type, Name, and etc.
27 Jan 2015
Vaclav Naydenov
Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM.
12 Jan 2015
Leom Burke
EF Code First and WPF with the Chinook Database - Styles and DataTemplates
30 Oct 2014
Vaclav Naydenov
How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.
25 Oct 2014
Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
24 Oct 2014
Shivprasad koirala, Marla Sukesh
This is the part 3 of the series Learn MSBI step by step
16 Oct 2014
Pavel Durov
Article about dynamic Sqlite database management on Android platform using Java class reflection.
15 Sep 2014
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
14 Sep 2014
Lean about how to manage the data
9 Sep 2014
Ahmed Alaa El-Din
This articles provides a brief description of different methods that Android platform can provide for a developer to save different data types with different storage methods like Shared Preferences, Internal Storage, External Storage, SQLite DB, and Web Services
13 Aug 2014
Here, we will see how to configure one to zero/one relation between two entities in Entity Framework Code First
28 Jul 2014
How to manage Entity Framework Code First in Real Time Projects
20 Jul 2014
Mubin M. Shaikh
This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube
25 Jun 2014
Josef Hardi
This is the third and final article about Semantika. This article will guide you to develop a simple "hello-world" query application
5 May 2014
Shuqian Ying
Client side data provider for data importing to a relational data service build for StackExchange data dump.
2 Apr 2014
Anand Gunasekaran
Working with text file as database can querying as RDBMS with SQL Queries.
26 Mar 2014
David Fahlander
Discover the hidden features of indexedDB!
17 Mar 2014
Batch scripts that help install MongoDB on a Windows PC
16 Mar 2014
ASP.NET Community
This example will show how is possible to upload files to SQL server database using C# and For demostration purposes database will have only
2 Mar 2014
ASP.NET Community
In my case, I use  a FileUpload Control(Id:->FileUpload1), an ImageButton(ImageButton1) or you can use the Image,  a Button Control(Id:->Updatebttn)
14 Jan 2014
ASP.NET Community
IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide
4 Dec 2013
Sergii Syrovatchenko
This article includes examples of T-SQL capabilities that allow to perform string concatenation flexibly and effectively through the use of different constructs.
30 Nov 2013
Too much data is breaking the system, we need a fix!
21 Nov 2013
Fetching complex data from multiple table using nested MySQL queries, JOIN operations, LIKE operator and aggregate functions(eg. GROUP BY, GROUP_CONCAT, etc.)
11 Oct 2013
ASP.NET Community
Following is an example of creating a transaction when require to save on many tables at once. I used Microsoft Enterprise Libraries. I assume one to
11 Oct 2013
ASP.NET Community
Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert]    (@SupplierID     bigint,     @ReferenceNo     NVARCHAR(20),    
11 Oct 2013
ASP.NET Community
DAL Should like following when inserting a image. I used the Enterprise Library to data access. Data type of EmployerImage is image @ SQL Server
11 Oct 2013
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
11 Oct 2013
ASP.NET Community
In this article I am explaining about how to show Loading... image using Update Progress at center of grid view. for  this article i have used North
11 Oct 2013
ASP.NET Community
Basic Hard Coded Cascading MenusTechnically your menus won't need javascript to be utilized. Just some basic CSS that will help with everything and
11 Oct 2013
ASP.NET Community
Providers factory provides us indepandent database access where we can connect to any database sources(SQLServer,DB2,Oracle,MS-Access).Provider
11 Oct 2013
ASP.NET Community
A RadioButtonList can be used to select 1 option within several options. The item "Pizza with egg" is selected by default.    <asp:RadioButtonList
11 Oct 2013
ASP.NET Community
 ASP Repeater ControlThe Repeater control is used to display a repeated list of items that are bound to the control. The Repeater control may
11 Oct 2013
ASP.NET Community
When working with an ASP.NET site that requires some sort of user authentication (almost every time, I'd say), we often need to establish our own
11 Oct 2013
ASP.NET Community
In this article I will sharing how to bind with GridView control with Database and without database using Data Table.Bind GridView with DatabaseI
11 Oct 2013
ASP.NET Community
If you use the membership providers, having visual studio keep this sql database file around for deployment can sometimes be convenient.
11 Oct 2013
ASP.NET Community
For ASP.NET developers, there is good news from Microsoft with the latest SQL Server release, Denali CTP3.Many developers like ASP.NET developers
11 Oct 2013
ASP.NET Community
Getting started with MongoDBMongoDB is a famous representative of NoSQL databases. It is a document-oriented database, which means that data will
11 Oct 2013
ASP.NET Community
Let see an example of using the database in LINQ and C#.netcf We will using classCustomer Here'ssome sample
11 Oct 2013
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
11 Oct 2013
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
11 Oct 2013
ASP.NET Community
LINQ to SQL is an interesting Object-Relational Mapper because it remembers the relationships objects have between each other.  As usual, LINQ to SQL
11 Oct 2013
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
10 Oct 2013
Mehdi Gholam
Even faster Key/Value store nosql embedded database engine utilizing the new MGIndex data structure with MurMur2 Hashing and WAH Bitmap indexes for duplicates. (with MonoDroid support)
5 Sep 2013
Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
22 Jun 2013
Adam Tibi
A typical implementation of a CQRS pattern ASP.NET MVC 4, Ninject and MongoDB. I will be demonstrating a sample applications that acts as a base building block for a CQRS-based architecture.
20 Jun 2013
Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
11 Jun 2013
Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
5 Jun 2013
Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
15 May 2013
Implementation of relative database constraints and permissioning using triggers and shadow tables.
21 Apr 2013
Rob Culhane
Dynamically add access database columns at runtime using
13 Mar 2013
A NoSQL-like document store in JSON format.
15 Feb 2013
Michael Haephrati
The DataTune system was one of the earliest data cleansing systems.
13 Feb 2013
Noor Ahmad Feroozi
A function to remove and select unique records from a DataTable in C#.NET and return a clean and duplicate-free DataTable
15 Jan 2013
Marco Sorich
Some guidelines for developing better MS Access solutions.
8 Aug 2012
CodeProject, DBNess
Welcome to our continuing series of Code Project interviews in which we talk to developers about their backgrounds, projects, interests and pet peeves. In this installment we talk to Vanessa Hurst, founder of Developers for Good, co-founder of Girl Develop It!, and a consultant and advisor to startu
25 Jul 2012
Wusheng Hu
This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.
7 May 2012
Jason Rudland
Trial of popular REST implimentations for NodeJS including the measuring of MongoDB insertion rates.
8 Mar 2012
Manjuke Fernando
Locks and duration of transactions in SQL Server
23 Jan 2012
Jaganathan Bantheswaran
A tool to generate SQL server DB script from the LightSwitch internal database
28 Sep 2011
Ivan Vodišek
An alternative approach to database modeling.
14 Jul 2011
5 Database Worst Practices which can be fatal to any business
14 Feb 2011
Stefan Savev 2
Fast External Sort in C#: sort 30 GB of integers on an external USB drive in one hour
23 Jan 2011
Pranay Rana
Manage SQL Server Database within Visual Studio Team System
31 Dec 2010
Manan J
Arrange Results to get the most relevant result first...
6 Aug 2010
Alexander Maximov, Apriorit Inc
The aim of this article is to create the library for writing e-mail messages in the *.pst format (used by Microsoft Outlook) to the file.
14 Jul 2010
Christopher R Davis, Michael S Knight
Generate an Entity Framework data access layer using an nHydrate model.
8 Jun 2010
Looking at the possibility of using CRUD applications to manage other CRUD applications inside a web browser and without any hand-coding. Also, presenting a step wizard deriving the database structure from the UI rather than the opposite.
7 Jun 2010
Dylan Morley
Describes how you can run multiple queries against an iSeries DB2 and cancel long running queries.
20 May 2010
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL