The Data Warrior

Changing the world, one data model at a time. How can I help you?

Archive for the tag “#SQLDeveloper”

Welcome to the Biggest KScope Conference Ever!

Day breaks over the Mighty Mississippi

Day breaks over the Mighty Mississippi

Day one at ODTUG’s KScope13 was awesome as always with a great set of symposiums and networking events.

At the speaker meeting we learned that there are 1,400 registered attendees, 30 countries represented and over 50 exhibitors making this the largest event and largest exhibit hall in the history of the Oracle Development Tools User Group (ODTUG).

So we must be doing something right to attract such a large crowd.

Part of what we do right is getting the top Oracle developers, consultants, and Oracle ACEs in the world to present. And we get stellar participation from the Product Management and Development teams at Oracle Corporation.

Even though it was Sunday, there was a tremendous turnout for our free Sunday Symposiums. In the Symposiums we had rooms dedicated to specific topics so attendees could stay in one place all day and get a series of related talks.

After conducting my now annual Morning Chi Gung class (had nine attendees!) I spent the day in the DB & Developer’s Toolbox Symposium. It had quite a line up.

First I attended Jeff Smith’s session  on SQL Developer 4.0 which will come out later this summer.

SQL Developer Product Manager, Jeff Smith of Oracle, introduces new features in the upcoming 4.0 release

SQL Developer Product Manager, Jeff Smith of Oracle, introduces new features in the upcoming 4.0 release

Got lots of great tips and trick which I am sure Jeff will be blogging about at ThatJeffSmith.com in the near future.

Next was Oracle Technologist Tom Kyte who spoke about many new features and enhancements to SQL And PL/SQL in the upcoming Oracle 12c release of the database.

Tom Kyte (of AskTom.com fame) introduces attendees to new SQL and PL/SQL features in Oracle 12c

Tom Kyte (of AskTom.com fame) introduces attendees to new SQL and PL/SQL features in Oracle 12c

And last for my day of learning was Maria Colgan discussing changes to the Oracle Optimizer in 12c.

Oracle Product Manager, Maria Colgan, discusses the Evolution of the Oracle Optimizer: Rules based to 12c

Oracle Product Manager, Maria Colgan, discusses the Evolution of the Oracle Optimizer: Rules based to 12c

As always, Maria provided so much information my head was ready to explode from information overload. And later in the week she has a second session on this topic with even more new features to discuss. If every Oracle DBA could attend one of her sessions, all of our databases would run better!

After the sessions it was time for formal and informal networking. There was the speakers meeting and the official welcome reception in the exhibit hall. I got to attend an official Oracle ACE dinner cruise on a steam powered paddle wheel river boat complete with live jazz band. Very much in the spirit of New Orleans.

Stay tuned for more reports as the week progresses.

Kent

The Oracle Data Warrior

P.S. I got to do a little touring as well and visited the oldest Catholic Cathedral in the United States. It is quite a beautiful church inside and out.

The beautiful St Louis Cathedral near Jackson Square  in New Orleans

The beautiful St Louis Cathedral near Jackson Square in New Orleans

Advertisements

Another Free Tip for SQL Developer Data Modeler (and a Challenge)

So here is another tip on using Oracle SQL Developer Data Modeler – but this time it is one I will NOT be showing during my session at #KScope13.

In SDDM there is a really nice wizard for building views. Once your view is built, you should probably test it right?

You could generate the DDL, or use DDL Preview, then open up SQL Developer, run the script to build the view, then select from the view to see the results.

Lotta steps, eh?

Or you could simply use the Test Query button on the View Properties dialog.

Press the button, then select a database connection from the drop down list (or create a new one if you need to). This will create a connection to the database and cause the SQL in the view to be executed. If everything works you will see “Query executed successfully”.

The Test Query button will first check that the SQL will execute

The Test Query button will first check that the SQL will execute

If you want to see the output of the query, just click the Query Results tab.

The Query Results tab lets you examine the output without opening another tool

The Query Results tab lets you examine the output without opening another tool

Pretty cool. And must faster than the old way.

Now for the Challenge:

  1. You must be attending KScope13.
  2. You must be the first person to find me onsite in New Orleans and tell me you read this post.
  3. You then have to show up at my Top Ten Tips session at the conference, join me at the podium and tell the attendees this tip!

Your reward:

  1. It might be your first chance to present at an international conference.
  2. I will buy you the adult beverage of your choice that evening and chat about SDDM (or another topic of your choosing).

