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.

Blogs

  • PostgreSQL - Some Basics

    There are many differences in the syntaxes of PostgreSQL and other database queries. Mentioned are some commonly used ones.
  • 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 system folder location C:\Program Files\MongoDB\Server\4.0\bin
  • 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 server using the command line. On the other hand, it's really hard to install and manage multiple versions of MySQL on your computer.
  • 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
  • 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.
  • Difference Between LINQ To SQL And Entity Framework

    Let us learn the differences between LINQ To SQL and Entity Framework.
  • 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.
  • 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 architecture for applications in real-time.
  • SQLite Viewer - An Alternate Option For Browsing SQLite Database

    The segment discusses the variety of applications that store their data in SQLite database format and how SQLite Viewer applications are used to view the database components.
  • Reduce Size Of MS Access DataBase

    MS Access databases tend to get large over a period of time and opening them can take awhile. This blog will show you how to reduce the database file size.
  • MySQL - Best Practices

    In this blog, you will learn about MySQL best practices.
  • Create DataBase In MS Access 2016

    This blog will show you how to create a new MS Access database and create a new table.
  • When To Use (And Not To Use) MongoDB

    In this blog, you will learn when to use (or not to use) MongoDB.
  • SQL vs. No SQL

    Despite the traditional relational DB world, there's also a trend toward NoSQL. The NoSQL databases enable storing unstructured and heterogeneous data. The enhanced scalability has helped grow their popularity to a greater extent in the current market.
  • HammerDB, Open Source Database Load Testing Tool

    HammerDB is a graphical open source database load testing and benchmarking tool for Linux and Windows to test databases running on any operating system. HammerDB is automated, multi-threaded and extensible with dynamic scripting support.
  • How to Create an Access Database by using ADOX and Visual C# .NET

    In this blog you will learn how to create an Access Database by using ADOX and Visual C# .NET.
  • Oracle: The importance of enabling autobackup in RMAN

    In this article you will learn the importance of enabling autobackup in RMAN.
  • Write DataBase Data to PDF File

    A file with .pdf file extension is called PDF (Portable Document Format) file. Nowadays PDF files are frequently used in important documents such as tax papers, bank statements, and other forms of documents that require the user to fill in data. There is a usual question that how to read data from a database using sql statements and write that data to a PDF document.
  • View More