Performing minor and major version upgrades for AWS RDS SQL Server

This article will show how to performing a minor and major version upgrade for AWS RDS SQL Server. In this article, I use the SQL Server 2017 version 14.0.3281 as a source RDS SQL Server.

Manage MDF Files in SQL Server 2019

Manage MDF Files in SQL Server 2019. This article explained types of SQL Server database files (MDF, NDF and LOG files) and how to attach and detach the database using SSMS and T-SQL.

Key Differences between SQL Server 2019 for Windows and Linux

SQL Server 2019 (Windows vs Linux) and a Simple Test Scenario to Spot the Difference. Article shows the results of test scenario which was carried out to understand if SQL Server 2019 on Linux performs better than on Windows.

How to Install Ubuntu 18.04 and SQL Server 2019 on Linux

How to Install Ubuntu 18.04 and SQL Server 2019 on Linux. This article shows step-by-step instruction on how to install SQL Server 2019 on Linux and Ubuntu 18.04 and how configure Network in Ubuntu.

Install and Configure SQL Server 2019 on Windows Server 2016

In this article, you will find a step-by-step explanation of the installation process of SQL Server 2019 on Windows Server 2016. Learn how to Install and Configure SQL Server 2019 on Windows Server 2016.

Data Virtualization with MongoDB using PolyBase in SQL Server 2019

In this article, you’ll learn the approach to integrate MongoDB data source using data virtualization technique in SQL Server 2019. In this article, you can see how SQL Server 2019 provides a platform to create a modern enterprise data hub using data virtualization technology and the PolyBase technique.

T-SQL scripts to copy or remove files from a directory in SQL Server 2019

This article explores T-SQL scripts to copy or remove files from a directory in SQL Server 2019. SQL Server 2019 introduced many new stored procedures, functions, dynamic management views(DMV). In this article, we will explore the xp_cmdshell procedure along with the new functions in SQL Server 2019 to copy or remove the files.

Java Language Extensions in SQL Server 2019

Java Language Extensions in SQL Server 2019. This article discusses the SQL Server 2019 new feature—Java Language Extensions.

SQL Server 2019 Memory-Optimized TempDB Metadata

In this article, I will walk-through the SQL Server 2019 new feature memory-optimized tempdb metadata. The most commonly faced performance problems in SQL Server world is known to be tempdb resource contention. Do you agree?. Let us find the answer in the article.

Install SQL Server 2019 on Windows Server 2016 with SQL Server

In this article, we will discuss configuring SQL Server Always On Availability Groups and perform failover validations. You should go through the following articles and build the infrastructure before proceeding with this article.