Database Development

Using Redis for Storing and Working with Geospatial Data

10 Aug 2022 by Aleksandr Ulanov

Learn how to use Redis and its geospatial indexes and commands for complex geo calculations

Dynamically Add Access Database Columns at Runtime using VB.NET

21 Apr 2013 by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

Getting Started with PouchDB - Part 1

15 Jan 2019 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.

Indexed Views and How It Can Help in Improving Query Performance

23 Mar 2019 by Minh Tuan Do

A considerable method to speed up query running time

Manage Entity Framework Code First in Real Time Projects

28 Jul 2014 by DiponRoy

How to manage Entity Framework Code First in Real Time Projects

Performance testing of ORM layers in Python and C++

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.

SqlServer & EF7: Using datetime vs datetime2 date type

8 Jun 2023 by Mark Pelf

Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

T-SQL reporting engine

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.

4db: A Dynamic File-based NoSQL Database for C++

22 Nov 2021 by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

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.

Automating the SQL Database Mirroring Setup

30 Dec 2019 by Dathuraj Pasarge

Database mirroring setup without any DBA effort - on every new database creation

Unattended installation of SQL Server 2012

11 Jul 2016 by 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.

DataProvider - A Static Library for Handling Databases from C++

8 Jan 2022 by Michael Haephrati

A Static Library which can be used for all kinds of database related needs

Understanding Vector Databases

9 Feb 2024 by Nicolas DESCARTES

What are vector databases?

artificial-intelligence

vector

Parameterize Schema Name in SSDT Database Project .dacpac file by using DacFx Public Model and System.Reflection

Upload an Image and an Audio file using C#

2 Mar 2014 by 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)

Refering dlls in SSIS Script Task

10 Apr 2015 by Rajeesh Madambat

Refer and write your own business logic in C# and add it to SSIS script task.

26 Feb 2016 by Pavel Sinkevich

How to programmatically change schema name in database project before deployment

THVDataSet - A Complete Delphi DataSet Based on Stream

7 Feb 2017 by hamdenvogel

Learn how to implement a real stream file based dataset descendant with blob support and much more

Delphi

desktop

Getting Started with PouchDB - Part 2

20 Jan 2019 by Paul D. Sheriff

In this 2nd part of my series on PouchDB, you learn how to perform multi-document inserts and reads.

SQL 2019 - New Features

13 Jan 2020 by koolprasad2003

New features of SQL 2019

SQL-Server-2019

SQL Server Database :: Source Control, Continuous Integration and Continuous Deployment using Github, TeamCity and Octopus

metastrings: A Simple File-based Dynamic NoSQL Database

9 Aug 2021 by Michael Sydney Balloni

Learn about the inner workings of a dynamic database, and how SQLite is a great fit

20 Oct 2019 by 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.

LiteDB - A .NET NoSQL Document Store in a Single Data File

14 Oct 2015 by Terence Wallace

Alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"

Entity Framework 7 – Database First – Using EFCorePowerTools

25 May 2023 by Mark Pelf

Tutorial on EF7 – Database First approach using GUI tools EFCorePowerTools

entity-framework

NodeJS REST server trials to validate effective scripting

7 May 2012 by Jason Rudland

Trial of popular REST implimentations for NodeJS including the measuring of MongoDB insertion rates.

Relative Constraints and Permissioning in T-SQL

15 May 2013 by h_wiedey

Implementation of relative database constraints and permissioning using triggers and shadow tables.

SQL-Server

Employee Info Starter Kit - Getting Started

11 Oct 2013 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

server

EF Code First and WPF with the Chinook Database. Part 3 – Styles and DataTemplates 101

12 Jan 2015 by Leom Burke

EF Code First and WPF with the Chinook Database - Styles and DataTemplates

A Database Initialiser for SQLite and NPoco

5 Jun 2021 by Private Dobbs

How to initialise a database and then automatically keep it up to date with version releases

SQL Object Dependencies with Simple RegEx and Some Algo Magic

10 Jan 2018 by ASkaeff

A simple yet powerful tool to analyze SQL object dependencies in quite a fast and reliable manner.

regular-expression

MySQL Auto Failover using Keepalived on CentOS

5 Dec 2019 by Renz Ladroma

A tutorial on how to setup Keepalived for MySQL Auto Failover

Linux

MySQL

Options for Database Backup and Restore - How to Export BACPAC using SSMS?

6 Apr 2021 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.

migration

application

Entity Framework 7 – Code First – Using CLI

