Click here to Skip to main content
14,835,369 members
Everything / Database Development

Database Development

database

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 vb.net
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 Satya Karki
This article describes the options to restore and backup database in SQL Server and explains how to Export BACPAC from SQL Server Management Studio.
by Satya Karki
How to import or restore BACPAC file using SSMS
by Vadim Loboda
A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters
by Rijwan Ansari
How to compare two databases using SQL Server Database Project (Template) available in VS.

All Articles

Sort by Score

Database Development 

Please Sign up or sign in to vote.
1 Dec 2019
Evoluteur
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
Please Sign up or sign in to vote.
21 Apr 2013
Rob Culhane
Dynamically add access database columns at runtime using vb.net
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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?
Please Sign up or sign in to vote.
14 May 2015
DaveMathews
Using SIML, a language designed for Digital Assistants, to create a Natural Language Interface to an SQL Database.
Please Sign up or sign in to vote.
23 Mar 2019
Minh Tuan Do
A considerable method to speed up query running time
Please Sign up or sign in to vote.
28 Jul 2014
DiponRoy
How to manage Entity Framework Code First in Real Time Projects
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
30 Dec 2019
Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
Please Sign up or sign in to vote.
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)
Please Sign up or sign in to vote.
10 Apr 2015
Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
Please Sign up or sign in to vote.
14 Oct 2015
Terence Wallace
Alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"
Please Sign up or sign in to vote.
26 Feb 2016
Pavel Sinkevich
How to programmatically change schema name in database project before deployment
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
13 Jan 2020
koolprasadd
New features of SQL 2019
Please Sign up or sign in to vote.
7 May 2012
Jason Rudland
Trial of popular REST implimentations for NodeJS including the measuring of MongoDB insertion rates.
Please Sign up or sign in to vote.
15 May 2013
h_wiedey
Implementation of relative database constraints and permissioning using triggers and shadow tables.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
12 Jan 2015
Leom Burke
EF Code First and WPF with the Chinook Database - Styles and DataTemplates
Please Sign up or sign in to vote.
7 Feb 2017
hamdenvogel
Learn how to implement a real stream file based dataset descendant with blob support and much more.
Please Sign up or sign in to vote.
2 Feb 2018
Private Dobbs
How to initialise a database and then automatically keep it up to date with version releases
Please Sign up or sign in to vote.
10 Jan 2018
ASkaeff
A simple yet powerful tool to analyse SQL object dependencies in quite fast and reliable manner.
Please Sign up or sign in to vote.
5 Dec 2019
Renz Ladroma
A tutorial on how to setup Keepalived for MySQL Auto Failover
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
16 Apr 2019
Dan Ionescu (USINESOFT)
LINQ extensions that allow to describe and to safely query cached data
Please Sign up or sign in to vote.
2 Feb 2020
Arthur V. Ratz
A Simple Web Application User Authentication Project Using Passport.js And JSON Web Tokens (JWT) explained.
Please Sign up or sign in to vote.
28 Sep 2011
Ivan Vodišek
An alternative approach to database modeling.
Please Sign up or sign in to vote.
5 Sep 2013
Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
11 Oct 2013
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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.   
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
11 Oct 2013
ASP.NET Community
Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert]    (@SupplierID     bigint,     @ReferenceNo     NVARCHAR(20),    
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
13 Mar 2016
Zohaib Sibte Hassan
A more detailed look into Iterators and Snapshots in LevelDB UWP
Please Sign up or sign in to vote.
13 Aug 2018
Member 13935194
In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.
Please Sign up or sign in to vote.
25 Oct 2014
Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
Please Sign up or sign in to vote.
18 Aug 2019
koolprasadd
SQL 2017 new features
Please Sign up or sign in to vote.
15 Feb 2013
Michael Haephrati
The DataTune system was one of the earliest data cleansing systems.
Please Sign up or sign in to vote.
8 Dec 2015
Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
Please Sign up or sign in to vote.
11 Apr 2016
VijayRana
MongoDB Tutorial - MongoDB specific queries
Please Sign up or sign in to vote.
20 May 2010
Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
Please Sign up or sign in to vote.
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...
Please Sign up or sign in to vote.
18 Mar 2021
VijayRana
A tutorial for MongoDB Tutorial
Please Sign up or sign in to vote.
1 Mar 2015
mbarbac
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
Please Sign up or sign in to vote.
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)
Please Sign up or sign in to vote.
1 Mar 2015
mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
Please Sign up or sign in to vote.
18 Apr 2016
VijayRana
Performance - Indexing in MongoDB
Please Sign up or sign in to vote.
8 Mar 2012
Manjuke Fernando
Locks and duration of transactions in SQL Server
Please Sign up or sign in to vote.
14 Aug 2017
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
5 Jun 2013
Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
Please Sign up or sign in to vote.
2 Apr 2014
Anand Gunasekaran
Working with text file as database can querying as RDBMS with SQL Queries.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
1 Jul 2018
Graeme_Grant
DotNet.Core.SQLite - A lightweight performance wrapper library for working with SQLite including usage examples in C# & VB
Please Sign up or sign in to vote.
16 Oct 2014
Pavel Durov
Article about dynamic Sqlite database management on Android platform using Java class reflection.
Please Sign up or sign in to vote.
1 Mar 2015
mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
Please Sign up or sign in to vote.
14 Sep 2015
nam1234567
Build your own database class library with C#
Please Sign up or sign in to vote.
24 Apr 2019
QxOrm
QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
23 Aug 2016
Suvendu Shekhar Giri
Introduction of new useful features in SSMS 2016
Please Sign up or sign in to vote.
24 Oct 2014
Shivprasad koirala, Marla Sukesh
This is the part 3 of the series Learn MSBI step by step
Please Sign up or sign in to vote.
15 Sep 2014
DiponRoy
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
5 Apr 2021U
Vadim Loboda
A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters
Please Sign up or sign in to vote.
7 Sep 2019
Shameel
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.
Please Sign up or sign in to vote.
13 Mar 2013
Chia-MingLiang
A NoSQL-like document store in JSON format.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
30 Nov 2013
DaveAuld
Too much data is breaking the system, we need a fix!
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
6 May 2016
Riccardo Cervelli
Sample for custom entity data model and jSon query with SqlServer 2016
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
21 May 2016
VijayRana
MongoDB Tutorial Day 4 :- Aggregation
Please Sign up or sign in to vote.
31 Dec 2010
Manan J
Arrange Results to get the most relevant result first...
Please Sign up or sign in to vote.
11 Jun 2013
Tom Glick Philadelphia, US
Using WCF REST Service to call Stored Procedures and run queries on SQL Server.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
21 Feb 2016
adityaswami89
NoSQL: MongoDB for beginners
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
11 Oct 2013
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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.   
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
11 Oct 2013
ASP.NET Community
Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert]    (@SupplierID     bigint,     @ReferenceNo     NVARCHAR(20),    
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
13 Mar 2016
Zohaib Sibte Hassan
A more detailed look into Iterators and Snapshots in LevelDB UWP
Please Sign up or sign in to vote.
13 Aug 2018
Member 13935194
In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.
Please Sign up or sign in to vote.
25 Oct 2014
Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
Please Sign up or sign in to vote.
18 Aug 2019
koolprasadd
SQL 2017 new features
Please Sign up or sign in to vote.
15 Feb 2013
Michael Haephrati
The DataTune system was one of the earliest data cleansing systems.
Please Sign up or sign in to vote.
8 Dec 2015
Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
Please Sign up or sign in to vote.
11 Apr 2016
VijayRana
MongoDB Tutorial - MongoDB specific queries
Please Sign up or sign in to vote.
20 May 2010
Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
Please Sign up or sign in to vote.
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...
Please Sign up or sign in to vote.
18 Mar 2021
VijayRana
A tutorial for MongoDB Tutorial
Please Sign up or sign in to vote.
1 Mar 2015
mbarbac
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
Please Sign up or sign in to vote.
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)
Please Sign up or sign in to vote.
1 Mar 2015
mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
Please Sign up or sign in to vote.
18 Apr 2016
VijayRana
Performance - Indexing in MongoDB
Please Sign up or sign in to vote.
8 Mar 2012
Manjuke Fernando
Locks and duration of transactions in SQL Server
Please Sign up or sign in to vote.
14 Aug 2017
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
5 Jun 2013
Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
Please Sign up or sign in to vote.
2 Apr 2014
Anand Gunasekaran
Working with text file as database can querying as RDBMS with SQL Queries.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
1 Jul 2018
Graeme_Grant
DotNet.Core.SQLite - A lightweight performance wrapper library for working with SQLite including usage examples in C# & VB
Please Sign up or sign in to vote.
16 Oct 2014
Pavel Durov
Article about dynamic Sqlite database management on Android platform using Java class reflection.
Please Sign up or sign in to vote.
1 Mar 2015
mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
Please Sign up or sign in to vote.
14 Sep 2015
nam1234567
Build your own database class library with C#