In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples
What if 1 second of a transaction process is too long? You can tune your queries. But what if...
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 2017 release. The current article will...
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...
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 multiple Date tables. This article is...
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...
Understanding DROP TABLE IF EXISTS SQL Statement
The T SQL DROP TABLE IF EXISTS statement is used to drop existing database objects. In this article, we are going to study the various use...
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...