Not a million dollars, but who knows where it might lead or who else you might meet along the way.

So, who’s up to the challenge?

See you in New Orleans.

Oh – if oyu missed the first tip, it is here.

Kent

P.S. Jeff (@thatJeffSmith) and Chet (@OracleNerd) – sorry guys but you are not eligible! (I may buy you beer anyway)

The 1st Tip is Free: Oracle SQL Developer Data Modeler

This year’s ODTUG KScope conference is less than a month away and I am ready to get to New Orleans and meet up with all my friends and colleagues to talk shop and learn some new things.

So in hopes of getting you to attend, I will share with you one of my productivity tips for using SQL Developer Data Modeler (SDDM).

DDL Previewer

I love this tool. I use it every single day in my work building data warehouses for my clients.

Really.

It’s easy – just right click on the table (or view) you want to check and Voila!

Right mouse over object to get preview option

Right mouse over object to get preview option

Once you pick “DDL Preview”, then you get the DDL in another window.

Example of DDL script in Preview Window

Example of DDL script in Preview Window

With this you can:

1. Check the design to see if it is what you wanted/expected.

2. Copy and paste it to a worksheet in SQL Developer where you can then execute it (if you have the rights!).

One more cool thing is that if you leave the DDL window open, you can now click on any other object in the open diagram and instantly see the DDL for that object.

So there you go – really 3 tips for the price of one!

If you want more, I will be presenting my Top 10 SDDM Tips and Tricks at KScope13 in New Orleans in a few weeks. So go register now!

See you in NOLA!

Kent

 

Oracle OpenWorld Day 3

Another one for the books…

As before you can see a bunch of my activities on twitter (@kentgraziano and #oow). I posted a few pictures throughout the day.

For the first time I got to watch two keynotes live without being in the cavern of a hall for four hours. Actually sat outside in the shade in Yerba Buena Gardens and watched it all on a really big screen.

Lots of  “cloud” talk from Oracle and its partners. CEO Larry E did a cool presentation or real-time analytics on 4.9 billion tweets gathered for the 5 days following the summer Olympic games. It was quite interesting to see the analysis of structured and unstructured data together in a drillable dashboard environment.

And it was…you guessed it…all in the cloud.

Big Data meets Big Iron

Pretty good slogan…guess for doing big data analysis you will need some pretty hefty hardware too…

Also attended two of Jeff Smith’s (@thatJeffSmith) presentations. One on collaborative model development with SQL Developer Data Modeler (my personal favorite) and one on SQL Developer Tips and Tricks (mostly tips).

Source control in SDDM

I also got in the tail end of a session on Pluggable Databases (PDB). Got some really nice summary slides (be sure to click on them and zoom so you can read them). Lots of great details on how PDB works and what it can and cannot do.

All about pluggable database

 

The details on PDB

After the second keynote it was over to the OTN Lounge for the first ever Tweet Meet. It was designed to let people meet the person behind the twitter handle. I think it was a good success with a great turn out. We even got one of the OTN guys to create his own twitter account so he could follow the Oracle Aces and Ace Directors more easily.

Finally dinner in North Beach with some friends at the Stinking Rose. This has become an annual tradition.

After dinner I did manage to catch the last set from Joss Stone performing in Union Square. That pretty much rocked. Glad I went.

Tomorrow night the BIG appreciation event: Pearl Jam (if I remember to pick up my wristband to get in).

Kent

 

Oracle Music Fest Schedule is Out & My Oracle OpenWorld Schedule

Happy Friday!

Yes Oracle has finally relased the schedule of artists and DJ who will grace tha attendees at OOW 2012 with their talent.

Suffice it to say – WOW!

You get all the details over at the OOW site – here.

And I have finally put together my tentative schedule of events, sessions, meetups, and concerts. I plan to focus on data warehousing, BI, and SQL Developer (no surprise there). Looking forward to learning about some new tools (Endeca), and more about Exalytics.

Also looking forward to seeing and networking with longtime friends and colleagues.

And of course, hearing some GREAT music (followed by early morning Chi Gung to keep healthy and energized).

You can see my schedule by clicking the link below (PDF).

OOW Schedule

I added a bit of color to differentiate the fun stuff from the work stuff…

There are few other dinners, etc on my agenda too (Stinking Rose anyone?), but some things you all do not really need to know <wink>.

Have a great weekend.

See you in SFO.

Kent

Post Navigation

%d bloggers like this: