Posted by & filed under Mobile Technology, Tech Support.

 

In order to wirelessly download all those purchased music, books, and vides from iTunes to your iPad/iPhone/iPod, launch iTunes then open the iTunes Store and click on the new Purchased link on the right side under Quick Links. You will see an icon to the right of your media that looks like a cloud with a down arrow.

You can click that for any media you want to download or choose to download all below that.

After your media has been downloaded to the iCloud, launch iTunes on your iPad/iPhone/iPod. Click on Purchased at the bottom right of iTunes. Download all the media you want and then it will be available in its respective locations on your device.

Posted by & filed under Mobile Technology.

After upgrading to iOS 5, if your GPS is “stuck” on, open your Settings app -> Location Services.

Within this menu, any app that is currently using your iPhone’s GPS will have a small purple arrow next to it. You can then end that app or disable Location Services for that individual app.

When I ran into this problem, I initially thought it was that I’d enabled Find My iPhone during iOS 5 setup. However, it turned out to be my recently updated Foursquare app in which I’d enabled the new Foursquare Radar feature in the app. So I just turned that off, and my GPS was no longer constantly active.

edit:  I’ve also noticed that sometimes Find My Friends will also cause this.

If you enjoyed this guide – follow me on Twitter @dreys!

Posted by & filed under Mobile Technology, Social Networking.

 

After you update your iPhone to iOS 5, you can then update your Foursquare app via the App Store.  The newest version of Foursquare includes Foursquare Radar.

Foursquare Radar will “buzz” you via vibration or alert/push when you’re near a point-of-interest, or somewhere where you have a chunk of friends checked in (to let you know that you clearly weren’t invited to a suaré).

To enable Foursquare Radar:

1. Update your iPhone to iOS 5
2. Update Foursquare to the latest version using the App Store.
3. Launch Foursquare and click the radar icon in the top left corner of the Foursquare home screen.

That’s it!

 

If you enjoyed this guide – follow me on Twitter @dreys!

Posted by & filed under Mobile Technology, Social Networking.

 

One of the nice new features of iOS 5 is its ability to “deeply-integrate” with Twitter.  This allows you to do useful things like Tweet photos directly from the iPhone Photos app, and much more.

To enable this integration, simply open up the Settings app on your iPhone, find the Twitter menu, open it and then sign in using your Twitter username/password.

Once you’ve done this, launch your Photos app and Tweet a Photo at me!  @Dreys

Posted by & filed under Mobile Technology.

 

In case you’ve been away from the digital news-o-sphere, iOS 5 for Apple’s iPhone was released earlier today, with a plethora of new features.

Finding some of those new apps and features, like iMessage, might be a bit tricky.  But what about Find My Friends?

Apple’s new Find My Friends app is located on the App Store.  Simply search for it and install it, much like any normal app.

 

If you enjoyed this guide – follow me on Twitter @dreys!

Posted by & filed under Mobile Technology.

 

In case you missed the news, Apple released the brand new version of their iOS operating system for iPhone today around 1pm EST.

But are you having trouble finding the iMessage app?  Or having trouble enabling iMessage?

Well, look no further.  It’s actually just your regular old Messages app that you’ve always used for texting.  iMessage will automatically send iMessages to the recipients who support it, and SMS texts to those who don’t.  Enjoy!

If you enjoyed this guide – follow me on Twitter @dreys!

Posted by & filed under Tech Support.

Recently I had to make sure I was getting backups of my many little SQL servers. In this case, I wanted to replace an old batch file I was using with something involving powershell.

As always, it proved to be an extreme improvement in functionality.

This script will loop through databases and start a transfer of whatever backup file is created, and then delete the backup once it’s been completed. It will also make sure the backup hasn’t been running too long, and inform you if it has.

Please let me know if you have any questions or comments.

#Load Assemblies and Modules
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | out-null
[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMOExtended') | out-null
Import-Module BitsTransfer

#Define some variables
$smtpServer = "mx.server.local"
$smtpTo = "chris@mx.server.local"
$remoteDest = "\\backupserver\SQLBackup"
$backupDest = "C:\SQLBackups"
$scriptTimeOut = (Get-Date).AddHours(1) #You may have to modify this depending on backup times.
$sqlServer = new-object ('Microsoft.SqlServer.Management.Smo.Server') #'server\instance'

#Internal only function
Function DB-Backup([string]$name,[string]$type)
{
if ($type -eq "Database") {$fileExt = ".bak"}
if ($type -eq "Log") {$fileExt = ".trn"}
$fileName = $backupDest + "\" + $name + (get-date -format yyyyMMddHHmmss) + $fileExt
$backupObj = new-object ('Microsoft.SqlServer.Management.Smo.Backup')
$backupObj.Action = $type
$backupObj.BackupSetDescription = "Full backup of " + $name
$backupObj.BackupSetName = $name + " Backup"
$backupObj.Database = $name
$backupObj.Devices.AddDevice($fileName, 'File')
$backupObj.MediaDescription = "Disk"
$backupObj.SqlBackup($sqlServer)
return $filename
}

#Kick off database backups and associated file transfers
$sqlServer.Databases | %{
#Do full backups on user type databases
if ($_.IsSystemObject -eq $False -and $_.IsMirroringEnabled -eq $False)
{
Start-BitsTransfer -Source (DB-Backup $_.Name "Database") -Destination $remoteDest -TransferType Upload -Asynchronous
#... and if the database isn't in simple recovery mode, lets do a log backup!
if ($_.DatabaseOptions.RecoveryModel -notmatch 'Simple')
{
Start-BitsTransfer -Source (DB-Backup $_.Name "Log") -Destination $remoteDest -TransferType Upload -Asynchronous
}
}
}

#Some fail safe on waiting for all transfers to have started... seemed like a good idea
Sleep 20

#While BITS transfer jobs exist, list the transfered ones and delete local copy
While (Get-BitsTransfer)
{
Get-BitsTransfer | ?{$_.JobState -eq "Transferred"} | %{
$_.FileList | % {Remove-Item $_.LocalName}
Complete-BitsTransfer $_
}
#Loop throttle
Sleep 10
#Better check to be sure we don't run too long
if ((Get-Date) -gt $scriptTimeOut)
{
Send-MailMessage -SmtpServer $smtpServer -From ("SQLBackup@" + ($env:computername).ToLower() + ".local") -To $smtpTo -Subject "SQL Backup" -Body "There is an issue with the backup job for SQL. You'd better check it out."
exit
}
}

Posted by & filed under Gaming, Social Networking.

 

To find your “Activity Score” on the social stock market Empire Avenue, the score by which you’re ranked among other people on your current index, simply open your My Profile page:

Then click the name of your current index (as seen above).

You will then be presented with a pop-up window that shows your current Activity Score (below)!

Have any other handy Empire Avenue tips?  Feel free to share them in the comments.

-@Dreys