How to use your Blackberry as a GPS tracker

Most Blackberries come with a built in GPS. I think this is a great feature, but I haven’t found allot of use for yet.
One use I did find however was as a GPS tracker. This allows me to track where I go on my motorcycle tours.
First you need to get beGPS from Blackberry App World
This is the free version, there is also a paid version with a few more options.
Then get GPSBabel from here to be able to convert the data that beGPS writes.
Once you have used beGPS the first time there should be a beGPS.log file on you Blackberry SD card. Copy the beGPS.log from off your Blackberry to your PC.
Then use GPSBabel to convert the log file to a KML file like this,

gpsbabel
gpsbabel

GPSBabel screen, note the translation options
or by the command prompt like this.
gpsbabel -i nmea -o kml begps.log begps.kml
Then you need to go to google maps and login with your Google account.
Go to My Maps, create a new map, and then use Import to import the KML file.
Done.

Compile Blackberry Playbook Applications without using Flash Builder

Blackberry have some great info on how to develop applications for their new Playbook HERE but it uses Adobe Flash Builder. Which you have to purchase at a significant cost from Adobe.
However there are alternatives. First, you’ll need to read the basics in THIS support form post. You’ll need the AdobeAIR SDK, the Blackberry Table OS SDK and optionally Flash Develop
You don’t have to use Flash Develop, you could use a plain text editor. But it is a very nice IDE to write in and does give you syntax highlighting. And it can compile the SWF file for you. You still have to create the batch file to launch your application into the virtual Playbook, but you can add that into the project and run it from there.
Good luck with your coding

Windows Multiple Remote Desktop MMC Snap-in

Desk #something, Windsorphoto © 2007 Patrick Quinn-Graham | more info (via: Wylio)
You can now get an Windows MMC snap-in that allows you to easily manage multiple remote desktop connections at once.
However it can be a little tricky to find, especially if you are running Windows 7
The file you need to download is here :
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=E487F885-F0C7-436A-A392-25793A25BAD7
it’s the “Windows Server 2003 Service Pack 1 Administration Tools Pack”
Which sound like just a service pack for the tools, but it’s the whole thing.
You then need to start MMC and then add “Remote Desktops” snap-in.
Then right-click on the “Remote Desktops” branch and choose “Add new connection.”

How to remove an IT policy from a Blackberry

1. Upgrade your Blackberry to OS 4.5 or higher
2. Backup your device using the Desktop Manager and then close Desktop Manager.
3. Go to Start->Run and type CMD
(you can also find the command prompt in Programs >Accessories.)
4. In the command window type the following including spaces:
cd c:program filescommon filesresearch in motionapploader
or if you are using 64-bit Windows 7, type
cd c:program files (x86)common filesresearch in motionapploader
5. Now type: loader.exe/resettofactory
6. After your device has finished restarting, you can use the desktop manager software to restore all or some of your data.
from : http://www.blackberryforums.com/rim-software/67224-remove-policy.html

Set the convenience key on you Blackberry 8800

 

You can change the action associated with the convenience key on the left side of your Blackberry with these simple instructions.
 
1. Open Options

2. Scroll down to Screen/Keyboard, and click the track ball/pad.

3. Scroll down to Convenience Key Opens, set to Compose here, and click the track ball again.

4. Scroll up or down and select the option you want by clicking the track ball.
5. Press the Escape key, and click Save to save changes.

Good Blackberry ebook reader


I have recently got myself a Blackberry 8800 phone.
While it is not the latest and greatest model it is still a very good smart phone.
One of the first things I wanted to do was find a ebook reader for it. After some trial and error and I found the KOBO reader an excellent choice.
You can get it from Blackberry App World or from Kobobooks
Kobobooks has a fairly good selection of books to choose from and most are a good price.

Creating a link between two SQL servers

To create a link between two SQL Servers you need to use the sp_addlinkedserver and sp_addlinkedsrvlogin stored procedures.
First,

sp_addlinkedserver @server='DBLINK01',@srvproduct='',@provider='SQLOLEDB',@datasrc='SQL-HOU-01';

Where,
@server is the name of the link
@srvproduct is the type of product, by default SQL Server
@datasrc is the server you link to
Then, you need to set the username and password to use on the link.

sp_addlinkedsrvlogin 'DBLINK01','false',null,'sa','Pa$$w0rd';

The first parameter is the name of the link to use,
The fourth is the account of the remote server to use,
The fifth is the password for the account.

Manually adding a mail account to SQL2005/2008

I was having trouble adding configuring Database Mail on a SQL2005 server today.
I followed the wizard just like I had done on the previous 6 servers, but this one just didn’t want to add it. It was giving me an error about not being able to insert a NULL into the server name field, although I was giving it a server name.
I tried manually adding the data into the table, but of course that didn’t work. You have to use a stored procedure.
You need to use msdb.dbo.sysmail_add_account_sp with options like below,

msdb.dbo.sysmail_add_account_sp @account_name='company.com mail server',@email_address='john.doe@company.com',@display_name='John Doe',@replyto_address='john.doe@company.com',@mailserver_name='mail.company.com',@port=25;