Recently we had a customer who wanted to have read only access to all tables in a schema, even tables not created yet. Apparently in Microsoft SQLServer, there is a way to grant a user schema permissions and includes objects not created yet. THis quick-tip presentation will demonstrate how to setup and deploy permissions to…

Recently we had a customer who wanted to have read only access to all tables in a schema, even tables not created yet. Apparently in Microsoft SQLServer, there is a way to grant a user schema permissions and includes objects not created yet. THis quick-tip presentation will demonstrate how to setup and deploy permissions to…

This session will focus on how Secure-24 leverages Oracle ZFS Storage,  Oracle Intelligent Storage Protocol (OISP), Templates and Oracle 12C RAC to implement a Private Cloud for Oracle 12c RAC applications.   This pairing of Database and Storage hardware through Oracle’s VCA has enabled Secure-24 to take advantage of the unique integration capabilities such as…

You write PL/SQL day in, day out - or maybe just occasionally. You are pressed for time and struggle to write code that runs fast, meets user requirements and is easy to maintain. You find it hard to remember a long list of guidelines and just throw up your hands, hoping to make it through…

This session is targeted at Front-end developers looking to leverage their (Javascript, CSS3, HTML5)  front- end design skills to create Modular Single Page applications with Oracles New Javascript Extension Toolkit (JET) framework. This presentation will include an overview on the JET framework, and discussion around the features and benefits along with a quick comparison on…

This session is targeted at Front-end developers looking to leverage their (Javascript, CSS3, HTML5)  front- end design skills to create Modular Single Page applications with Oracles New Javascript Extension Toolkit (JET) framework. This presentation will include an overview on the JET framework, and discussion around the features and benefits along with a quick comparison on…

Originally introduced for non database data,  Oracle ASM Cluster File System (ACFS) added the support  Oracle database files in Oracle 12c.  Today IT organizations may leverage Oracle ACFS to establish pooling of storage across database, middleware and applications in their private Cloud. Come to this session to explore the Oracle ACFS and how it is…

By introducing the In-Memory column store, Oracle 12c In-Memory Database option is designed to significantly improve query performance for OLAP applications such as Business analytics applications.  Recently released Oracle In-Memory advisor  provides advises on In-Memory  store configuration  and which tables or segments should be loaded into the In-Memory  store and the estimated performance improvements. This…

Oracle Database Appliance is a powerful system and a great platform for consolidating databases. Oracle Enterprise Manager allows you to manage your data as a service. Combine these two technologies and you have an enterprise-class, private database cloud solution at a low entry cost point. This session demonstrates how Oracle Enterprise Manager allows you to…

RMAN as most know it, is one of the most important utilities in a DBAs arsenal. In earlier releases it is fair to say that occasionally it did create havoc and some DBA's were afraid to use it.   Is it too complex? “Backup database” - does not look to complex does it? This session will…