dbForge Edge: Your Best Universal Tool for Multidatabase Challenges
Handling several database management systems simultaneously is inevitable in working on multiple...
Introduction to ABP Framework – a Complete Web Platform for Software Development
ABP Framework is a complete infrastructure that helps developers build modern web applications according to the best practices of software...
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...
DevOps Solutions for Database Development Automation
What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating the development, deployment,...
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...
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 development and maintenance. One...
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...