AppsLab at the Maker Faire

Last week was Maker Week for us, and the culmination was the Maker Faire over the weekend.

This was my first Maker Faire, and wow was it an absolutely blast. I highly recommend taking in one of their events if there’s one in your town. Perhaps the best attribute of the Maker Faire is that it includes not just technology, but also handicrafts, woodcraft, pretty much every kind of craft. Walking around, you can feel (more...)

Randomly Humorous Correlations

Love this so much, Tyler Vigen’s Spurious Correlations, randomly compares data sets and creates correlations. Frequently, hilarity ensues.

cageCorrelation

Like The Onion, I’m sure its “findings” will be misrepresented as serious news soon.

h/t Flowing Data

 Possibly Related Posts:

Tweets from Jeremy’s MakerCon Keynote

Yesterday, our fearless leader, Jeremy Ashley (@jrwashley), gave a keynote at MakerCon. Unfortunately, I had to miss it, but the guys reported a positive reaction. Noel (@noelportugal) pointed me to tweets for rapid reaction.

Here’s a sample:

tweet


tweet1

tweet2

Yeah, I cherry-picked, but you can read the reactions yourself if you don’t believe me.

The keynote was recorded, and if it becomes freely-available, I’ll embed here. We also have awesome pictures on the way (more...)

OK Google, Where’s My Car?

Google Now recently added a Parking Location card to help you solve the classic dude-where’s-my-car problem. According to The Verge:

The company’s Google Now assistant will now recognize when you’ve left a moving vehicle and automatically keep track of your car’s last location. There’s no magic happening here: Google does all of this using your smartphone’s bevy of sensors. It’s essentially guesswork, and the company readily admits that it may sometimes guess wrong. “You (more...)

A Week with the Amazon Fire TV

Even though I’m more than content with the Chromecast, the Amazon Fire TV caught my eye for a very simple reason: Amazon Prime content.

I’ve been buying digital content from Amazon since they launched their MP3 Store, the first place to buy music without any DRM, back in 2007, and Amazon is the only place to get stuff like Dora and other Nickelodeon shows. Yeah, that’s a parenting problem.

Amazon doesn’t support the Chromecast and probably won’t anytime (more...)

Ooops!

A recent IT-related survey had in its list of questions one rather interesting offering:

“Are there any safeguards preventing the DBA from accidentally dropping a table?”

That is probably not a commonly considered aspect of data security however it is an issue that should be voiced and addressed. How do you ensure that the DBA doesn’t, or can’t, drop a table accidentally? Oracle has at least two ways to ensure that a table cannot (more...)

The Nymi Nears Production

Noel (@noelportugal) chatted with the Bionym guys at SXSW earlier this year, and I know I speak for all of us here in the ‘Lab when I say I’m very stoked to get my Nymi and start playing with it.

Check out Techcrunch’s writeup and demo video.

Since I can’t embed TC’s video for some annoying reason, here is ninja cat instead.

Just pretend really hard, or watch the video over at TC.

Aside (more...)

Let’s All Join In

While investigating a question on returing unmatched rows between two tables I set up an example where both tables had indexes which could be used to speed up the query and hopefully return the result set in less time than required for a full table scan. To my surprise when the index was used on the table with the missing record the query returned no rows. Not understanding this behavior (as I KNEW there was (more...)

My Career

The next time anyone asks me what I do for a living I’m just going to point them to this YouTube video.

Found on the twitters thanks to Nick Hodge and Jess Dodson.

Hide And Seek (After A Fashion)

Indexes can be very useful tools to improve query performance, but it can be difficult to test indexes in an environment that exactly mirrors production. Although not the preferred method, Oracle offers in 11.2 and later releases the option of invisible indexes. What are invisible indexes? An invisible index can’t be ‘seen’ by any session by default, so it can be created and remain unavailable until testing is scheduled. This can be confusing since (more...)

You Take Too Long

Sometimes statements take longer than you’d like to complete. This can happen for a number of reasons including data changes, table growth, stale statistics and the occasional optimizer bug you haven’t encountered before. When it’s a SQL query that is misbehaving it’s pretty easy to find the cause and, in many cases, fix it. When it’s PL/SQL it isn’t as easy to do. There are views available from Oracle to assist in this endeavor and, (more...)

My Latin American Tour in March

At March I will be presenting my very successful seminar “Mastering Backup and Recovery” in some countries of Latin America for the very first time. Thank you Panama, Chile and Brazil OUGs for inviting me to your amazing countries! Please, use the following links for registration and also to find more information about the seminar: […]

Join me at the next OTN Virtual Developer Day

    Hi All, On February 4, 2014 at 9:30 am PT I will be talking on the next OTN Virtual Developer Day about Oracle VM and Oracle Database. Come and discover the answers for the following questions: Does an Oracle Database perform well on a virtualized environment? What virtualization technology is more stable and […]

Problems when doing a V2V or P2V of a windows server to Oracle VM

Some time ago, I received the request to migrate some Windows 2008 Servers to my Oracle VM farm and after complete the P2V migration the newly create VM would not start. It would crash on boot with blue screen and error: STOP: 0x0000007B (0xXXXXXXXX,0xXXXXXXXX,0×00000000,0×00000000) This issue is related to the storage drivers needed for the guest […]

Space Exploration

Managing free space in a tablespace seems to be an easy task, what with the views DBA_DATA_FILES, DBA_TEMP_FILES and DBA_FREE_SPACE avaliable. Those views can provide accurate information for datafiles not set to autoextend, however for autoextensible datafiles they can paint a bleaker picture because they’re based on the current size of the file, not the autoextend limit that file could reach. Let’s look at how those views, without taking autoextend into consideration, can report a (more...)

OSD-04400: unable to acquire internal semaphore for process and OS 183 (Windows)

I hit the following problem with a 9.2.0.8 database running on Windows 2003 this morning (info pulled from the alert log).  The database had failed to restart after a client’s cold backup process ALTER DATABASE MOUNT Wed Jan 15 22:32:08 2014 ORA-09341: scumnt: unable to mount database OSD-04400: unable to acquire internal semaphore for process

Read More...

You’re Not In The Group

In yet another Oracle forum (yes, I’m in a number of them) the following question was posed:


I'm reading oracle 9i sql and there is an example of a subquery which I'm trying to write as a group by query.

 select empno, ename, sal
 from emp
 where sal =
 (select min(sal) from emp);

 This works but I don't understand why I can't write this as a group by expression

 select empno, ename, min(sal)
 from emp
  (more...)

Playing with Software

I’ve been trying to install open source software. In this case an application called Moodle. I followed the instructions to install it on an Ubuntu Server vm but they were missing a couple of key points.

After installing the Moodle package (under “Moodle Installation” in the instructions) you need to (more...)

Joint Webinar with Oracle – Top 5 Key Reasons Why Oracle VM is Best for Oracle Database

Top 5 Key Reasons Why Oracle VM is Best for Oracle Database When: Tuesday December 17th , 10am PST Register Here: http://event.on24.com/r.htm?e=725350&s=1&k=1512E332202610FE9518AB8B01354C6A&partnerref=Francisco Oracle VM application-driven architecture is designed for rapid deployment and ease of lifecycle management providing IT a highly scalable and cost effective virtualization solution for Oracle (more...)

6 Version Control Tools for PeopleSoft

Oracle doesn't provide a version control feature for PeopleSoft. So here are some tools available in the market which can do version control and much more for PeopleSoft.