RDBMS

There are projects you never forget. For me, it was the night (actually, many nights) we moved over a billion recordsfrom our old database to a new one… without a single second...

How to keep your database bills low while making your queries fly like a sports car Hey there, fellow data wrangler! If you’re here, you’re probably scratching your head over...

Forget the endless list of SQL questions — these 6 advanced queries are the ones interviewers actually care about When it comes to developer interviews, SQL always shows up like...

Dưới đây là các ý chính từ bài viết “Artem Khrenov – Database Schema Design: Principles Every Developer Must Know”. 1. Lý do schema thiết kế tốt rất quan trọng

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published...

Dapper is a micro-ORM or a Data Mapper. It internally uses ADO.NET. Additionally, Dapper maps the ADO.NET data structures to your custom POCO classes. As this is additional work Dapper does, in theory,...

Dapper is a lightweight ORM (Object-Relational Mapping) framework for .NET Core and is commonly used to query databases in .NET Core applications. Here are some of the advanced features of Dapper in .NET Core:

A database is like a joke — if you have to explain it, it’s probably not designed well… Picture this: It’s 3AM on a Saturday morning, and I’m sitting at my desk, three hours...

This article assesses the design approach of my free index maintenance tool for SQL Server and Azure: SQL Index Manager. The article analyzes the approach of the RedGate SQL Index Manager (v1.1.9.1378) and DevArt - dbForge Index...