menu
techminis

A naukri.com initiative

google-web-stories
Home

>

Databases

Databases

source image

Dbi-Services

1M

read

381

img
dot

Image Credit: Dbi-Services

SQL Server 2025 – Standard Developer edition

  • SQL Server 2025 introduces the Standard Developer edition for deploying in development, quality, and testing environments without additional licensing fees.
  • The available editions in SQL Server 2025 include Express, Web, Standard, Enterprise, Standard Developer, and Enterprise Developer.
  • The Standard Developer edition solves the issue of using different editions in various environments, ensuring consistency and feature alignment.
  • Installation of the Standard Developer edition can be done easily through the graphical interface or by using a specific PID parameter in the .ini file.

Read Full Article

like

22 Likes

source image

Dbi-Services

1M

read

49

img
dot

Different types of Oracle wallets

  • An Oracle wallet is used to store certificates for Listeners with https protocol or as an encrypted password store for Oracle logins.
  • It is an encrypted, password-protected PKCS#12 container file that can be accessed with openssl tools.
  • Storing credentials in an Oracle wallet is a proprietary extension from Oracle.
  • Different types of Oracle wallets include normal, auto_login, auto_login_local, and auto_login_only.
  • Auto_login wallets allow for non-interactive logins without a password prompt.
  • The auto_login_only wallet does not have a PKCS#12 container and allows access without a password.
  • Wallet types can be determined by analyzing the content using octal dump (od) utility.
  • Converting wallets between auto_login and non-auto-login types is possible with orapki commands.
  • Ensure filesystem permissions are secure and restrict access to wallets for better security.
  • Auto_login_only wallets are suitable for storing trusted certificates for client-connects.

Read Full Article

like

3 Likes

source image

Dev

1M

read

304

img
dot

Image Credit: Dev

AI-Driven SQL Dataset Optimization: Best Practices & Updates for Modern Applications

  • AI research in SQL relies heavily on high-quality datasets for training and evaluation purposes to enhance application capabilities in the field.
  • Recent years have seen the creation of various Text2SQL datasets like Spider and BIRD-SQL, alongside the associated leaderboards for evaluation.
  • New datasets introduced in 2025 include NL2SQL-Bugs dedicated to identifying semantic errors and OmniSQL, the largest cross-domain synthetic dataset.
  • TINYSQL offers a structured text-to-SQL dataset for interpretability research, catering to basic to advanced query tasks for model behavior analysis.
  • The article lists various datasets such as WikiSQL, Spider, SParC, CSpider, CoSQL, and more, emphasizing complexity, cross-domain challenges, and application scenarios.
  • Datasets like SEDE and CHASE introduce unique challenges like complex nesting, date manipulation, and pragmatic context-specific tasks for text-to-SQL.
  • The article acknowledges contributions like EHRSQL for healthcare data, BIRD-SQL for cross-domain datasets, and Archer for bilingual text-to-SQL datasets.
  • Innovations like BEAVER from real enterprise data and PRACTIQ for conversational text-to-SQL datasets continue to advance the field.
  • Diverse datasets like TURSpider in Turkish and synthetic_text_to_sql for high-quality synthetic samples further enrich the text-to-SQL research landscape.
  • Developers are encouraged to explore these datasets, contribute to advancements, and leverage the vast resource of publicly available datasets to improve text-to-SQL models.

Read Full Article

like

18 Likes

source image

Soais

1M

read

422

img
dot

PeopleSoft India SIG 2025- Powering the Future with Innovation and Intelligence

  • The PeopleSoft India Special Interest Group (SIG) 2025 event at Oracle's Technology Hub in Bangalore showcased updates like UX enhancements and machine learning integration for the PeopleSoft community.
  • Key highlights included modernized UI/UX, real-time search with Elastic Search, advanced analytics through Pivot Grid 2.0 and Kibana Dashboards, Cloud Manager enhancements, Docker & Kubernetes support, AI and machine learning features.
  • PeopleTools 8.61 enhancements featured a revamped Fluid UI, mobile optimization, accessibility improvements, and AI integration.
  • Overall, PeopleSoft is evolving with intelligence, agility, visualization, and connectivity, offering smart automation, DevOps tools, insightful dashboards, and secure integration with cloud and AI services.

Read Full Article

like

25 Likes

source image

Soais

1M

read

327

img
dot

Mastering the Keystroke Method in Test Automation

  • The Keystroke Method is an innovative approach to test automation that replicates user behavior by capturing and replaying keyboard inputs and mouse actions, beneficial for complex user interfaces.
  • This technique involves recording and replaying keyboard and mouse inputs to simulate user actions effectively, especially in dynamic UI settings.
  • Implementation steps for the Keystroke Method include selecting nodes in desktop applications, entering values in input fields using keystrokes, moving the mouse cursor with keystrokes, and assigning dynamic objects for mouse click actions.
  • Tools like Worksoft Certify support the Keystroke Method, enabling realistic user experience simulation through automated testing.

Read Full Article

like

19 Likes

source image

Hackernoon

1M

read

299

img
dot

Image Credit: Hackernoon

