corpus.blog
41554 blogs · [ { "id": "01a0c55a-ff02-702b-9543-fd3d7c95c5c8", "title": "Is \"fragmentation\" still a dirty word?", "url": "https://connor-mcdonald.com/2023/05/21/is-fragmentation-still-a-dirty-word/", "published_at": "2023-05-21T03:59:11+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a37802f63", "title": "Can you pass the EMPTY SCHEMA test?", "url": "https://connor-mcdonald.com/2023/05/02/can-you-pass-the-empty-schema-test/", "published_at": "2023-05-02T11:40:51+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a37cb7b7b", "title": "Sample schemas are now easier than ever", "url": "https://connor-mcdonald.com/2023/04/19/sample-schemas-are-now-easier-than-ever/", "published_at": "2023-04-19T02:33:46+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a388c35e3", "title": "Better error messages means less errors", "url": "https://connor-mcdonald.com/2023/04/11/better-error-messages-means-less-errors/", "published_at": "2023-04-11T03:37:20+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a38a17541", "title": "23c for Developers is HERE", "url": "https://connor-mcdonald.com/2023/04/04/23c-for-developers-is-here/", "published_at": "2023-04-04T00:52:13+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a39979728", "title": "Avoiding INSERT glitches with SQL*Plus and SQLcl", "url": "https://connor-mcdonald.com/2023/03/07/avoiding-insert-glitches-with-sqlplus-and-sqlcl/", "published_at": "2023-03-07T10:19:46+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a39edccb1", "title": "A key difference between TP and TPURGENT", "url": "https://connor-mcdonald.com/2023/02/21/a-key-difference-between-tp-and-tpurgent/", "published_at": "2023-02-21T10:09:16+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3a346353", "title": "When EZCONNECT is not so easy", "url": "https://connor-mcdonald.com/2023/02/06/when-ezconnect-is-not-so-easy/", "published_at": "2023-02-06T11:40:43+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3acbe463", "title": "The new forums", "url": "https://connor-mcdonald.com/2023/02/02/the-new-forums/", "published_at": "2023-02-01T23:59:36+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3b655bbf", "title": "SQL engine and PL/SQL functions", "url": "https://connor-mcdonald.com/2023/01/25/sql-engine-and-pl-sql-functions/", "published_at": "2023-01-25T06:53:34+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3b8f4bb2", "title": "The podcast is back for 2023!", "url": "https://connor-mcdonald.com/2023/01/12/the-podcast-is-back-for-2023/", "published_at": "2023-01-12T08:22:03+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3bdd5140", "title": "ORDS upgrades are so easy", "url": "https://connor-mcdonald.com/2023/01/10/ords-upgrades-are-so-easy/", "published_at": "2023-01-10T13:52:14+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3c415fb0", "title": "Audit trails and the importance of TIMEZONE", "url": "https://connor-mcdonald.com/2023/01/06/audit-trails-and-the-importance-of-timezone/", "published_at": "2023-01-06T02:38:11+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3d14d72a", "title": "TEMP is a four letter word", "url": "https://connor-mcdonald.com/2023/01/02/temp-is-a-four-letter-word/", "published_at": "2023-01-02T11:13:54+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3da8577c", "title": "2022 – the year in review", "url": "https://connor-mcdonald.com/2022/12/19/2022-the-year-in-review/", "published_at": "2022-12-19T02:36:05+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3e8ca0fb", "title": "Faster operations with CLOBs", "url": "https://connor-mcdonald.com/2022/12/06/faster-operations-with-clobs/", "published_at": "2022-12-06T06:32:56+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3f348b74", "title": "The cost of DBMS_PARALLEL_EXECUTE", "url": "https://connor-mcdonald.com/2022/11/30/the-cost-of-dbms_parallel_execute/", "published_at": "2022-11-30T09:33:30+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3f608093", "title": "Google-like search for your entire application", "url": "https://connor-mcdonald.com/2022/11/23/google-like-search-for-your-entire-application/", "published_at": "2022-11-23T06:58:11+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a3facf26c", "title": "I did not write this blog post", "url": "https://connor-mcdonald.com/2022/11/11/i-did-not-write-this-blog-post/", "published_at": "2022-11-11T05:51:36+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a4069a318", "title": "From stateful to stateless PL/SQL", "url": "https://connor-mcdonald.com/2022/11/09/from-stateful-to-stateless-pl-sql/", "published_at": "2022-11-09T05:34:50+00:00" }, { "id": "01a0c563-62fb-720f-a855-1b5a40ad8f7f", "title": "A Security Disaster", "url": "https://connor-mcdonald.com/2022/11/02/a-security-disaster/", "published_at": "2022-11-02T07:27:03+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5b411140", "title": "The Halloween Pumpkins of Terror", "url": "https://connor-mcdonald.com/2022/11/01/the-halloween-pumpkins-of-terror/", "published_at": "2022-11-01T05:23:58+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5b6a6170", "title": "CloudWorld is done!", "url": "https://connor-mcdonald.com/2022/10/27/cloudworld-is-done/", "published_at": "2022-10-27T02:33:50+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5b82448e", "title": "CloudWorld – Thursday Thrills", "url": "https://connor-mcdonald.com/2022/10/20/cloudworld-thursday-thrills/", "published_at": "2022-10-20T15:44:28+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5bf9b295", "title": "CloudWorld – Wednesday Avawanche", "url": "https://connor-mcdonald.com/2022/10/19/cloudworld-wednesday-avawanche/", "published_at": "2022-10-19T14:13:54+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5bfab29c", "title": "Easy data access from Excel #JoelKallmanDay", "url": "https://connor-mcdonald.com/2022/10/11/easy-data-access-from-excel-joelkallmanday/", "published_at": "2022-10-10T23:40:32+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5c795d2d", "title": "Quick Tip on Datapatch", "url": "https://connor-mcdonald.com/2022/10/06/quick-tip-on-datapatch/", "published_at": "2022-10-06T07:00:20+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5d77c69c", "title": "CloudWorld – Tuesday Turmoil", "url": "https://connor-mcdonald.com/2022/10/05/cloudworld-tuesday-turmoil/", "published_at": "2022-10-05T05:56:03+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5e2a3fe1", "title": "What are the Squirrels doing? SQL fun and games", "url": "https://connor-mcdonald.com/2022/09/29/what-are-the-squirrels-doing-sql-fun-and-games/", "published_at": "2022-09-29T03:17:00+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5e7828b7", "title": "Patching just keeps getting easier", "url": "https://connor-mcdonald.com/2022/09/27/patching-just-keeps-getting-easier/", "published_at": "2022-09-27T09:59:51+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5f6c9112", "title": "Can you FLASHBACK an IDENTITY column?", "url": "https://connor-mcdonald.com/2022/09/26/can-you-flashback-an-identity-column/", "published_at": "2022-09-26T12:20:28+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc5f9832af", "title": "INTERVAL partitions in multiple tablespaces", "url": "https://connor-mcdonald.com/2022/09/09/interval-partitions-in-multiple-tablespaces/", "published_at": "2022-09-09T08:24:46+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc602c1812", "title": "XMLTABLE and data “corruption”", "url": "https://connor-mcdonald.com/2022/08/26/xmltable-and-data-corruption/", "published_at": "2022-08-26T09:27:39+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc607d572b", "title": "The DBMS_REDEFINITION trap", "url": "https://connor-mcdonald.com/2022/08/17/the-dbms_redefinition-trap/", "published_at": "2022-08-17T09:37:23+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc6082be6f", "title": "Natural Keys versus Surrogate Keys….Here we are again!", "url": "https://connor-mcdonald.com/2022/08/10/natural-keys-versus-surrogate-keys-here-we-are-again/", "published_at": "2022-08-10T10:24:44+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc6156a057", "title": "A simple benchmark harness", "url": "https://connor-mcdonald.com/2022/08/08/a-simple-benchmark-harness/", "published_at": "2022-08-08T05:08:40+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc61d0c626", "title": "Powerpoint hack for tech presenters", "url": "https://connor-mcdonald.com/2022/08/05/powerpoint-hack-for-tech-presenters/", "published_at": "2022-08-05T02:03:36+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc6230d1ce", "title": "Juice up your JSON on Autonomous", "url": "https://connor-mcdonald.com/2022/07/14/juice-up-your-json-on-autonomous/", "published_at": "2022-07-14T03:49:32+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc62d97542", "title": "Digging deeper into SQL under APEX", "url": "https://connor-mcdonald.com/2022/07/12/digging-deeper-into-sql-under-apex/", "published_at": "2022-07-12T02:24:33+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc63c48cf6", "title": "PL/SQL – choosing the BEST data type", "url": "https://connor-mcdonald.com/2022/07/08/pl-sql-choosing-the-best-data-type/", "published_at": "2022-07-08T06:32:34+00:00" }, { "id": "01a0c56a-cca9-70d8-9794-39cc63ee0abc", "title": "Kscope 22 – the joy of in-person conferences", "url": "https://connor-mcdonald.com/2022/07/07/kscope-22-the-joy-of-in-person-conferences/", "published_at": "2022-07-07T09:47:38+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644222b80e", "title": "Comparing two database objects for differences", "url": "https://connor-mcdonald.com/2022/06/08/comparing-two-database-objects-for-differences/", "published_at": "2022-06-08T09:59:04+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-266442f698e5", "title": "Recycling saves the planet but maybe not your database", "url": "https://connor-mcdonald.com/2022/05/30/recycling-saves-the-planet-but-maybe-not-your-database/", "published_at": "2022-05-30T06:58:53+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-266443e14d1c", "title": "Is my table marked for archive?", "url": "https://connor-mcdonald.com/2022/05/25/is-my-table-marked-for-archive/", "published_at": "2022-05-25T08:06:40+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-2664442afa9f", "title": "Version 7 was so much better…", "url": "https://connor-mcdonald.com/2022/05/13/version-7-was-so-much-better/", "published_at": "2022-05-13T04:17:18+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644483fb4b", "title": "The Fractional Part of a TIMESTAMP. Be careful.", "url": "https://connor-mcdonald.com/2022/05/12/the-fractional-part-of-a-timestamp-be-careful/", "published_at": "2022-05-12T07:24:00+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644529a4bf", "title": "Implementing dynamic partitions AND subpartitions", "url": "https://connor-mcdonald.com/2022/04/22/implementing-dynamic-partitions-and-subpartitions/", "published_at": "2022-04-22T06:55:28+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644600dd2f", "title": "DBMS_OUTPUT … A (formatting) love story", "url": "https://connor-mcdonald.com/2022/04/19/dbms_output-a-love-story/", "published_at": "2022-04-19T02:38:11+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-266446d5eda7", "title": "My poor developers! PLSQL is going to be so hard on them!", "url": "https://connor-mcdonald.com/2022/04/13/my-poor-developers-plsql-is-going-to-be-so-hard-on-them/", "published_at": "2022-04-13T07:08:34+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-266446fa1dfb", "title": "A little bit of PLSQL and a little bit of network", "url": "https://connor-mcdonald.com/2022/04/12/a-little-bit-of-plsql-and-a-little-bit-of-network/", "published_at": "2022-04-12T02:20:26+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-266447da78d7", "title": "A little bit of PLSQL can be a huge win", "url": "https://connor-mcdonald.com/2022/04/11/a-little-bit-of-plsql-can-be-a-huge-win/", "published_at": "2022-04-11T07:53:40+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644828e9fc", "title": "DBMS_METADATA for INDEXES", "url": "https://connor-mcdonald.com/2022/04/06/dbms_metadata-for-indexes/", "published_at": "2022-04-05T23:34:20+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-266448302df7", "title": "Enforcing DEFAULT values", "url": "https://connor-mcdonald.com/2022/03/30/enforcing-default-values/", "published_at": "2022-03-30T06:56:20+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644846c7dc", "title": "Block recovery a lot easier than I thought", "url": "https://connor-mcdonald.com/2022/03/28/block-recovery-a-lot-easier-than-i-thought/", "published_at": "2022-03-28T06:20:45+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-266448eeaeaa", "title": "When re-ordering columns is warranted", "url": "https://connor-mcdonald.com/2022/03/22/when-re-ordering-columns-is-warranted/", "published_at": "2022-03-22T04:01:30+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644931425a", "title": "Don’t run tight on PGA", "url": "https://connor-mcdonald.com/2022/03/10/dont-run-tight-on-pga/", "published_at": "2022-03-10T07:04:31+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-266449dfc29e", "title": "After you clone your pluggable database", "url": "https://connor-mcdonald.com/2022/03/07/after-you-clone-your-pluggable-database/", "published_at": "2022-03-07T08:02:03+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644a7c0c6e", "title": "Cleaner DDL than DBMS_METADATA", "url": "https://connor-mcdonald.com/2022/03/02/cleaner-ddl-than-dbms_metadata/", "published_at": "2022-03-02T08:58:32+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644b32c0e7", "title": "INITRANS grabs a little more space", "url": "https://connor-mcdonald.com/2022/02/16/intrans-grabs-a-little-more-space/", "published_at": "2022-02-16T03:43:56+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644c27e4bc", "title": "V$SESSION_LONGOPS and parallel query", "url": "https://connor-mcdonald.com/2022/02/11/vsession_longops-and-parallel-query/", "published_at": "2022-02-11T08:06:27+00:00" }, { "id": "01a0c573-b978-70dd-ab9b-26644cd3b0cc", "title": "A new dictionary view for privileges", "url": "https://connor-mcdonald.com/2022/02/06/a-new-dictionary-view-for-privileges/", "published_at": "2022-02-06T09:42:43+00:00" }, { "id": "01a0c581-ba95-706f-a641-de250067e4e8", "title": "Awesome DATE / TIMESTAMP enhancement in Autonomous Database", "url": "https://connor-mcdonald.com/2022/02/02/awesome-date-timestamp-enhancement-in-autonomous-database/", "published_at": "2022-02-02T01:18:09+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2500ee99a7", "title": "Silent data corruption – constraints spanning multiple rows", "url": "https://connor-mcdonald.com/2022/01/31/silent-data-corruption-constraints-spanning-multiple-rows/", "published_at": "2022-01-31T06:44:36+00:00" }, { "id": "01a0c581-ba95-706f-a641-de25015129a5", "title": "New Podcast Episode – The Optimizer with Nigel Bayliss", "url": "https://connor-mcdonald.com/2022/01/25/new-podcast-episode-the-optimizer-with-nigel-bayliss/", "published_at": "2022-01-25T05:49:11+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2501ec6c21", "title": "Careful with SQL*Plus and SQL_ID feedback", "url": "https://connor-mcdonald.com/2022/01/17/careful-with-sqlplus-and-sql_id-feedback/", "published_at": "2022-01-17T06:25:01+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2502743522", "title": "UTL_HTTP, secure hosts and ORA-24263 certificate errors", "url": "https://connor-mcdonald.com/2022/01/13/utl_http-secure-hosts-and-ora-24263-certificate-errors/", "published_at": "2022-01-13T05:23:34+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2502db4b8e", "title": "New Podcast Episode! Why every DBA should learn APEX", "url": "https://connor-mcdonald.com/2022/01/06/new-podcast-episode-why-every-dba-should-learn-apex/", "published_at": "2022-01-06T05:54:13+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2503566df7", "title": "Wrapping up 2021", "url": "https://connor-mcdonald.com/2021/12/23/wrapping-up-2021/", "published_at": "2021-12-23T15:31:40+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2503d11446", "title": "Twas the night before … log4j", "url": "https://connor-mcdonald.com/2021/12/22/twas-the-night-before-log4j/", "published_at": "2021-12-22T01:24:14+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2504b8d25f", "title": "Christmas SQL", "url": "https://connor-mcdonald.com/2021/12/20/christmas-sql/", "published_at": "2021-12-20T03:12:30+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2504eda068", "title": "Detecting if your database is multitenant", "url": "https://connor-mcdonald.com/2021/12/13/detecting-if-your-database-is-multitenant/", "published_at": "2021-12-13T01:40:02+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2505663bf7", "title": "SQL*Plus shortcut for fast data unload", "url": "https://connor-mcdonald.com/2021/12/06/sqlplus-shortcut-for-fast-data-unload/", "published_at": "2021-12-06T13:15:07+00:00" }, { "id": "01a0c581-ba95-706f-a641-de25058b5d3b", "title": "The Importance Of Testing", "url": "https://connor-mcdonald.com/2021/11/29/the-importance-of-testing/", "published_at": "2021-11-29T07:08:48+00:00" }, { "id": "01a0c581-ba95-706f-a641-de250643e013", "title": "Testing versus the Database", "url": "https://connor-mcdonald.com/2021/11/22/testing-versus-the-database/", "published_at": "2021-11-22T07:21:30+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2506e6e71b", "title": "SQL Macros – complex SQL made easy. Elapsed time calculation", "url": "https://connor-mcdonald.com/2021/11/16/sql-macros-complex-sql-made-easy-elapsed-time-calculation/", "published_at": "2021-11-16T05:58:53+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2507a705c7", "title": "The big table dilemma – what about transaction rates?", "url": "https://connor-mcdonald.com/2021/11/14/the-big-table-dilemma-what-about-transaction-rates/", "published_at": "2021-11-14T05:38:00+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2507ea4fd2", "title": "When does a table become too big?", "url": "https://connor-mcdonald.com/2021/11/13/when-does-a-table-become-too-big/", "published_at": "2021-11-13T09:21:19+00:00" }, { "id": "01a0c581-ba95-706f-a641-de25080ccb45", "title": "Formula 1 data–staying up to date", "url": "https://connor-mcdonald.com/2021/11/12/formula-1-data-staying-up-to-date/", "published_at": "2021-11-12T01:30:06+00:00" }, { "id": "01a0c581-ba95-706f-a641-de25088f510f", "title": "Database World 2021 – now it is your turn", "url": "https://connor-mcdonald.com/2021/11/08/database-world-2021-now-it-is-your-turn/", "published_at": "2021-11-08T06:34:49+00:00" }, { "id": "01a0c581-ba95-706f-a641-de2508c1fea5", "title": "APEX demos – Formula 1 Racing Data ?", "url": "https://connor-mcdonald.com/2021/11/05/apex-demos-formula-1-racing-data/", "published_at": "2021-11-05T14:08:58+00:00" }, { "id": "01a0c581-ba95-706f-a641-de25095d779a", "title": "Quick and easy sample data", "url": "https://connor-mcdonald.com/2021/11/02/quick-and-easy-sample-data/", "published_at": "2021-11-02T08:15:47+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0ab34012f", "title": "Keeping my SQLcl toasty fresh!", "url": "https://connor-mcdonald.com/2021/10/29/keeping-my-sqlcl-toasty-fresh/", "published_at": "2021-10-29T02:32:32+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0abab7e23", "title": "New podcast episode! ORACLE-BASE enters the chat", "url": "https://connor-mcdonald.com/2021/10/19/new-podcast-episode-oracle-base-enters-the-chat/", "published_at": "2021-10-19T08:36:19+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0ac069966", "title": "19c Express Edition #JoelKallmanDay", "url": "https://connor-mcdonald.com/2021/10/11/19c-express-edition-joelkallmanday/", "published_at": "2021-10-11T05:37:13+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0ac33b839", "title": "The HOST command in SQL*Plus and SQLcl", "url": "https://connor-mcdonald.com/2021/10/07/the-host-command-in-sqlplus-and-sqlcl/", "published_at": "2021-10-07T06:53:43+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0ac5466de", "title": "Get the SQL_ID for a SQL statement BEFORE you run it", "url": "https://connor-mcdonald.com/2021/10/04/get-the-sql_id-for-a-sql-statement-before-you-run-it/", "published_at": "2021-10-04T07:10:34+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0ac564fa8", "title": "Integration with SQL", "url": "https://connor-mcdonald.com/2021/09/30/integration-with-sql/", "published_at": "2021-09-30T10:14:58+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0acc3f94c", "title": "EZconnect for SQL*Plus", "url": "https://connor-mcdonald.com/2021/09/24/ezconnect-for-sqlplus/", "published_at": "2021-09-24T08:50:38+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0aceac457", "title": "21cXE – post install tip", "url": "https://connor-mcdonald.com/2021/09/23/21cxe-post-install-tip/", "published_at": "2021-09-23T01:17:50+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0addd2751", "title": "Is my table temporal?", "url": "https://connor-mcdonald.com/2021/09/17/is-my-table-temporal/", "published_at": "2021-09-17T08:47:31+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0aeb0f120", "title": "SQL trace on your cloud database", "url": "https://connor-mcdonald.com/2021/09/15/sql-trace-on-your-cloud-database/", "published_at": "2021-09-15T05:31:24+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0af099ecc", "title": "Can you solve this blocksize puzzle?", "url": "https://connor-mcdonald.com/2021/09/09/can-you-solve-this-blocksize-puzzle/", "published_at": "2021-09-09T06:37:54+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0af8e126c", "title": "New Podcast Episode! The most important skill you need", "url": "https://connor-mcdonald.com/2021/09/06/new-podcast-episode-the-most-important-skill-you-need/", "published_at": "2021-09-06T05:09:56+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0b016773b", "title": "Before you case-insensitive your whole database!", "url": "https://connor-mcdonald.com/2021/09/02/before-you-case-insensitive-your-whole-database/", "published_at": "2021-09-02T03:24:14+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0b05e1b7c", "title": "21c … a more secure DataPump", "url": "https://connor-mcdonald.com/2021/08/30/21c-a-more-secure-datapump/", "published_at": "2021-08-30T02:17:26+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0b114d174", "title": "21c database creation seems to hang", "url": "https://connor-mcdonald.com/2021/08/25/21c-database-creation-seems-to-hang/", "published_at": "2021-08-25T02:54:54+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0b1d19ab2", "title": "21c software installation OS groups", "url": "https://connor-mcdonald.com/2021/08/18/21c-software-installation-os-groups/", "published_at": "2021-08-18T04:50:06+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0b1f61fb3", "title": "21c software … where did everything go?", "url": "https://connor-mcdonald.com/2021/08/16/21c-software-where-did-everything-go/", "published_at": "2021-08-16T05:12:00+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0b22f5886", "title": "New podcast episode! Testing and breaking things", "url": "https://connor-mcdonald.com/2021/08/09/new-podcast-episode-testing-and-breaking-things/", "published_at": "2021-08-09T04:54:18+00:00" }, { "id": "01a0c58f-a16f-7018-8c2f-91e0b28c0db5", "title": "We killed sequence contention!", "url": "https://connor-mcdonald.com/2021/08/06/we-killed-sequence-contention/", "published_at": "2021-08-06T06:53:00+00:00" } ] posts Claim your blog
Back to connor-mcdonald.com
Blog · corpus.blog/blogs/connor-mcdonald.com/posts

