Click here to Skip to main content

Submit your article

SQL

SQL

Great Reads

Comparator - Data Sources Comparer

by Alex Pumpet

A simple program for comparing table data from two sources - SQL databases, Excel, CSV or XML-files

Using Python Scripts from a C# Client (Including Plots and Images)

by Thomas Weller

Demonstrates how to run Python scripts from C#

Create & Populate Time Dimension with 24 Hour+ Values

by Mubin M. Shaikh

Create time dimension with 24 hour plus values and time buckets in your data warehouse

Ultra-Rapid PHP Application Development

by Christoph Buenger

Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).

Latest Articles

How to Repair Corrupt SQL Database using DBCC CHECKDB Command?

by Stellar Data Recovery

Discover step-by-step instructions to repair SQL databases with DBCC CHECKDB, plus explore advanced tools for a quick and secure repair.

The Lessons I Have Learned from My Database Mishaps

by Trần_Tuấn_Anh

A series of my experiences and mistakes in working with databases up until now.

Code Generator for SQL Server

by Homero Ibarra Ramírez

Tool on T-SQL to code basic generator for SQL Server

Escaping the IF..THEN Hell in C# with SQL

by David De Leeuw 2021

Refactoring a complicated procedural program, using SQL, Dapper, simple objects, lambda etc.

All Articles

SQL

Use Azure Functions to Process a CSV File and Import Data into Azure SQL

13 Feb 2020 by Jeremy Likness

Tutorial for file processing and importing to SQL leveraging serverless Azure Functions

Oracle-Style Global Temporary Tables for PostgreSQL

20 Mar 2017 by AlexeyYakovlev

A library to emulate Oracle-style permanent temporary tables in the PostgreSQL database

NLP-Samurai@0.0.10 Natural Language Processing Engine In Node.js, Angular 2 and MySQL

4 Apr 2020 by Arthur V. Ratz

Introducing NLP-Samurai@0.0.10 Natural Language Processing Engine.

RoomExistingSQLiteDBConverter

27 Oct 2019 by TheOldFogie

App to convert an exisiting non-Room database for Room

SPDiscover - Testing Large Systems Built on Stored Procedures Rolled into a Simple to Use Program

4 Sep 2020 by DotNetSteve

Testing large systems built on stored procedures can quickly become unyielding. Here are some thoughts on managing the complexity which have been rolled into a simple to use program

FFDB

27 Mar 2019 by rushfive

NFL Database Engine for PostgreSql and Mongo (easily works with other custom databases too)

EF Core 3.x Support for SQL Server's TRY_PARSE Function

28 Feb 2022 by Richard Deeming

EF Core methods to call SQL Server's TRY_PARSE function

Inno Setup Dependency Installer

7 Aug 2023 by DomGries

Download and install any dependency such as .NET, Visual C++ or SQL Server during your application's installation!