Sync iTunes to Android

After hours of trying other solutions, I finally found how to synch music to an android device from my iTunes list.

- Install this app, Sync iTunes to android-windows
- Download the Windows app on the computer you have iTunes installed on.
- Change the location if you want them to be on an SD card. Follow the guide for this question, "How to sync to external sdcard?" here.

By default it will store to location recommended by your phone manufacturer. However we provide a setting in synctunes android app where you can change the location to external sdcard. To do that your first step should be to unsync/delete any music from phone you’ve previously synced, if you do not, it will take up space unnecessary disk space, because we are now defining new location and all music would now go there. To set the new location open synctunes on your phone then go to Settings -> Service uncheck it. The change the sdcard location and check the service again. Press back button to come back to main screen. Now when you sync again your files will go to external sdcard.If you can not locate the sdcard settings please contact us for help 

- Find the IP address of your Android device through the Wifi app. Select the connection, and tap it to see the details. It will show the IP address.
- Enter the IP address when you set up the windows app. This guide will show you how.

Get a DB Diagram in PDF from SQL Server Managment Studio

Here is a way to save a database diagram into a file format so that you can easily pan without it trying to refresh from the DB.

open the diagram and right click somewhere in the middle and you'll have there the option to "Copy diagram to clipboard". From here you paste to MSPaint or another image creator and save to wanted format; (http://dba.stackexchange.com/questions/34132/how-export-a-sql-server-2008-diagram-to-pdf-filetype)

From there just paste into MsPaint or some other program and save it.

Plex Media Server

Last January, I set up Plex Media Server for my home media system.

Here is a guide to having it actually start up like a real service in windows so you don't have to login to have it work.

Plex Queue

I just figured out how to use the Plex Queue. Now I don't have to download videos and store them locally.

At http://plex.tv/web/app#!/playlist/queue/help you see
1 - a button you can drag to your bookmark bar. It contains the following javascript

javascript:%20var%20s=document.createElement("script");s.type="text/javascript";s.src="//plex.tv/queue/bookmarklet_payload";var%20h=document.getElementsByTagName("head")[0];h.appendChild(s);void(0);

When you click this bookmarklet on a page with a video, it will add it to your plex queue. It does this by connecting through to your plex account and the plex account your plex server is using.

2 - A generated email address after the pattern, queue+[generatedKey]@save.plex.tv. If you email a link to a page that has a video you would like to watch later, just email the url to it.

So far, I have been able to queue from these sites, youtube, gc.lds.org, lds devotionals. Facebook videos that are public do not seem to work.

Using Google Voice on Chrome with Multiple Sessions

If you share a windows login with someone else in your house, managing account logins in browsers can be tricky. I think I just figured out how to get a secondary account session to work with the Google Chrome Google Voice extension.

- Log in as the second session in Google Chrome.
  https://support.google.com/accounts/answer/1721977?hl=en&rd=1
- Tell the GV extension to use the second account session.
  chrome-extension://kcnhkahnjcbndmmehfkdnkjomaanaooo/options.html

Disable Firefox Close Other Tabs Warning

In Firefox there is not a "Don't ask again" check box on the Close Other Tabs warning dialog. Here is how you disable the dialog

    - Type about:config into the location bar and press enter
    - Accept the warning message that appears, you will be taken to a list of preferences
    - Locate the preference browser.tabs.warnOnClose, if its value is set to true, double-click on it to change its value to false
    - Repeat this for these 3 preferences browser.warnOnQuit, browser.warnOnRestart and browser.showQuitWarning

H/T to https://support.mozilla.org/en-US/questions/753984#answer-302390

Space on Solid State C Drive

Adding a SSD for a C drive does make a system faster but they are much smaller than regular hard drives. 

I found this article that said that you can safely delete old files in the windows temp folder. It freed up over 25 GB of space for me.

Run "Disk Cleanup" and get rid of Windows Update files.

Use WinDirStat to find files to delete
- Delete the contents of C:\WINDOWS\Installer\$PatchCache$\Managed. See also this.  This folder was 4.6 GB for my in June 2015!
- Also try this "Is it safe to delete files Under C:\WINDOWS\SoftwareDistribution\Download" this was 1.6 GB
- Delete *.dmp files.
- Delete Acrobat Setup Files
- Uninstall Microsoft Windows SDK