connor-mcdonald.com

connor-mcdonald.com

2023

Is "fragmentation" still a dirty word?original ↗
21 May 2023
Can you pass the EMPTY SCHEMA test?original ↗
2 May 2023
Sample schemas are now easier than everoriginal ↗
19 Apr 2023
Better error messages means less errorsoriginal ↗
11 Apr 2023
23c for Developers is HEREoriginal ↗
4 Apr 2023
Avoiding INSERT glitches with SQL*Plus and SQLcloriginal ↗
7 Mar 2023
A key difference between TP and TPURGENToriginal ↗
21 Feb 2023
When EZCONNECT is not so easyoriginal ↗
6 Feb 2023
The new forumsoriginal ↗
1 Feb 2023
SQL engine and PL/SQL functionsoriginal ↗
25 Jan 2023
The podcast is back for 2023!original ↗
12 Jan 2023
ORDS upgrades are so easyoriginal ↗
10 Jan 2023
Audit trails and the importance of TIMEZONEoriginal ↗
6 Jan 2023
TEMP is a four letter wordoriginal ↗
2 Jan 2023

2022

2022 – the year in revieworiginal ↗
19 Dec 2022
Faster operations with CLOBsoriginal ↗
6 Dec 2022
The cost of DBMS_PARALLEL_EXECUTEoriginal ↗
30 Nov 2022
Google-like search for your entire applicationoriginal ↗
23 Nov 2022
I did not write this blog postoriginal ↗
11 Nov 2022
From stateful to stateless PL/SQLoriginal ↗
9 Nov 2022
A Security Disasteroriginal ↗
2 Nov 2022
The Halloween Pumpkins of Terrororiginal ↗
1 Nov 2022
CloudWorld is done!original ↗
27 Oct 2022
CloudWorld – Thursday Thrillsoriginal ↗
20 Oct 2022
CloudWorld – Wednesday Avawancheoriginal ↗
19 Oct 2022
Easy data access from Excel #JoelKallmanDayoriginal ↗
10 Oct 2022
Quick Tip on Datapatchoriginal ↗
6 Oct 2022
CloudWorld – Tuesday Turmoiloriginal ↗
5 Oct 2022
What are the Squirrels doing? SQL fun and gamesoriginal ↗
29 Sept 2022
Patching just keeps getting easieroriginal ↗
27 Sept 2022
Can you FLASHBACK an IDENTITY column?original ↗
26 Sept 2022
INTERVAL partitions in multiple tablespacesoriginal ↗
9 Sept 2022
XMLTABLE and data “corruption”original ↗
26 Aug 2022
The DBMS_REDEFINITION traporiginal ↗
17 Aug 2022
Natural Keys versus Surrogate Keys….Here we are again!original ↗
10 Aug 2022
A simple benchmark harnessoriginal ↗
8 Aug 2022
Powerpoint hack for tech presentersoriginal ↗
5 Aug 2022
Juice up your JSON on Autonomousoriginal ↗
14 Jul 2022
Digging deeper into SQL under APEXoriginal ↗
12 Jul 2022
PL/SQL – choosing the BEST data typeoriginal ↗
8 Jul 2022
Kscope 22 – the joy of in-person conferencesoriginal ↗
7 Jul 2022
Comparing two database objects for differencesoriginal ↗
8 Jun 2022
Recycling saves the planet but maybe not your databaseoriginal ↗
30 May 2022
Is my table marked for archive?original ↗
25 May 2022
Version 7 was so much better…original ↗
13 May 2022
The Fractional Part of a TIMESTAMP. Be careful.original ↗
12 May 2022
Implementing dynamic partitions AND subpartitionsoriginal ↗
22 Apr 2022
DBMS_OUTPUT … A (formatting) love storyoriginal ↗
19 Apr 2022
My poor developers! PLSQL is going to be so hard on them!original ↗
13 Apr 2022
A little bit of PLSQL and a little bit of networkoriginal ↗
12 Apr 2022
A little bit of PLSQL can be a huge winoriginal ↗
11 Apr 2022
DBMS_METADATA for INDEXESoriginal ↗
5 Apr 2022
Enforcing DEFAULT valuesoriginal ↗
30 Mar 2022
Block recovery a lot easier than I thoughtoriginal ↗
28 Mar 2022
When re-ordering columns is warrantedoriginal ↗
22 Mar 2022
Don’t run tight on PGAoriginal ↗
10 Mar 2022
After you clone your pluggable databaseoriginal ↗
7 Mar 2022
Cleaner DDL than DBMS_METADATAoriginal ↗
2 Mar 2022
INITRANS grabs a little more spaceoriginal ↗
16 Feb 2022
V$SESSION_LONGOPS and parallel queryoriginal ↗
11 Feb 2022
A new dictionary view for privilegesoriginal ↗
6 Feb 2022
Awesome DATE / TIMESTAMP enhancement in Autonomous Databaseoriginal ↗
2 Feb 2022
Silent data corruption – constraints spanning multiple rowsoriginal ↗
31 Jan 2022
New Podcast Episode – The Optimizer with Nigel Baylissoriginal ↗
25 Jan 2022
Careful with SQL*Plus and SQL_ID feedbackoriginal ↗
17 Jan 2022
UTL_HTTP, secure hosts and ORA-24263 certificate errorsoriginal ↗
13 Jan 2022
New Podcast Episode! Why every DBA should learn APEXoriginal ↗
6 Jan 2022

