Tips on Remote Desktop Connection

Create a shortcut and in the properties , type /admin or /console, it will connect to the server via Console instead of regular session.

Useful article on Reporting Service Maintenance Rpts

On reports maintenance and monitoring

http://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered

 

Basic idea is to utilize the execution log table inside report server. However , the data in this table will be removed automatically after 60 days. Therefore, you need to run a package from MSFT to move those log data into a separate database and start to report from there.

HL7 pipe counter

Freeware

http://www.comstock-software.com/Blog/?Tag=HL7+Interface

Meditech tricks

Ctrl+F12 : Magic Key menu

Shift+F8: Field name in meditech DPM

Tether BB Pearl 8130 to Laptop

Step 1; Install the latest Desktop manager which will give you the modem driver

 

Step 2: Click Mobile internet at the bottom left and there you go

 

If you encounter some problem, you may have some issue with the modem. What you need is to download the file called “BlackBerry USB and Modem Drivers_ITA.msi” and install on your laptop. Should be good to go!

 

Heads-up:

My current data plan gives me 500MB from telus, if using tethering, it will become quickly consumed and the catch is here, if you go over 500mb via tethering, they charge $8 per MB.  Better go with a flex data plan if you intend to use mobile internet quite often.