Database Development

database

Great Reads

Model-driven REST or GraphQL API for CRUD and More

by Evoluteur

Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL

Using Redis for Storing and Working with Geospatial Data

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

by Rob Culhane

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

Getting Started with PouchDB - Part 1

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.

Latest Articles

Understanding Vector Databases

by Nicolas DESCARTES

What are vector databases?

Introduction to B-trees: Concepts and Applications

by Ștefan-Mihai MOGA

How to solve real-life problems using B-trees

SqlServer & EF7: Using datetime vs datetime2 date type

by Mark Pelf

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

Entity Framework 7 – Code First – Using CLI

by Mark Pelf

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

All Articles

top

Database Development

A Basic Introduction to Sqoop Import & Export for MySql Table to be Used as Hadoop Distributed File System (HDFS) in Cloudera

7 Jan 2017 by SrikantSahu

This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

hadoop

MySQL

big-data

database

A Closer Look at Lookup Tables

20 Oct 2016 by Bryan Kowalchuk

The two most common database lookup table patterns are examined

A simple hack of a built-in MS SQL Server WITH ENCRYPTION mechanism

27 Mar 2012 by Marian Placko

This article shows a simple hack of a built-in MS SQL Server WITH ENCRYPTION mechanism

Aggregate Product function extends SQL

19 Feb 2015 by DrABELL

Technique to extend capability of standard SQL by adding the Aggregate Product Function

ALTE Azure Table Storage Indexed ORM

29 Jan 2019 by nickdenker

An ORM style layer which turns Azure Table Storage into a cheap and scalable indexed noSQL database - without the costs associated with Azure CosmosDB.

Always use Binding Variables in SQL queries

19 Apr 2011 by Amit Kumar Tiwari

Boost application speed and performance

Always use Binding Variables in SQL queries

28 Apr 2011 by reshi999

Thanks for that. In MS SQL Server, I use the following technique to avoid full compile:DECLARE @sql VARCHAR(100)DECLARE @pk INTSET @pk = 2SET @sql = 'SELECT id, pcname FROM pod WHERE id = ' + CAST(@pk AS VARCHAR)EXEC (@sql)-- or -- EXEC sp_sqlexec @SQL

Amount to Words

18 Dec 2016 by NightWizzard

Convert amounts to their spoken equivalents

An Algorithm For Grouping Data on One or More Fields Using a DataReader In .NET

7 Jan 2010 by jfernand

Introduction...

database

Android - To Do\Shopping List [Tip/Trick] - Part 2

13 Jun 2013 by Deepali Dhingra

This tip explains how to create a to do or Shopping List app with listview, sqlite, dialog and customadapter.

Automatic Numbering for the Primary Key Column

19 Dec 2013 by Shweta Lodha

Automatic numbering for the primary key column

DataTable

database

Backup All MySQL Databases in C# WinForm with 1 Click

17 Sep 2018 by adriancs

A tool to backup & restore all MySQL databases in one click

MySQL

WinForms

database

Build a Calendar Without Pre-Existing Tables

31 Jan 2017 by #realJSOP

Using common table expressions to build data from thin air.

C# Convert DataTable to List of Objects Dynamically

6 Dec 2014 by saddam abu ghaida

This article describes how to convert any Data Table to List of Objects at runtime using Reflection

Compare Two Databases, Find Differences and Update using Visual Studio

5 Apr 2021 by Rijwan Ansari

How to compare two databases using SQL Server Database Project (Template) available in VS.

SQL

Visual-Studio

database

Connect MongoDB from Any Working Directory on ubuntu

4 Nov 2014 by binit.ku.singh

Connect MongoDB from any working directory on ubuntu

MongoDB

NoSQL

database

Connect WPF with Wamp Server MySql

5 Aug 2014 by Anis Derbel

The easy way to connect to Mysql using Wamp server on WPF

Convert DateTime string to DateTime variable

