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...)
Love this so much, Tyler Vigen’s Spurious Correlations, randomly compares data sets and creates correlations. Frequently, hilarity ensues.
Like The Onion, I’m sure its “findings” will be misrepresented as serious news soon.
h/t Flowing Data
Possibly Related Posts:
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:
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...)
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...)
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...)
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...)
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.
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...)
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...)
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...)
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...)
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...)
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...)