Introduction to ABP Framework – a Complete Web Platform for Software Development
ABP Framework is a complete infrastructure that helps developers build modern web applications...
SQL JOINs Tutorial with Examples
In this article, we are going to takes a close look at SQL Server JOINs. We will review all supported SQL Server JOIN types with syntax,...
Top-10 SQL Server Management Studio (SSMS) Add-ins You Should Use in 2021
If you deal with SQL infrastructure, especially Microsoft SQL Servers, you deal with SSMS. The SQL Server Management Studio is the default...
DevOps Solutions for Database Development Automation
What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating...
Create Indexed Views in SQL Server
Introduction You would have already heard about views in databases. We create views for a number of reasons. One of the main reasons for...
10 Best MySQL GUI Tools
MySQL is among most widely-used and popular database technologies, so quite a lot of tools have been created in order to make the processes...
How to Automate the Process of SQL Server Database Schema Synchronization
The goal Keeping two databases in sync is a task we often encounter when working on SQL database...
Bulk Insert Data Files Into SQL Server
According to Wikipedia, the bulk insert is a process or method provided by a database management system to load multiple rows of data into...
Counting references to a record in a table via Foreign Keys
I have recently needed to solve the task for my own purpose: to calculate the number of external records linked by a foreign key for each...
SQL Server: Useful Tips for Newbies
In this article, we will discuss typical errors that newbie developers may face with while...