2021

Wrapping up 2021original ↗
23 Dec 2021
Twas the night before … log4joriginal ↗
22 Dec 2021
Christmas SQLoriginal ↗
20 Dec 2021
Detecting if your database is multitenantoriginal ↗
13 Dec 2021
SQL*Plus shortcut for fast data unloadoriginal ↗
6 Dec 2021
The Importance Of Testingoriginal ↗
29 Nov 2021
Testing versus the Databaseoriginal ↗
22 Nov 2021
SQL Macros – complex SQL made easy. Elapsed time calculationoriginal ↗
16 Nov 2021
The big table dilemma – what about transaction rates?original ↗
14 Nov 2021
When does a table become too big?original ↗
13 Nov 2021
Formula 1 data–staying up to dateoriginal ↗
12 Nov 2021
Database World 2021 – now it is your turnoriginal ↗
8 Nov 2021
APEX demos – Formula 1 Racing Data ?original ↗
5 Nov 2021
Quick and easy sample dataoriginal ↗
2 Nov 2021
Keeping my SQLcl toasty fresh!original ↗
29 Oct 2021
New podcast episode! ORACLE-BASE enters the chatoriginal ↗
19 Oct 2021
19c Express Edition #JoelKallmanDayoriginal ↗
11 Oct 2021
The HOST command in SQL*Plus and SQLcloriginal ↗
7 Oct 2021
Get the SQL_ID for a SQL statement BEFORE you run itoriginal ↗
4 Oct 2021
Integration with SQLoriginal ↗
30 Sept 2021
EZconnect for SQL*Plusoriginal ↗
24 Sept 2021
21cXE – post install tiporiginal ↗
23 Sept 2021
Is my table temporal?original ↗
17 Sept 2021
SQL trace on your cloud databaseoriginal ↗
15 Sept 2021
Can you solve this blocksize puzzle?original ↗
9 Sept 2021
New Podcast Episode! The most important skill you needoriginal ↗
6 Sept 2021
Before you case-insensitive your whole database!original ↗
2 Sept 2021
21c … a more secure DataPumporiginal ↗
30 Aug 2021
21c database creation seems to hangoriginal ↗
25 Aug 2021
21c software installation OS groupsoriginal ↗
18 Aug 2021
21c software … where did everything go?original ↗
16 Aug 2021
New podcast episode! Testing and breaking thingsoriginal ↗
9 Aug 2021
We killed sequence contention!original ↗
6 Aug 2021
Previous Next