SQL JOINs Tutorial with Examples
In this article, we are going to takes a close look at SQL Server JOINs. We will review all...
What is MySQL ENUM? (Top 12 Key Facts You Need to Know)
MySQL ENUM is a string data type with a value chosen from a list of permitted values. You set these permitted values during table creation...
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...
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 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...
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 designing T-SQL code. In addition, we will have...
XML performance tips
Parsing data from XML using XQuery is a routine practice. In order to do this most effectively,...
