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

  • 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
  • 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 th
  • 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.
  • 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 the
  • 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.
  • RavenDB 4.0 Is Available Now

    Today, RavenDB has got a new version, RavenDB 4.0.0,
  • Difference Between LINQ To SQL And Entity Framework

    Let us learn the differences between LINQ To SQL and Entity Framework.
  • How To Use Indexed DB To Improve Page Load Performance

    Indexed DB is a local storage system, which will store data in client-side on browser. This is useful for applications that require us to store large amounts of data. These applications can run more e
  • Difference Between MySQL DATETIME And TIMESTAMP DataTypes

    A simple question that may come to one's mind while working with MySQL is "Whether to assign DATETIME or TIMESTAMP datatype for a column as both seem to store the same data?”. Even though the
  • Introduction Of MongoDB

    This Blog contains basic knowledge of Mongo DB as well as the advantages of Mongo DB and the difference between SQL and MongoDB.
  • PostgreSQL 10 RC1 Released

    PostgreSQL Global Development Group has announced the PostgreSQL 10 RC1 which is now available for download.
  • Frequent Pattern And Market Basket Implementation

    Frequent pattern mining is about the item sets and sequences which appear in a data set.
  • Getting Started With MongoDB

    MongoDB is an open-source/cross platform (Windows, Linux, etc) document database that is NoSql in JSON format database. A NoSQL database means it does not have any relationships (non-relational databa
  • Building An Enterprise-Grade Database Architecture For Real-Time Applications

    The need for speed and big scale has exposed legacy database technologies that pose considerable challenge for deployment teams. That is why it is important to create an enterprise-grade database arch
  • Improved Functionality In dbForge Studio For SQL Server v5.5

    Devart has released the new version of dbForge Studio for SQL Server v5.5 with greatly improved key features.
  • Data Science - Basics Of Statistics - Part One

    Data Science means Science which is being driven by data, by means of getting useful insights from the set of data available, plotting the data visually and predicting the future.