Database

The first article in this series was a quick introduction on how to load big chunks of data and then retrieve values using WebApi and LINQ. In this article, I will start from that project, extending it...

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...

This article describes ways to improve SQL query performance for very large data sets having million and billions of records in many tables. Introduction I have been working on one of...

Key Takeaways For object-oriented design we follow the SOLID principles. For microservice design we propose developers follow the “IDEALS”: interface segregation, deployability (is on you), event-driven, availability over consistency, loose-coupling, and single responsibility.Interface...

This article is the first article of a three-part MongoDB tutorial series. Introduction Welcome to the MongoDB Tutorial. This is the first part in the MongoDB article series.

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,...

In this article, we hope to provide resources that will help you hit the ground running on your path to learning about document databases and Couchbase. This article is a sponsored article. Articles such...

Mọi cơ sở dữ liệu (CSDL – database) đều được tạo ra theo cách không giống nhau, mỗi loại đều có ưu và nhược điểm riêng. Thực tế cho thấy những loại database như MySQL, MongoDB đôi...

If your application is experiencing load problems, time to bring out the champagne! Your web-app must be pretty successful to get to this stage. You’ve reached the capacity number of users that your application is able to...

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...