Databases & DBA
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Here you may find Databases & DBA related articles and news.

RECENT POSTS

  • Extended Security Updates No More Freebies

    As data professionals, we should always strive to keep our systems updated and patched to ensure proper security of our environments. Microsoft has moved away from releasing service packs to releas...
  • Advanced Query Search On Stored Data In MongoDB - Part Four

    In this article, we will discuss the advanced search command of a MongoDB Database. If you want to read the previous articles of these series, then follow the links.
  • Query On Stored Data In MongoDB - Part Three

    In this article, we will discuss about different process to fetch document data from MongoDB.
  • Insert, Update And Delete Document In MongoDB - Part Two

    in this article, we will discuss about how to insert, update and delete documents from MongoDB
  • MongoDB - Day 1 (Introduction To MongoDB)

    This article provides an introduction to MongoDB. MongoDB is a document-based open-source database. MongoDB is a leading NoSQL database.
  • Introduction To MongoDB - Part One

    This article is basically an introductory article which will demonstrate how to start MongoDB
  • MongoDB 4.0 Announced With Other Major Updates

    MongoDB Inc. has recently announced the release of MongoDB 4.0.
  • SQL Server 2016 Install - Issues "Oracle JRE 7 Update 51 (64-Bit) Or Higher Is Required For Polyb...

    When Install the SQL Server 2016 got "Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase" Failed
  • Importance Of Statistics

    Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and play a part in execution plans. The cardinality estimator relies heavily on sta...
  • Apache Flink 1.5.0 Released

    Recently, the Apache Flink community has announced the availability of Apache Flink 1.5.0.
  • Essential Features Of TablePlus - The Best GUI Tool To Manage Relational Databases

    TablePlus helps you to be more efficient while working with multiple relational databases. You can connect to the server, create a new database, manipulate and save your data at a fast speed, high-...
  • MariaDB TX 3.0 Announced

    The MariaDB Corporation has today released MariaDB TX 3.0, a new version that is equipped with enterprise-level features and functionality and is capable of replacing costly enterprise databases.
  • How To Survive As A Lone DBA

    Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived as the Lone DBA for 56 database servers for over a deca...
  • Quick Model Database Tidbit

    I am finding more and more that Database Admins are not using the Model database to its fullest potential and some not at all.
  • MySQL 8.0 Released

    Oracle has recently announced the release of its open-sourced database management system MySQL 8.0.
  • Working With In-Memory Database - Redis

    In this article we will see how to implement Redis in-memory database in C# .Net applications
  • Just Check ALL The Boxes

    Today I ran into something on a client-server that unfortunately I see too often. The DBA goes through the trouble of configuring and setting up alerts/operators but doesn’t really understand what...
  • Let's Learn Oracle Server Architecture

    In this blog, let us learn about the architecture of Oracle Server
  • What Is An Observable?

    Observables emit data as a stream of values, observers are functions which subscribe(i.e consume) this data and do some processing on this received data.
  • Oracle Announces World’s First Autonomous Data Warehouse Cloud

    Recently, Oracle has announced the availability of a new Oracle Autonomous Data Warehouse Cloud that will be equipped with Oracle's previously announced autonomous database.
  • Know Your Database Metadata With C# Code

    In this blog, we will see some tricks to analyze the database metadata.
  • Continue With Learning Indexes In MongoDB

    This is the continuation of exploring the Indexes on MongoDB. We will be discussing various MongoDB indexes which we can perform on our data.
  • Understanding Fragmentation In Distributed Databases

    This article explains about fragmentation types in distributed databases.
  • Learn MongoDB With Me - Part Two

    This is the second article of the series “Learn MongoDB with Me,” and if you haven’t read my previous post on this topic, I strongly recommend you find it here. This is a continuation of exploring ...
  • Learn MongoDB With Me

    Here, we are going to do some exercises with MongoDB. We will be talking about Mongo Shell, how we can configure MongoDB, and what Indexes are in MongoDB, and more.