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

  • PostgreSQL - Some Basics

    There are many differences in the syntaxes of PostgreSQL and other database queries. Mentioned are some commonly used ones.
  • Find Methods, Operators, And Filters In MongoDB

    In this video of MongoDB Series, I will show how to import JSON data to a MongoDB Database (Collection) and perform some operations with find and findOne methods. Also, we will see some queries with c
  • How To Install MongoDB Locally And Perform CRUD Operations (Basic-Query)

    This video explains how to perform basic CRUD operation on MongoDB using MongoShell. We will learn the functionality and usage of find, insertOne, insertMany, deleteOne, deleteMany, updateOne,updateMa
  • DataTypes In MongoDB

    In this article, we will learn about the Datatypes and its usage in the MongoDB. As we already know, MongoDB stores data in BSON format. BSON stands for the Binary-encoded format of JSON. Using BSON,
  • Creating Your First MongoDB Atlas Cluster

    MongoDB Atlas is an online no-sql database that allows you to run a MongoDB database as a service. Running MongoDB as a service means that you no longer need to host your own servers or manage upgrade
  • MongoDB Database Backup And Restore

    Open command prompt by pressing window + R and change directory to the location in which MongoDB server is saved. Go to MongoDB folder >Server >bin folder and copy the folder address. In my syst
  • Working With Databases In MongoDB

    In this article, we will learn about Database in MongoDB. If you are new to MongoDB then I would recommend you to go through the previous article in this series.
  • Configure A Windows Service For MongoDB

    In this article, we will learn how to configure a Windows Service for MongoDB.
  • Retrieve Operation In MonGoDB Using Robo 3T

    In this article, we will learn how to retrievethe data from MongoDB. We will learn from the basics because I have written this Series of articles focusing on the beginners.This article give some basic
  • How To Set Up And Start With MongoDB

    In this article, we will learn How to set up and starts with MongoDB in Windows Operating System.
  • Update Operation In MonGoDB Using Robo 3T

    In this article, we will learn how to Update the data from MongoDB Using Robo 3T. We will learn from the basics because I have written this article focusing on the beginners. In my previous article, w
  • Normalization In Databases

    Sometimes the database design that looks Ok at first sight may have some hidden problems. One such kind of problem is Non-Atomic Values. This means that the value that stored in a single column in the
  • Delete Operation In MonGoDB Using Robo 3T

    In this article, we will learn how to delete the data from MongoDB using Robo 3T. We will learn from the basics because I have written this article focusing on the beginners. In my previous article, w
  • Insert Operation In MongoDB Using Robo3T

    In this article, we will learn how to insert data in MongoDB using Robo 3T. We will learn from basics because I have written this article focusing on the beginners. We will also learn how we can setup
  • Getting Started With SQLite

    Getting Started With SQLite. SQLite is a lightweight local database and it's become the industry standard for mobile apps. Learn SQLite, SQLite tutorial.
  • Install Multiple Versions Of MySQL On Mac

    To install MySQL on Mac, the two most common ways are Docker and Homebrew service. But Docker might be too big and eat up a large portion of memory, or sometimes you feel clumsy configuring the local
  • 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 releasing
  • 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.
  • 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 statis
  • 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-end
  • 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 decade.
  • 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.
  • Working With In-Memory Database - Redis

    In this article we will see how to implement Redis in-memory database in C# .Net applications