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

Improve EF Core 6\7 "Contains" Performance with OpenJson (SQL Server) - NuGet Package

by Bert O Neill

How Entity Framework Core 6 or 7 projects can take advantage of EF Core 8's OpenJson without having to migrate to EF Core 8 - using a custom NuGet Package for SQL Server

Small function to replace characters with SQL Server

by Wendelius

A small function utilizing CTE to replace undesired characters from a string

Simplifying Dynamic SQL Queries with Dapper

by Mishael Ogo

A look at a simple SQL builder for Dapper

Reorganize and Rebuild Indexes and Update Statistics

by GabrieleTronchin

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

All Articles

top

SQL

Inserting XML Schema in to SQL Server Db.

31 May 2016 by KK Kod

Problem and Solution

XML

SQL