-
Oracle 23ai Read-Only Users: Locking Down Accounts Without Breaking the App
Granting 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)
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 taking seriously.
-
Migrating Off NVARCHAR JSON Hacks to SQL Server 2025’s Native JSON Type
A 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 Core gotchas, and the still-rough new JSON index actually look like.
-
Fixing Replication Lag with Parallel Logical Replication in Aurora PostgreSQL
Our 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
Bumping 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 the monitoring query that broke along the way.
Blog Posts
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.
