There are many hundreds of interesting blogs in the Oracle Database space to choose from. I’m happy to say that about 300,000 of you spent at least a couple of minutes on my blog in 2013. In case you didn’t have a chance to read all 105 or so new posts, I’ll share with you the highlights. Before you run away screaming, thanks for hanging out with us in 2013 and we look forward to…
2013 has been a big year for us here at Oracle and in the tools group. We saw major updates for both SQL Developer and SQL Developer Data Modeler. For the data modeler, versions 3.3 and 4.0 brought significant feature and platform updates. Both are still free by the way 🙂 I’m still very, very high and excited about the new and improved search feature introduced in v3.3. I’ve blogged quite a bit on it,…
A new version of Oracle SQL Developer has been officially released. Oracle developers, DBAs, and data professionals will find that v4.0 is perhaps our best release yet. Of course, we always say that 🙂 So here’s 10 reasons to go upgrade. 10. Version 3.2 is more than a year old. Version 3.2 was released last November. Tens of thousands (maybe more!) of man and woman-hours have gone into the making of version 4. 9. New…
A few things have changed when it comes to running SQL Developer on a Windows machine. In previous versions, the first thing you’d see when running SQL Developer would be a prompt asking for the location of Java. Turns out, it’s hard for Java applications to run without Java. On Macs and Linux/Unix environments, we don’t prompt for the location of the JDK. The OS tells us where it is. So why not do this…
One of our bigger new features for version 4 is our new support for the Database Diagnostic Pack. We have a new interface for your ASH, AWR, ADDM reports, and snapshots, baselines, etc. I want to show you a quick navigation trick today: how to quickly go from snapshots with findings to the actual ADDM findings report. On the DBA tree, click on the Snapshots node. Don’t expand the node, click on the top level…
The name probably gives it away, but just in case you weren’t aware of this, Oracle SQL Developer Data Modeler is an extension of Oracle SQL Developer. They share a framework that is derived from JDeveloper. The latest framework has some new user interface widgets that were adopted directly from Netbeans. I’ve blogged a bit on this topic in regards to SQL Developer, but a lot of those ‘cool things’ are also available in the…
Did you know Oracle SQL Developer allows you to configure Database Auditing and view your audit trails? Well, now you do! This is not new for version 4.0, but the screenshots in this post are from version 4.0. This feature is available under the DBA panel, which can be found on the View menu. I won’t say whether Database Auditing is the right solution for you – I don’t know your requirements, but I WILL…
So for some reason, our New Hire Program invited me BACK to talk to our newly hired developers. I had an hour to talk about our development tools, but I wouldn’t call it training really. My colleague Joel does an actual 2 hour lab teaching them to use APEX – that’s closer to REAL training. So given an hour, and being the lead up into the lunch hour, what should I say? I like bully…
Ah the beautiful data model. They say a picture is worth a 1,000 words. And then we have our diagrams, how many words are they worth? So our models describe how the data ‘works’ – whether that be at a logical-business level, or a technical-physical level. Developers like to say that their code is self-documenting. These would be very lazy or very bad (or both) developers. Models are the same way, you should document your…
I was testing a reported bug in SQL Developer today – so the bug I was looking for wasn’t there (YES!) but I found a different one (NO!) – and I was getting frustrated by having to check the same boxes over and over again. What I wanted was INSERT STATEMENTS to the CLIPBOARD. I’m always doing the same thing, over and over again. And I never go to FILE – that’s too permanent for…
