Database development

Pivot Tables in MySQL

13:03 Database development, Tables • One Comment

Briefly about Pivot tables Pivoting data by means of tools (dbForge Studio for MySQL) Pivoting data...
Read More

Deploying Database from Source Control

06:55 Database development, Source control

These days, development teams start new projects from choosing a version control system. There are many benefits of source control systems...
Read More

Database Checkpoints in SQL Server

08:24 Database development, Statements

In this article, we will talk about SQL Server Checkpoints. To enhance performance, SQL Server applies modifications to database pages in...
Read More

SQL Server: DELETE vs TRUNCATE

07:05 Database development, Statements

T-SQL provides two keywords that allow you to delete data from a table. They are DELETE...
Read More

ROLLBACK TRUNCATE in SQL Server

07:00 Database development, Statements

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