In this article, I am going to explain the step by step installation process of MySQL database server 8.0.19. MySQL is open-source, cross-platform relational database management server developed by Swedish company “MySQL AB” and later acquired by Oracle corporation. MySQL is offered as an open-source MySQL community server edition and enterprise server edition. In this article, I am going to install the MySQL Community server edition.
Read more »
In this article, it will be shown how to install MySQL 5.7 and 8.0.19 versions on an Ubuntu 18.04 machine.
Read more »
This article explores estimating the AWS RDS SQL Server cost so that you can plan resources accordingly.
Read more »
This article explores the server and database audit in AWS RDS SQL Server.
Read more »
This article installs SQL Server on Linux on the Amazon EC2 instance with Red Hat OS prepared in the earlier article.
Read more »
This article explores the configuration of the Red hat Amazon EC2 instance for SQL Server installation.
Read more »
This article explores the differential backups in AWS RDS SQL Server using recovery scenarios.
Read more »
This article shows the best way to import a copy of your MySQL database table to SQL Server using the SQL Server import data feature. We’ll demonstrate how to perform data import and export using a query with the assistance of SQL Server Management Studio.
Read more »
In this article, it will be described how to connect to remote MySQL Server on Linux OS using SSH key pairs. Windows OS will be used as a host from which will be established a connection using PuTTY as a client. Besides using PuTTY as a client for establishing the connection to remote machines, it will be used to generate and use secure shell – SSH keys as well.
Read more »
This article covers the following topics:
This article explores data import in SQL Server from a CSV file stored in the Amazon S3 SSIS bucket.
Read more »
This article will explain how to set up a connection from a Windows host OS using a PuTTY client to a remote MySQL server on Linux Ubuntu 18.04.
Read more »
Amazon provides AWS RDS SQL Server as a managed relational database service. You can deploy databases instantly without worrying about underlying hardware platform, license cost, managing data centers. AWS RDS database instances are highly available. It provides a failover mechanism using the Mult-AZ deployments.
Read more »
This article explores a method to enforce SSL for all connections in AWS RDS SQL Server.
Read more »
This article will guide you with all the necessary steps to successfully create a linked server in SSMS to connect to the MySQL database.
Read more »
In the article, Recover Data in AWS RDS SQL Server, we explored the process of native backup and restoration for the AWS RDS SQL Server database. It involves the following steps:
Read more »
This article explores the process to recover data in AWS RDS SQL Server and its recent enhancements.
Read more »
Microsoft SQL Server and MySQL, both are quite well-established database engines. In our role as a DBA, at some given time point we require T-SQL straddling between both database engines unites Select, Insert, Update, Delete and some other…
Read more »
In this article, we will talk about how to send the SQL Server Transactional Replication on Linux Environment.
Read more »
In this article, we will review how to create custom SQL Server docker images and run the containers from the custom images, upload the custom images to the docker hub.
Read more »
A graph database is a type of NoSQL database that is based on graph theory. Graph databases are ideal for storing data that has complex many to many relationships. In this article, we will study the very basics of graph databases with the help of a simple example.
Read more »
Replication is a process to manage multiple copies of the same data at a different node. Microsoft SQL Server supports Merge Replication, Transaction Replication, Peer to Peer Replication and Snapshot Replication.
Read more »
A couple of years ago, Microsoft announced that SQL Server would be available on Open Source (Linux). In this article, we will go through the installation of Microsoft SQL Server on Linux (Ubuntu) and each step in detail.
Read more »
In this article, we will review Transparent Data Encryption (TDE) in AWS RDS SQL Server. AWS RDS supports TDE on SQL Server Enterprise edition of 2012,2014,2016 and 2017 editions.
Read more »
This article gives an overview of Service Principal Name (SPN) for using the Kerberos authentication in SQL Server connections. We use the Kerberos authentication to authenticate windows users securely for providing access to SQL Server.
Read more »© 2020 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy
