A database is a collection of data or records. Database management systems are designed to manage databases. A database management system (DBMS) is a software system that uses a standard method to store and organize data. The...
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...
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...
Building APIs is one of the most important tasks for developers in modern engineering. These APIs allow different systems to communicate and exchange data. While REST has been the de facto standard for implementing APIs for many years, new...
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 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...
What is Cachalot DB?
An in-memory database for dotnet applications
All data is available in memory and distributed on multiple nodes, allowing for blazing-fast queries. Like Redis but with some...
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...
ASP.NET Core Using JWT Authentication WEB API and consume it in Angular2 Client Application with proper project structure setup.
Download source code
Introduction
I was trying to implement JWT Auth in web API. I want to consume the Web API in...
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...
