Random pieces of code and life

mac : Other useful default writes

Joshua — Tue, 07 Sep 2010 13:50:43 +0000

Disable Guest Accounts for Shares on OSX Tiger
sudo defaults write /Library/Preferences/com.apple.AppleFileServer guestAccess -bool false
Disable Dashboard
defaults write com.apple.dashboard mcx-disabled -boolean YES
Reduce Safari Rendering delay
defaults write com.apple.Safari WebKitInitialTimedLayoutDelay 0.25
Increase animation speed of sheets
defaults write NSGlobalDomain NSWindowResizeTime .001
Disable spotlight
edit /etc/hostconfig to change "SPOTLIGHT=-YES-" to "SPOTLIGHT=-NO-"
Enable Safari debug menu
defaults write com.apple.Safari IncludeDebugMenu 1
Get rid of .DS_Store files on network shares (specifically works for smb shares)
defaults write com.apple.desktopservices DSDontWriteNetworkStores true
Show full path to current directory in Finder title defaults write com.apple.finder _FXShowPosixPathInTitle -bool YES
Mount external drives at boot rather then on user login
defaults write /Library/Preferences/SystemConfiguration/autodiskmount AutomountDisksWithoutUserLogin -bool true
Setting a custom software update server for a client
defaults write /Library/Preferences/com.apple.SoftwareUpdate CatalogURL "http://customupdateserver.com/index.sucatalog"
Show All Files in Finder
defaults write com.apple.finder AppleShowAllFiles TRUE
Terminal Focus Follows Mouse
defaults write com.apple.Terminal FocusFollowsMouse -string YES
Add Application to OSX Dock (example uses Calculator.app)
defaults write com.apple.dock persistent-apps -array-add "< dict><key>tile-data</key><dict><key> file-data</key><dict><key>_CFURLString </key><string>/Applications/Calculator.app/</string><key>_CFURLStringType</key><integer>0 </integer></dict></dict></dict>";
Disable the OSX Crash Reporter
defaults write com.apple.CrashReporter DialogType none
Add Recent Applications Stack to the Dock
defaults write com.apple.dock persistent-others -array-add '{ "tile-data" = { "list-type" = 1; }; "tile-type" = "recents-tile"; }'
Change Login Screen Background
sudo defaults write /Library/Preferences/com.apple.loginwindow DesktopPicture "/Library/Desktop Pictures/Aqua Blue.jpg"
Disable Time Machine External Disk as Backup Prompt
defaults write com.apple.TimeMachine DoNotOfferNewDisksForBackup -bool YES
Disable mouse/trackpad acceleration
- defaults write .GlobalPreferences com.apple.mouse.scaling -1
- defaults write .GlobalPreferences com.apple.trackpad.scaling -1

from : http://ccn.ucla.edu/users/jkyle/weblog/e8fc1/Useful_Defaults_Hacks_for_OSX.html

Original post

mac : Stop .DS_Store files on network drives

Joshua — Tue, 07 Sep 2010 13:46:57 +0000

Code:

defaults write com.apple.desktopservices DSDontWriteNetworkStores true

Original post

mac : fix home and end keys

Joshua — Thu, 19 Aug 2010 12:19:25 +0000

create the file ~/Library/KeyBindings/DefaultKeyBinding.dict

Code:

{
    /* home */
    "\UF729"  = "moveToBeginningOfLine:";
    "$\UF729" = "moveToBeginningOfLineAndModifySelection:";
 
    /* end */
    "\UF72B"  = "moveToEndOfLine:";
    "$\UF72B" = "moveToEndOfLineAndModifySelection:";
 
    /* page up/down */
    "\UF72C"  = "pageUp:";
    "\UF72D"  = "pageDown:";
}

Original post

sql : remove character from field

Joshua — Thu, 19 Aug 2010 12:19:00 +0000

UPDATE table SET field = replace(field, "#", "")

Original post

mac : lock computer app

Joshua — Mon, 19 Jul 2010 20:24:00 +0000

i wrote a one click program to lock mac with screen saver password
Lock.app.zip

Original post

mac : triple monitor

Joshua — Fri, 16 Jul 2010 20:22:30 +0000

Encore ENMUV-2 video adapter

DisplayLink MacOSX 1.6b2.zip

Original post

windows : easy SQL backups

Joshua — Tue, 13 Jul 2010 19:36:01 +0000

Run this on each database

Code:

ALTER DATABASE database_name SET RECOVERY SIMPLE

Create "backup_databases.sql" file

Code:

/*-------------------BACKUP EACH DATABASE-------------------*/
 
BACKUP DATABASE ABC TO DISK = 'C:\SQL_BACKUPS\ABC.bak';
 
BACKUP DATABASE MNO TO DISK = 'C:\SQL_BACKUPS\MNO.bak';
 
BACKUP DATABASE XYZ TO DISK = 'C:\SQL_BACKUPS\XYZ.bak';

Create "run_database_backup.bat" batch file

Code:

sqlcmd -S server\instance -i C:\pathto_sql_file\backup_databases.sql

Run the batch file as a scheduled task.

-------------------------------------------------

To Restore

Code:

RESTORE DATABASE database_name FROM DISK ='C:\SQL_BACKUPS\database_name.bak'

Original post

mac : DMG to ISO

Joshua — Fri, 09 Jul 2010 20:57:51 +0000

hdiutil convert /path/to/filename.dmg -format UDTO -o /path/to/savefile.iso

Original post

	`{`
	`/* home */`
	`"\UF729" = "moveToBeginningOfLine:";`
	`"$\UF729" = "moveToBeginningOfLineAndModifySelection:";`

	`/* end */`
	`"\UF72B" = "moveToEndOfLine:";`
	`"$\UF72B" = "moveToEndOfLineAndModifySelection:";`

	`/* page up/down */`
	`"\UF72C" = "pageUp:";`
	`"\UF72D" = "pageDown:";`
	`}`

	`/-------------------BACKUP EACH DATABASE-------------------/`

	`BACKUP DATABASE ABC TO DISK = 'C:\SQL_BACKUPS\ABC.bak';`

	`BACKUP DATABASE MNO TO DISK = 'C:\SQL_BACKUPS\MNO.bak';`

	`BACKUP DATABASE XYZ TO DISK = 'C:\SQL_BACKUPS\XYZ.bak';`