Author: {coding}Sight

A community platform for IT specialists

Introduction to ABP Framework – a Complete Web Platform for Software Development

Uncategorized

ABP Framework is a complete infrastructure that helps developers build modern web applications...
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 Server Management Studio is the default...
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...
Read More

10 Best MySQL GUI Tools

Tools & technologies, Utilities & Extensions

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...
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...
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 records linked by a foreign key for each...
Read More

SQL Server: Useful Tips for Newbies

Database development

In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
Read More

XML performance tips

Database administation, Perfomance Tuning

Parsing data from XML using XQuery is a routine practice. In order to do this most effectively,...
Read More
Close