SSW BIG Tech Breakfast
SSW Update - How much intelligence in the setup.exe?
Tech Breakfast - January 2006
SSW Tech Breakfast


11 days to go!

Reporting Services 2005
Friday 27th January 2006
8:00am - 11:00am
Location: SSW
Share in Adam Cogan's knowledge and acquire the skills to author, deploy and manage reports using the brand new Microsoft Reporting Services 2005. After this session you will be able to:
  • Understand the Architecture of Microsoft Reporting Services and Office integration.
  • Author reports using Report Designer.
  • Deploy and publish reports.
  • Manage the lifecycle of a report, including report scheduling and backup and restore.
  • Understand how to apply Reporting Services to a business problem.

Register NOW

Tech Breakfast - February 2006
SSW Tech Breakfast


39 days to go!


TOP 15 SQL Server DBA Tasks for SQL Server 2005
Friday 24th February 2006
8:00am - 11:00am

In this session we will examine:

  • How to automate your SQL Server 2005 servers and set them on "auto-pilot" for routine tasks.
  • How best to take advantage of the DBMaint utility to automate your backups and index reorganisation. Take a look at how to set-up your alerts and operators to get proper notifications when events occur.
  • Administering proper security, testing your restores, and routine performance monitoring. tuning. Examine resources to help you diagnose problems as they occur on your SQL Servers.

Register NOW

Happy New Year from SSW
Merry Christmas :)




From all the staff at SSW we would like to wish you the very best for 2006.

May this year bring you health, wealth and happiness.

HAPPY NEW YEAR - Have a blast :)

Lumigent Log Explorer You are going to a site outside of SSW
Access Unlimited
by Garry Robinson You are going to a site outside of SSW
Database FAQ's and Links

How do I restore the Northwind sample Database to its original state?  - answered by Ross Donald.
How do I install SQL Server 2005 with the Adventure Works Samples? - answered by: Michael Mileos

The Cutting Edge

G'Day Developers!

How much intelligence in the setup.exe?

Setup.exe should really just do an xcopy. I don't believe in putting very much intelligence (like creating databases, virtual directories etc) into the Wise Setup. We put them into the actual app. However if you want to, see our KB about how to create a SQL Server database or how to create a virtual directory as part of a script.

Exceptions do exist. We do put intelligence into the setup.exe if we need a clean uninstall. Examples where we put intelligence in the setup.exe:
  • Adding a VS.NET Toolbar - SSW Health Auditor adds a Toolbar - we would prefer to do that inside the UI of the CodeAuditor.exe however if they uninstalled that, the toolbar would still be there.
  • Adding a Outlook Toolbar - SSW Lookout and SSW eXtreme Emails have the same situation, installing Toolbars in Outlook
  • Installing MSDE - but the uninstall should tell them they have to delete the database first as per RulestoBetterInterfaces.aspx#CreateDatabase

If you make an exception you should add a file noting this
eg. C:\Program Files\SSW Code Auditor\_Instruction.txt

More on Rules to Successful Projects

Cheers until next time, Adam
SSW Chief Architect and Microsoft Regional Director, Australia

Got a comment for Adam? 6164616d636f67616e407373772e636f6d2e6175

Sydney .NET User Group - The best place to learn .NET for free in Sydney

User Group


2 days to go!


 Sydney .NET User Group Wednesday 18th January 2006

Microsoft's VirtualEarth Online Mapping
There are over 50 apps that run on top of Microsoft's VirtualEarth online mapping service. This month Adam Cogan and Neil Roodyn (if he has recovered from his nasty back injury) will take us over the top 5 that have popped up on You are going to a site outside of SSW

2 Cool Techniques For Flexible Windows Apps
Also this month Paul Stovell will look at 2 cool things he has worked into a Windows Forms App:

  1. Making an app more flexible for a large range of customers, without hardcoding business rules and choose into Tools - Options. You will see him using .NET and reflection to allow users to automate your applications.

  2. Making an app more flexible for a large range of customers, without hardcoding UI. Paul will show how you can host the ASP.NET runtime with your own Windows Forms client application, allowing you can render your own ASP.NET pages.

Wednesday 18 January 2006 5:45 pm
See You There!! | Sorry I can't make it

Reporting Services Training - Sydney
Reporting Services


42 Days to go!

Creating Reporting Solutions using Microsoft SQL Server 2005

Monday 27th & Tuesday 28th February 2006

No doubt that by now you have heard of Microsoft SQL Server Reporting Services - Microsoft's solution to the web reporting problem. Join Microsoft Regional Director and SSW Chief Architect Adam Cogan as he takes you through the basics of Reporting services, managing your report content, administering your reports as well as adding custom code.

Read more and Register NOW

Employment Opportunities @ SSW

We are seeking enthusiastic people to join the SSW team.

  • .NET Software Developer - with OLAP expertise
  • Marketing Manager.
Read more and Apply NOW
SSW SQL Auditor
SSW SQL Auditor

Keep your SQL Server database free from design flaws with SSW SQL Auditor

Are you looking for a consistent and optimised SQL Server database? Maintaining consistent quality code across a large team can be a challenge. Even when standards are in place, developers can make mistakes that will slip through Quality Assurance. SQL Auditor is a part of the range of database tools designed by SSW to  help to check best practice standards and optimise SQL Server performance. SSW SQL Auditor supports SQL Server 7/2000

More on SSW SQL Auditor...

SSW Home
User Group
Contact Us

Advertise with SSW | Unsubscribe | Previous SSW Updates | Got a Hot Tip to share? | Got a comment to make?
You were sent this newsletter because you have previously enquired about SSW products or consulting services.
Powered by SSW Email Merge PRO!
Currently 17,908 members