The MerchantStore
DirectoryAbout UsLink to Us

146 Software — Database Entries

Software — Database — October 24th, 2025

Strategic Domain-Driven Design: The Forgotten Foundation of Great Software
Most teams skip strategic DDD and focus only on code. Learn how domains, contexts, and patterns align software with business reality.
October 24, 2025Source

Software — Database — October 20th, 2025

Should You Use Azure Data Factory?
Yes for most ETL scenarios, ADF handles data movement, basic transformations, and scheduling well, just don't expect it to replace custom code for complex business logic.
October 20, 2025Source

Software — Database — October 17th, 2025

DevEx Ambient Agent With Advanced Knowledge Graph
The Agentic DevEx Assistant boosts developer productivity by automating tasks, providing contextual insights, and offering personalized career growth guidance.
October 17, 2025Source

PostgreSQL Full-Text Search versus Pattern Matching: A Performance Comparison
We'll analyze the performance of PostgreSQL full-text search (FTS) versus pattern and regex searching, highlighting trade-offs and execution efficiency.
October 17, 2025Source

SAP users still wrestling with business case for S/4HANA
A decade later, ERP giant struggles to convince legacy customers to upgrade
October 17, 2025Source

Software — Database — October 10th, 2025

Data API Builder 1.6 Adds HTTP Header Controls and Flexible Logging
Microsoft has released Data API Builder (DAB) 1.6, expanding the open-source runtime's capabilities for REST and GraphQL endpoints over Azure SQL, PostgreSQL, MySQL, and Cosmos DB. The new version introduces advanced HTTP header behaviours for better client-side control and a revamped logging subsystem designed to improve diagnostics and observability in both cloud and on-premise deployments.
October 10, 2025Source

Microsoft Azure Gets An Ultra Upgrade With NVIDIA's GB300 "Blackwell Ultra" GPUs, 4600 GPUs Connected Together To Run Over Trillion Parameter AI Models
Microsoft has announced its first at-scale production cluster featuring NVIDIA's GB300 "Blackwell Ultra" GPUs for massively-sized AI models.
October 10, 2025Source

Software — Database — October 8th, 2025

IBM invites CockroachDB to infest its mainframes with PostgreSQL
Vendors promote bridge to modern architecture for legacy systems, but Db2 not going anywhere just yet
October 8, 2025Source

Microsoft is moving GitHub over to Azure servers
It's the first major change to GitHub since losing its CEO.
October 8, 2025Source

Software — Database — October 3rd, 2025

Agoda Leverages ChatGPT in the CI/CD Process for SQL Stored Procedure Optimization
Agoda utilizes ChatGPT within their CI/CD process to optimize SQL stored procedures, shortening optimization times and reducing developer workload.
October 3, 2025Source

Software — Database — September 29th, 2025

Fork yeah: Valkey 9 sharpens edge against Redis
Open source database adds multi-tenant clustering, safer shutdowns, and eyes life beyond caching
September 29, 2025Source

Software — Database — September 25th, 2025

Lessons Learned From Building Production-Scale Data Conversion Pipelines
Converting large-scale enterprise data between systems is less about perfection than about making the right tradeoffs and engineering for scale and flexibility.
September 25, 2025Source

Software — Database — September 22nd, 2025

Azure IOT Cloud-to-Device Communication Methods
Learning and choosing the correct cloud-to-device communication method to send a message to the device using the Azure IoT Hub to build an effective IoT system.
September 22, 2025Source

Datadog Launches Monocle, a Unified Rust-Powered Real-Time Metrics Engine
Datadog has launched Monocle, a new real-time timeseries storage engine written in Rust. The system unifies the company's metrics storage infrastructure, delivering higher ingestion throughput and lower query latency while reducing operational complexity. Monocle replaces several generations of storage backends, addressing concurrency challenges and scaling limits that accumulated over time.
September 22, 2025Source

Easiest way to run LLMs locally
Most of you have interacted with a large language model (LLM) by now, or what we call AI these days. They've come a long way from being seen as hallucinating, incompetent chatbots to useful tools to have today. You're likely using an LLM from one of the Big 3 (OpenAI, Anthropic, Google), and a local LLM will likely not replace that either, but it does give you more options in privacy and control.
September 22, 2025Source

Scaling an Embedded Database for the Cloud -- Challenges and Trade-Offs
Stephanie Wang explains the journey of building MotherDuck, a serverless data warehouse, from the ground up using the in-process DuckDB. She discusses the challenges of cloudifying an embedded database, including coupled compute and storage, and details architectural choices and engineering tradeoffs made to enable cloud-native capabilities.
September 22, 2025Source

Software — Database — September 19th, 2025

User group says SAP's licensing models make cloud migration harder
DSAG criticizes separate regimes for public, private cloud, says users need more time to upgrade in uncertain times
September 19, 2025Source

Software — Database — September 16th, 2025

How TBMQ Uses Redis for Persistent Message Storage
Learn how we use Redis to scale MQTT session persistence in TBMQ — replacing PostgreSQL and improving performance with Lua scripts and the Lettuce async client.
September 16, 2025Source

