Windows 7 BSOD atikmdag.sys

If you get a blue screen of death with an atikmdag.sys error, then this YouTube video will show you how to fix it.

SP2-0734 Unknown Command Beginning - Oracle

If you encounter an SP2-0734 Unknown Command Beginning in Oracle, the solution is easy -- remove white space.  Check the beginning of your command for an extraneous space.

Open Excel Spreadsheets Side By Side

Tami Savage posts a concise YouTube video showing how to open Excel spreadsheets side by side (not to be confused with the video Side to Side by Ariana Grande and Nicki Minaj). 

Excel and SEO

Search Engine Optimization (SEO) and Microsoft Excel go hand in hand.  Here's an excellent tutorial from Acuity Training showing how to use Excel to in your SEO analysis.

How to Save Spotify Playlists

Some playlists in Spotify update regularly.  For example, Discover Weekly updates every Monday.  If you love a regularly updated playlist and want to keep it beyond the update, you'll have to save it.

You can do this one of 2 ways.  First, in desktop version of Spotify, create a new playlist by either selecting File > New playlist, right clicking in the playlist area and selecting Create Playlist, or typing CTRL+N.  Then you'll have to name the new playlist.  Once you've done that, you simply highlight the items you want to save.  For the entire playlist, use Edit > Select All or press CTRL+A.  If you want only certain items, you can use CTRL+left click to select multiple non-consecutive items or SHIFT+left click to select consecutive items.  Drag all selected items to the new playlist.

If you want to automate saving and enjoy tweaking settings and are comfortable with very light coding, you can use the web service IFTTT to automate saving certain playlists.  This IFTTT recipe saves Discover Weekly.  This one saves Release Radar via IFTTT.  The only drawback to this approach is it saves the entire playlist and keeps appending new ones onto the same saved playlist, so you'll eventually have a long one.

More about IFTTT and Spotify in this Make Use Of article by Mark O'Neill.