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

Simplifying Dynamic SQL Queries with Dapper

by Mishael Ogo

A look at a simple SQL builder for Dapper

.NET 8 — Transactional Outbox Pattern With EF Core

by GabrieleTronchin

In this project, I've implemented the Transactional Outbox Pattern using EF Core.

Reorganize and Rebuild Indexes and Update Statistics

by GabrieleTronchin

A simple stored procedure to add at your database to keep it reactive

Automatic Missing Indexes Creation Statements

by GabrieleTronchin

Automatic creation of non clustered indexes using system SQL entities

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

.NET 8 — Transactional Outbox Pattern With EF Core

U 16 Apr 2024 by GabrieleTronchin

In this project, I've implemented the Transactional Outbox Pattern using EF Core.

entity-framework

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!