Software — Database — September 9th, 2025

Tutorial: RAG at Scale With Vector Databases versus Lakehouse Architectures
Learn how to scale RAG pipelines by storing embeddings in vector databases versus lakehouses, with hands-on examples and key trade-offs.
September 9, 2025Source

Understanding Table Statistics in SQL Server: Importance, Performance Impact, and Practical Examples
SQL Server table statistics guide the optimizer in building efficient query plans. DBAs must keep them updated to avoid poor performance from stale data.
September 9, 2025Source

Software — Database — September 5th, 2025

Picking Server CPUs for Databases in 2025 is Still Complex
If you look at any major server CPU launch, you will undoubtedly see some form of claim that the CPU is good for databases. Storing and retrieving information is a basic function of traditional computing. Recently, I was at a dinner with a number of STH readers, and all of them ran databases. One individual exclaimed how they had nightmares of a 192-core processor, while another was explaining how awesome that would be to deploy.
September 5, 2025Source or Watch Video

Software — Database — September 4th, 2025

Microsoft simplifies Azure VM security, here's how
Microsoft has released Trusted Launch in-place upgrade support for Azure Virtual Machines and Scale Sets. This allows users to enhance security without downtime or complex migrations. It's now generally available for existing Gen1 and Gen2 VMs and Uniform scale sets, and in private preview for Flex scale sets. What's nice about this upgrade for customers is that it's provided at no additional cost.
September 4, 2025Source

PostgreSQL 18 eyes analytics boost and distributed future
Async I/O and UUID v7 highlights of the September release, though some SQL features are delayed
September 4, 2025Source

PostgreSQL 18 Release Candidate Now Available
The PostgreSQL Global Development Group has announced the availability of the first release candidate (RC) for PostgreSQL 18, with a planned general availability date of September 25, 2025. To upgrade from earlier versions, users will need to employ a major version upgrade strategy such as pg_upgrade or pg_dump/pg_restore. Several bug fixes were applied since Beta 3, including improvements to vacuumdb and guidance on reindexing full-text search indexes after upgrading. The RC is expected to be nearly identical to the final release, with minor fixes made before its general availability.
September 4, 2025Source

Software — Database — September 1st, 2025

Azure budget alerts go berserk after Microsoft account migration misfire
Cloud customers left reeling as forecasts leap hundreds of percent
September 1, 2025Source

Software — Database — August 29th, 2025

Implementing Write-Through Cache for Real-Time Data Processing: A Scalable Approach
Learn how a write-through local cache boosts performance and consistency in high-volume data streams while reducing database load.
August 29, 2025Source

Keep Your Search Cluster Fit: Essential Health Checks to Keep Elasticsearch Healthy
A search cluster in top notch state requires frequent monitoring for health stats. Let's look at some health checks to always keep your ES cluster fit.
August 29, 2025Source

Microsoft to enforce MFA for Azure resource management in October
Starting in October, Microsoft will enforce multi-factor authentication (MFA) for all Azure resource management actions to protect Azure clients from unauthorized access attempts.
August 29, 2025Source

OpenAI and Microsoft's contract negotiations threaten investment and potential IPO — companies battle over AGI secrecy and Azure exclusivity
Microsoft and OpenAI butt heads over ongoing contract negotiations
August 29, 2025Source

Ransomware Group Exploits Hybrid Cloud Gaps, Gains Full Azure Control in Enterprise Attacks
Storm-0501 has been leveraging cloud-native capabilities for data exfiltration and deletion, without deploying file-encrypting malware.
August 29, 2025Source

Software — Database — August 25th, 2025

Building a 3D WebXR Game with WASI Cycles: Integrating WasmEdge, Wasmtime, and Wasmer to Invoke MongoDB, Kafka, and Oracle
Develop Fullstack WASM and WASI using all the most popular frameworks, databases, frontends, etc., from top to bottom, including source code
August 25, 2025Source

Instacart Consolidates Search Infrastructure on PostgreSQL, Phasing out Elasticsearch
Instacart has redesigned its search infrastructure by replacing Elasticsearch with PostgreSQL, combining keyword and embedding-based retrieval in a single system. By consolidating catalog and search data into Postgres, the company aimed to simplify operations, reduce synchronization overhead, and improve precision and recall in search results.
August 25, 2025Source

Linux Foundation says yes to NoSQL via DocumentDB
PostgreSQL implementation of document-oriented NoSQL datastore adopted under permissive MIT license
August 25, 2025Source

Microsoft announces VM Conversion tool
Although Microsoft Azure offers a managed environment hosted on the cloud with many pay-as-you-go (PAYG) services, there are many organizations which prefer to keep their data on-premise because of compliance or data governance reasons. To cater to this use-case and its users, Microsoft has now announced the public preview of a VM Conversion tool.
August 25, 2025Source