1 Jun 2023 by Mark Pelf

Tutorial on EF7 – Code First approach using Command Line (CLI)

entity-framework

Entity Framework 7 – Database First – Using CLI

25 May 2023 by Mark Pelf

Tutorial on EF7 – Database First approach using Command Line (CLI)

entity-framework

Getting Started with PouchDB - Part 3

21 Jan 2019 by 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.

Cachalot DB as a Distributed Cache with Unique Features

16 Apr 2019 by Dan Ionescu (USINESOFT)

LINQ extensions that allow to describe and to safely query cached data

Implement a Distributed Database to Your Java Application

7 Oct 2021 by Sam B. Brown

Interference open cluster is a simple Java framework that enables you to run a distributed database service within your Java application

Single Database for Multiple Microservices with FluentMigrator

3 Jun 2022 by Ivan Yakimov

How to use single database to store information from several microservices with the help of FluentMigrator

Workaround for AT TIME ZONE Performance Issues in SQL Server Views & Dynamic SQL

6 Mar 2023 by Andriy Protskiv

Workaround for performance issues with AT TIME ZONE

Binary Relational Modeling

28 Sep 2011 by Ivan Vodišek

An alternative approach to database modeling.

Visual Basic Using Reflection to Map DataTable in MySQL Database

5 Sep 2013 by Mr. xieguigang 谢桂纲

Easy way to map the table in the mysql database.

Configuring SQL Server

11 Oct 2013 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

LINQ to SQL Relationships

11 Oct 2013 by 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

LINQ

create LINQ to database in the .NET Compact Framework 3.5

11 Oct 2013 by ASP.NET Community

Let see an example of using the database in LINQ and C#.netcf We will using classCustomer Here'ssome sample

LINQ

How to create Umbraco database on shared hosting.

11 Oct 2013 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

SQL Server Express LocalDB

11 Oct 2013 by 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

Getting started with MongoDB

11 Oct 2013 by 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

How to stop creating the aspnetdb.mdf database

11 Oct 2013 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.

Creating a custom membership provider

11 Oct 2013 by 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

Binding Grid View Control

11 Oct 2013 by 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

RadioButtonList

11 Oct 2013 by ASP.NET Community

A RadioButtonList can be used to select 1 option within several options. The item "Pizza with egg" is selected by default.

data

ASP Repeater Control and Export to Excel

11 Oct 2013 by 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

ASP

table

Displaying Update progress at center of gridview

11 Oct 2013 by 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

grid

Binding

Creating Menus with JavaScript, LINQ, and SqlDataAdapter

11 Oct 2013 by 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

Provider Factory

11 Oct 2013 by ASP.NET Community

Providers factory provides us indepandent database access where we can connect to any database sources(SQLServer,DB2,Oracle,MS-Access).Provider

DB2

Creating a Transaction (Enterprise Libraries)

11 Oct 2013 by 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

Saving Records & Caputring Return Value (Enterprise Library)

11 Oct 2013 by ASP.NET Community

Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert] (@SupplierID bigint, @ReferenceNo NVARCHAR(20),

stored-procedure

DateTime

Saving and Calling a image from SQL Server DB

11 Oct 2013 by 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

server

Creating a Full Text Service and Searching items from Code behind

11 Oct 2013 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

Iterators and Snapshots for LevelDB UWP

13 Mar 2016 by Zohaib Sibte Hassan

A more detailed look into Iterators and Snapshots in LevelDB UWP

Integrate Firebase Phone Authentication With Laravel

13 Aug 2018 by Member 13935194

In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.

Introduction to B-trees: Concepts and Applications

20 Jan 2024 by Ștefan-Mihai MOGA

How to solve real-life problems using B-trees

Semantic Database: Concept, Architecture and Implementation

25 Oct 2014 by Marc Clifton

No word has a value that can be identified independently of what else is in its vicinity.

SQL 2017 - New Features

18 Aug 2019 by koolprasad2003

SQL 2017 new features

SQL-Server-2017

The Data Tune System

15 Feb 2013 by Michael Haephrati

The DataTune system was one of the earliest data cleansing systems.

Dev

data

Kerosene ORM: a dynamic, configuration-less and self-adaptive ORM for POCO objects supporting a SQL-like syntax from C#

Friday the 13th - JSON is Coming to SQL Server

8 Dec 2015 by Jovan Popovic(MSFT)

Overview of built-in support for JSON text processing in new SQL Server

MongoDB Tutorial - Day 2

11 Apr 2016 by VijayRana

MongoDB Tutorial - MongoDB specific queries

Database Export Wizard for ASP.NET and SQL Server

20 May 2010 by Evoluteur

A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL

Hidden Gems of DEFAULT TRACE in SQL Server

21 Mar 2016 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...

Mongo DB Tutorial and Mapping of SQL and Mongo DB Query

18 Mar 2021 by VijayRana

A tutorial for MongoDB Tutorial

1 Mar 2015 by 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.

RaptorDB - The Key Value Store V2

10 Oct 2013 by 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)