12 Dec 2012 by Pranay Rana

Convert DateTime string to DateTime variable

database

formatting

DateTime

Convert SQL Server Database to PostgreSQL

2 Jan 2016 by RickZeeland

This console application converts an SQL Server database to PostgreSQL.

Coping with DBNull

17 Sep 2016 by Midi_Mick

A set of helper functions to cope with DBNull results from database queries

SQL

.NET

database

Count Lines of code in a database

26 Apr 2010 by Mycroft Holmes

Assuming that a carriage return represents a line of code, this will count the lines of code in a SQL 2008 database:SELECT ROUTINE_NAME,ROUTINE_TYPE,LEN(ROUTINE_DEFINITION )-len(REPLACE(ROUTINE_DEFINITION,CHAR(10),'')) LOCFROM INFORMATION_SCHEMA.ROUTINESCOMPUTE...

database

Create Insert SQL Statement from the Records in an Existing Table

8 Mar 2016 by markkang

This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database

Create job to export Stored Procedure daily

27 Nov 2012 by Aadhar Joshi

Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.

Creating a Windows Azure SQL Database

4 Mar 2014 by Malak Zia Nasir

Cloud computing is the trend of nowadays; this article provides some basic steps to create and connect a Windows Azure SQL Database to a simple application.

Crystal Reports User Group Selections

6 May 2010 by JasonDove

This is a great to allow users control over their reports and cutting down on the volume of reports needed to meet the business’s needs.The basis of this solution is to control which fields are grouped on within the report which will in turn change the summary operations and change the...

reporting-services

CrystalReports

database

Crystal Reports: 3 New Uses For Sub Reports

12 Mar 2010 by JasonDove

I hate sub reports and always consider them the last resort in any reporting solution. The negative effect on performance and maintainability is just not worth the easy ride they give the report writer. Nine times out of ten reporting requirements can be met using a little forethought and...

recursion

database

Crystal Reports: 5 Tests for Top Performance

29 Mar 2010 by JasonDove

It is complete, your masterpiece report. Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways.Then….Disaster!You try to run the report for a month against the live database and not...

reporting-services

CrystalReports

database

Day 1 : Database Connectivity ASP.NET/C# with SQL Server (Create Operation)

29 Mar 2016 by VijayRana

CRUD operation in ASP.NET/C# with SQL Server for beginners

Delete Similar Databases

31 May 2012 by Manas Bhardwaj

I had these similar databases on my dev environment which I had to delete multiple times during development. As this process was becoming more and more mechnical, I wanted to have a script which would do this for me.

SQL-Server

database

Detects Differences Between Databases

15 Sep 2016 by GhostHost

Compare two databases to detect which object has been modified from an old version of the same database.

DROP IF EXISTS in SQL Server 2016

1 Oct 2016 by Suvendu Shekhar Giri

Enhancement on dropping an object with check for existence in SQL Server 2016

SQL-Server-2016

SQL-Server

database

Dynamic ORDER BY with multiple criteria in T-SQL

28 May 2013 by Bob Crowley

How to use a CASE statement in ORDER BY to avoid dynamic SQL

Easy Compare DB

24 Apr 2023 by Eligio Morgado H.

Compare two SQL Server databases and show difference in tables and fields

.NET6

SQL-Server

database

Encrypt all Stored Procedures with PowerShell

7 Aug 2012 by kennysun

encrypt all stored procedures in SQL server with powershell

Entity Framework Code First Migrations Alternative

30 Jul 2014 by DiponRoy

How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first

Error Message: Saving Changes Is Not Permitted

3 May 2016 by Michael Haephrati

How to overcome an error message preventing you from saving a change in an SQL Server database

SQL-Server

database

Export & Import Data+Attach Database of Higher Version to Lower Version

29 May 2014 by NIKS SHINE

Uploading database of higher version of DBMS to the lower version one.

data

export

database

