G’day all friends and clients of SSW!
As the year rattles by and things start heating up, with preparation for the GST and the Olympics with business as usual to cap it off, take the time to sit back, relax and browse through our monthly newsletter.
This month
1. THE ACCESS/ASP/SQL SERVER USERS GROUP, WEDNESDAY 19TH APRIL
2. DEVCON2000 ROUND UP AND REVIEW
3. MICROSOFT SQL SERVER CONFERENCE MAY 2000
4. TIME SAVING PRODUCT – DATAPRO! RENOVATOR
5. HOT TIPS
6. POSITIONS VACANT. WORK AT SSW
7. FOR LET - OFFICE SPACE IN NEUTRAL BAY. SUIT DEVELOPER
1. The Access/ASP/SQL Server Users Group
Sponsored by Microsoft and SSW
Wednesday 19th April 2000, 5:45 pm - www.ssw.com.au/accessUG
Are you an Access/SQL Server/ASP developer looking for hot tips, inside information and great contacts?
Then come along to your User Group at the Microsoft Building at North Ryde!
Up for discussion this month alongside our usual forum of discussion and information
· SQL Server 7.0 Service Pack 2
SQL Server Service Pack 2 (SP2) addresses specific issues that were discovered in SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 since their ship date.
http://www.microsoft.com/sql/support/sp2.htm
It is a 40MB download. Early reports from the newsgroups indicate problems with Replication.
· Product Review Embarcadero Change Manager
For info visit www.gbsweb.com
2. DevCon 2000 Round Up & Review
DevCon 2000 was a tremendous success. Held at the Manly Pacific, attendees enjoyed 4 days of excellent presentations and tips on Access, VB, SQL Server, XML, InterDev and more…
If you have any questions or issues still outstanding please bring them along to the Users Group on Wednesday.
Want to learn more? Then make your way to...
3. MICROSOFT SQL SERVER CONFERENCE MAY 2000
Adam would like to extend the following invitation to all members of the users group.
MICROSOFT SQL SERVER 2000 CONFERENCE
May 2-4, 2000, Australian Technology Park, Sydney
If you're a developer, DBA, architect or consultant focused on building and
deploying applications and services based on Microsoft SQL Server and the Microsoft
DNA 2000 architecture, this is a 'must attend' event for you!
Running over 3 Days, with 4 streams and 48 sessions planned, this conference
is the biggest Australian Microsoft SQL Server event ever.
To find out more about special registration discounts and to register now, visit:
www.microsoft.com/australia/Events/sqlserver2000/
Or phone: 1800 020 090
4. Time Saving Product: DataPRO Renovator Version 6.4
'SSW Data PRO! Renovator' (97 & 2000) is a productivity tool utility that
can make your life easier!
With SSW Data PRO! Renovator and its friendly interface you can compare two
databases structure and:
· Generate difference reports for you to make the changes manually, or
· Step through the wizard and the data will be AUTOMATICALLY moved into
the new structure (renames are it's strongest feature)
If you don't have access to the current structure you can have the differences
written to a table that can be used with its sister product 'SSW Data PRO!'
to commit changes automatically (useful in deployment).
For more information www.ssw.com.au/DataPRORenovator
5. Hot Tips
· The StrConv Function
· Simplifying Debugging
1) The StrConv Function
If you have problems with the formatting of sting data, the StrConv function
can be useful.
For example, you may wish to convert a name of "JOE BLOGGS" to proper
case i.e "Joe Bloggs", or you may wish to convert from lower to upper
case.
For example, to convert all data in a field to proper case, you could use:
StrConv([User_Name],3)
or to convert to upper case, you could use:
StrConv([User_Name],1)
Thanks to David Klein for this tip
2) Use Resume 0 to simplify debugging.
If you get an error, hit Ctrl-Break at the error msgbox and the code window appears with the msgbox command highlighted. Place the cursor on the Resume 0 and hit Ctrl-F9 (set next line) then Ctrl-F8 (step one line) and you are back at the line that caused the error. I automatically add "Resume 0 'For debugging" to the end of all error handlers for this purpose.
Thanks to Ted Avery for this tip
Got a hot tip you want to share? Email to 696e666f72407373772e636f6d2e6175
6. Positions Vacant
SSW is expanding its list of clients and the office is a veritable breeding ground for energy and ideas. We are looking for a new developer who is keen to play a key role in the success of SSW.
· SQL Server Developer
If you’ve got 12-18 months of solid SQL experience and are looking for a new working environment contact 696e666f72407373772e636f6d2e6175
7. For Let – Newly Refurbished Office Space
Within the SSW offices there is newly furnished office available for let.
It is fully furnished and partitioned and is ideal for two people (approx. 20sqm)
· Excellent Northside Location
· Easy City Access (express bus or hop straight on the freeway –
20 minutes to airport)
· Air-conditioning
· Kitchenette
· Only $825 per month.
If you are running a small business and are looking for a place to move, email us: 696e666f72407373772e636f6d2e6175 and drop by to have a look.
SSW’s Marketing Team edits this newsletter. We would like your feedback. If you have a tip you want to share, a website you want us to review or comments on our service, please write to 696e666f72407373772e636f6d2e6175 or visit us at www.ssw.com.au
SSW Pty Limited
Gateway Court, Suite 10, 81 - 91 Military Road, Neutral Bay, NSW,
2089
Phone: +61 2 9953 3000 Fax: +61 2 9953 3105
www.ssw.com.au
SSW specialises in delivering efficient, cost effective solutions for your database or Internet requirements. Our ability to integrate these functions together helps companies streamline operations, while making the most of opportunities presented by the 'on-line' world.
If you can't use our services at the moment but know someone who may, pass on our details.........it could earn you some easy $$$$! SSW has a guaranteed $150 Spotters Fee for any referrals we convert into new Database or Web Site development business.
We're not the people surfing the net, we're the people making the waves.
You receive this newsletter as a client and friend of Superior Software for
Windows.
To unsubscribe from this newsletter: info@s*w.com.au