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

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

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

Using .NET Core 8.x to create a WebAPI framework which saves each user's data in a personal copy of Sqlite database.

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

This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.

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

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.

This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access and breaches.. The post Securing data in SQL Server appeared first on Technology with Vivek Johari..

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