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

US Federal Holidays (SQL)

31 Jan 2017 by #realJSOP

A scalar function to determine if a given DateTime is one of the ten US federal holidays, using SQL Server.

SQL

SQL-Server

Dev

DBA

database

Build a Calendar Without Pre-Existing Tables

31 Jan 2017 by #realJSOP

Using common table expressions to build data from thin air.

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

22 Sep 2017 by #realJSOP

It doesn't always happen the way you expect.

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.

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

GMapsTable: Usage

11 Jun 2017 by AivanF

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

Always use Binding Variables in SQL queries

19 Apr 2011 by Amit Kumar Tiwari

Boost application speed and performance

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

Connect WPF with Wamp Server MySql

5 Aug 2014 by Anis Derbel

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

The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

17 Jul 2017 by Arif H Shigri

This tip will discuss the difference between ROW_NUMBER(), RANK() and DENSE_RANK().

SQL

SQL-Server

database

How-To Create a CLR Function with EffiProz Database

17 Mar 2010 by arith silva

EffiProz(www.e...

.NET

ADO.NET

database

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

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

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

Using XPath to Query the Internet

10 Dec 2013 by Bruce Yang CL

A way to query the data from Internet

A Closer Look at Lookup Tables

20 Oct 2016 by Bryan Kowalchuk

The two most common database lookup table patterns are examined

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

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

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

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

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.

Writing DB Classes for the web

23 Jul 2010 by deostroll

write classes meant for use in aspx code behind pages which talk with the database

ASP.NET

database

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

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.

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.

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

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

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

Aggregate Product function extends SQL

19 Feb 2015 by DrABELL

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

Use SQL to generate large data sequence

19 Feb 2015 by DrABELL

Generate large data series by using Cartesian Product and small data table

HTML5 Tables Formatting: Alternate Rows, Color Gradients, Shadows

16 Jun 2015 by DrABELL

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

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"

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

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

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.

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.

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

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

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

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.

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.

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

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

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

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

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

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

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

7 Jan 2010 by jfernand

Introduction...

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

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

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

Encrypt all Stored Procedures with PowerShell

7 Aug 2012 by kennysun

encrypt all stored procedures in SQL server with powershell

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

Youtube video list with PHP

6 Jun 2015 by Magyar András

Load videos automatically from selected Youtube channel with PHP and Youtube Data API v3

Tips for SQL-Indexes

21 Jan 2011 by Mahendra Vishwakarma

Tips for SQL-Indexes

database

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.

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

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

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

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

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

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

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

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

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

Updating an SQLite database

21 Aug 2011 by Mike Hankey

Updating an SQLite database to a new version and copying the contents of the old one into the updated database.

SQLite

database

Simple Daily SQL Server Database Backup Batch File

6 Jul 2015 by Mike Trank

Simple Daily SQL Server Database Backup Batch File

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

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

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.

Amount to Words

18 Dec 2016 by NightWizzard

Convert amounts to their spoken equivalents

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.

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

Using Visual Studio to find a database connection string

14 Jan 2012 by OriginalGriff

Visual Studio has a Server Explorer built in to handle database access - it can lalso generate database connection strings ready for saving in application config files.

Visual-Studio

database

T-sql over clause to aggregating without groupby

2 May 2011 by pankajupadhyay29

A nice way to get aggregated value without group by

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

Generating constructors at compile time

8 Dec 2014 by PIEBALDconsult

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

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 ...

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

Convert DateTime string to DateTime variable

12 Dec 2012 by Pranay Rana

Convert DateTime string to DateTime variable

database

formatting

DateTime

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

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

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

MFC CRecordset - How to Bypass the 255 Column Limit

21 May 2021 by rev78

Simply bypass the 255 columns in MFC CRecordset