Microsoft Azure Hardware Security to Help Thwart the World's 3rd Largest GDP
At Hot Chips 2025, Microsoft went into its Azure Hardware Security. The goal is to keep Azure secure since it is a giant cloud service. Microsoft does not just have to protect against external traffic threats, instead it has multi-tenant workloads to keep safe, and some customers want to ensure they are secure from even Azure itself.
August 25, 2025Source

Up to 2.5 Billion Users Impacted by Google Database Hack
Google insists the compromised database contained 'basic and mostly publicly available business information,' like business names and contact information.
August 25, 2025Source

Software — Database — August 22nd, 2025

Data Lake, Warehouse, or Lakehouse? Rethinking the Future of Data Architecture
AI is driving data lakes, warehouses, and lakehouses to converge into open, real-time platforms powered by Iceberg, Trino, and DuckDB.
August 22, 2025Source

Microsoft announces SQL Server 2025 Release Candidate 0
A private preview of SQL Server 2025 began in November 2024, followed by a public preview in May 2025. Now, it is time for the natural next step, as the tool has received its first release candidate, dubbed "RC0", bringing it one step closer to general availability, hopefully later in the year.
August 22, 2025Source

Software — Database — August 19th, 2025

Building a Secure and Unified Data Platform
Learn to build a secure GCP stack using a custom VPC, VM with private access, managed Cloud SQL PostgreSQL, and BigQuery for real-time federated queries.
August 19, 2025Source

Software — Database — August 16th, 2025

Oracle Brings Database Services Directly to AWS Cloud
AWS recently announced the general availability of Oracle Database@AWS, a new option for Oracle Exadata workloads, including Oracle Real Application Clusters (RAC), within AWS. This new option allows enterprises to migrate Oracle Exadata workloads to dedicated infrastructure on AWS, simplifying cloud migration and unifying data across platforms.
August 16, 2025Source

Software — Database — August 11th, 2025

MSSQL Extension for VS Code 1.34.0 Deepens Copilot Agent Mode, Adds Colour‑Coded Connections
The Azure SQL team has released version 1.34.0 of the MSSQL extension for Visual Studio Code, a cross‑platform tool for developing against SQL Server, Azure SQL Database and SQL Database in Fabric. Carlos Robles, principal product manager at Microsoft, explains that the update continues the extension's goal of making SQL development conversational, visual and local by improving Copilot Agent mode, adding colour-coded connections, streamlining local container workflows and polishing the Schema Designer.
August 11, 2025Source

Software — Database — August 8th, 2025

Sopra Steria bags £115 million legacy extension from UK pensions department after delays to replacement ERP project
New SaaS system awaits a 'fully costed and deliverable integrated plan' before it can support 280,000 employees
August 8, 2025Source

Software — Database — August 4th, 2025

Microsoft's new database migration tool has a temporary security cost
Microsoft has announced that Azure Database Migration Service (DMS) now includes a generally available schema migration feature that simplifies moving data by automatically including schemas, tables, indexes, views and other database objects. With this feature, Microsoft hopes to reduce manual effort and ensure consistency between source and target databases.
August 4, 2025Source

Software — Database — July 29th, 2025

Varonis unveils Next-Gen Database Activity Monitoring for agentless database security and compliance
Varonis released Next-Gen Database Activity Monitoring (DAM), a new approach to database security that deploys quickly and overcomes the challenges legacy vendors face in preventing data breaches and ensuring regulatory compliance.
July 29, 2025Source

Software — Database — July 22nd, 2025

Customers fret about downtime with hyperscalers' PostgreSQL services
Smaller vendors offering alternatives cash in concerns
July 22, 2025Source

Software — Database — July 18th, 2025

Not so SaaSy now: Oracle sugars BYOL deals as AWS database tie-in goes live
Big Red incentivizes perpetual licenses with 76% savings as it parks racks in hyperscaler datacenters
July 18, 2025Source

Software — Database — July 17th, 2025

Rapid AWS Prototyping With LocalStack: A Developer's Guide to Building AWS PoCs Locally
This article shows how to use LocalStack to build and test AWS-based Proof of Concepts (PoCs) entirely on your local machine.
July 17, 2025Source

Software — Database — July 14th, 2025

Understanding Time Series Databases
Time series databases (TSDBs) are specialized database systems optimized for storing, retrieving, and analyzing chronological data.
July 14, 2025Source

Software — Database — July 12th, 2025

Microsoft Launches Azure DevOps MCP Server in Public Preview
The release enables GitHub Copilot to access and interact with Azure DevOps project data using natural language prompts within developer environments such as VS Code.
July 12, 2025Source

Software — Database — July 11th, 2025

Indexed Views in SQL Server: A Production DBA's Complete Guide
Learn indexed views in SQL Server from a seasoned DBA's perspective with practical examples, performance testing, and best practices for database optimization.
July 11, 2025Source

More license upheaval to come after SAP kills RISE with SAP products, users warn
Intro of package for cloud ERP is creating challenges, and more changes likely next year
July 11, 2025Source

Scaling Multi-Tenant Go Apps: Choosing the Right Database Partitioning Approach
Multi-tenant applications face a fundamental challenge: how to efficiently store and query data for tenants of vastly different sizes?
July 11, 2025Source

Testing the MongoDB MCP Server Using SingleStore Kai
In this article, learn how to set up and test the MongoDB MCP Server with SingleStore Kai using MCPHost, notebooks, and real-time queries powered by Ollama LLM.
July 11, 2025Source

When MySQL, PostgreSQL, and Oracle Argue: Doris JDBC Catalog Acts as the Peacemaker
What is this magical Doris JDBC Catalog? It's like a universal key in the data world, opening the doors to multiple databases with one key.
July 11, 2025Source

Software — Database — July 10th, 2025

Write-back to aging UK health systems lessens benefits of Palantir-based platform
Controversial system requires local NHS investment to maximize productivity
July 10, 2025Source

Software — Database — July 7th, 2025

Azure AI Foundry Agent Service Gains Model Context Protocol Support in Preview
Microsoft recently announced the preview release of Model Context Protocol (MCP) support within its Azure AI Foundry Agent Service. The service, which became publicly available in May, aims to significantly boost interoperability for Artificial Intelligence (AI) agents.
July 7, 2025Source

Software — Database — July 5th, 2025

Atlassian's 4 Million PostgreSQL Database Migration: When Standard Cloud Strategies Fail
Atlassian recently migrated 4 million Jira databases to Amazon Aurora, intending to reduce costs and improve the reliability of its Jira Cloud platform. Due to the large number of files involved and the constraints of managed services, the team developed a custom tool to orchestrate the process, as traditional cloud migration strategies were not viable.
July 5, 2025Source

Software — Database — June 23rd, 2025

Building an SQL to DataFrame Converter With ANTLR
ANTLR is a powerful tool that lets you define grammars and build translators. Migrating SQL to DataFrames is tough. ANTLR helps by automating the conversion.
June 23, 2025Source

Private equity types to snap up NoSQL biz Couchbase
$1.5 billion offered for database company valued at $1.2 billion four years ago
June 23, 2025Source

Software — Database — June 18th, 2025

ScyllaDB paddles toward scale and profit with Raft-powered upgrade
Cassandra rival releases new DBaaS relying on consensus algorithm
June 18, 2025Source

Secure DevOps in Serverless Architecture
Mitigating risk in cloud Environments and enabling DevSecOps development lifecycle, enforcing least privilege access, and continuously monitoring workflows.
June 18, 2025Source

Software — Database — June 16th, 2025

Monitoring and Managing the Growth of the MSDB System Database in SQL Server
The msdb system database in SQL Server is crucial for managing and maintaining tasks such as job scheduling, alerts, and database mail. Learn more about it.
June 16, 2025Source

Safeguarding Cloud Databases: Best Practices and Risks Engineers Must Avoid
This article explores database security practices in cloud environments, highlighting risks like misconfigurations, insufficient encryption, and excessive privileges.
June 16, 2025Source

Software — Database — June 13th, 2025

Exploring the IBM App Connect Enterprise SELECT, ROW and THE Functions in ESQL
This article is all about the different ways you can use SELECT in IBM App Connect Enterprise: returning arrays, rows, or just that one perfect value.
June 13, 2025Source

Software — Database — June 6th, 2025

Data Storage and Indexing in PostgreSQL: Practical Guide With Examples and Performance Insights
Explore how PostgreSQL handles large data using TOAST and improves query speed with indexes like B-tree, GIN, and BRIN, cutting query times by over 90%.
June 6, 2025Source

Software — Database — June 3rd, 2025

What is Microsoft Fabric for Azure Cloud (Beyond the Buzz) and How It Competes with Snowflake and Databricks
Microsoft Fabric is a lakehouse built on OneLake Storage in Azure Cloud and competes with Databricks and Snowflake for data analytics and AI.
June 3, 2025Source

Software — Database — May 28th, 2025

Memory-Optimized Tables: Implementation Strategies for SQL Server
Through practical implementation guidance and real-world examples, learn how this in-memory technology can deliver 5- 30x performance improvements for OLTP workloads.
May 28, 2025Source

Software — Database — May 27th, 2025

Data Lake versus Warehouse versus Lakehouse versus Mart: Choosing the Right Architecture for Your Business
Choosing between data lakes, warehouses, lakehouses, and marts depends on your business needs and data maturity. This article breaks each down with real-world examples.
May 27, 2025Source

Software — Database — May 23rd, 2025

Distributed Consensus: Paxos versus Raft and Modern Implementations
In this post we'll explore the fundamentals of distributed consensus, compare Paxos and Raft, and examine recent implementations like Kafka Raft.
May 23, 2025Source

Implementing API Design First in .NET for Efficient Development, Testing, and CI/CD
Even after a decade of API design first being mainstream, the .NET world is still more code first. If you are in same boat then please follow along.
May 23, 2025Source

Microsoft stitches transactional databases to Fabric analytics system
SQL Server and Cosmos DB added to data lake platform as lure for building AI features into transactional systems
May 23, 2025Source

