Databases News, Latest Updates and Recent Announcements on Techminis

A naukri.com initiative

New

Home

Databases

Medium

187

Image Credit: Medium

Advanced Oracle PL/SQL Explained Simply

Oracle PL/SQL is a powerful tool that still runs many of the world's biggest systems.
In this article, the essentials of Oracle PL/SQL are explained simply, including packages, procedures, functions, ref cursors, and loops.
Packages in Oracle PL/SQL are used to organize related logic in one place.
The article provides an example of a package with a procedure to insert an employee and a function to retrieve their salary.

Read Full Article

11 Likes

Medium

421

Image Credit: Medium

The Hidden Art of SQL Optimization: 9 Tricks That Work Like Magic

The real SQL experts know a few powerful tricks to keep databases lightning fast.
Use EXPLAIN (or EXPLAIN ANALYZE) to understand how a query is executed and find areas for optimization.
Avoid retrieving unnecessary data to reduce I/O and memory usage.
Filter rows before performing joins to reduce the dataset the DB engine has to work with.

Read Full Article

25 Likes

Mysql

402

Galera Cluster vs InnoDB Cluster in MySQL 8.4 – preamble

MySQL 8.4 offers two options for High Availability clusters: Galera Cluster and MySQL InnoDB Cluster.
Workload characteristics, application compatibility, and operational preferences are the deciding factors.
Galera Cluster is virtually synchronous, while InnoDB Cluster offers single primary and multi-primary modes.
The webinar will cover topics such as write throughput, read throughput, hot row problem, mixed workload, and node failure & recovery testing.

Read Full Article

24 Likes

Dev

256

Image Credit: Dev

PawSQL for Jetbrains - Optimize your SQL Queries within Jetbrains IDEs

PawSQL for Jetbrains is a powerful plugin that integrates PawSQL engine's SQL optimization capabilities into Jetbrains IDEs.
The plugin supports smart index recommendations, query rewriting, and performance validation.
Developers can optimize SQL queries by selecting the text, right-clicking, and choosing the workspace for optimization.
Installation can be done from Jetbrains Marketplace or by downloading and installing the plugin from disk.

Read Full Article

15 Likes

Dbi-Services

443

PostgreSQL 18: Support for asynchronous I/O

PostgreSQL 18 introduces support for asynchronous I/O, a significant advancement for the platform.
The default setting for the new io_method parameter is 'worker' with a default of 3 worker processes.
Other options for io_method include 'io_uring' for asynchronous I/O using io_uring and 'sync' for traditional synchronous I/O.
The performance impact of different io_method settings is tested using data loading and pgbench benchmarks.
Results show that for the tested workloads, 'worker' is slower compared to 'sync' and 'io_uring'.
Despite the performance differences, the overall impact of the new asynchronous I/O support is significant.
Tests on an AWS EC2 instance running Debian 12 with gp3 storage volume were conducted to validate the performance.
Multiple tests with different io_method settings show comparable performance across 'sync', 'io_uring', and 'worker'.
Increasing system stress with higher client and job counts also results in consistent performance across io_method settings.
The article concludes with optimism about future improvements in PostgreSQL and acknowledges the efforts of those involved in developing the asynchronous I/O support.
The support for asynchronous I/O in PostgreSQL 18 is seen as a significant step forward that promises further enhancements in performance and scalability.

Read Full Article

26 Likes

Eu-Startups

274

“A true Founder’s Fund”: DIG Ventures closes €90 million Fund for early-stage startups

London-based DIG Ventures closes €90 million Fund for early-stage startups.
The institutional LPs backing the fund include The Hillman Company, Granite Capital, Sofina, and Grove Street.
DIG Ventures offers hands-on, operator-led guidance to early-stage founders in scaling their companies.
The fund has already invested in over 15 B2B SaaS, AI, and cloud infrastructure startups.

Read Full Article

16 Likes

Guardian

320

Image Credit: Guardian

Revealed: Big tech’s new datacentres will take water from the world’s driest areas

Big tech companies like Amazon, Microsoft, and Google are operating datacentres in some of the world's driest areas and are planning to build more, raising concerns about their impact on water scarcity.
Efforts to mitigate water use by Amazon have faced opposition from within, with concerns raised about the ethics of their plans.
Datacentres, crucial for remote data storage and processing, require water for cooling, with 38 active datacentres in water-scarce areas identified.
Amazon, Microsoft, and Google are planning a 78% increase in datacentres globally to meet the rising demand for storage, raising environmental concerns.
In regions facing water scarcity, the high water usage of datacentres poses significant challenges, with Microsoft and Google reporting percentages of water consumption in such areas.
Amazon's planned datacentres in Spain's Aragon region have raised concerns over water consumption and energy usage, impacting local communities.
There are worries about the ecological impact of datacentre expansions in dry regions, exacerbating water scarcity and environmental crises.
Amazon, Microsoft, and Google aim to become 'water positive' by 2030 through water offsetting initiatives, which have sparked debates about their effectiveness.
Google and Microsoft are also investing in efficient water usage strategies, amid growing concerns about the local and global implications of water-intensive datacentres.
Trump's 'Project Stargate' highlights the growing investments in AI infrastructure, with concerns raised about water usage and the sustainability of datacentre operations.

Read Full Article

19 Likes

Dev

393

Image Credit: Dev

Backup (and restore) an Sql database inside a docker container.

This script demonstrates how to backup and restore an SQL database inside a Docker container.
The script uses sqlcmd, which is included in many Visual Studio workflows, to connect to the SQL server.
The backup script utilizes the BACKUP DATABASE command to save the database to a specified disk location.
The restore script demonstrates how to restore a database using the RESTORE DATABASE command.

