Cut and Merge Video Excerpts

There is a talk that I wanted to take parts of and merge them together into a shorter video. Here is how I did that.

- I downloaded the video from YouTube.
- I used VLC Player to cut out the parts of the video I wanted
- I used MS Movie Maker to merge the parts into one video
  I followed the instruction here
  * Click the Add videos and photos button for all the parts
  * Use the Save Video/Recommended for this project dialog to save it to a mp4 format that YouTube will accept

Cut Parts of a Video with VLC Player

1. Open VLC Player
2. Click on the View menu and check Advanced Control
3. Select the video you want to cut
4. Press the Record button to cut, or record, the part of the video you want and to stop press the record button to end the cut. This is a little tricky in that it seems to take a second or so to actually start recording after you press the record button. I found that I had to click the button on the word before to get it to start recording at the correct place.
5. The Videos will be automatically saved in the My Videos folder

(Transcribed from "How to Cut or Record Video with VLC Media Player 2013 Exclusive Video HD", DrTheComputer, YouTube Feb 12, 2013)

Direct Dial in Android

To add a direct dial shortcut on a device running Android 4.0 (Ice Cream Sandwich):

1. Press the main app drawer icon (middle icon in system tray)
2. Scroll to “Widgets” folder (on the right) until you reach the “Direct Dial” widget
3. Press and hold the “Direct dial” widget until you see the home screen grid
4. Release the direct dial widget wherever you’d like your widget (shortcut) to appear on the home screen
5. Once you release the widget (shortcut) it will pull up your Contacts list
6. Select Contact you wish to have as a direct dial

From How To: Add A Direct Dial Shortcut To Your Android Homescreen at CultOfAndroid.com

Google Drive Automatic Download

I made a mobile version of a PDF file and I wanted others to be able to download it on their devices. Here I found some instructions that helped me craft a url to do it with.

You have a file (say a 100mb presentation) in Google Drive (aka Google Docs) and you want to share it with your friend who does not have a Google/Gmail account at all.
1) In Google Drive,  seeing the file listed, put a check in front of it, and at the top of the list of files, click More--Share--Share
2) On the Sharing settings for the file, where you see "Private - Only the people listed below can access"  - Click CHANGE
3) Change default sharing to be "Anyone with the link" then click SAVE
4) Now you should see a link to the file (copy this with Ctrl-C or by the mouse)
something like this:
https://docs.google.com/open?id=0B4OExGgOTeXXXXXXXXXXYYYYYZZZZZGU4OGJlMTNlNzBh
5) Click DONE
6) Create your new email
7) Now you need the link from the other step (unique to each file) you share
8) Make a link in your email based on putting your like and this new prefix
Yours: https://docs.google.com/open?id=0B4OExGgOTeXXXXXXXXXXYYYYYZZZZZGU4OGJlMTNlNzBh
New Prefix: https://drive.google.com/uc?export=download&id=
Result Link to email: https://drive.google.com/uc?export=download&id=0B4OExGgOTeXXXXXXXXXXYYYYYZZZZZGU4OGJlMTNlNzBh
9) Email it to your friend, when they click the link the file automatically downloads.

Republic Wireless

Here are some of the settings I use with our Republic Wireless phones.

From Using Google Voice with Republic Wireless

Using Google Voice for Voicemail 

If you want to use your Republic Wireless number as your public phone number but still want to get the benefits of GV voicemail (transcribed messages, forever storage) you can activate GV voicemail on your phone. 

The Republic Wireless Community has a page with images for this. 

1. Open the Republic app.
2. Tap Republic on the top left corner to access the app's menu.
3. Tap Settings.
4. Under Voicemail, tap Voicemail forwarding.
5. Enter your Google Voice number. 

If you want to use your Republic Wireless number as your public phone number but still want to get the benefits of GV voicemail (transcribed messages, forever storage) you can activate GV voicemail on your phone. 

Set up your voicemail greetings at the GV site. 

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.