Installing Ubuntu 18.04 for SQL Server 2019 on Virtual Machine Using VMware Workstation
Microsoft has been supporting SQL Server for Linux-based operating systems since the SQL Server...
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 of SQL Server UPPER Function
There are many cases of SQL lowercase that we need to change for our purposes. For instance, we have keywords or strings of characters in...
Power BI: How to Create Date Tables Using Dax Format Functions
To utilize the time intelligence built-in features and functions in Power BI reports, you can use...
Understanding SQL DELETE Column from Table
Adding and removing columns are among the most common tasks when you manage tables in databases. And it might seem strange, but many users...
How to Use Array Functionality in SQL Server
Have you ever been asked how to create array in SQL Server? Or, you might be asked how to how to store values in an array in SQL Server....
Understanding DROP TABLE IF EXISTS SQL Statement
The T SQL DROP TABLE IF EXISTS statement is used to drop existing database objects. In this...
SQL AVG Function: A Complete Guide
In mathematics, the Average value represents the middle value that we calculate by dividing the sum of all values by the number of values....
Transparent Data Encryption (TDE) in SQL Server in an AlwaysOn Availability Group on Example
Availability Groups are fantastic for High Availability/Disaster Recovery solutions, and I’m sure that fellow DBAs will agree with me....
Creation of Pandas DataFrame in Python with Examples
Python is a general-purpose language that can work with various types of data structures and solve...
