In this article, we are going to learn about the stored procedures in MySQL. In this article, I am covering the basics of the stored procedure that includes the following
Read more »
Technologies
Implement an Amazon Aurora Serverless cluster
January 4, 2021In this 4th article for the Amazon Aurora series, we will discuss and implement an Amazon Aurora Serverless cluster.
Read more »
Rewind or Forward the Amazon Aurora Cluster with MySQL compatibility using backtrack feature
December 24, 2020In this article, we will explore the useful backtrack feature for Amazon Aurora clusters.
Read more »
Explore Amazon Aurora global databases with MySQL compatibility
December 21, 2020In the article, Deploy your AWS RDS Aurora database clusters for MySQL, we explored the Amazon Aurora concept and deployment. In this article, we will understand about the global database feature and its implementations.
Read more »
Deploy your Amazon Aurora database clusters for MySQL
December 18, 2020Introduction
Amazon offers managed database service for various database products such as Microsoft SQL Server, MySQL, PostgreSQL, Oracle. In these relational database services (RDS), AWS manages the operating system, networking components, backups, monitoring solutions. In the previous articles, we explored many useful RDS features under the AWS RDS category on SQLShack.
Read more »
How to install SQL Server 2019 on RedHat Linux 18
December 9, 2020In this article, we will learn to install SQL Server 2019 on the RedHat Linux 18 on a virtual machine.
Read more »
Configure an iSCSI initiator in Ubuntu 18.04
November 26, 2020In this article, I am going to explain how we can configure iSCSI initiator and iSCSI target server on ubuntu 18.04. In my previous article, we have learned the step by step configuration process of configuring the iSCSI target and initiator in Windows Server 2016. The following are the links to these articles:
Read more »
Split native databases backup and restore for AWS RDS SQL Server from AWS S3 buckets
November 24, 2020In this article, we will explore how to split native backup and restore for AWS RDS SQL Server from the AWS S3 bucket.
Read more »
Configure SQL Server Replication between AWS RDS SQL Server and On-premises SQL Server
November 20, 2020In this article, we will implement a SQL Server Replication between AWS RDS SQL Server and On-premises SQL Server instance.
Read more »
Import data into Azure SQL database from AWS Redshift
November 10, 2020In this article, we will learn an approach to source data from AWS Redshift and populate it in the Azure SQL database, where this data can be used with other data on the SQL Server for desired purposes.
Read more »
Install SQL Server Linux (2017 version) on SUSE Linux in Amazon EC2 instance
October 26, 2020In this article, we will install and configure SQL Server Linux (2017 version) on SUSE Linux in the Amazon EC2 Instance.
Read more »
Data Virtualization with MongoDB using PolyBase in SQL Server 2019
October 9, 2020In 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.
Read more »
Install SQL Server Express on Windows Server 2016 using docker containers
October 9, 2020In this article, we will install the SQL Server Express edition on Windows Server 2016 using a SQL Server Docker container.
Read more »
SQL Server Always On Availability Groups for SQL Server Linux instances
October 6, 2020In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances.
Read more »
![user database [LinuxAGSQL]](https://s33046.pcdn.co/wp-content/uploads/2020/10/user-database-linuxagsql-624x475.png)
Restore a SQL database from Windows SQL Server to SQL Server Linux instance
October 5, 2020Database professionals get the standard requirement for SQL database restores from production to non-production instances. As you know, SQL Server runs on the Linux and Windows operating systems starting from SQL Server 2016. Suppose you are exploring the SQL Server Linux instance features and configurations.
Read more »
Explore SQL Server PolyBase External Tables in SQL Server Always On Availability Groups
September 29, 2020In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups.
Read more »
Explore Manual Snapshots in AWS RDS SQL Server
September 23, 2020In this article, we explore the use of manual snapshots in AWS RDS SQL Server.
Read more »
Learn MySQL: Delete and Update Statements
September 18, 2020In this article, we are going to learn how we can update and delete data using Delete and Update statements. In my previous articles, we have learned how we can insert data using INSERT statement, and sort and filter data using WHERE and ORDER BY statements.
Read more »
Backup SQL databases on the AWS S3 bucket using Windows PowerShell
September 16, 2020In this article, we will explore taking backups of native SQL databases into the AWS S3 bucket.
Read more »
Configuring ODBC drivers for Azure Database for MySQL
September 15, 2020In this article, I am going to show how we can configure the ODBC driver to connect the Azure Database for MySQL Server. Also, I am going to demonstrate the configuration using the SQL Server Integration Services (SSIS) package.
Read more »
How to create an AWS SageMaker Instance
September 7, 2020This article provides a step by step explanation of how to get started with AWS Sagemaker by creating an AWS SageMaker instance for using machine learning related features on AWS Cloud.
Read more »
Saving AWS Redshift costs with elastic resize
September 3, 2020In this article, you will learn to elastically resize the AWS Redshift cluster to save costs.
Read more »
Saving AWS Redshift costs with scheduled pause and resume actions
August 31, 2020This article helps you learn the AWS Redshift cluster pricing model, as well as options to pause and resume cluster on-demand and on-schedule.
Read more »
Working with AWS Neptune Graph Databases
August 28, 2020This article provides a step by step explanation of how to work with AWS Neptune Graph database. We will understand the basic concept and use-case of graph databases and then create a graph database instance as well as access it with Jupyter notebooks.
Read more »
Getting started with AWS RDS Aurora DB Clusters
August 24, 2020This article provides a step by step explanation of how to create an Aurora DB cluster that is compliant with MySQL or PostgreSQL.
Read more »