Tuesday, April 27, 2010

More than just pictures

Here is another reason why you need to consider your google habits.  If you have had a google van drive down your street taking photos, they may also have been recording your wireless address as well. http://www.theregister.co.uk/2010/04/22/google_streetview_logs_wlans/

Monday, April 12, 2010

MUST Express Helper

Hi Garry,
Just to let you know of our new product called MUST Express Helper which fills the need to run maintenance plans, backups and other timed activities which full SQL Server would use the SQL Agent to do.
Express Helper is a companion tool for servers running SQL Express and provides a user friendly interface for scheduling Backups, Database Tuning and executing TSQL tasks on a scheduled basis. Just like full SQL Server the backups are executed in cycling sets of files which get over-written as the cycle progresses through the set.

Express Helper comes with a .net windows application interface and is executed as a true windows service on the server, it will generate it’s own SQL Server database called ExpressHelper on the same SQL Server that you are administrating which is where it logs all activity. Any errors and a general monitoring of activity is also supported by the service writing messages into the windows application event log.

Shown below is the simple multi-tabbed .net windows application interface for controlling backups and database tune.




And below we see the windows service which the product installs for you.









MUST Express Helper is licensed on a per-server basis. I use this for my own customers and being able to schedule up sets of backups and running database maintenance plans makes server maintenance a lot simpler.


Regards  
Andy Couch

Friday, April 09, 2010

vbMAPI - Outlook Security Evader

A new method for sending e-mails programmatically through Outlook without the dreaded security warnings.

Unlike competing solutions (such as Outlook Redemption), this new technique requires no DLLs or any third-party add-ins - it is a pure self-contained VBA solution (also works with VB6).

You can download the trial version here. Getting started manual here

Cost is only £30 (US $50/EUR €40) per developer. Check it out.

Wayne

Sunday, April 04, 2010

XML Importing Into Access

Albert Kallal has posted sample code for Importing XML into Access (if the Access importing falls short of the mark)
http://www.utteraccess.com/forum/Xml-Sql-Put-Code-t1940040.html

BTW. Access Importing Rules Of Thumb

  • if it imports then Access is a great tool.
  • If it doesn't then watch out as it could be tricky.
  • XML Notepad is a great free editor from Microsoft.
  • When importing, you may need to use temp tables
  • Make sure that your primary keys stop multiple imports from duplicating data
Garry