Tanishk

GeneralBeginner

Introduction to ThruDB

This article will provide an insight to ThruDB, and the features and services provided by it. ThruDB is an open source database built on top of Apaches Thrift framework.

#thrudb

GeneralBeginner

Introduction to NoSQL

Understand the four NoSQL families (key-value, document, wide-column and graph), see a working example of each, and learn what each one makes you give up.

#big-data#nosql

GeneralBeginner

Basic Concepts of DBMS

Learn the core DBMS concepts through one worked SQL example: tables, primary and foreign keys, relationships, normalization, ACID transactions and indexes.

SQL ServerBeginner

Introduction to Reporting Services in SQL Server

Understand how SQL Server Reporting Services works, what a report is made of, and what its replacement by Power BI Report Server means for you.

GeneralBeginner

Introduction to Ingres Database and Its Tools

Find out who owns Ingres now, what Actian Ingres offers in its current releases, and which command-line and graphical tools you use to run it.

Apache CouchDBBeginner

How to Install CouchDB on Windows

Install Apache CouchDB on Windows with the MSI installer, complete the single-node setup, verify it with a test document, and fix the common startup and login errors.

#windows

GeneralBeginner

Introduction to Database Performance and Tuning

Follow the tuning loop: find the costliest queries, read their execution plans, fix them with indexes or rewrites, and check statistics, memory and locks.

SQL ServerBeginner

Backup and Recovery in SQL Server

Plan a SQL Server backup strategy around RPO and RTO: recovery models, full, differential and log backups, the backup chain, and how to verify backups restore.

#restore

SQL ServerBeginner

Basic Functions of SQL Server

Use SQL Server's everyday built-in functions for type conversion, NULL handling, logic and math, and avoid the truncation, rounding and conversion errors they cause.

#sql-server-2014

GeneralBeginner

Big Data: The Future Has Arrived

See what became of the 2016 Hadoop stack and what replaced it: object storage, Iceberg and Delta Lake tables, lakehouses and cloud SQL warehouses.

#big-data

SQL ServerBeginner

Migrate to SQL Server 2016

How to upgrade and migrate your existing SQL Server database to SQL Server 2016.

#sql-server-2014#sql-server-2016

MySQLBeginner

New Features of MySQL 5.7

MySQL 5.7 is the latest release of the most popular open source database. Here is a list of new and improved features in this release.

#mysql-5.7