Database design

Nisarg Upadhyay
Control flow designer

Copy SQL Databases between Windows 10 and CentOS using SQL Server data tools

October 19, 2022 by

In this article, we are going to learn how to copy the SQL database created on different instances of the SQL Server. This article is the fourth article on Manage SQL Server on CentOS topic. In my previous article, Copy SQL Databases between Windows 10 and CentOS using the SQL Server import-export wizard, we learned how to copy data SQL database between windows 10 and CentOS Linux using the wizard.

Read more »
Nisarg Upadhyay
Connect to Server

Manage SQL Databases in CentOS: Manage filegroups of user databases

October 5, 2022 by

This article explains how to manage a data file and filegroups in an SQL database created on CentOS Linux. In my previous article, Manage filegroups of SQL Databases, we learned about the different types of filegroup and data files in SQL Server 2019 on windows and how to manage them using T-SQL queries. In this article, we will learn how to manage the filegroups in SQL Server 2019 on CentOS. I am going to cover the following topics in the article:

Read more »
Nisarg Upadhyay
Save SSIS Package

Copy SQL Databases between Windows 10 and CentOS using the SQL Server import-export wizard

September 21, 2022 by

In this article, we will learn how we can backup and restore the SQL Database in CentOS. This article is the third article on the topic Manage SQL Server on CentOS. In my previous article, we learned how to copy data SQL database between windows 10 and CentOS Linux using SQL Server management studio.

Read more »
Nisarg Upadhyay
View memory optimized data

Managing memory-optimized file groups of SQL Database

August 17, 2022 by

This article explains how to manage a memory-optimized filegroup of SQL Database. The memory-optimized filegroup contains the memory-optimized tables and table variables. I have written two articles that explain how we can migrate the disk-based tables to memory-optimized tables. Now, we will learn how to add memory-optimized filegroups in a SQL database. I will cover the following topics in the article.

Read more »