In SQL Server, Change Data Capture (CDC) is a powerful feature that tracks changes (inserts, updates, and deletes) made to. The post Understanding CDC in SQL Server appeared first on Technology with Vivek Johari..

Added enhancements to Sqlstone framework

Visual Studio extension that auto-generates SQL Server ER diagrams based on a single table

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

NET8/EF8 Breaking Change. Old servers/databases might not understand queries from EF8.

SQL Injection (SQLi) is a serious security vulnerability that allows attackers to execute arbitrary SQL code on a database. This can lead to unauthorized access, data breaches, and even complete system compromise.

This application lets you copy tables from folder with CSV files to SQL Server

This article explains how and where browsing history is stored and how to fetch it.

Query Excel or CSV files with T-SQL without importing them in a table first

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.