Oracle PL/SQL Performance Tuning Tips & Techniques

PL-SQL Performance Tuning Cover2

Dulcian’s Michael Rosenblum and Dr. Paul Dorsey have just completed another book for Oracle Press: Oracle PL/SQL Performance Tuning Tips & Techniques This book present a hands-on approach to enabling optimal results from PL/SQL. The book begins by describing the discovery

Tagged with: , , , , ,
Posted in BLOG, Code tips, Development, Dulcian News, News, Oracle, Our Books, PL/SQL, Publications, Resources, What's New

The BEST IT Project Management Book Ever is: “If Disney Ran Your Hospital”

If Disney Ran Your Hospital: 9 1/2 Things you Would Do Differently (Fred Lee, 2004, Second River Healthcare) is not even an IT book. As the title suggests, it is about hospital administration.  But no book has influenced my thinking about project

Tagged with: , , ,
Posted in About Dulcian, BLOG, Consulting, Other

Top 5 Issues that Cannot be Resolved by DBAs at NYOUG

The New York Oracle Users Group held its Spring General Meeting yesterday. It was a great meeting with great speakers, including: Alex Gorbatchev from Pythian gave a presentation about eliminating guesswork from our decision making process in Oracle (BAAG Party) Michael Rosenblum – Dulcian, Inc. discussing common system issues

Tagged with: , , ,
Posted in Conferences, Events

“We don’t want to be dependent upon Oracle.”

I have lost a lot of projects due the little sentence: “We don’t want to be dependent upon Oracle.”  (I just lost another one this week.) It has been used to justify all sorts of crazy decisions such as: Spend millions of

Tagged with: , , ,
Posted in Consulting, Development, Products, Resources, Training

Case-sensitive object names

A tip/funny story from our colleague Grigoriy Novikov: There was one project with which I was involved that required a lot of different tools used by a lot of developers with different fields of expertise. The Java developer group was

Tagged with: , , , ,
Posted in Code tips, Consulting, Resources, SQL

Expert PL/SQL Practices for Oracle Developers and DBAs

A9781430234852-3d_1

Expert PL/SQL Practices for Oracle Developers and DBA’s was released on August 1, 2011. It was written by 15 PL/SQL senior developers and DBAs. Since one of them is my colleague and friend, Michael Rosenblum (Misha), I got the chance to

Tagged with: , , , , ,
Posted in BLOG, Our Books, Resources

Creating a comma-separated list of items from a column

We needed to create a comma-separated list of items out of a column. We wanted “Red,Orange,Blue,Black,White”, and in the database we had Red Orange Blue Black White Grigoriy Novikov came up with a number of solutions: Solution 1: The basic

Tagged with: , , , , , , ,
Posted in BLOG, Code tips, Oracle, PL/SQL, SQL

Oracle PL/SQL For Dummies

dummies

Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless! Do you need to get up to speed on PL/SQL programming?  Read this book to find out about code

Tagged with: , ,
Posted in Oracle, Our Books, PL/SQL, Publications, Resources

Oracle JDeveloper 10g Handbook

Oracle JDeveloper 10g Handbook

The Oracle JDeveloper 10g Handbook is a software developer’s reference manual for the product. Authors: Avrom Roy-Faderman, Peter Koletzke, Paul Dorsey Book Description Publication Date: July 27, 2004 The book helps developers create web and database applications with Oracle JDeveloper 10g–the

Tagged with: , ,
Posted in Our Books

Oracle Developer: Advanced Forms and Reports

OracleDevFormsRep

Oracle Developer: Advanced Forms and Reports Authors Peter Koletzke, Paul Dorsey Description Develop powerful web-based and client/server applications in record time. Maximize the power of Oracle Developer to create sophisticated, flexible, and user-friendly database applications. This unique guide contains an invaluable

Tagged with: , , ,
Posted in Our Books
Disclaimer
The information presented on this blog is presented to provide general technical information. If, while attempting to apply any of the ideas, procedures, or suggestions herein, you experience any kind of programming or system problems or failure, it will be as a result of your own actions. Dulcian, Inc. and all authors of text found anywhere on this site, and all internally-linked Web sites, Mail Lists, Blogs and/or e-mail group discussion, disclaim responsibility for any user's actions and any damage that may occur based on information found on this website and associated Mail Lists, Blogs and/or e-mail group discussion. Any technical advice or directions found on or through this site is provided AS IS and its provided without warranty or any guarantee of its accuracy. You perform any modifications to programs or software AT YOUR OWN RISK.