I stumbled upon an interesting discussion in the ODTUG group on LinkedIn this weekend. A vendor is doing some research I suppose and wanted to know who enjoyed using what IDE and why. Here’s the original question: In your opinion which is the best IDE for PL/SQL programming and why? e.g. PL/SQL Developer, Toad, Oracle SQL Developer. To participate in the conversation, you’ll need to join the group on LinkedIn. My only input was to…
Toad used to just be a simple freeware software program. Oracle developers could download it and use it in a matter of a few minutes. Today, it’s an entire brand at Quest Software – and does everything from Oracle to Apache Hadoop and surely isn’t limited to just developers anymore. This week my friend and co-worker Steven launched a new contest where Toad users can compete for prizes and money by taking a series of…
In yesterday’s post, I posed a question: What Hint Do You See Over or Misused? Gary (Twitter) responded with With APPEND the rows are written directly to the datafiles and are not logged. If the DBA doesn’t know that unlogged changes are being made then whatever recovery plans they have may be useless when it comes to restoring from a backup. In theory they can set FORCE LOGGING on individual tablespaces so they can’t be…
I’ve overheard the SQL Server folks talking about the challenges of support applications where the NOLOCK (or is it NO_LOCK?) hint has been deployed to make transactions and queries go faster. This probably causes more problems than it solves, and rather trying to rehash what I’ve heard second hand, I suggest you go listen to a MSFT MCM talk about it. Brent Ozar PLF co-founder Kenda Little does an excellent overview on it here. That…
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…
I’ve been blogging in one form or another for about 5 years. Since I published that first story, I’ve spent more than a little bit of time waiting for comments to start flooding in. And they haven’t really flooded in. If I compare my posts to folks that I follow (Mark Schaefer and Brent Ozar), my 6 comments looks puny to their 337. I have a pretty good idea why a blog post may or…
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…
Someone asked me yesterday where do I get my blog topics and ideas from. Usually it’s from watching too much TV, but often it’s an actual question or topic that is raised by a co-worker or customer. Yesterday I was asked by my boss about how to find out when TRUNCATEs have been issued because I know that truncates cannot be rollbacked from so they wouldn’t be in the redo logs Now, in my boss’…
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.…
Disclosure: I manage a blog syndication site, OraDBPedia. Part of my job involves looking for compelling bloggers in the Oracle database space and convincing them to let us syndicate their content. Syndicate: (Communication Arts / Journalism & Publishing) (tr) to sell (articles, photographs, etc.) to several newspapers for simultaneous publication — from FreeDictionary.com The general idea for a blogger is to get their content to as many different sets of eyes as possible. The more…