-
Oracle 23ai Read-Only Users: Locking Down Accounts Without Breaking the App
Continue reading →: Oracle 23ai Read-Only Users: Locking Down Accounts Without Breaking the AppGranting only SELECT never actually guaranteed a read-only account. Here is what Oracle 23ai’s account-level READ ONLY flag enforces instead, and the ORA-28194 error that caught a report job I didn’t expect to break.
-
A Week With GitHub Copilot in SSMS: What Natural-Language T-SQL Got Right (and Wrong)
Continue reading →: A Week With GitHub Copilot in SSMS: What Natural-Language T-SQL Got Right (and Wrong)I spent a week actually using GitHub Copilot in SSMS on real report requests and blocking investigations instead of ignoring the badge in the corner. Here’s what natural-language T-SQL got right, and the one warning in Microsoft’s own docs worth…
-
Migrating Off NVARCHAR JSON Hacks to SQL Server 2025’s Native JSON Type
Continue reading →: Migrating Off NVARCHAR JSON Hacks to SQL Server 2025’s Native JSON TypeA malformed webhook payload sat undetected for three weeks in an NVARCHAR(MAX) column before it blew up a batch job. Here is how SQL Server 2025’s native json type would have stopped that, and what the ALTER TABLE migration, EF…
-
Fixing Replication Lag with Parallel Logical Replication in Aurora PostgreSQL
Continue reading →: Fixing Replication Lag with Parallel Logical Replication in Aurora PostgreSQLOur nightly batch job kept freezing a downstream reporting dashboard for several minutes, and it turned out our Aurora PostgreSQL subscription was just waiting for one giant transaction to commit. Here’s how turning on parallel logical replication fixed it.
-
SQL Server 2025 Intelligent Query Processing: What Changed at Compatibility Level 170
Continue reading →: SQL Server 2025 Intelligent Query Processing: What Changed at Compatibility Level 170Bumping our database to SQL Server 2025’s compatibility level 170 quietly changed how two of our worst-behaved queries got their execution plans. Here is what Parameter Sensitive Plan optimization’s new DML support and Optional Parameter Plan Optimization actually did, and…
-
Priority Transactions: Letting the Database Roll Back Its Own Blockers in Oracle AI Database 26ai
Continue reading →: Priority Transactions: Letting the Database Roll Back Its Own Blockers in Oracle AI Database 26aiA hung transaction used to mean tracking down the blocker and killing the session by hand. In Oracle AI Database 26ai the database can roll back a lower-priority blocker automatically, and I walk through how to set it up and…
-
Automatic Transaction Quarantine in Oracle AI Database 26ai: When One Bad Transaction Won’t Take Down the Whole Database
Continue reading →: Automatic Transaction Quarantine in Oracle AI Database 26ai: When One Bad Transaction Won’t Take Down the Whole DatabaseOne transaction failing to recover used to mean the whole database could go down until Oracle Support helped you skip past it. In Oracle AI Database 26ai, SMON quarantines that one transaction instead, and I walk through monitoring and resolving…
-
Oracle AI Database 26ai Is a Patch, Not an Upgrade: Reading the New Version Numbers
Continue reading →: Oracle AI Database 26ai Is a Patch, Not an Upgrade: Reading the New Version NumbersI was asked to scope a 26ai upgrade project the way we scoped our last major version move. Turns out if you are already on 23ai, it is just a quarterly patch, and I walk through the new version numbering…
-
WAIT and NOWAIT: Giving Every DML Statement a Lock Timeout
Continue reading →: WAIT and NOWAIT: Giving Every DML Statement a Lock TimeoutWho this is for: anyone who has run a one-off UPDATE, gotten pulled away before committing it, and come back to find three other sessions queued up behind a lock nobody could tell how long to wait for. A teammate…
-
Small Oracle 23ai Syntax Wins That Saved Me Real Time
Continue reading →: Small Oracle 23ai Syntax Wins That Saved Me Real TimeA spreadsheet seed job and a rounding check on the same Friday showed me how much small Oracle 23ai syntax has quietly improved. Here is what multi-row inserts and select without from actually save, and where they still need care.
Oracle ACE Pro · AWS Community Builder
Arvind Toorpu
Oracle Certified Professional and Cloud Ops Database Manager at a financial services firm. Fourteen years architecting and running Oracle, SQL Server, PostgreSQL and MySQL estates, including migrations of hundreds of databases to AWS, Azure and OCI.
This blog is the tuning, recovery, security and migration work behind that — written up as it actually happened, errors included.
Oracle ACE Pro 2026 · AWS Community Builder 2026 · Oracle Certified Professional
Oracle · SQL Server · PostgreSQL · MySQL | AWS · Azure · OCI | Awards · Publications
Browse by topic
Oracle · Backup & Recovery · Administration & Maintenance · Security & Auditing · Cloud & Migration · Performance & Tuning · SQL Server · PostgreSQL & Aurora · All topics →
Latest writing
Hello,
Arvind Toorpu
I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems
Let’s connect
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
