Nach Markierungen suchen

Bitemp Remodeler v0.1.0 Released

I’ve been working on a flexible table API generator for Oracle Databases since several months. A TAPI generator doesn’t sound like a real innovation. But this one contains some features you probably have not seen before in… ...read more...

Veröffentlicht 25 Sep 2016 23:21 von triBLOG

Gespeichert unter: Oracle

Last week in Stream Processing & Analytics 8/2/2016

This is the 25th installment of my blog series around Stream Processing and Analytics. As usual, find below the new blog articles, presentations, videos and software releases from last week: News and Blog Posts General IoT Spotlight: Sensor to Dashboard...

Veröffentlicht 2 Aug 2016 20:04 von triBLOG

Gespeichert unter: Oracle, Trivadis, fast data, EDA, nifi, spark-streaming, Stream Processing, kafka, streamsets, streaming-analytics, kafka-streams, azure-stream-analytics, oracle stream analytics

Partial Indexes Trilogy – Part 3: Queries on Partial Indexes

After creating local and global partial indexes, the last part of this blog post trilogy shows how partial indexes are used by the optimizer for SQL queries – especially for queries in Data Warehouse environments. As we have seen before, …...

Veröffentlicht 21 Jul 2016 10:13 von triBLOG

Gespeichert unter: Oracle

Partial Indexes Trilogy – Part 2: Global Partial Indexes

Partial Indexes, introduced with Oracle 12c, are available for local and global indexes. In part 2 of this blog post trilogy, let’s focus on global partial indexes on a partitioned table. Whenever possible, I try to avoid global indexes in … Continue...

Veröffentlicht 8 Jul 2016 18:06 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, Partitioning, Oracle 12c

Partial Indexes Trilogy – Part 1: Local Partial Indexes

Sometimes it would be useful to create indexes for only some of the partitions of a partitioned table. Oracle 12c supports this possibility with Partial Indexes. This blog post shows how local partial indexes can be created – even on … Continue...

Veröffentlicht 28 Jun 2016 23:54 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, Partitioning, Oracle 12c

Trivadis PL/SQL & SQL Coding Guidelines Version 3.1

The latest version 3.1 of the Trivadis PL/SQL & SQL Coding Guidelines has 150 pages. More than 90 additional pages compared to version 2.0. Roger Troller did a tremendous job in updating and extending an already… ...read more...( read more Mehr...

Veröffentlicht 28 Jun 2016 19:47 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, PL/SQL Cop

PL/SQL Bulk Unwrap

406 days ago I’ve released PL/SQL Unwrapper for SQL Developer version 0.1.1 and blogged about it. With this extension you can unwrap the content of a SQL Developer window. Time for an update. With the… ...read more...( read more ) Mehr…

Veröffentlicht 26 Jun 2016 22:44 von triBLOG

Gespeichert unter: Oracle, PL/SQL, SQL Developer, unwrap, oddgen

How to Integrate Your PL/SQL Generators in SQL Developer

About three weeks ago Steven Feuerstein tweeted in his tip #501 a link to a generator for the WHEN clause in DML triggers on Oracle Live SQL. Back than I refactored the generator for oddgen – the… ...read more...( read more ) Mehr…

Veröffentlicht 22 Mai 2016 19:40 von triBLOG

Gespeichert unter: Oracle, SQL Developer, oddgen

Oracle Stream Analytics (OSA): the new Oracle Stream Explorer

A few days ago, Oracle released the new version of Oracle Stream Explorer and renamed it to Oracle Stream Analytics (OSA). This new version is an impressive release with over 15 new major features! It really deserves the name change. Enhanced Patterns...

Veröffentlicht 5 Mai 2016 14:38 von triBLOG

Gespeichert unter: Oracle, Trivadis, Oracle SOA Suite, soa-suite, fast data, EDA, OSA, Stream Processing, streaming-analytics, oracle stream analytics

PL/SQL Cop Meets oddgen

Until August 2015 it never occurred to me that one could use non-PL/SQL code within conditional compilation blocks. Back than we discussed various template engine options as foundation for oddgen – the Oracle community’s dictionary-driven...

Veröffentlicht 26 Apr 2016 21:50 von triBLOG

Gespeichert unter: Oracle, PL/SQL, SQL Developer, TVDCC, PL/SQL Cop, oddgen

Monitoring PL/SQL Code Evolution With PL/SQL Cop for SonarQube

Last week I’ve presented the PL/SQL Cop tool suite to a customer in Germany. While preparing the demo I had taken my first deeper look at the PL/SQL Cop SonarQube plugin, written by Peter Rohner, a… ...read more...( read more ) Mehr…

Veröffentlicht 23 Apr 2016 13:48 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Oracle 12c, TVDCC, PL/SQL Cop, SonarQube

Better call Thomas – Bayes in the Database

This is my third and last post covering my presentations from last week’s Tech Event, and it’s no doubt the craziest one :-). Again I had the honour to be invited by my colleague Ludovico Caldara to participate in the cool “Oracle Database...

Veröffentlicht 4 Mrz 2016 13:10 von triBLOG

Gespeichert unter: Oracle, Performance, statistics, Swingbench, benchmarks, Benchmarking, transparent data encryption, R, Markov Chain Monte Carlo, sampling, JAGS, Bayes, Bayesian

Tune the App, Not the SQL – DBA Sherlock’s Adventures in Hibernate/jOOQ Land

Last weekend at Trivadis Tech Event, in addition to my session on Oracle 12c Client High Availability for Java (Application Continuity, Transaction Guard … choose your degrees of freedom”), I gave a quite different talk called Tune the App...

Veröffentlicht 1 Mrz 2016 16:10 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, optimizer, java, JDBC, Client Programming, Tracing, jOOQ, Hibernate

Oracle 12c Transaction Guard, Application Continuity … choose your degrees of freedom!

Last Saturday at Trivadis Tech Event, I presented on Application Continuity, Transaction Guard … choose your degrees of freedom”. What a strange title, you will be asking! What do Application Continuity (AC) and Transaction Guard (TG) have...

Veröffentlicht 29 Feb 2016 10:22 von triBLOG

Gespeichert unter: Oracle, High Availability, java, RAC, JDBC, Client Programming, Application Continuity, Transaction Guard

Identity Columns and Data Pump

Identity columns were introduced in Oracle 12c to automatically create sequence numbers for a column – usually for the primary key. Interesting question: What is the behavior of identity columns if the table is exported and imported using Data Pump...

Veröffentlicht 15 Feb 2016 16:11 von triBLOG

Gespeichert unter: SQL, Oracle, Oracle 12c

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives