SSW Tech Breakfast

SSW Update - Do you know when to use Reporting Services?

Tech Breakfast - October 2006

Tech Breakfast

8 days      to go!

SQL Server 2005: Advanced Indexing Strategies
Friday 6th October 2006
8:00am - 11:00am

In this session we look at a fast-paced collection of indexing tips and tricks based on an already optimised base table structure. How you create your base table - as well as cluster it - has a big impact on that table's performance.

Once the base table structures have been defined and you have to further improve system performance, where do you look and how do you do this?

We will also talk about targeting both the known and finding the unknown performance problems. Once you know where the problems are we'll go through numerous options to improve the performance using indexes.

Register NOW

Tech Breakfast - October 2006 

Tech Breakfast

29 Days to go!

Introduction to Microsoft Expression
Friday 27th October 2006

A practical session for the IT Industry exposing attendees to the new Microsoft Expression framework.

Register NOW

Tech Breakfast - Nov 2006

Tech Breakfast

57 Days to go!

SYDNEY: Rules to Successful Projects (Part A & B) - Presented by Adam Cogan
Friday 24th November 2006

What makes a good software development consultancy? What sets one company completely above another? What makes a project completely successful? In this special Sydney session, Adam will look at each of these questions and give you the answers you are looking for!

Register NOW

News - October 2006

SSW Consulting Completes 2 year financial modeling project for Commonwealth Bank of Australia

More SSW News

Employment Opportunities at SSW

Due to the tremendous growth that our business has experienced over the last few months, we are seeking enthusiastic people to join the SSW team.

Our Company is based in Neutral Bay which is one of the most elegant and scenic areas of Sydney. SSW is an Australian owned progressive consulting firm specialising in building, implementing and maintaining Microsoft .NET software applications.

We are currently looking for:

  • .NET (and OLAP) Developer
  • IT Marketing Administrator
  • Office Manager
  • Project Manager

Read more and Apply NOW...

Microsoft Gold Certified Partner

Microsoft Gold Certified Partner

Microsoft Gold Certified Partners are the elite Microsoft Business Partners who earn the highest customer endorsement.

Call us NOW +61 2 9953 3000

The Cutting Edge

G'Day Developers!

Do you know when to use Reporting Services?

Like any solution, Reporting Services has its pros and cons. From our experience, we have discovered these things about Reporting Services:


  • Parameters - you are forced to use built-in controls
  • Query string - when you change the parameters and refresh a report, the values do not appear directly in the query string, making it hard to copy/paste URLs
  • Can't separate SQL into a strongly-typed dataset or middle-tier object like in ASP.NET
  • There are potential difficulties with the deployment of RS reports and the exposing of them. However, once we have the infrastructure...


  • You can develop read only reports faster in Reporting Services than ASP.NET
  • Maintenance with RS is easier as in most cases you don't have to write any code
  • Flexibility with groupings and totals is easier ?in ASP.NET you would need to iterate through the DataSet keeping variables with the totals
  • Parameters are built-in ?in ASP.NET there is code
  • Drilldown interactivity ?in ASP.NET you need to code up a treeview
  • Users can have reports emailed to them automatically on a schedule
  • Users can export natively to PDF and XLS, plus a variety of other popular formats

So in conclusion, if you will only ever need 1 report, go with ASP.NET - it is easier to get up and running. If you plan to have more than one report, use Reporting Services - it's worth the time to set-up.

For a more detailed comparison between reporting solutions, take a look at our Guidelines for Report Solutions - Web Clients.

More on Rules to Better Microsoft SQL Reporting Services...

Cheers until next time,

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

20 days to go!

Sydney .NET User Group
Wednesday 18th October 2006
5:45pm - 9:00pm
Location: Microsoft, Sydney

Software as a Service - Catching the Long Tail

The guest speaker Nigel Watson from Microsoft Australia will be talking about how from small start-ups to large enteprises, software as a service (SaaS) is changing how software is designed, developed and consumed. This session discusses the business drivers behind SaaS, and then looks at how these in turn drive the architecture of SaaS solutions as opposed to 'on-premise' software.

Along the way, he will discuss the technical issues that any current or prospective SaaS vendor will need to grapple with in order to successfully deliver software as a service.


Tim Kremer will continue to discuss the Microsoft Ajax Library from last month's session and will further reinforce its benefits and features such as:

- Ability to integrate cross-browser client script libraries with the ASP.NET 2.0 server-based development framework.

