An informal study of the Sqlite database and how many concurrent inserts it can handle. Will help you decide if you want to use Sqlite in your projects.

SQL

.NET

data

DbSharpApplication (DAL Generator Tool on .NET6, and released new version on .NET8)

17 Feb 2024 by Higty

A DAL generator that generates StoredProcedure client class and creates Table and Record classes

Writing a Lexical Analyzer for SQL in C#

11 Jan 2024 by Nicolas DESCARTES

How to write a lexical analyzer for SQL?

SQL

DBA

lexical

POCO Generator

7 Jan 2024 by yuvalsol

POCO generating application for SQL Server

Modeling Data in CosmosDB: Transitioning Away from the SQL Paradigm

11 Dec 2023 by Nicolas DESCARTES

How to model data in Azure CosmosDB with an SQL background?

SQL

Azure

SQL Server: Unexpected Behavior of the LIKE Operator When Used with the ISNULL Function

6 Dec 2023 by scastelli

SQL resolves special character challenges, streamlining NULL parameter handling

SQL

SQL-Server

spSearchTables: Search and Find Tables or Columns by Name or Value

21 Nov 2023 by Federico Di Marco

spSearchTables: a helper T-SQL stored procedure for digging into (large) databases

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

SQL

DBA

database

Understanding Service Principal Names for SQL Server Integrated Security

15 May 2023 by Bruno van Dooren

Basics of Service Principal names, and what they mean for SQL Server security

Migrating a SQL Database with CLR Integration from Old SQL Server Versions

4 May 2023 by Bruno van Dooren

Ways to deal with changed security for CLR code in SQL databases

Controlling Service Startup Order in Docker Compose

20 Mar 2023 by Bogdan Marian

Ensure your Docker Compose services start in the correct order

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

Full Tutorial on using Always Encrypted with Azure Key Vault in ASP.NET and ASP.NET Core

21 Feb 2023 by Gelu Vac

How to use Always Encrypted using MSSQL Encrypt Columns feature with encryption keys stored in Azure Key Vault

Automatic Compilation and Distribution of Reports and Analyses

3 Feb 2023 by JBartlau

This article demonstrates how Report Server offers a distribution of reports that save time, increase efficiency, and reduce potential errors.

Binding Several Data Sources to One Reporting Tool

1 Feb 2023 by JBartlau

This article sheds light on why it is useful to combine different data sources in a report.

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

Dapper - The Pocket Rocket Mapper

3 Jan 2023 by George Swan

An introduction to employing Dapper in an ASP.NET 7 application

SQL-File Technology for Transact-SQL

19 Dec 2022 by Sergei Y.Kitáev

Introduction to statically parameterized SQL language

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

14 Dec 2022 by Ravi K. Acharya

Third and final part of the step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus

EF Core Contexts Sharing Transaction

26 Nov 2022 by Rudi Breedenraedt

How to share a transaction across multiple Entity Framework contexts

SQL

entity-framework

Pitfalls of the SQL Server Service Broker

16 Oct 2022 by Herman<T>.Instance

It should reflect the event

SQL

.NET

DBA

Different Ways to Maintain Audit Information for DML in SQL

8 Aug 2022 by Avinash A. Dhumal

Implement an audit mechanism for your DML objects

SQL

Windows

Conditional filtering in SQLAlchemy and Python

3 Jul 2022 by DiponRoy

Conditional filter query example in SQLAlchemy and Python

Merge Data in Database

28 Jun 2022 by DiponRoy

How to use MERGE statements in different databases

Lightweight Implementation of Autocomplete

4 Mar 2022 by gggustafson

Autocomplete, or word completion, is a feature in which an application predicts the rest of a word a user is typing. This article describes a lightweight implementation.

Top 10 Benefits of .NET Reporting Tools

28 Feb 2022 by MESCIUS

In this article, we’ll identify the top 10 benefits of using reporting tools for your development projects.

Streaming at Scale with Azure Event Hubs, Streaming Analytics, and Azure SQL Part 1: Getting Streaming Data into Azure

22 Feb 2022 by Sander Rossel

How to write a Python app to ingest weather data into Azure using an Azure Event Hub

How to Write Code to Solve a Problem, A Beginner's Guide Part 2: Syntax Errors

14 Feb 2022 by OriginalGriff

By the time you have read this, you will have no problem with compiling your programs ever again. Well, probably you won't. OK - maybe a little. Depends on the compiler.

SQL

C++

Why HTML5? Why Not? UI / UX Versus Storage Challenge (Part 3 of N)

7 Jan 2022 by raddevus

Includes complete C# Web API which allows you to post your app data using simple method

