How To
How to Rename a SQL Server Database
When working with SQL databases for quite a long period of time, you might come across a situation when you need to give your...
Working with Integration Tests in ASP.NET 6 Core
Testing is an integral element of the development process for every application. There are many types of tests such as unit tests, integration tests,...
MySQL ORDER BY Clause: Syntax and 13 Examples
In MySQL, the ORDER BY clause is used to sort the records fetched by the SELECT statement, in ascending or descending order. And while...
How to Use pgFormatter: Features and Alternatives
Formatting makes SQL code accurate, readable, understandable, and standardized for teams and individuals. SQL formatter is a tool that beautifies code automatically. Formatting tools...
How to Automatically Commit SQL Server Database Schema Changes to the GIT Repository
Want to make git 'commit' automatically run every time a database schema is updated? Read more to find out how you can do this...
PostgreSQL Foreign Key
To create relationships between tables and enforce referential integrity in PostgreSQL, the FOREIGN KEY constraint is your best approach. This key ensures that data...
Data and Schema Comparison Log Delivery to Email
In this article, we will demonstrate to you how to set up automatic email delivery of the log file in both cases: when SQL...
MySQL Variables – Definition and Examples
MySQL variables store data, label data, and let developers create more accurate and efficient code by turning long and complicated strings of characters into...
Working with Windows Management Instrumentation (WMI) Technology in C#
In this article, we will talk about Windows Management Instrumentation (WMI) technology. Also, we will discuss how to work with it in C# and...
How to Script Tables with Parent Objects in dbForge Studio for SQL Server
Occasionally, database developers encounter the necessity to conduct both forward and reverse engineering on their databases and specific database objects, which may involve object...
