A PowerShell Tool to Get the Status of SQL Agent Jobs
From a certain point in my career, I started to play around with PowerShell. But I never imagined...
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...
What is SQL Server Express? Definition, Benefits and Capabilities
SQL Server Express is a free lightweight edition of SQL Server with limited functionality, available for all versions starting from SQL...
SQL Server Business Intelligence (BI) – Traditional Tools and Technologies
If Business Intelligence (BI) is in your focus, you need two things to be a success. They are the...
How to Download and Install SQL Server Express Edition?
SQL Server is Microsoft’s premier database management system that we can use to develop relational databases. It also offers support for...
How to Rename a Table Name in SQL Server
One of the most critical database administrator’s duties is managing database objects. For instance, the application logic changes,...
How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways
This article will present the step-by-step installation process of the MySQL server on Ubuntu. For...
Backup and Restore MySQL Database Using mysqldump
The current article focuses on applying the mysqldump utility to backup and restore MySQL databases. This utility is the most common tool...
ODBC Driver for MySQL: How to Install and Set up Connection (Step-by-step)
This article focuses on the step-by-step processes of installing and configuring the ODBC driver for MySQL. In particular, it will cover...
Microsoft SQL Server Express Edition Limitations and Versions
What is SQL Server Express? SQL Server Express Edition is a free edition of SQL Server. Microsoft...