Tools & technologies

A PowerShell Tool to Get the Status of SQL Agent Jobs

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

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

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

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

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

How to Download and Install SQL Server Express Edition?

Code Management, Tools & technologies

SQL Server is Microsoft’s premier database management system that we can use to develop relational databases. It also offers support for...
Read More

How to Rename a Table Name in SQL Server

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

Tools & technologies

This article will present the step-by-step installation process of the MySQL server on Ubuntu. For...
Read More

Backup and Restore MySQL Database Using mysqldump

Tools & technologies, Utilities & Extensions

The current article focuses on applying the mysqldump utility to backup and restore MySQL databases. This utility is the most common tool...
Read More

ODBC Driver for MySQL: How to Install and Set up Connection (Step-by-step)

Tools & technologies

This article focuses on the step-by-step processes of installing and configuring the ODBC driver for MySQL. In particular, it will cover...
Read More

Microsoft SQL Server Express Edition Limitations and Versions

Code Management, Tools & technologies

What is SQL Server Express? SQL Server Express Edition is a free edition of SQL Server. Microsoft...
Read More
Close