Software — Database — May 13th, 2025

DGS GraphQL and Spring Boot
This article explain how to use and implement DGS GraphQL using Spring Boot, and the GraphQL dashboard to make specific REST requests.
May 13, 2025Source

Software — Database — May 9th, 2025

Power BI Embedded Analytics — Part 2: Power BI Embedded Overview
This article is part of a four-part series. This article covers Power BI Embedded solutions, licensing, authentication, and APIs.
May 9, 2025Source

Revolutionizing Financial Monitoring: Building a Team Dashboard With OpenObserve
Find out how building a unified OpenObserve dashboard transformed my financial monitoring journey—cutting downtime, lowering cost, and enabling proactive operations.
May 9, 2025Source

The Human Side of Logs: What Unstructured Data Is Trying to Tell You
Metrics show what happened. Unstructured data shows why. In this article, we learn why we don't just ignore the messy signals.
May 9, 2025Source

Software — Database — May 6th, 2025

30 years of MySQL, the database that changed the world
From ubiquitous go-to system for early Noughties startups to a legacy like no other
May 6, 2025Source

Software — Database — April 28th, 2025

Building Event-Driven Go Applications With Azure Cosmos DB and Azure Functions
Learn how to build serverless Azure Functions with Go, using Cosmos DB triggers and Azure OpenAI for generating embeddings in this step-by-step guide.
April 28, 2025Source

Software — Database — April 25th, 2025

Azure MCP Server Enters Public Preview: Expanding AI Agent Capabilities
Microsoft has announced the Public Preview of the open-source Azure MCP Server, a new tool designed to enhance the capabilities of AI agents by providing access to Azure resources. The Azure MCP Server allows AI agents to interact with Azure services such as file storage, databases, and logs, and execute CLI commands.
April 25, 2025Source

Software — Database — April 22nd, 2025

How to Restore a Transaction Log Backup in SQL Server
Learn to restore SQL Server transaction log backups step by step, including prerequisites, backup types, troubleshooting errors, and best practices.
April 22, 2025Source

Software — General Information — April 22nd, 2025

Relax, AWS reassessing colo lease talks is just 'routine capacity management'
Hyperscaler says there's no decrease in demand, it's just looking for good deals
April 22, 2025Source

Software — Database — April 4th, 2025

Home Office haunted by 25-year-old asylum system
'Full benefit' of replacement will not be realized until old one is shut down, projects watchdog warns
April 4, 2025Source

How Doris Connects to Multiple Databases for Federated Analytics and Data Migration
Learn how to use Apache Doris's JDBC Catalog to connect multiple databases, enable federated analytics, and migrate data efficiently.
April 4, 2025Source

Software — Database — April 2nd, 2025

Lessons from Migrating an Oracle Database to AWS RDS
Migrating an on-prem Oracle database to AWS RDS brings cost savings and automation but comes with performance tuning limits, upgrade challenges, and DBA restrictions.
April 2, 2025Source

Software — Database — March 31st, 2025

The Notion Formula Ladder: 5 Steps to Proficiency
Notion formulas are a powerful tool for managing data, automating workflows, and enhancing the functionality of your workspace. The video from Thomas Frank Explains explores Notion formulas across five levels of complexity, offering a structured approach to mastering their use. Whether you're a beginner or an advanced user, you'll discover practical insights into formulas, variables, conditional logic, and more, allowing you to optimize your Notion experience.
March 31, 2025Source or Watch Video

Software — Database — March 21st, 2025

How Doris SQL Cache Saved My Daily Morning Meetings
Doris SQL Cache can intelligently remember query results and make repetitive queries as smooth as silk, thus significantly improving query performance.
March 21, 2025Source

Software — General Information — March 21st, 2025

Automating HCP Terraform Workspaces: a New Approach to Team Onboarding
HashiCorp Cloud Platform (HCP) recently elaborated on automating the Terraform workspace creation using a TFE provider and building an onboarding module. This approach addresses the challenge of manual workspace creation, which has been a bottleneck for teams scaling their operations.
March 21, 2025Source

Google Cloud Launches A4 VMs with NVIDIA Blackwell GPUs for AI Workloads
Google Cloud has unveiled its new A4 virtual machines (VMs) in preview, powered by NVIDIA's Blackwell B200 GPUs, to address the increasing demands of advanced artificial intelligence (AI) workloads. The offering aims to accelerate AI model training, fine-tuning, and inference by combining Google's infrastructure with NVIDIA's hardware.
March 21, 2025Source

SmolDocling : Streamlined OCR Document Conversion and Lightweight Understanding
Have you ever found yourself wrestling with bulky OCR tools that demand more resources than your system can handle, only to deliver results that don't quite fit your specific needs? It's a common frustration for anyone trying to streamline document processing workflows, especially when the task at hand requires precision and adaptability. Whether you're dealing with receipts, legal documents, or complex PDFs, the struggle to balance efficiency with accuracy can feel like an uphill battle.
March 21, 2025Source

Software — Database — March 17th, 2025