Find Duplicate Files in FILETABLE

20 Mar 2015 by Sarathi Balakrishnan

Remove duplicate files with same file content, even with different file name using FILETABLE with simple CTE.

SQL-Server

FileStream

database

Find Sp from database which is related to(using) table XXX

27 Feb 2010 by Pranay Rana

Problem : - During project development I got the requirement that I have to modified the column name of the table which is used in the no of procedure i.e i have to found all procedure related to that table and modify it For the above problem following are the solution that i used First ...

Four Pitfalls of SQL Processing with NULL Values

1 Nov 2022 by Tomas@PawSQL

How to cope with all scenarios regarding NULL value handling in your daily work

SQL

PostgreSQL

database

Framework for Performing Aggregation and Plain MongoDB Queries in myBatis Style

12 Sep 2013 by dmgcodevil

Framework for performing aggregation and plain MongoDB queries in myBatis style

Full Service SQLite for WPF (Including File Handling)

19 Jun 2015 by ergohack

System.Data.SQLite is great, but was missing some BLOB support. Switching to the native source project was easier than expected and provided significant functionality benefits.

Generating constructors at compile time

8 Dec 2014 by PIEBALDconsult

This is an alternative for "C# Convert DataTable to List of Objects Dynamically"

GMapsTable: Usage

11 Jun 2017 by AivanF

Read how to add a dynamic table on Google map for your webpage

How to backup multiple databases using Perl

7 Jan 2012 by Carlos Luis Rojas Aragonés

How to backup multiple databases using Perl

Perl

SQL

database

How to connect to Analysis Services (SSAS) from a different domain user

2 Oct 2010 by kasiarun

How to connect to Analysis Services (SSAS) from a different domain user

How to Create SQL Server Database Project With Visual Studio

4 Apr 2021 by Rijwan Ansari

Learn about SQL Server Database Project (Template) available in VS

How to display images from the database in your JSP pages - the easy way

25 Sep 2011 by ludovicianul

The easiest and elegant way to read images from the database and display them in the UI.

image

web

database

How to find a specific string from stored procedures, triggers and functions in database

4 Feb 2012 by RasikaLB

You can find queries to find a specific string from MSSQL Server

SQL

server

database

How to find a specific string from stored procedures, triggers and functions in database

27 Jan 2012 by jim lahey

Please see my alternative tip #2:Do the same thing with SMO[^]There's a Microsoft API for all this, it's been around for a while.

SQL

server

database

How to find a specific string from stored procedures, triggers and functions in database

7 Feb 2012 by Member 2077086

Simply add your search phrase and run to find jobs, Stored Procedures, Keys, Tables, Views, Indexes, Defaults, and Functions.set nocount on declare @Keyword as varchar(200)set @Keyword = 'Search prase'--

SQL

server

database

How to fix "LocalDB - Requested Login failed"

20 May 2014 by Ed Nutting

How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"

How to get the details of Open Transaction in SQL Server

2 Sep 2010 by tarun_j200

How to Insert HTML Table Data into SQL Server in a Single Batch by Using JQuery Ajax and Structured Parameter

29 Nov 2015 by Amit Singh Baghel

Saving Details Table Data (An HTML Table) in Database by converting it into a jagged array and passing it to a table type parameter

How to Modify Views, Triggers and Procedures from Code

30 Sep 2019 by NightWizzard

Read and/or modify database objects like views, triggers, stored procedures and functions from .NET code.

How to setup database versioning tool RoundhousE

2 Sep 2014 by Rohan Kishor Garud

RoundhousE (RH) is a database migrations engine that uses plain old SQL Scripts to transition a database from one version to another.

How to Shrink SQL Server database files?

5 Jan 2011 by thatraja

How to Shrink SQL Server database files?

SQL

database

How to Shrink SQL Server database log files?

5 Jan 2011 by thatraja

How to Shrink SQL Server database log files?

SQL