Kerosene ORM Maps In Depth

1 Mar 2015 by mbarbac

A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.

MongoDB Tutorial - Day 3 (Performance - Indexing)

18 Apr 2016 by VijayRana

Performance - Indexing in MongoDB

Dev

Locks and Duration of Transactions in MS SQL Server

8 Mar 2012 by Manjuke Fernando

Locks and duration of transactions in SQL Server

Dev's User Guide To SqlLocalDb (Sql Express)

14 Aug 2017 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.

A Coder Interview With Vanessa Hurst

8 Aug 2012 by 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

All-Topics

data

Create a div based grid functioning on JSON data using MVC with Entity Framework and MySQL

5 Jun 2013 by Rajat Bittharia

Grid based on JSON data using MVC with Entity Framework and MySQL.

FlatFile Database System

2 Apr 2014 by Anand Gunasekaran

Working with text file as database can querying as RDBMS with SQL Queries.

Masking Sensitive Data with SQL Server 2016

15 Aug 2016 by Suvendu Shekhar Giri

How sensitive data in SQL Server 2016 can be masked from the outer world using Dynamic Data Masking

SQL-Server-2016

SQL-Server

Build Your Own Database

14 Sep 2015 by nam1234567

Build your own database class library with C#

VS2013

Android dynamic Sqlite database management v.2

16 Oct 2014 by Pavel Durov

Article about dynamic Sqlite database management on Android platform using Java class reflection.

Kerosene ORM Dynamic Records In Depth

1 Mar 2015 by mbarbac

A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library

Autogenerate Unit Tests For Your Database Objects - Visual Studio 2019 & 2022 (amd64) Extension

4 Jan 2023 by Bert O Neill

Features and functionalities associated with Autogenerate DB Unit Test app

QxOrm - C++ ORM (Object Relational Mapping) Library

24 Apr 2019 by QxOrm

QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)

LiteDB - A .NET NoSQL Document Store in a Single Data File

18 Oct 2017 by Mauricio David

Simple, fast and free embedded .NET NoSQL Document Store in single data file

Simplifying Data Access in ASP.NET MVC WebAPI with Class Library and Entity Framework

13 Jun 2024 by Zohaib Waqar

Simplifying data access using class libraries and Entity Framework without the need for a .edmx file (ADO.NET)

That's not a database, dude!

1 Dec 2022 by OriginalGriff

There are many things you can use to store information, but not all of them are databases. And trying to use them as such is a really, really bad idea.

Create First SSRS Report with SQL Server Analysis Services OLAP Cube

20 Jul 2014 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

Top 10 Exciting New Features in SQL Server Management Studio 2016

23 Aug 2016 by Suvendu Shekhar Giri

Introduction of new useful features in SSMS 2016

SQL Queries to Manage Hierarchical or Parent-child Relational Rows in SQL Server

15 Sep 2014 by DiponRoy

Some queries to find generation of each row, all possible children, all possible parents, managing recursion

How to Save Object Graph in Master-Detail Relationship with One Stored Procedure

26 May 2023 by Vadim Loboda

A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters

DBA

Basic Handling and Types of Database Relationships in Entity Framework

25 Jul 2012 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.

Input, Output and Input/Output SqlParameter Behavior Explained

1 Nov 2016 by 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.

Restrict Access to SQL Server Data using a Facade Database

7 Sep 2019 by 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.

SQL-Server

best-practices

NoSqlJsonFile - .NET lightweight Document Store

13 Mar 2013 by PraiseTheSun

A NoSQL-like document store in JSON format.

JSON

Step-by-Step PHP Tutorials for Beginners - Creating your PHP Program FROM SCRATCH: Basic Authentication, Membership and CRUD Functionalities

26 Jan 2021 by Kristian Guevara

PHP tutorials for beginners

Developing Automated Data Purge Solution

30 Nov 2013 by DaveAuld

Too much data is breaking the system, we need a fix!