Best Practices for Data Warehouses in Microsoft Fabric
Leverage Microsoft Fabric for unified data warehousing; follow best practices for schema, ingestion, transformation, security, optimization, and continuous monitoring.
March 17, 2025Source

Celonis slaps SAP with lawsuit claiming it's gatekeeping customer data
Process mining specialist accuses the ERP giant of rigging game with fees, restrictions, and a closed ecosystem
March 17, 2025Source

Software — Database — March 13th, 2025

City council rejects inquiry into £130M Oracle IT disaster
Opposition faults leadership as officers accused of misleading councillors
March 13, 2025Source

How To Prevent WordPress SQL Injection Attacks
What makes WordPress websites such a prime target for hackers? Anders Johansson delves into how WordPress SQL injection attacks work and shares strategies for removing and preventing them.
March 13, 2025Source

Software — Database — March 12th, 2025

MariaDB reboots DBaaS plans with open source at the core
Five years after it launched its first database service, the MySQL fork is trying again
March 12, 2025Source

Software — Database — March 11th, 2025

CRM Database Explained: Definition, Benefits & Best Practices
Learn what a CRM database is, its key features, types, benefits, and best practices, as well as how to choose the right one for your business.
March 11, 2025Source

Europe's largest council kept auditors in the dark on Oracle rollout fiasco for 10 months
It took a whistleblower to expose disastrous ERP go-live
March 11, 2025Source

Software — Database — February 18th, 2025

Oracle extends 19c database support to 2032, making it 'longest strategic release'
Meanwhile, on-prem version of 23ai remains uncertain
February 18, 2025Source

UK electrical utility seeks partner for £81M SAP overhaul as support deadline closes in
Integrations with third-party software await chosen provider
February 18, 2025Source

Software — Database — February 14th, 2025

Critical PostgreSQL bug tied to zero-day attack on US Treasury
High-complexity bug unearthed by infoseccers, as Rapid7 probes exploit further
February 14, 2025Source

PostgreSQL flaw exploited as zero-day in BeyondTrust breach
Rapid7's vulnerability research team says attackers exploited a PostgreSQL security flaw as a zero-day to breach the network of privileged access management company BeyondTrust in December.
February 14, 2025Source

Software — Database — February 10th, 2025

SQL Dynamic Data Masking for Privacy and Compliance
SQL Server Dynamic Data Masking helps protect sensitive data by obscuring it from non-privileged users, ensuring compliance with GDPR, HIPAA, and PCI-DSS.
February 10, 2025Source

Software — Database — February 7th, 2025

Control Your Services With OTEL, Jaeger, and Prometheus
In this article, we will combine OTEL, Jaeger, and Prometheus for faster, centralized observability and quick troubleshooting in distributed systems.
February 7, 2025Source

Data Management With PostgreSQL Partitioning and pg_partman
PostgreSQL table partitioning divides large tables into smaller segments to boost query performance, simplify maintenance, and enable scalable data management.
February 7, 2025Source

Software — Database — February 5th, 2025

Demystifying Sorting Assertions With AssertJ
Know the options for sorting assertions in AssertJ, including ascending/descending order, multiple attributes, null handling, and case-insensitive sorting.
February 5th, 2025Source

Software — Database — February 3rd, 2025

All You Need to Know About Apache Spark
Apache Spark is a fast, open-source cluster computing framework for big data, supporting ML, SQL, and streaming. It's scalable, efficient, and widely used.
February 3rd, 2025Source

Building RAG Apps With Apache Cassandra, Python, and Ollama
A brief introduction to Apache Cassandra for retrieval-augmented generation using Python and Ollama for developing applications free of cost locally or on a server.
February 3rd, 2025Source

'Forbidden Words': Github Reveals How Software Engineers Are Purging Federal Databases
A project called "Remove-DEI" shows the tweaks used to remove "forbidden words" from a database about childhood school readiness.
February 3rd, 2025Source

MuleSoft OAuth 2.0 Provider: Password Grant Type
Learn to configure MuleSoft as an OAuth 2.0 provider with the Password Grant type, securing APIs and managing user authentication with best practices.
February 3rd, 2025Source

Software — Database — January 22nd, 2025

Hybrid Search Using Postgres DB
This article explains how to implement hybrid search (lexical and semantic) in a single PostgresDB using full-text-search and pgvector.
January 22nd, 2025Source

Software — Database — January 20th, 2025

AWS declares it's Iceberg all the way until customers say otherwise
Cloud giant explains its thinking behind support for Apache open table format
January 20th, 2025Source

Troubleshooting Connection Issues When Connecting to MySQL Server
Resolve MySQL connection issues with step-by-step fixes for errors like access denied, host not allowed, and authentication protocol mismatches.
January 20th, 2025Source

Software — Database — January 17th, 2025

Business Logic Database Agent
A natural language agent to create database business logic using declarative rules: an admin web app, API, and database in 1 minute. Download to customize in your IDE.
January 17th, 2025Source