Read Full Article

23 Likes

Dev

164

Image Credit: Dev

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

There are four strings separated into two parts by vertical bar, namely: ID|DUE_DATE, 80781|2026–12–01, VARCHAR2|DATE, |yyyy-mm-dd.
The task is to generate a four-field result set by extracting the first and second parts of each string and writing them as separate records.
While SQL has limited string functions and lacks set related functions, SPL has built-in string processing functions that can parse strings into batch records.
esProc SPL is a suitable solution as it supports ordered sets and allows direct retrieval of set members by position.

Read Full Article

9 Likes

Dev

453

Image Credit: Dev

Free $245 Oracle Certifications till May 15th

Oracle is providing free technical certifications worth $245 till May 15th, 2025.
Courses available for free certification include Oracle AI Vector Search Professional, Oracle APEX Developer Professional, Oracle Fusion Cloud Applications HCM Foundations Associate, Oracle Fusion Cloud Applications ERP Foundations Associate, Oracle Fusion Cloud Applications SCM Foundations Associate, Oracle Fusion Cloud Applications CX Foundations Associate, Oracle Cloud Success Navigator: Essentials Training and Assessment, Become An OCI Foundations Associate, Become a OCI AI Foundations Associate, Oracle APEX: Foundations, Introduction to Oracle Cloud Essentials, and Discover and Train in CyberSecurity.
The certifications cover various topics such as AI-powered applications, no-code/low-code development, human capital management, enterprise resource planning, supply chain management, customer experience, Oracle Cloud Success Navigator, Oracle Cloud Infrastructure, and cybersecurity.
Oracle Cloud certifications and badges are accessible on the Oracle Learning platform.

Read Full Article

27 Likes

Siliconangle

Image Credit: Siliconangle

What to expect at the AI Agent Builder Summit: Join theCUBE April 16

Causal AI is on the rise, with 7 in 10 AI professionals planning to adopt by 2026 for systems that explain decisions and build trust.
Leaders recognize the importance of trust in innovation, stating 'No trust, no ROI.'
The AI Agent Builder Summit by theCUBE on April 16 will cover agentic AI, causal intelligence, and real-world solutions.
The focus will be on transitioning from generative AI to agentic AI systems for better outcomes and understanding.
Agentic AI shifts computing towards proactive systems that learn, collaborate, and operate autonomously within workflows.
Explainability is key, with causal AI gaining traction for transparent decision-making, as correlation doesn't imply causation.
The summit will address barriers in deploying agentic systems and the importance of strategic roadmap and explainability.
Major vendors like IBM and Microsoft are investing in human-interpretable decision support systems and causal AI platforms.
The summit aims to explore AI architectures, workflows, and breakthroughs for trust, clarity, and measurable ROI.
TheCUBE offers extensive coverage and insights from the AI Agent Builder Summit on April 16, available on-demand.

Read Full Article

2 Likes

Dbi-Services

330

PostgreSQL 18: Allow NOT NULL constraints to be added as NOT VALID

In PostgreSQL 17 and earlier versions, NOT NULL constraints are enforced immediately upon creation.
To bypass the constraint, users had to drop it and then re-add it after loading data.
PostgreSQL 18 introduces the ability to add NOT NULL constraints as NOT VALID.
This allows data loading even if constraints would initially be violated.
Constraints added as NOT VALID will not be enforced until validation occurs.
The new feature provides flexibility for data loading and constraint management.
Users can manually fix data inconsistencies before validating constraints.
PostgreSQL 18 now supports adding constraints as NOT VALID for better control.
This enhancement streamlines the process of loading data with constraints.
Users can now add NOT NULL constraints that are deferred until validation.

Read Full Article

19 Likes

Sqldbanow

183

How to Fix: 'Microsoft.ACE.OLEDB.12.0' Provider is Not Registered on the Local Machine

To fix the error 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine while importing Excel or CSV files into SQL Server, you can download the Microsoft Access Database Engine 2016 Redistributable from the official Microsoft download page.
Select the version based on your system - either the 32-bit version (recommended even on 64-bit systems) or the 64-bit version (only if all tools are 64-bit).
After downloading, open Command Prompt as Administrator, navigate to the folder where the .exe file is downloaded, and use the 'AccessDatabaseEngine.exe /quiet' command to install the provider silently without UI interruptions.
Restart SQL Server Management Studio (SSMS) and try the import or export task again, the 'Microsoft.ACE.OLEDB.12.0' provider error should be resolved.

Read Full Article

11 Likes

Dbi-Services

Image Credit: Dbi-Services

Best Practices for Structuring Metadata in M-Files

Metadata in M-Files is used to describe documents and make them easier to find and categorize.
Defining clear and consistent metadata fields such as document type, department, project/client name, and status is crucial.
Utilize metadata card configuration to customize input of relevant data efficiently and improve readability.
Leveraging automatic metadata population reduces manual entry and improves accuracy.

Read Full Article

4 Likes

Medium

151

Image Credit: Medium

My 15-day SQL Challenge Entry Highlights

This article highlights the author's 15-day SQL Challenge entry and their perfect score on three medium and three hard questions.
The author utilized a recursive CTE in the day 12 question.
The author shares their thought process and the steps taken to reach the final answers.
The author also provides a real-world example of how this analysis could be beneficial for a job board like LinkedIn.

Read Full Article

9 Likes

For uninterrupted reading, download the app

Databases

Discover more