Sharded Multi-Tenant Database using SQL Server Row-Level Security

24 Nov 2021 by Rick Drizin

An overview of how to design a scalable Multi-Tenant Database using Row-Level Security Predicate Functions and DDL triggers to enforce that all shared tables are always restricted according to the tenant.

SQL

SQL-Server

Audit Tables and Data Versioning on SQL Server

23 Nov 2021 by Rick Drizin

Simple structure for keeping SQL Server Auditing Tables and Versioned Records in the same set of tables, using Audit Triggers and Entity Framework

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!

Why I Targeted T-SQL: A Confession

11 Nov 2021 by honey the codewitch

Silly SQL Tricks, Mistakes and Other Nonsense

SQL

parsing

regular-expression

NoSQL or not NoSQL?

9 Nov 2021 by Daniele Fontani

That is the question. A comparison between these two technologies and some tips to choose the best that suits your needs.

SQL Index Manager – Free GUI Tool for Index Maintenance on SQL Server and Azure

7 Nov 2021 by Sergii Syrovatchenko

Open source index maintenance tool for SQL Server and Azure

Insight.Database - .NET Micro ORM, Part 1 - Write Less Code in Data Access layer using Auto Interface Implementation

6 Nov 2021 by keerthi raja

An overview of Insight.Database, micro-orm for .NET

Install and Configure SQL Server Reporting Services (SSRS)

30 Oct 2021 by Hardik.Sheth1717

How to install and configure SSRS

SQL

SSRS

reporting-services

Step by Step Installation of Microsoft SQL Server on Windows System

26 Oct 2021 by Hardik.Sheth1717

How to install Microsoft SQL Server on a Windows system

SQL

SQL-Server

MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET

24 Sep 2021 by adriancs

A tool to export and import MySQL database in .NET

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

ASP.NET Core Microservices With Angular 11 Front End

3 Aug 2021 by Yaseer Mumtaz

ASP.NET Core Microservices With Angular 11 Front End, API Gateway, Redis and SQL Server

SQL Server JSON: Performance Cookbook

25 Jul 2021 by Sergii Syrovatchenko

Here's everything you need to know about high-performance JSON parsing for SQL Server

Fast Typo-Insensitive String Matching in a Program and a Database

12 Jul 2021 by David Wincelberg

Strings that differ by typos can be matched.

5 Jul 2021 by gggustafson

This article provides the code necessary to implement a website login mechanism without using third-party software.

SQL

Javascript

PHP

Documenting MS SQL Server Databases

27 Jun 2021 by Evgeniy Gribkov

The examples of SQL Server database documentation using both the extended properties and a third-party utility.

SQL

database

Top 20 exciting features of SQL Server 2012 – Part 2

24 Jun 2021 by Shivprasad koirala

In this article we will talk about the next 5 interesting SQL Server 2012 features.

Vector: A Concept-Driven Approach to SQL UDT

26 May 2021 by Giovanni Bejarasco

A walkthrough in UDT programming with primary focus on database concepts

Brief Introduction of a Continuous SQL-stream Sending and Processing System (Part 2: MySQL)

4 Apr 2021 by Yuancai (Charlie) Ye

Continuous SQL-stream Sending and Processing System

The Oracle Call Interface (OCI) and ODP.Net - Part 1

23 Mar 2021 by Espen Harlinn

Proven techniques for fast Oracle Database access using .NET 5.0 and native C++

Mongo DB Tutorial and Mapping of SQL and Mongo DB Query

18 Mar 2021 by VijayRana

A tutorial for MongoDB Tutorial

SQL Server Express Edition on Steroids

13 Mar 2021 by Sergii Syrovatchenko

How to omit many restrictions on SQL Server Express Edition

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

A Model to Represent Directed Acyclic Graphs (DAG) on SQL Databases

26 Jan 2021 by Kemal Erdogan

Addressing the general problem of representing directed acyclic graphs (DAGs) in SQL databases

Transform Clipboard Contents Between Copy and Paste

2 Jan 2021 by Brad Joss

Alter your clipboard contents before pasting to automate tasks

Brief Introduction of a Continuous SQL-stream Sending and Processing System (Part 1: SQLite)

1 Jan 2021 by Yuancai (Charlie) Ye

Application of SocketPro onto various databases for continuous inline request/result batching and real-time stream processing with bi-directional asynchronous data transferring

Using the PetaPoco ORM to Manage SQLServer, SQLIte, MySQL and ProgreSQL Databases

10 Dec 2020 by Leif Simon Goodwin

Simple WPF app that shows how to use PetaPoco library to manage an SQL database

