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