Pivot Tables in MySQL
Briefly about Pivot tables Pivoting data by means of tools (dbForge Studio for MySQL) Pivoting data...
Deploying Database from Source Control
These days, development teams start new projects from choosing a version control system. There are many benefits of source control systems...
Database Checkpoints in SQL Server
In this article, we will talk about SQL Server Checkpoints. To enhance performance, SQL Server applies modifications to database pages in...
SQL Server: DELETE vs TRUNCATE
T-SQL provides two keywords that allow you to delete data from a table. They are DELETE...
ROLLBACK TRUNCATE in SQL Server
Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all data loss. The worst thing is that you...