ASP.NET Core Blazor and EF Core Raw SQL Queries for Stored Procedure

14 Oct 2020 by syed shanu

Creating an SP to search and bind Customer details in Blazor application

SQL

D.O.T.S. - Distributed Obfuscated Transmission of Status

7 Oct 2020 by Henry Sheldon

A study in communication across multiple technologies using Azure cloud services, all based on a centralized informational domain

Dynamic Query Builder for Dapper

7 Aug 2020 by Rick Drizin

Dapper Query Builder using String Interpolation and Fluent API

SQL

entity-framework

dapper

Export All Tables from Microsoft SQL Server Database in Flat File format (csv, txt) at one Go !!

14 Jul 2020 by Mubin M. Shaikh

Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format

SQL Query Performance Improvement in SQL Server

4 Jul 2020 by Mahesh Pratap Singh

SQL Query performance improvement in SQL Server for large data

Duplicate songs detector via audio fingerprinting

23 Jun 2020 by Ciumac Sergiu

Explains sound fingerprinting algorithm, with a practical example of detecting duplicate files on the user's local drive.

How to Manipulate Hierarchical Information in Flat Relational Database Tables

21 May 2020 by Akshay Srinivasan2

This article describes a technique to quickly retrieve and present hierarchical information from a flat relational database table with only one table scan.

AZURE Data Factory – Copy with Stored Procedure Data from One Database to Another on AZURE SQL

4 Apr 2020 by Venkatesh Subbarao

How to copy tables with Stored procedure data from one database to another in AZURE SQL.

SQL

Azure

DayPilot - AJAX Monthly Event Calendar for ASP.NET MVC in 10 Minutes

11 Mar 2020 by Dan Letecky

Create an AJAX monthly event calendar (with drag and drop support) displaying data from SQL Server database in just 10 minutes (including a coffee break).

Master Chef (Part 1) ASP.NET Core MVC with Fluent NHibernate and AngularJS

6 Feb 2020 by Fred Song (Melbourne)

In this article, I want to show how to build a Single Page Application – MasterChef with ASP.NET Core MVC, Fluent Hibernate, and Angular JS.

SQL 2019 - New Features

13 Jan 2020 by koolprasad2003

New features of SQL 2019

SQL

SQL-Server-2019

database

A Note on Hibernate - Many to Many

3 Jan 2020 by Dr. Song Li

This is a note on Hibernate many to many mappings.

SQL

Java

Dev

Automating the SQL Database Mirroring Setup

30 Dec 2019 by Dathuraj Pasarge

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

SQL Server Performance Issue After An Upgrade

9 Dec 2019 by Kanishka Basak

Analysis and troubleshooting a database performance bottleneck

Data Science - Journey through Life Cycles. Part 1

26 Nov 2019 by @Abdul Azeez Thekkekandy

This article explores Data Science lifecycles - Business Understanding, Data Understanding and Data Preparation

8 Nov 2019 by Sanwar ranwa

How to login with Facebook and Google using Angular 8

Analyzing 200 years of climate data using SAP HANA and Amazon SageMaker

4 Nov 2019 by Allister Beharry

Using data from the Global Historical Climatology Network project we can crunch, analyze, and make predictions using gigabytes of numeric climate data collected over two centuries with the SAP HANA in-memory database and Amazon SageMaker hosted Jupyter notebooks.

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

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.

SQL Server Database :: Continuous Integration using Github and TeamCity

20 Oct 2019 by Ravi K. Acharya

Second part of the step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus

Speed Up ASP.NET Core WEB API Application. Part 2

2 Oct 2019 by Eduard Silantiev

Using various approaches to increase ASP.NET Core WEB API application's productivity

Speed Up ASP.NET Core WEB API Application: Part 1

2 Oct 2019 by Eduard Silantiev

Create a test RESTful WEB API service using ASP.NET Core 2.1

Integrate SAP-HANA EML Library And TensorFlow Model Server (TMS) to Predict S&P 500 Index: Part 3: Predict S&P 500 Index Using EML Library

29 Sep 2019 by Arthur V. Ratz

How to predict S&P 500 Index on the SAP-HANA SQL-engine backend using EML library

artificial-intelligence

Design

Architect

Migrating Your SQL Server Workloads to PostgreSQL – Part 1

22 Sep 2019 by Shameel

Part 1 of this multi-part article series discusses Open Source considerations, history of SQL Server and PostgreSQL, choosing the right PostgreSQL version for your needs and On-Premise vs Cloud comparison

Database for financial accounting application IV: General Purpose Documents & Fixed assets

18 Sep 2019 by Niemand25