Install Azure CLI 2.0 on Microsoft Windows
Azure CLI is a Microsoft cross-platform tool that allows users to remotely access Azure services...
Understanding SQL Server ALTER TABLE ADD COLUMN Statement
This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this statement is to add a new column to an existing...
Using INNER JOIN to Combine SQL Server Tables and Display Them in ASP.NET Webforms
This article describes the ways of using an INNER JOIN to combine results from two tables in the SQL Server database and display them in an...
Understanding MySQL TRUNCATE TABLE by Practical Examples
MySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL...
SQL DROP TABLE Statement and Various Use Cases
The SQL DROP TABLE statement serves to drop the table from the database. It removes the table and its data and indexes associated with it....
How to Parse Strings Like a Pro Using SQL SUBSTRING() Function?
Do you enjoy parsing strings? If so, one of the indispensable string functions to use is SQL SUBSTRING. It is one of those skills a...
Fundamentals of Managing Datafiles in SQL Server
Introduction Datafiles are physical objects that constitute the most important part of the database...
Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables
INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML operations based on comparing two tables or...
Five Different Methods To Start, Stop, And Restart SQL Server Services
When we install the SQL Server, it also installs the following services: SQL Server database engine service to manage and access data in...
Install and Configure SQL Server 2019 on Windows Server 2016
SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5....