Schema Changes Are a Blind Spot
Schema changes and migrations can quickly spiral into chaos, leading to significant challenges. Let's see how to overcome these challenges.
January 17th, 2025Source

Software — Database — January 13th, 2025

Copy SQL Execution Plan from One Database to Another in Oracle 19c
In this step-by-step guide, we will cover SQL Plan Management (SPM), exporting or importing plans, and fixing execution plans for consistent query behavior.
January 13th, 2025Source

Software — Database — January 10th, 2025

Optimizing SQL Server Performance With AI: Automating Query Optimization and Predictive Maintenance
AI enhances SQL Server performance through query optimization and predictive maintenance, boosts efficiency, reduces latency, and improves system scalability.
January 10th, 2025Source

Software — Database — January 9th, 2025

10 Power BI Techniques to Take Your Reports to The Next Level
Have you ever found yourself staring at a mountain of data, wondering how to make sense of it all? Maybe you've already dipped your toes into Power BI and discovered its potential to transform raw numbers into meaningful insights. But now, you're ready to take things up a notch—to move beyond the basics and create reports that don't just inform but truly engage.
January 9th, 2025Source

Formulating a Robust Strategy for Storage in Amazon Relational Database Service PostgreSQL Deployments
This article explores understanding the key components of RDS storage, optimizing these storage factors, and capping storage growth by utilizing retention periods.
January 9th, 2025Source

High Performance Time - Series Database Design with QuestDB
Vlad Ilyushchenko discusses database design and focuses on geographical data distribution, simplifying data pipelines with HA writes, data visualization with SQL extensions, and providing data scientists with scalable data access.
January 9th, 2025Source

Software — Database — January 8th, 2025

UN's aviation agency confirms attack on recruitment database
Various data points compromised but no risk to flight security
January 8th, 2025Source

Software — Database — January 7th, 2025

Testing Is a Cross-Cutting Concern; So Are Databases
It’s essential to test all database changes cohesively throughout the pipeline. Let’s explore how this can be achieved with a modern approach.
January 7th, 2025Source

Software — Database — January 3rd, 2025

ToDoList 9.0 adds Attribute Editor and MySQL import support amid a host of feature additions
AbstractSpoon Software has unveiled a New Year's gift for fans of its portable Windows to-do manager with the release of ToDoList 9.0.
January 3rd, 2025Source

Software — Database — January 2nd, 2025

Optimizing Performance in Azure Cosmos DB: Best Practices and Tips
Optimize performance, minimize costs, and ensure scalability in Azure Cosmos DB with practices like selecting the right partition key and tuning queries.
January 2nd, 2025Source

Stop Being Afraid of Databases
Ensuring database reliability can be difficult. Our goal is to speed up development and minimize rollbacks. Achieving efficient processes requires database observability.
January 2nd, 2025Source

Software — Database — December 31st, 2024

Microsoft Introduces Serverless GPUs on Azure Container Apps in Public Preview
At the recent Microsoft Ignite conference, the company announced the public preview of Azure Container Apps with serverless GPUs powered by NVIDIA. This feature allows customers to utilize NVIDIA A100 GPUs and NVIDIA T4 GPUs in a serverless environment, providing scaling and flexibility for real-time custom model inferencing and other machine-learning tasks.
December 31st, 2024Source

Software — Database — December 30th, 2024

Setting Up a ScyllaDB Cluster on AWS Using Terraform
This article will teach you how to set up, deploy, manage, and scale ScyllaDB clusters on AWS using Terraform with this comprehensive step-by-step guide.
December 30th, 2024Source

Software — Database — December 25th, 2024

The Future of Data Lies in Transformer Models versus Big Data Transformations
Last year witnessed the explosive rise of large models, generating global enthusiasm and making AI seem like a solution to all problems.
December 25th, 2024Source

Software — Database — December 13th, 2024

Which Flow Is Best for Your Data Needs: Time Series versus Streaming Databases
While both are used to handle time-related data, their underlying technologies and main purpose are built to serve different purposes.
December 13th, 2024Source

Software — Database — December 10th, 2024

In-Depth Analysis of MySQL 8.0 Performance Degradation
We've analyzed the causes of increased response latency in MySQL 8.0. Users can understand the performance decline from both read/write operations and the code level.
December 10th, 2024Source

Software — Database — December 25th, 2024

Azure Boost DPU: Microsoft's New Silicon Solution for Enhanced Cloud Performance
At the recent Ignite conference, Microsoft announced the Azure Boost DPU, its first in-house DPU designed for efficient, low-power, data-centric workloads. According to the company, this single piece of silicon combines high-speed Ethernet and PCIe interfaces, network and storage engines, data accelerators, and security features into a fully programmable system on a chip.
December 25th, 2024Source

Software — Database — November 21st, 2024

Build Autonomous SQL Databases in Microsoft Fabric
Microsoft Fabric is ushering in a new era of database management through its innovative autonomous SQL databases. These innovative databases are designed to streamline your management tasks while significantly enhancing application development capabilities. By seamlessly integrating operational and analytical data across various cloud environments, Microsoft Fabric is set to transform the way you handle and interact with data.
November 21st, 2024Source

