Understanding MySQL TRUNCATE TABLE by Practical Examples
MySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL...
SQL DROP TABLE Statement and Various Use Cases
The SQL DROP TABLE statement serves to drop the table from the database. It removes the table and its data and indexes associated with it....
Five Different Methods To Start, Stop, And Restart SQL Server Services
When we install the SQL Server, it also installs the following services: SQL Server database engine service to manage and access data in...
Install and Configure SQL Server 2019 on Windows Server 2016
SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5....
Manage MDF Files in SQL Server 2019
An SQL Server database contains primary data files, secondary data files (optional), and transaction log files. The primary and secondary...
Deploy SQL Server AlwaysOn Availability Groups on Linux
In the previous article, I explained how we could install Ubuntu 18.04 and SQL Server 2019 on the virtual machines. Now, before we proceed...
SQL Server Express Edition: Installation, Benefits, and Limitations
The SQL Server Express edition is a free version of SQL Server 2019. You can use it to deploy small...
How to Install Ubuntu 18.04 and SQL Server 2019 on Linux
The previous article explained the creation of a virtual machine using Oracle VM Virtual machine. Now, we will learn how to install Ubuntu...
Сreating a Virtual Machine With Oracle VM Virtual Box
Microsoft announced cross-platform support of SQL Server – the SQL Server 2017 and SQL Server 2019 work on Microsoft Windows and Linux....
Create, Deploy, and Execute the SSIS package using SQL Server Agent
This article explains how to create an SSIS package using SQL Server Data Tools, deploy it with the...
