Basics of SQL Server ALTER TABLE Statement
This article focuses on the ALTER TABLE statement in SQL Server and the following tasks on SQL...
SQL Reference Table: How to Create and Write Basic Queries
This article will focus on writing SQL queries against the database reference table with a fairly simple structure to understand and...
An Overview of the PRINT Statement in SQL Server
The SQL PRINT statement serves to display the user-defined message. For example, you are developing a script with T-SQL Loops, and you want...
How to Easily Get Data from Web Source Using Power BI Rest API Calls
Microsoft Power BI is a data visualization and analytics tool which lets you create powerful...
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,...
SQL Basic Commands: How to Write Simple Queries with Examples
This article explains writing simple SQL queries from the most basic ones and gradually improving the script to solve some mathematical and...
Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function
Today’s code editors and word processors come with a search and replace feature. It is...
Power BI REST API No Code Options for Easy Data and Reports Download
Microsoft’s Power BI REST API no-code option is extremely helpful as it allows calling Power BI REST API without writing a single...
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...