How to Set Up PostgreSQL with NestJS and Docker for Fast Local Development: A Quick Guide

  • Setting up PostgreSQL with NestJS and Docker for fast local development is essential for new projects.
  • Using Docker to run a local Postgres instance ensures minimal friction, reproducibility, and ease of access.
  • Key components include Dockerfile, docker-compose.yml, .env file, sample NestJS config, and practical development commands.
  • Commands like npm run db to access database shell and npm run api for the app container provide an interactive development workflow.

Read Full Article

like

18 Likes

source image

Amazon

1M

read

327

img
dot

Image Credit: Amazon

How Amazon maintains accurate totals at scale with Amazon DynamoDB

  • Amazon's Finance Technologies Tax team manages tax computation, deduction, and reporting across global jurisdictions using the DynamoDB-tiered tax withholding system.
  • The system processes billions of transactions annually, requiring millisecond latency at scale and accurate tracking of individual transaction values for tax calculations.
  • Challenges include handling tiered tax rates based on cumulative thresholds and maintaining data consistency across high transaction volumes.
  • The solution involves API Gateway, Lambda functions, DynamoDB for tracking cumulative values, and handling error retries using Amazon SQS.
  • Implementation includes atomic conditional writes for updating transaction values and audit records, optimizing throughput and minimizing conflicts.
  • Performance evaluations show increased throughput with concurrency, but also highlight transient conflict trade-offs in highly concurrent scenarios.
  • The DynamoDB conditional write feature allows for simplified, scalable transaction processing without the need for optimistic locking.
  • Authors include Principal Solutions Architect, Principal Engineer, and Software Development Engineers from Amazon Finance Technology.
  • The system's proactive handling of ConditionalCheckFailedExceptions ensures data consistency and high scalability for concurrent transactions.
  • For those looking to implement similar scalable systems, leveraging DynamoDB features and concurrency control mechanisms is essential.

Read Full Article

like

19 Likes

source image

Amazon

1M

read

249

img
dot

Image Credit: Amazon

Build an AI-powered text-to-SQL chatbot using Amazon Bedrock, Amazon MemoryDB, and Amazon RDS

  • Text-to-SQL is a valuable approach leveraging large language models to automate SQL code generation for various data exploration tasks like analyzing sales data and customer feedback.
  • The article discusses building an AI text-to-SQL chatbot using Amazon RDS for PostgreSQL and Amazon Bedrock, with Amazon MemoryDB for accelerated semantic caching.
  • Amazon Bedrock, with foundation models from leading AI companies like AI21 Labs and Amazon, assists in generating embeddings and translating natural language prompts into SQL queries for data interaction.
  • Utilizing semantic caching with Amazon MemoryDB enhances performance by reusing previously generated responses, reducing operational costs and improving scalability.
  • Implementing parameterized SQL safeguards against SQL injection by separating parameter values from SQL syntax, enhancing security in user inputs.
  • The article highlights Table Augmented Generation (TAG) as a method to create searchable embeddings of database metadata, providing structural context for precise SQL responses aligned with data infrastructure.
  • The solution architecture includes creating a PostgreSQL database on Amazon RDS, using Streamlit for the chat application, Amazon Bedrock for SQL query generation, and leveraging AWS Lambda for interactions.
  • The step-by-step guide covers prerequisites, deploying the solution with CDK, loading data to the RDS, testing the text-to-SQL chatbot application, and cleaning up resources efficiently.
  • By following best practices like caching, parameterized SQL, and table augmented generation, the solution showcases enhanced SQL query accuracy and performance in diverse scenarios.
  • Authors Frank Dallezotte and Archana Srinivasan provide insights into leveraging AWS services for scalable solutions and optimizing AI and ML workloads with Amazon RDS and Amazon Bedrock.
  • The demonstration exhibits the capability of the text-to-SQL application to support complex JOINs across multiple tables, emphasizing its versatility and performance.

Read Full Article

like

15 Likes

source image

Dbi-Services

1M

read

109

img
dot

Image Credit: Dbi-Services

SQLDay 2025 – Wrocław – Sessions

  • The SQLDay conference in Wrocław began with a series of sessions covering cloud, DevOps, Microsoft Fabric, AI, and more.
  • Morning Kick-Off: The day started with sponsors' presentation, acknowledging their support for the event.
  • Key Sessions: Sessions included discussions on Composable AI, migrating SQL Server databases to Microsoft Azure, Fabric monitoring, DevOps in legacy teams, productivity solutions, and Azure SQL Managed Instance features.
  • Insights: The sessions provided insights on integrating AI into enterprise architecture, best practices for database migration, monitoring tools for Microsoft Fabric, challenges of introducing DevOps in legacy systems, productivity solutions using AI, and updates on Azure SQL Managed Instance features.

Read Full Article

like

6 Likes

source image

Dbi-Services

1M

read

413

img
dot

Image Credit: Dbi-Services