- Atlas' ability to take advantage of AJAX techniques on the web, thus enabling you to create ASP.NET pages with a rich, responsive UI and server communication.

- Due to Atlas' extension of ASP.NET, it is fully integrated with server-based services.

Throughout his presentation Tim will take a one step further by providing you with worked examples of the new client libraries as well as using the server side libraries to add ajax functionality to your ASP.NET existing applications.

See You There!! | Sorry I can't make it

Gain the knowledge and skills required to deploy and manage reports using Microsoft Reporting Services

Microsoft SQL Server 2005 Reporting Services - 2 Day Program


18 days to go!

Microsoft SQL Server 2005
Reporting Services

Monday 16 & Tuesday 17 October 2006
9:00am - 5:00pm
Location: SSW, Sydney

This 2 day course has been specifically designed by the Sydney based SQL Guru and MS Regional Director Adam Cogan. Throughout this course Adam will cover the most popular reporting technologies in the industry, comprehend the new Report Designer, the important differences between Access Reports and Reporting Services and much more.

There is also a practical side to this course as you will get to be exposed to real life examples of Microsoft's landscape of enterprise reporting and learn the right and wrong ways of developing reports.  

To find out more about the course's content, please see More on Reporting Services Training

Register now

NRG Solutions & SSW in association with Users present: Earning More Per Hour As a Developer

Attend these sessions and learn to market yourself and position your solutions to customers. 


Picture of Steve HerzbergSteve Herzberg - Sales Director at NRG Solutions. Steve has worked closely with Microsoft at this year's Code camp and has for the past few years assisted the team at SSW with tailored marketing and sales support. NRG Solutions are a training consulting company with a focus on sales and marketing skills and strategies for IT staff and companies. Steve is regarded as one of Australia's most engaging speakers and will show you how to take the next step in your career as a developer . Clients of NRG Solutions include: ANZ Bank, CGU, Microsoft, SSW, Cricket Australia & Fitness First.

In this introductory workshop, Steve will cover:

  1. How to conduct great client focused sales meetings
  2. Understanding why writing a proposal is often not the best approach to winning a new client
  3. When is the best time to position your solution to a client
  4. Appreciate how and why clients make decisions when buying IT and choosing developers
  5. Understand how to retain and effectively grow business from your clients
  6. Appreciate the power of your non verbal message
  7. Earn more per hour and clearly justify why you emerge the hourly rate that you do

Picture of Adam Cogan

Adam Cogan - Chief Architect at SSW and Microsoft Regional Director. Adam has been developing custom solutions for businesses across a range of industries such as Government, banking, insurance and manufacturing since 1990 for clients such as Microsoft, Quicken, and the Fisheries Research and Development Corporation. His wealth of experience in the industry and unsurpassed technical knowledge will ensure attendees get the most out of these sessions.

Managing a team of coders can be a tricky experience, especially as most coders like to do things their own way. During this session Adam will go through a list of rules that help make the development process as smooth as possible. These rules govern the creation of specifications and schedules, best methods for testing and fixing bugs and even the employees working conditions.

So come and join Steve and Adam as they take you through "Earning More Per Hour as A Developer"
More on "Earning More Per Hour as a Developer"...

Sydney Full Day Workshop - $99 (+GST)
Date: 29th September 2006 - 1 day to go!
Time: 11:00am - 5:00pm
Location: Microsoft Sydney
1 Epping Rd,
North Ryde,
Sydney NSW 2113
Register now
Brisbane Full Day Workshop - $199 (+GST)
Date: 10th October 2006 - 12 days to go!
Time: 11:00am - 5:00pm
Location: Microsoft Brisbane
Level 9, Waterfront Place,
1 Eagle Street,
Brisbane QLD 4000
Register now
Canberra Full Day Workshop - $199 (+GST)
Date: 31th October 2006 - 33 days to go!
Time: 11:00am - 5:00pm
Location: Microsoft Canberra
Level 2, 44 Sydney Avenue,
Canberra ACT 2600
Register now

Featured Service: SharePoint

SharePoint 2007 
Microsoft's CMS solution

Microsoft Office SharePoint Server 2007 improves organisational effectiveness by providing one unified suite of enterprise-scale applications. This satisfies diverse business-critical needs such as; managing content and business processes, simplifying how people work together across boundaries, and enabling better informed decision-making.

More on SSW Microsoft SharePoint 2007...


Currently 22,013 members