Loading
Are The DBAs Paranoid By Nature
With respect to the job functions of Database Administrators, the term “paranoid” does not necessarily imply that they are under an extreme state of paranoia; however, perhaps in their zealous effort to carry out their job functions to the best of their capabilities, they may appear to be control freaks.
Quickly Determining Azure SQL Database Size
In this article, I'll show you a quick and easy way to determine how much space your Azure SQL Databases are consuming.
Getting Started With Apache Cassandra
Apache Cassandra is a highly scalable and distributed NoSQL database designed for handling massive amounts of data across multiple servers while maintaining high availability and fault tolerance. It's built to handle both structured and semi-structured data with a decentralized architecture that ensures there's no single point of failure.
What Is Dynamic SQL
This article is about Dynamic SQL in SQL Server and how to write Dynamic SQ.
Query Processing In DBMS
Query Processing in DBMS is the approach of selecting the best strategy or plan which can be used to respond to a database request.
No Likes And Range Queries In Cassandra
Cassandra's design philosophy emphasizes efficient distributed data storage and retrieval using partition keys and clustering columns. While it may not support arbitrary substring matching (No Likes queries) and requires careful consideration for efficient range queries, understanding and designing your data model accordingly can help you make the most of Cassandra's capabilities
Need Of Polyglot Persistence
Polyglot Persistence refers to the practice of using multiple database systems, each optimized for a specific type of data storage and retrieval, within a single application or system architecture. This approach recognizes that different data storage requirements might be best served by different types of databases, and thus, it allows for the selection of the most appropriate database for each use case.
Strategic Alert and Security Configuration
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 the options in the configurations mean. So, unfortunately, that means they take the CYA (cover your ass) approach and they check all of them. Now, not only have I seen this with alerts but also with things like security configurations as well. My advice is to always take a second and research what each option is before you check the little boxes, especially when it comes to security. Always follow the rule of less is more.
How to Select Employees Who Were Born on the Last Day of the Month?
To select employees who were born on the last day of the month from a database or employee records, you'll need to use SQL or a similar query language to filter the data based on the birth dates. Here's a step-by-step guide on how to achieve this:
Types of Databases
There are multiple types of databases, such as relational database management systems, object databases, graph databases, network databases, and document db. In this article, we discuss the types of Database Management Systems or DBMS.
Most Popular Databases In The World (2023)
Do you wonder which database is the most popular database in the world? This article lists world’s most popular databases and their rankings.
What Is A Network Database?
Network databases represent data in a tree-like structure. In this article, we'll learn basics of hierarchical database management systems and how data is represented and stored in a hierarchical database.
Most Popular Graph Databases
Graph databases, or Graph DBMS, are growing in popularity. Neo4j is the most popular graph database. This article lists the most popular graph databases.
Stored Procedure in Snowflake
A Stored Procedure in Snowflake is a precompiled set of SQL and/or JavaScript code that can be stored in the Snowflake database and executed later as a single unit. It allows you to encapsulate complex logic or business rules into a reusable and manageable code block. Stored procedures are primarily used for performing repetitive tasks, complex calculations, data validation, or any operations that involve multiple SQL statements and business logic.
Getting started with SQLite
Learn the basics of SQLite, including installation, command-line access, creating tables, inserting data, and backing up a database.
Startup of Database in Oracle 11g
Considering that you have installed the oracle for the first time and is about to start the database instance.
Quick Model Database Tidbit
"Quick Model Database Tidbit" refers to a concise and brief piece of information or knowledge about the "model" database in the context of a database management system like Microsoft SQL Server. This tidbit could cover various aspects of the "model" database, such as its purpose, characteristics, role in database creation, default settings, or any notable features. It's a snippet of information that provides a snapshot of key details about the "model" database in a short and easily digestible format.
Introduction of Stored Procedures
A stored procedure is a set of precompiled SQL statements that are stored in a database. It is designed to perform a specific task or a series of tasks and can be executed by calling its name rather than writing out the individual SQL statements each time. Stored procedures are often used to encapsulate business logic, improve performance, and maintain data integrity in a database system. They can accept input parameters, process data, and return results, making them a powerful tool for managing and manipulating data within a database.
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 efficiency and load faster.
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 just cumulative updates and the occasional hotfixes. These hotfixes may or may not be security related, but it behooves us to ensure things get patched. Not just from a SQL Server perspective but also from a Windows perspective.
What is a Graph Database
Big data, semantic searches, and real-time responses are the reason behind the growing demand for graph databases. This article talks about what a graph database is, why graph databases are popular, and why and when we should use a graph database.
Understanding Fragmentation In Distributed Databases
Fragmentation in distributed databases refers to the division of a database into smaller parts or fragments that are stored on different computers or nodes within a network. This division is done to enhance performance, improve data availability, and distribute the processing load.
Configure A Windows Service For MongoDB
In this article, we will learn how to configure a Windows Service for MongoDB.
What Is Storage Provisioning In Virtualization Concepts
In this article, you will learn what is Storage Provisioning in Virtualization Concepts.
iseries As/400 Setup In Windows Operating System And Accessing Its Database
In this article, you will learn about iseries As/400 setup in Windows operating system and accessing its database.
How To Track Database Changes
To track database changes, you can implement a database change tracking system that records and monitors modifications to the data and schema within the database. Here's a short description of how to track database changes
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, we learned the Insert and Delete operations in MongoDB.
MongoDB - Day 16 (Sharding)
MongoDB sharding is a method of partitioning data across multiple servers to handle big data and high traffic. It improves database performance and scalability by distributing data and operations across multiple shards, each running on separate hardware. Sharding allows MongoDB to grow and meet the demands of large-scale applications by ensuring data is efficiently spread across the shards, enabling balanced data distribution and optimized query performance.
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 understanding how we retrieve Data from Database and Display it in our Application.
