Author: {coding}Sight

A community platform for IT specialists

dbForge Edge: Your Best Universal Tool for Multidatabase Challenges

MySQL, Oracle, PostgreSQL, SQL Server, Tools & technologies

Handling several database management systems simultaneously is inevitable in working on multiple...
Read More

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

SQL JOINs Tutorial with Examples

Database development, Statements

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

Top-10 SQL Server Management Studio (SSMS) Add-ins You Should Use in 2021

Tools & technologies, Utilities & Extensions

If you deal with SQL infrastructure, especially Microsoft SQL Servers, you deal with SSMS. The SQL...
Read More

DevOps Solutions for Database Development Automation

Programming, SQL Server

What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating the development, deployment,...
Read More

Create Indexed Views in SQL Server

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

10 Best MySQL GUI Tools

MySQL, Tools & technologies, Utilities & Extensions

MySQL is among most widely-used and popular database technologies, so quite a lot of tools have...
Read More

How to Automate the Process of SQL Server Database Schema Synchronization

Automation, Database administation, PowerShell

The goal Keeping two databases in sync is a task we often encounter when working on SQL database development and maintenance. One...
Read More

Bulk Insert Data Files Into SQL Server

Database administation, Work with data

According to Wikipedia, the bulk insert is a process or method provided by a database management system to load multiple rows of data into...
Read More

Counting references to a record in a table via Foreign Keys

Constraints, Database development

I have recently needed to solve the task for my own purpose: to calculate the number of external...
Read More