Software — Database — November 18th, 2024

How Uber Sped up SQL-based Data Analytics with Presto and Express Queries
Uber uses Presto, an open-source distributed SQL query engine, to provide analytics across several data sources, including Apache Hive, Apache Pinot, MySQL, and Apache Kafka. To improve its performance, Uber engineers explored the advantages of dealing with quick queries, a.k.a. express queries, in a specific way and found they could improve both Presto utilization and response times.
November 18th, 2024Source

Software — Database — November 16th, 2024

Native Vector Support in Azure SQL Database in Public Preview
Microsoft recently launched a public preview of native vector support for the Azure SQL Database. With this update, the database can now store and process vector embeddings directly within it.
November 16th, 2024Source

Software — Database — November 15th, 2024

GraphRAG: Improving global search via dynamic community selection
Retrieval-augmented generation (RAG) allows AI systems to provide additional information and context to a large language model (LLM) when generating a response to a user query. However, traditional RAG-based methods can struggle to retrieve information that requires high-level knowledge of the entire dataset, especially with abstract and global questions such as the keywordless query: "Catch me up on the last two weeks of updates."
November 15th, 2024Source

Software — Database — November 12th, 2024

LocalStack raises $25M to help developers emulate and test cloud apps locally
Knowing how your cloud application will behave in production usually requires significant development and testing in the environment in which it will be deployed, be that AWS, Azure, Google Cloud, or wherever. But this can be a resource-intensive endeavor, particularly with issues relating to latency (the time it takes to constantly send data) and the costs associated with this.
November 12th, 2024Source

Software — Database — November 7th, 2024

Microsoft announces Azure Linux 3.0 for AKS preview
Microsoft has just announced the availability of Azure Linux 3.0 for Azure Kubernetes Service (AKS), which is now available as a preview on AKS version 1.31. Azure Linux 3.0 was made generally available a few months ago on GitHub; you can see the full release notes here.
November 7th, 2024Source

Software — Database — November 5th, 2024

Microsoft Azure Cheat Sheet: Key Services & Commands Guide
The rise of cloud computing provides businesses the ability to quickly provision computing resources without the costly and laborious task of building data centers, and without the costs of running servers with unutilized capacity due to variable workloads.
November 5th, 2024Source

Software — Database — November 3rd, 2024

Hacked TP-Link routers at center of massive botnet used to attack Azure customers
The network is probably still operational and likely acquiring new infrastructure
November 3rd, 2024Source

Software — Database — November 2nd, 2024

Microsoft confirms Azure Virtual Desktop black screen and Office app issues in Windows 10
Microsoft has updated the official Windows Health Dashboard website with a new known issue for those still rocking the good-old Windows 10. According to Microsoft, version 22H2 with recent updates may experience issues logging in to Azure Virtual Desktop and other problems.
November 2nd, 2024Source

Software — DataBase — Resources

A practical comparison of Map-Reduce in MongoDB and RavenDB
Over the past week I've been learning about MongoDB. in my adventures with Node.js I am now at the point where I need some kind of data store.
Provides InformationSource

Access database repair
Access database repair tool for the recovery of corrupt databases in Microsoft Access 95, 97, 2000, 2002 (XP), 2003, 2007, 2010 and 2013. It recovers all data from a corrupt mdb, mde, accdb or accde database even in the hardest cases.
Provides a ServiceSource

Argentum Software
Argentum Corporation — Cataloging Software, Backup Software, Database Software.
Provides ProductsSource

Convert MySQL to MSSQL
MS Access to MySQL converter tool safely converts the database tables or records with password protected records.
Provides ProductsSource

Database DebunkIing
Site dedicated to dispelling fallacies and misconceptions prevailing in the database industry.
Provides InformationSource

Database Normalization and Table structures
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form).
Provides InformationSource

Database Research at Waterloo
Research areas include traditional relational database systems, complex objects, geometric data, text, and real-time data.
Provides InformationSource

David Consulting Group
DCG services include software metrics, software process improvement and outsourcing.
Provides InformationSource

DecisionDatabases.com
DecisionDatabases.com is proficient in providing syndicated research report, customized research reports, company profiles and industry databases across multiple domains.
Provides ProductsSource

Erlangen University Department of Database Systems
Research projects include data warehousing, scientific database management, workflow management, and distributed data.
Provides ProductsSource

InfluxData
An open-source distributed time series database with no external dependencies.
Provides ProductsSource

MySQL in Docker with Java Hibernate
Recently, I started working on a new server project at work, and wanted to be able to run a local dev environment with Docker. this has become my normal flow for a couple of server projects because of how easy Docker is to work with, and especially for the fact that I don't need to set up any of the supporting structure on my machine to run the server.
Provides InformationSource

TechnicalSharp
technical solution for you
Provides InformationSource

Temporal Database Concepts
Defines a wide range of terms and concepts specific to the temporal database research community.
Provides InformationSource

The MerchantStore © 1997 — 2025