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...
Understanding SQL DELETE Column from Table
You can delete a column from the table in different ways. The most popular of them are:...
How to Create and Configure Microsoft Azure DevOps CI/CD Pipeline Agent
What is CI / CD Pipeline in Azure DevOps? In the process of learning Azure DevOps, you’ll face numerous challenges, but the most...
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 knowledge and tools. If you target 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...
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 demonstration purposes, I created a...
Backup and Restore MySQL Database Using mysqldump
The current article focuses on applying the mysqldump utility to backup and restore MySQL...
