Databases Resources

Best Methods To Backup and Restore Database in SQL Server

Explore methods to back up and restore the Database in the SQL Server. Get the complete solutions to Backup and Restore Database in SQL Server.

November 30, 2023

by Mithilesh Tata

CORE

· 1,221 Views · 1 Like

Decompose Legacy System Into Microservices: Part 2

In this article, follow along with a breakdown of a legacy insurance Reimbursement Calculation System into microservices in a domain-specific example.

November 29, 2023

by Somasundaram Kumarasamy

· 2,278 Views · 2 Likes

Demystifying Databases, Data Warehouses, Data Lakes, and Data Lake Houses

Databases for transactions, data warehouses for analytics, and data lakes and lake houses for analytics with flexibility and scalability.

November 29, 2023

by Anirudha Bhadoriya

· 1,550 Views · 5 Likes

The Efficiency of ELT Over ETL

Understand the difference between ELT and ETL and their impact on cloud data integration.

November 29, 2023

by John Lanctot

· 1,624 Views · 2 Likes

The Role of Metadata in Data Management

Metadata is central in modern data management, vital for integration, quality, security, and key in digital transformation initiatives.

November 29, 2023

by Helen Stewart

· 1,739 Views · 2 Likes

What Is SQL Vector Database?

SQL vector databases blend the strengths of SQL and vector databases, providing a streamlined approach to storing and querying high-dimensional vectors through SQL.

November 29, 2023

by Usama Jamil

· 1,630 Views · 2 Likes

Data Consistency in Distributed Systems: Transactional Outbox

In this article, we will discuss how to deal with consistency in microservice architecture using the transactional outbox pattern.

November 28, 2023

by Viacheslav Shago

· 2,517 Views · 4 Likes

Why SQL Isn’t the Right Fit for Graph Databases

Graph database vs. relational database GQL vs. SQL graph data modelling database schema design SQL performance issue QQL intuitiveness.

November 28, 2023

by Ricky Sun

· 1,741 Views · 2 Likes

How to Detect VPN Proxies With Python and IP2Location.io API

VPN detection is a crucial focus for developers when addressing security concerns. Find out how to detect VPN using IP2Location.io API in Python.

November 28, 2023

by camimi Morales

· 1,578 Views · 2 Likes

Navigating the API Seas: A Product Manager's Guide to Authentication

Learn about API keys for single-entity access, OAuth for third-party integration, and JWT for stateless authentication.

November 28, 2023

by Lakshmi Sushma Daggubati

· 1,798 Views · 2 Likes

Live Database Migration

In this article, learn more about database migration — the process of transferring data from one database system to another.

November 28, 2023

by Saurav Bhattacharya

· 1,262 Views · 3 Likes

Monitoring Applications at Scale in AWS

AWS provides local metrics/monitoring via CloudWatch. But things get complicated when we need to monitor multiple applications from all these accounts.

November 28, 2023

by Pranav Kumar Chaudhary

· 1,459 Views · 2 Likes

Evolution of Software Architecture: From Monoliths to Microservices and Beyond

Tracking software architecture evolution from monolithic systems to serverless designs, addressing changing business and technology needs.

November 28, 2023

by Pier-Jean MALANDRINO

· 2,147 Views · 3 Likes

Are You Facing an Error When You Run the StartDagServerMaintenance.ps1 Script?

Learn how to address errors with the StartDagServerMaintenance.ps1 script in Exchange Server, and discover reliable recovery solutions for database issues.

November 28, 2023

by Shelly Bhardwaj

· 1,243 Views · 2 Likes

Converting Multi-Frame TIFF to GIF in Cross-Platform .NET Environments

Converting multi-frame TIFF images to GIF format is a unique challenge, especially in a cross-platform .NET context. Here, explore a solution to this challenge.

November 28, 2023

by Somasundaram Kumarasamy

· 1,281 Views · 2 Likes

Distributed Systems: CAP Theorem

In this article, we will learn about the CAP theorem from a distributed system perspective using a simple database analogy.

November 28, 2023

by Vetriselvan M

· 1,152 Views · 2 Likes

An In-Depth Exploration of REST, gRPC, and GraphQL in Web Projects

Choosing an API plays a pivotal role in determining the success and efficiency of a web dev project. Explore 3 prominent contenders: REST, gRPC, and GraphQL.

November 28, 2023

by Rama Krishna Panguluri

· 1,640 Views · 4 Likes

A Comprehensive Guide to Cloud Monitoring Tools: Ensuring Optimal Performance and Security

In this article, we will explore some of the most popular cloud monitoring tools and their key features.

November 28, 2023

by Aditya Bhuyan

· 2,341 Views · 3 Likes

Extracting Table Structures

Extracting table structures from SQL Server databases, converting them to JSON format, keeping them in Azure Studio, and then loading them into BigQuery.

November 28, 2023

by Prashanth Mally

· 1,791 Views · 1 Like

Unblock Your Software Engineers With Unblocked

AI is playing an ever-increasing role in our field as developers with the capacity to significantly increase our productivity in ways we’ve never seen before.

November 27, 2023

by Tyler Hawkins

CORE

· 2,112 Views · 2 Likes

The Latest Databases Topics