Sit back and relax as I take you through one of my favorite Toad features: Data Compare. In less than five minutes see how to: Set your data comparison target and source Configure which columns to compare Use WHERE clause filters to limit data compared View the results Synchronize the data (optional)
My employer has a freeware utility you can run on your network to find and document instances of SQL Server. One of SQL Server’s primary advantages is also one of its primary disadvantages – you can spin one up in a manner of minutes. To grow deals at a company buying our SQL Server software, we’d offer to document their servers for them. They would claim they only had 10-15 instances of SQL running. We’d…
It’s one of the most iconic scenes in American film – Roy Schneider’s character is chumming the water and sees the shark they are hunting. The massive size of the fish causes him to comment, “We’re gonna need a bigger boat!” It’s shark week, and I was struggling with inspiration for blog posts, so apologies if this metaphor is stretched beyond your imagination. When Oracle (and SQL Server) need to do some expensive math operations,…
I sell software for a living. Just in case you forgot, or never knew, my job is to present our software solutions to a customer and make sure there are no technical objects preventing them from buying it. Does this make me a weasel? Relatively, maybe a little bit. But, I sleep very well at night – and it’s not because of my $10,000 Dodo down pillows. Our tools are actually very good and are…
I used to love getting my essays handed back to me from my teacher. I would quickly look for the red ink comments scattered throughout my paper. I was looking for approval – ‘Yes Jeff, you are truly a genius!’ I do not get the impression that developers either enjoy reviewing co-worker’s code, or having their code reviewed. Does your organization perform code reviews? When I poll audiences, it’s pretty rare to get a lot…
It turns out that everyone online isn’t as nice as you. Some people are online to prove how smart and funny they are. Unfortunately, a sizable minority of these people also just happen to be jerks. On Twitter yesterday, Karen suggested it might be because of a lack of women participants or moderators. While I can’t offer evidence to support or reject Karen’s jibe regarding lack of women, I do have some experience with moderators.…
I am noticing a very disturbing trend in the Southeast US – the local Oracle User Groups are withering away. One of the questions I like to end a presentation with is to inquire about the presence of a local Oracle User Group. More frequently than not, the answer is, “Well, we used to have one.” Now before I jump up onto my soapbox, I have a very big confession to make – I have…
How much time to do you spend debugging database application problems? Probably more time than you want. How much of that time is spent capturing the SQL that is being submitted by your application to the database? I’m going to guess that it’s a significant amount. Asssuming you have access to production (or a test environment that adequately replicates production), then you probably want to check out V$SQLTEXT_WITH_NEWLINES. Before I talk about V$SQLTEXT_WITH_NEWLINES, let’s talk…
People are always asking me, ‘Jeff, what’s going to be in the new version of X?’ or ‘Jeff, what’s new in X?’ or ‘Jeff, what’s wrong with you?!?’ If I’m feeling particularly chippy, I’ll reply something along the lines of ‘How well do you think you’ve mastered the current version of X?’ If you haven’t seen something before, that means it’s new for you, right? I think that was a NBC promo ad back in…
Post Updated on November 10, 2011. 11gR2 was supposed to be 12g..or so the story goes. You can read tons of posts on OTN from several years ago where 12g is referenced. Nothing recent though. So… Oracle Open World 2011 is coming soon, and you know the Big Red Machine will want to have a big splash. Will it be a new version of their RDBMS solution? And for all those people who just got…