Rumor Starter: SUN to Kill MySQL?

So, with Sun spending $1 billion to by MySQL, you have to wonder why they did it. Is an open source software company that reported $60 million dollars in earnings recently really worth $1 billion? I have a hard time buying the idea that Sun is buying MySQL to expand the open source community.

Instead, I do think that this could be a back door move to benefit Oracle. Afterall, Oracle hates the competition from MySQL and have always been friendly with SUN. So, what if Oracle simply slipped the $1 billion to Sun to buy MySQL and in return simply asked them to bury the product. This would give Sun some technology to build on and help their friend Oracle in the market place.

With all of that said, this is simply me thinking out loud, and there is no evidence to support it. I just think it would be an interesting move for Oracle and Sun that would benefit each.

How To: Listen LESS and Learn MORE

In this day and time of ever-increasing amounts of information, it can be hard to keep up. If you’re like me, you may have started supplementing your reading with audio books or podcasts. However, with the large amount of audio available, how do you ever listen to it all AND retain any of it?

Well, my solution to one accidentally presented a solution to the other. It all began when I bought my mp3 player last December. I started downloading different podcasts to listen to on my way to and from work and on my lunch break. Soon, I found several that I really liked and was going back and getting new ones from the same source each week. It wasn’t long before I found that I had more audio to listen to than I had time to listen. So, while I was playing around some of the menus one day, I found the setting that allows for me to speed up or slow down the audio that I am playing. The scale on my player goes from -8 to +8. Using the +8 setting increases the speed of the audio approximately 20% over the original recording speed. Doing this allowed me to speed up my audio (without any noticable change in pitch or quality) and allow me to listen to more in less time.

At the same time, I found that I was having to pay closer attention to what I was listening to, simply because everyone was talking faster than I was used to. So, as I began to get used to the speed of the audio, I found that I was actually able to remember more about what I had just heard than I was when I was listening to the audio at normal speed. Now, I don’t know why this is, I just know that it works for me. I’m sure there is some theory or psychological explanation for it, but, frankly, I don’t care why it works, just that it does.

So, if you want to pack more listening and learning into your day and not sacrifice time, try speeding up you audio.

WARNING: I have found that once I’ve gotten used to the higher speed audio, I want to speed it up even more, which I can do on my mp3 player. Also, if you get used to the faster speed of the audio, listening to the same program at normal speed can be dangerous to your sanity. It just seems like everyone is talking sooooo sloooooowww.

Excel Tip: Create a Hidden Workbook to Save All Your Macros, Scripts, and Formulas

If you’re like me, you use MS Excel quite a bit.  I love Excel.  I personally think that it is the greatest piece of software ever created.  In my position with my company I get a chance to use it quite a bit, and often find myself reusing the same bit of VBA script or the same formula for many different projects.  I get really tired of rewriting the same script, recording the same macro, or trying to remember exactly how I built that last formula before I can use it again.  If this ever happens to you, you will understand the frustration.

Well, a couple of years ago I stumbled upon a great tip that has saved me considerable time and frustration, and has even made me look like a hero several times.  The magic lies in a small, somewhat hidden folder within the Microsoft Office installation folder called “XLStart”. 

“What’s so magical about this folder,” you may ask.

Well, that’s what I am about to show you.

First, let’s focus on those often used macros, scripts, and formulas that you have saved in many other Excel workbooks, text files, Post-It Notes, and other divers sources.  Round all of the little nuggets up and save them to one work book.  Make sure that your macros and scripts do not make references to specifically named sheets in the original source.  If they do, I have found that it is best to either change them to the generic “Sheet#” naming that Excel uses by default.  You can also have the script prompt you for the desired sheet name if you like.

Second, try to find a way to organize all of the formulas and macros in a way that you will be able to easily find them.  I find it very useful to put the name of the formula and/or a small explanation of it just above the cell you are saving the formula in.  You should also have some sample data for the formula to use, just so you can remember exactly what it does, just in case you don’t use it for a long time.

Next, save the workbook you have just populated to the “XLStart” folder.  If you used the default installation, the folder should be located using the following path:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
Just remember to name this something beside Book1.  I named mine “MacroBook”, just to make things obvious for me.

The last and my favorite part of this is to hide the workbook so that it doesn’t get in your way every time you open Excel. To do this, just go to the menu bar and click “Window” and the “Hide” and select the workbook you saved.  Now, close Excel.  It will ask if you want to save the changes you made to your workbook.  Click “Yes”. 

Now, every time you open Excel, this new workbook with your great macros and formulas will be opened in the background and ready for use.  To use a macro, simple click on the macro button like you would to run a macro as if you just made it in your current workbook.  The macro selection box will pop up and you will see all of the macros listed for all open workbooks.  They will show up in the format WorkbookName.xls!Macroname.  Simply select it an run it.  To use your formulas, simply go to the toolbar, click “Window” and then “Unhide”, select your hidden workbook and it will appear.  Then, simply copy and paste the formula you would like to use into the workbook you are working on.  When done, simply re-hide the book you had hidden.

This may seem like a long way to go save some simple formulas, but trust me, if you have any complicated formulas or macros that you find yourself re-creating very often, you will quickly come to love this little tip.  So, give it a try and let me know how you like it.

The Freeware PC

OK, so I’m a geek. I admit it. Heck, I wear it like a badge of honor. With that said, I don’t have the money to purchase all of the software to do all of the fun things I want to do with the little free time that I have to play around on my home PC. So, as so many do I turned to alternate (cough peer-to-peer cough) sources of software. I was able to locate and install just about any software that I wanted. However, things like viruses, spy-ware, and subscriptions became a bit of a hassle.

Search, download, install, curse the lack of working serials, uninstall, search some more.

It was such a frustrating circle that I have decided to exit the loop. No more searching for the latest, greatest software in the backrooms of the internet hoping I didn’t get busted for pirating. I’ve decided to go legit. What I have decided to do is to create a fully-functioning PC that runs only cost-free, spy-ware-free, virus-free software. The only exception to this rule being the operating system. I don’t really have the time or desire to become proficient enough in Linux to replace my home PC. At least not yet.

Along with the search for the best freeware tools I am going to blog each step of the way. I hope to have a good review of each product I decide to include in the mix along with the links so that you can download it yourself. At the same time, I hope that you will suggest some tools that I may not have run across on my own.

Well, happy reading and I look forward to your comments.