Vendor Relationship Management

How to do Partitioning in Hive - Demo code

 

Branches of Economics to Study

What is Real GDP

 

What is GDP (Gross Domestic Product)

 

Accounting Equation

Introduction to Hive

SQL SERVER – Most Used Database Files – Script

Bucketing & Hive - Demo

 Implement Bucketing in Hive

SQL Server to Elasticsearch using Logstash

  # MSSQL-ELK

Loading data from SQL Server to ELK stack

Types of Indexes in PostgreSQL

Checklist to tune PostgreSQL Query performance

Setup Streaming Replication in PostgreSQL

Understanding Streaming Replication in PostgreSQL

Maintenance (Vacuum, Analyze, Re-index) in PostgreSQL

Memory Parameters in PostgreSQL

Memory Components in PostgreSQL

Types of Join: Nested Loop, Merge and Hash Joins in SQL Server

Find fragmentation for all tables for all databases in server

Moving Database files of Primary AG server to another disk