SQLDay 2025 – Wrocław – Workshops

  • SQLDay 2025 in Wrocław featured pre-conference workshops on various Microsoft Data Platform topics.
  • Workshop sessions included topics such as Advanced DAX, Execution Plans in Depth, Becoming an Azure SQL DBA, Enterprise Databots, Analytics Engineering with dbt, and more.
  • Sessions catered to different professionals, ranging from experienced Power BI users to SQL Server professionals and those transitioning to cloud environments.
  • SQLDay workshops offered valuable insights into Azure, Power BI, SQL Server, and data engineering, providing attendees with practical knowledge and hands-on experiences.

Read Full Article

like

24 Likes

source image

Dbi-Services

1M

read

222

img
dot

Image Credit: Dbi-Services

SQL Server 2025 Public Preview and SSMS 21 now available

  • SQL Server 2025 public preview and SSMS 21 are now available for download.
  • Key changes with SQL Server 2025 include a native vector type, vector index, optimized locking, and REST API enhancement.
  • SSMS 21, based on Visual Studio 2022, offers built-in Copilot integration and a Dark Theme.
  • Users are encouraged to install SSMS 21, provide feedback, and expect more blog posts to showcase new features of SQL Server 2025.

Read Full Article

like

13 Likes

source image

Dev

1M

read

350

img
dot

Image Credit: Dev

Spark Augmented Reality (AR) Filter Engagement Metrics

  • Completed an SQL challenge on interviewmaster.ai involving analyzing engagement metrics of branded AR filters.
  • Query 1: Retrieved AR filters with user interactions in July 2024 and sorted by total interaction count.
  • Query 2: Obtained total interactions per AR filter in August 2024, filtered for filters with over 1000 interactions.
  • Query 3: Identified top 3 AR filters with the most interactions in September 2024.

Read Full Article

like

21 Likes

source image

Dbi-Services

1M

read

86

img
dot

Image Credit: Dbi-Services

PostgreSQL 17-18 major upgrade – blue-green migration with minimal downtime

  • PostgreSQL 18 Beta 1 introduces new features like improved IO on reads, pg_createsubscriber, and pg_upgrade options to facilitate smoother major upgrades through blue-green migration using logical replication technology.
  • pg_createsubscriber automates setting up logical replication by converting a physical standby server into a logical replica without copying initial table data, simplifying the process, especially for large databases.
  • PostgreSQL 18 Beta 1 adds the --all flag to pg_createsubscriber for creating logical replicas for all databases in an instance with a single command, streamlining replication setup in multi-database environments.
  • PostgreSQL 18 brings new capabilities to pg_upgrade, such as the --swap option for faster upgrades, along with improvements like pg_stat_subscription_stats, enhancing monitoring of logical replication write conflicts.
  • The article outlines a step-by-step blue-green migration process starting with setting up the blue (primary) environment with PostgreSQL 17, configuring replication settings, creating a physical replica (green environment), and transitioning to logical replication.
  • The guide covers creating a publication for all tables, using pg_createsubscriber for logical replication setup, upgrading the green environment to PostgreSQL 18 using pg_upgrade with the --swap method, and ensuring successful logical replication post-upgrade.
  • The process involves performing failover and cutover to the upgraded green environment after stopping new writes on the primary, syncing latest LSN, dropping subscription, and executing failover commands to switch application traffic to the upgraded instance.
  • The article concludes with insights on leveraging blue-green migrations for major version jumps, automation using tools like Ansible playbooks, involving DEV teams for testing post-upgrade, and addressing logical replication limitations.

Read Full Article

like

5 Likes

source image

Dev

1M

read

109

img
dot

Image Credit: Dev

Rediscovering ACID – The Foundation of Reliable Databases

  • Engineers are rediscovering the importance of ACID properties in databases like PostgreSQL and MySQL.
  • ACID stands for Atomicity, Consistency, Isolation, and Durability, ensuring reliable transactions.
  • Atomicity guarantees that transactions complete entirely or not at all, exemplified through money transfers.
  • Consistency enforces rules like constraints and foreign keys, Isolation prevents transaction interference, and Durability ensures data persists post-commit.

Read Full Article

like

6 Likes

source image

Dev

1M

read

418

img
dot

Image Credit: Dev

Python for Oracle on ARM Linux | Part 2 - "shell like" SQL scripts

  • Python can be a powerful alternative to shell scripting for Oracle DBAs, providing better readability and cross-platform compatibility.
  • By using Python's subprocess module, DBAs can automate tasks like running SQL commands, managing script execution, and spooling outputs.
  • Key benefits include integration with Python capabilities like data parsing, reporting, and automation frameworks.
  • The essential Python module needed for these tasks is subprocess, which allows running programs such as sqlplus.
  • Setting up variables like connection string, SQL file path, output file path, and command argument is crucial for the process.
  • Subprocess is utilized with shell=True to run the SQL*Plus UNIX command and execute SQL scripts.
  • An example SQL script provided in the article demonstrates data retrieval and JSON processing for weather data.
  • A Python script 'py_ora.py' is created to run SQL files via SQL*Plus, redirecting outputs to a specified file for review.
  • Running 'py_ora.py' in a miniconda environment successfully executes the SQL file and captures the expected outputs.
  • The approach showcased emphasizes the use of Python over traditional shell scripting for Oracle DBA tasks, enhancing automation and maintainability.

Read Full Article

like

25 Likes

For uninterrupted reading, download the app