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 »
Technologies
Estimating AWS RDS SQL Server costs
January 23, 2020This article explores estimating the AWS RDS SQL Server cost so that you can plan resources accordingly.
Read more »
Auditing in AWS RDS SQL Server
January 20, 2020This article explores the server and database audit in AWS RDS SQL Server.
Read more »
SQL Server Linux installation for Amazon EC2 instance with Red Hat OS
January 9, 2020This article installs SQL Server on Linux on the Amazon EC2 instance with Red Hat OS prepared in the earlier article.
Read more »
Installation of SQL Server Linux on Red Hat in Amazon EC2 instances
December 17, 2019This article explores the configuration of the Red hat Amazon EC2 instance for SQL Server installation.
Read more »
An overview of native differential backups in AWS RDS SQL Server
December 9, 2019This article explores the differential backups in AWS RDS SQL Server using recovery scenarios.
Read more »
Importing Data into SQL Server from MySQL using SSMS
November 29, 2019This 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 »
Using SSH keys to connect to a remote MySQL Server
November 28, 2019In 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 »
Query Amazon Athena external tables using SQL Server
November 15, 2019This article covers the following topics:
- Overview of the Amazon Athena
- Query CSV file stored in Amazon S3 bucket using SQL query
- Create SQL Server linked server for accessing external tables
Data Import from Amazon S3 SSIS bucket using an integration service (SSIS) package
October 28, 2019This article explores data import in SQL Server from a CSV file stored in the Amazon S3 SSIS bucket.
Read more »
How to Connect to a Remote MySQL Server Using SSH
October 18, 2019This 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 »
Multi-AZ Configuration for AWS RDS SQL Server
October 10, 2019Amazon 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 »
Enforce SSL connections in AWS RDS SQL Server
October 7, 2019This article explores a method to enforce SSL for all connections in AWS RDS SQL Server.
Read more »
How to create and configure a linked server to connect to MySQL in SQL Server Management Studio
October 7, 2019This 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 »
Encrypted Backup and Restore in AWS RDS SQL Server
October 4, 2019In 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 »
Recover Data in AWS RDS SQL Server
September 27, 2019This article explores the process to recover data in AWS RDS SQL Server and its recent enhancements.
Read more »
MySQL Query (T-SQL) Tutorial for SQL Server
September 25, 2019Microsoft 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 »
SQL Server Transactional Replication on Linux
September 12, 2019In this article, we will talk about how to send the SQL Server Transactional Replication on Linux Environment.
Read more »
Creating your own SQL Server docker image
September 9, 2019In 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 »
Understanding Graph Databases in SQL Server
August 16, 2019A 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 »
SQL Server Merge Replication on Linux
August 15, 2019Replication 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 »
SQL Server Installation & Troubleshooting on Ubuntu
August 15, 2019A 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 »
Transparent Data Encryption (TDE) in AWS RDS SQL Server
July 23, 2019In 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 »
Overview of Service Principal Name and Kerberos authentication in SQL Server
July 18, 2019This 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 »
Azure Kubernetes Service (AKS) – Managing SQL Server database files
June 18, 2019In this article, we will review on managing database files of SQL Server running on Azure Kubernetes service.