When migrating on-premises SQL Server database to Azure SQL environment, identifying the right compute capacity of the target environment to match the resource consumption of(more…)
Introduction to Azure Database Services
Azure SQL database is a cloud based Database as a Service provided by Microsoft Azure platform. This service is based on the traditional SQL Server(more…)
Integrating AD to Microsoft SQL Server On Linux
In this exercise we will see the implementation of Windows Active Directory integration to Microsoft SQL Server on Linux environment. In this example Centos1 is(more…)
Installing & Configuring Microsoft SQL Server On Linux
This exercise demonstrates the installation and configuration of Microsoft SQL Server on Linux environment, this is a standalone deployment . Step 1 – Create “mssql”(more…)
Installing Postgres Database
This exercise demonstrates the installation and configuration of Postgres database on Linux environment using source tar file. Step 1 – Download Postgres tar file Step(more…)
Installing MySQL On Centos 7 Linux
In CentOS 7 Linux MariaDB is by default installed, due to this you may face issue installing MySQL. If you want to install MySQL, first(more…)
Sharding Mongodb
Sharding is a method for distributing data across multiple machines. MongoDB uses sharding to support deployments with very large data sets and high throughput operations.(more…)
Mongodb Installation & Configuration
MongoDB is a cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. MongoDB is developed by MongoDB(more…)
6. Configure HDP Namenode High Availability
Namenode is a Hadoop master daemon responsible for managing the file system namespace & regulates clients access. There is only one primary Namenode & one(more…)
5. Configure Hive
Hive is an Apache project software for data warehouse and as part of Hadoop ecosystem it provides data query & analysis interface using SQL like(more…)