database

How to Shrink SQL Server database log files?

8 Feb 2010 by Huisheng Chen

DUMP TRANSACTION FooDB WITH NO_LOGBACKUP LOG FooDB WITH NO_LOGDBCC SHRINKDATABASE(FooDB)EXEC sp_dboption 'FooDB', 'autoshrink', 'TRUE'

SQL

database

How To Use Oracle's TRIM, LTRIM and RTRIM Functions

27 Dec 2016 by Database Star

How to use these three functions and what the differences are between them

SQL

Oracle

database

How-To Create a CLR Function with EffiProz Database

17 Mar 2010 by arith silva

EffiProz(www.e...

.NET

ADO.NET

database

HTML5 Tables Formatting: Alternate Rows, Color Gradients, Shadows

16 Jun 2015 by DrABELL

HTML5/CSS3 advanced formatting of web Tables and ASP.NET GridView

Import or Restore BACPAC File using SQL Server Management Studio

6 Apr 2021 by Satya Karki

How to import or restore BACPAC file using SSMS

Java & JDBC & SQLite: Read Data from User-selected db Table and Show in JTable

4 Sep 2014 by Emiliarge

A JavaFX/Swing NetBeans 8.0 Project with JFrame created by NetBeans's GUI Builder

Known Limitation of MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4

11 Nov 2015 by Masteramuk

Basic rules for using MySQL Cluster (NDB) from MyISAM or InnoDB

Large Volume Data Synchronization Process Between Central Database (Remote) and Branch Database

5 Dec 2014 by Md.Sajidur rahman

This structure describes how to process data from multiple branches and store to analysis.

data-center

database

List Batching/Paging With Entity Framework or Any IEnumerable in C#

19 May 2019 by DiponRoy

The aim of this helper class is to divide a large IEnumerable into multiple small list.

List of Tables of Microsoft Access DataBase

17 Feb 2011 by dontumindit

While dealing with databases, sometimes there is a need to get a list of tables in the application

Loading an Image and Saving it into a database

23 Aug 2011 by Armando de la Torre

How to load an image from the filesystem and save it into a Database

Making It Easier to Replace Null with DBNull.Value

16 Mar 2023 by raddevus

Function to help convert null to DBNull.Value for inserting in database

Nullable

database

MessageBox Database Tables

26 Feb 2014 by VIGNESH SUKUMAR

Quick view of Biztalk MessageBox Tables

Method to Change Source of a Form’s Subform Source to a Query or Table in Microsoft Access

12 Sep 2018 by Clifford Nelson

Method to change source of a Form’s Subform source to a Query or Table in Microsoft Access

MFC CRecordset - How to Bypass the 255 Column Limit

21 May 2021 by rev78

Simply bypass the 255 columns in MFC CRecordset

Microsoft SQL Server – Bulk Delete Prescription

28 Jan 2013 by MinhajMohammed

This article is not going to give you a pinpoint solution for a specific delete challenge, but rather it is meant to give a broader picture of the problem domain and the various tools you can opt based on your situation.

database

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

14 Jun 2020 by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

Oracle Parameterized Queries for the .NET Developer

5 Feb 2016 by Foothill

A Primer for Writing Parameterized Oracle Queries for the .NET SQL Server Developer

OracleDataReader FetchSize Property

25 Jul 2012 by cesar_boucas

"Application performance depends on the number of database round-trips to retrieve data. The less round-trips, the better the performance."

Dev

database

Pay Attention to What "Script...To" Generates

22 Sep 2017 by #realJSOP

It doesn't always happen the way you expect.

PHP's Database Operation- Go OO

8 Oct 2014 by Peter Leow

The OO way to writing your database operation code in PHP

SQL

PHP

database

Pivoting on SQL Server Varchar Data Types

22 Feb 2016 by Sifiso W Ndlovu

This tip illustrates a workaround to SQL Server pivoting on variable character data types.

Post on how to do Paging in Oracle

2 Feb 2011 by Santopk

Oracle Paging

SQL

database

Problem with OLE Db Provider in Windows XP Media Center

22 May 2011 by fgoldenstein

Cannot open Microsoft Access database -> Exception message "unknown"

exceptions

database

Random Date/Time Test Data Generation

25 Aug 2016 by Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

Reading Duplicate Values from the Table

7 Apr 2010 by Indrajeet Sutar

Hi, on many occasions we want to search some repeated values in one or more columns. It is quite simple to do this...select ColumnName, count(ColumnName) as NumberOfTimesfrom TableNameGroup By ColumnNamehaving (count(ColumnName) > 1)At the same time, there is also a requirement...

SQL

database

Record Count of Tables in SQL Server

16 Aug 2011 by thatraja

The below query can be used to get the record count of all tables in the current database.

SQL-Server

SQL-Server-2005

database

Record Count of Tables in SQL Server

19 Feb 2010 by Md. Marufuzzaman

This is good... You can also consider this link.[^]

SQL-Server

SQL-Server-2005

database

Record Count of Tables in SQL Server

26 Aug 2010 by Pranay Rana

Number of different ways to get total number of rows from tables

SQL-Server

SQL-Server-2005

database

Record Count of Tables in SQL Server

26 Aug 2010 by tarun_j200

Also use either this one:SELECT OBJECT_NAME(SYSINDEXES.id), SYSINDEXES.rowcntFROM SYSINDEXES INNER JOIN SYSOBJECTS ON SYSINDEXES.id = SYSOBJECTS.idWHERE SYSINDEXES.indid

SQL-Server

SQL-Server-2005

database

Record Count of Tables in SQL Server

16 Aug 2011 by Graham Cottle

Sometimes it is necessary to have the schema name included as well. I concatenate with the table name for my convenience, but it is not vital to do so.SELECT sys.sysindexes.rows, sys.schemas.name + '.' + sys.objects.nameFROM sys.objectsINNER JOIN sys.schemasON ...

SQL-Server

SQL-Server-2005

database

Reset PLSQL sequence value

24 Dec 2010 by Shahriar Iqbal Chowdhury/Galib

Reset PLSQL sequence value

Search in your DB-Objects With Multiple Keywords

27 Aug 2013 by hmdmgd3

SQL code allows you to find objects using multiple keywords in your DB

Simple Daily SQL Server Database Backup Batch File

6 Jul 2015 by Mike Trank

Simple Daily SQL Server Database Backup Batch File

Single SP for Multiple Search Scenario

2 Apr 2016 by SantanuDebnath

Write one SP for multiple Search

Some internal SQL Sever Queries

22 Feb 2010 by Gaurav Dudeja India

The following query uses the sys.objects catalog view to return all database objects that have been modified in the last 10 days.SELECT name AS object_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc ,create_date ,modify_dateFROM sys.objectsWHERE modify_date >...

SQL

server

database

SQL Atomic Operation on UPDATE and DELETE

13 Jan 2012 by Robby Tendean

How to do SQL atomic operations on UPDATE and DELETE syntax.

SQL Executer to run SQL Queries

21 Feb 2011 by dontumindit

Installing Oracle or SQL Server just to practice SQL Queries is not a good idea. They occupy a lot of space and also slow down the normal processing of the PC.

SQL

database

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

30 Oct 2015 by JoaoSousa23

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

SQL

server

database

Streamlined [Data Model-less] Record Editing with a SQLite Data Object Window Base Class

11 Jul 2015 by ergohack

This SQLite Data Object Window base class automates the data updates and the data bindings between the XAML presentation and the SQLite database allowing the minimum of code needed to present and edit SQLite database records.

T-sql over clause to aggregating without groupby

2 May 2011 by pankajupadhyay29

A nice way to get aggregated value without group by

T-SQL

SQL-Server