Technologies

Auditing in AWS RDS SQL Server

January 20, 2020 by Rajendra Gupta

This article explores the server and database audit in AWS RDS SQL Server.

SQL Server Linux installation for Amazon EC2 instance with Red Hat OS

January 9, 2020 by Rajendra Gupta

This article installs SQL Server on Linux on the Amazon EC2 instance with Red Hat OS prepared in the earlier article.

Installation of SQL Server Linux on Red Hat in Amazon EC2 instances

December 17, 2019 by Rajendra Gupta

This article explores the configuration of the Red hat Amazon EC2 instance for SQL Server installation.

An overview of native differential backups in AWS RDS SQL Server

December 9, 2019 by Rajendra Gupta

This article explores the differential backups in AWS RDS SQL Server using recovery scenarios.

Importing Data into SQL Server from MySQL using SSMS

November 29, 2019 by Jignesh Raiyani

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.

Using SSH keys to connect to a remote MySQL Server

November 28, 2019 by Marko Zivkovic

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.

Query Amazon Athena external tables using SQL Server

November 15, 2019 by Rajendra Gupta

This 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, 2019 by Rajendra Gupta

This article explores data import in SQL Server from a CSV file stored in the Amazon S3 SSIS bucket.

How to Connect to a Remote MySQL Server Using SSH

October 18, 2019 by Marko Zivkovic

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.

Multi-AZ Configuration for AWS RDS SQL Server

October 10, 2019 by Rajendra Gupta

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.

Enforce SSL connections in AWS RDS SQL Server

October 7, 2019 by Rajendra Gupta

This article explores a method to enforce SSL for all connections in AWS RDS SQL Server.

How to create and configure a linked server to connect to MySQL in SQL Server Management Studio

October 7, 2019 by Marko Zivkovic

This article will guide you with all the necessary steps to successfully create a linked server in SSMS to connect to the MySQL database.

Encrypted Backup and Restore in AWS RDS SQL Server

October 4, 2019 by Rajendra Gupta

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:

Recover Data in AWS RDS SQL Server

September 27, 2019 by Rajendra Gupta

This article explores the process to recover data in AWS RDS SQL Server and its recent enhancements.

MySQL Query (T-SQL) Tutorial for SQL Server

September 25, 2019 by Jignesh Raiyani

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…

SQL Server Transactional Replication on Linux

September 12, 2019 by Jignesh Raiyani

In this article, we will talk about how to send the SQL Server Transactional Replication on Linux Environment.

Creating your own SQL Server docker image

September 9, 2019 by Ranga Babu

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.

Understanding Graph Databases in SQL Server

August 16, 2019 by Ben Richardson

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.

SQL Server Merge Replication on Linux

August 15, 2019 by Jignesh Raiyani

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.

SQL Server Installation & Troubleshooting on Ubuntu

August 15, 2019 by Jignesh Raiyani

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.

Transparent Data Encryption (TDE) in AWS RDS SQL Server

July 23, 2019 by Ranga Babu

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.

Overview of Service Principal Name and Kerberos authentication in SQL Server

July 18, 2019 by Rajendra Gupta

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.

Azure Kubernetes Service (AKS) – Managing SQL Server database files

June 18, 2019 by Ranga Babu

In this article, we will review on managing database files of SQL Server running on Azure Kubernetes service.

AWS RDS – SQL Server Administration

May 30, 2019 by Ranga Babu

In this article, we will review common database administration tasks for AWS RDS (Relational Database Service) SQL Server instance. RDS does not provide access to some of the system procedures and tables that require advanced privileges. So, we cannot perform all the administration tasks on the RDS SQL Server instance.

Creating Containers with PowerShell For Azure Cosmos DB

May 30, 2019 by Timothy Smith

In many situations, we will develop, test or prove new concepts by horizontally scaling new SQL API containers in Azure Cosmos DB over possibly using existing containers. As we’ve seen in previous tips, we can create and remove Cosmos database accounts and databases by using the Azure Portal or PowerShell’s Az module along with making some updates to the configuration, such as the RUs for performance reasons. Similarly, we can create and remove a container through the Azure Portal along with creating and removing the container with PowerShell’s Az module.