Tech-Ed 2006

It looks like the Microsoft Australia Tech-Ed 2006 page (http://www.microsoft.com/australia/teched2006/) was updated over the weekend with additional details including further track information. Also if you are looking at taking a taking an MCP Exam in the next couple of months it might be worthwhile holding out until Tech-Ed as they will be available for $60 (instead of $180).  If you are looking for details regarding preferred hotels these are displayed when you purchase your ticket however if you have already purchased your ticket or just want to have a look at the hotels on offer they can be found at https://www.infosalons.com.au/teched2006/ita/ita.asp.

Inaugural WARDY IT Monthly Community Dinner

Last night was the first WARDY IT Monthly Community Dinner which was held at Ahmets Turkish restaurant at Southbank. The event was a great success and the feedback from the event was extremely positive with everyone looking forward to the next dinner.  The consensus was that having the opportunity to ‘find out what other people are doing and how they are doing it’ was a great idea.  We were also lucky enough for Adam Cogan from SSW to attend last night’s dinner. Adam is in town to present at tonight’s QLD MSDN User Group on ‘integrating VSTS into your current systems’, for more details and to find out when this presentation is being held in other capital cities refer to http://www.ssw.com.au/ssw/events/conference.aspx.

One of the suggestions made last night is that the WARDY IT Monthly Community Dinner should be scheduled to occur on a re-occurring basis on the 2nd Monday of the Month and when there is a public holiday the next Tuesday.  So the next WARDY IT Monthly Community Dinner will be on Tuesday the 13th of June due to the Queens Birthday public holiday.

If you would like to be involved in the next WARDY IT Monthly Community Dinner, it is being held on Tuesday the 13th of June from 6:30PM at the Punjabi Palace Indian restaurant at West End.

WHERE Punjabi Palace Indian restaurant | 135 Melbourne Street | West End http://www.punjabipalace.com.au/inner.asp?menu=4
WHEN Tuesday 13th June | 6:30PM
RSVP Friday 9th June
Please note that your are responsible for the cost of your own dining.

Please ensure that you RSVP to this event by sending me an email (peter @ wardyit.com) prior to Friday the 9th of June so that I can make a booking for you.

I look forward to seeing you at the next WARDY IT Monthly Community Dinner.

DNRTV with Adam Cogan

I have recently been re-listening to some of the older .Net Rocks (http://www.dotnetrocks.com) episodes whilst travelling to a remote client site and one of the suggestions on episode #93 was for an ‘audio shootout’ to review the most popular ASP.Net controls available. Well the previous DNRTV episode (http://dnrtv.com/default.aspx?showID=17) with Adam Cogan from SSW does just that.

It is always good for someone who has used all of the controls to review them unbiasedly, as the problem with reviews of third-party controls is the best review typically goes to the sponsor of the review. In this DNRTV episode Adam isn’t afraid to speak his mind on some of the benefits as well as the limitations of most of the popular ASP.Net controls available for Grids, Treeviews and Datepickers. If you are looking at purchasing a Third-Party ASP.Net control then you shouldn’t miss this episode of DNRTV as it might save you from shelling out for a control only to find out that it doesn’t cut the mustard.

UNPIVOT a Table

The example below illustrates how to UNPIVOT a table.  The example can be used in both SQL Server 2000 and 2005.

CREATE TABLE dbo.TableToUnPivot
(
SalesYear INT,
Q1 INT,
Q2 INT,
Q3 INT,
Q4 INT
)

INSERT dbo.TableToUnPivot SELECT 2003, 1, 2, 3, 4
INSERT dbo.TableToUnPivot SELECT 2004, 5, 6, 7, 8
INSERT dbo.TableToUnPivot SELECT 2005, 9, 10, 11, 12

SELECT  *
FROM  dbo.TableToUnPivot

Returns:

SalesYear   Q1          Q2          Q3          Q4
———– ———– ———– ———– ———–
2003        1           2           3           4
2004        5           6           7           8
2005        9           10          11          12

SELECT SalesYear, T1.Nums AS Quarter,
CASE T1.nums
WHEN 1 THEN Q1
WHEN 2 THEN Q2
WHEN 3 THEN Q3
WHEN 4 THEN Q4
ELSE NULL
END AS UnPivotedData
FROM TableToUnPivot
CROSS JOIN
(
SELECT 1
UNION
SELECT 2
UNION
SELECT 3
UNION
SELECT 4
) T1 (nums)
ORDER BY SalesYear, Quarter

Returns:

SalesYear   Quarter     UnPivotedData
———– ———– ————-
2003        1           1

2005        1           9
2005        2           10
2005        3           11
2005        4           12

(12 row(s) affected)

SQL Server 2005 Import Export Wizard

A question I have been asked a lot lately is “where has the Import Export Wizard gone in SQL Server 2005”.  The wizard has not disappeared although it is no longer as obvious as it used to be.

The easiest way to launch the Import Export Wizard is to execute dtswizard.exe from START | Run.

Alternatively you can open SQL Server Business Intelligence Development Studio and start a new Integration Services project.  You can then select the SSIS Import Export Wizard from the Project menu.

WARDY IT Monthly Community Dinner

There has been a lot of community discussion recently regarding the opportunities available for IT professionals to get together in a social environment to share experiences and advice regarding the challenges that we tackle everyday.

With this is mind, I would like to start a monthly Community Dinner where there is an opportunity to meet other IT professionals and gain an insight into how problems and issues are being tackled ‘on the other side of the fence’.

If you would like to be involved in the Inaugural WARDY IT Monthly Community Dinner, it is being held on Monday the 15th of May from 6:30PM at Ahmets Turkish restaurant at South Bank.

WHERE Ahmets Turkish restaurant | Shop 10/164 Grey Street | South Bank http://www.ahmets.com/contact_us.html
WHEN Monday 15th May | 6:30PM
RSVP Friday 12th May
Please note that your are responsible for the cost of your own dining.

Please ensure that you RSVP to this event by sending me an email (peter @ wardyit.com) prior to Friday the 12th of May so that I can make a booking for you.

Please feel free to pass this invitation along to any colleagues that you feel may be interested in participating in this event. As anyone who has a passion for excellence whether you are a CIO or a Graduate Developer is welcome to attend.

I look forward to seeing you at the Inaugural WARDY IT Monthly Community Dinner.