Tools & technologies

A PowerShell Tool to Get the Status of SQL Agent Jobs

09:48 Languages & Coding, PowerShell, Tools & technologies

From a certain point in my career, I started to play around with PowerShell. But I never imagined...
Read More

Top-10 SQL Server Management Studio (SSMS) Add-ins You Should Use in 2021

13:28 Tools & technologies, Utilities & Extensions

If you deal with SQL infrastructure, especially Microsoft SQL Servers, you deal with SSMS. The SQL Server Management Studio is the default...
Read More

What is SQL Server Express? Definition, Benefits and Capabilities

09:55 Code Management, Tools & technologies

SQL Server Express is a free lightweight edition of SQL Server with limited functionality, available for all versions starting from SQL...
Read More

Understanding SQL DELETE Column from Table

14:28 Database development, SSMS, Statements, Tools & technologies

You can delete a column from the table in different ways. The most popular of them are:...
Read More

How to Create and Configure Microsoft Azure DevOps CI/CD Pipeline Agent

13:26 Azure, Cloud, Tools & technologies

What is CI / CD Pipeline in Azure DevOps? In the process of learning Azure DevOps, you’ll face numerous challenges, but the most...
Read More

SQL Server Business Intelligence (BI) – Traditional Tools and Technologies

12:15 Business intelligence, Power BI, Tools & 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...
Read More

How to Download and Install SQL Server Express Edition?

13:25 Code Management, Tools & technologies

SQL Server is Microsoft’s premier database management system that we can use to develop...
Read More

How to Rename a Table Name in SQL Server

10:56 Database development, SSMS, Stored Procedures, Tables

One of the most critical database administrator’s duties is managing database objects. For instance, the application logic changes,...
Read More

How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways

10:48 Tools & technologies

This article will present the step-by-step installation process of the MySQL server on Ubuntu. For demonstration purposes, I created a...
Read More

Backup and Restore MySQL Database Using mysqldump

16:38 Tools & technologies, Utilities & Extensions

The current article focuses on applying the mysqldump utility to backup and restore MySQL...
Read More