South African SQL Server User Group revived

Gail (our very own SQL MVP, aka GilaMonster) is reviving the SQL Server User Group, with a meeting at 18:30 on Tuesday the 21st of October.

Lime Green Businessman Holding A Skeleton Key And Standing In Fr 

The session is titled "Effective Indexing". For more details teleport to here.

Posted by willy with no comments

DRP Drilldown - LINQ

When 29th October 2008 (08:30-15:00)
Where BB&D, Collaboration Centre
Presenter Robert MacLean, BB&D ASTRA Technology Core (ATC)
Description

A drilldown bootcamp, focusing on LINQ, which is the code name for a set of extensions to the .NET Framework that encompass language-integrated data query, set, and transform operations.

This is a developer readiness program (DRP event. Seats are therefore limited and registration essential.

saa_Logo_thumb3_thumb3interop_thumb4_thumb3

This Developer Readiness Program (DRP) session, hosted in the Collaboration Centre at Barone, Budge & Dominick (BB&D), is open to one registered SA Architect member for free. To reserve a seat, please contact one of the SA Architect leads, see www.saarchitect.net for details.

Posted by willy with no comments
Filed under:

Tech·Ed Online: What are MVPs and what does it take to be one?

Microsoft has posted the first of three Tech Ed Online sessions we were involved in ... tough seeing and listening to myself. Thanks Ruari, Henk and Zayd for a great chat and recording q;-)

Microsoft has posted the video to Tech·Ed Online: What are MVPs and what does it take to be one?. You can find the video on the Portal page and the Library page.

Please be sure to let us know if you have any questions or concerns with the contents q;-)

clip_image001www.microsoft.com/techedonline

The other two videos will probably be posted on the 27th October.

Posted by willy with no comments

RDBMS 101 - Relational Set Operators

Busy with DBMS implementation and management studies I stumbled across the following statement "To be considered minimally relational, the DBMS must support the key relational operators SELECT, PRODUCT and JOIN".

Although there are eight (8) documented relational operators, only a few database systems support all eight. What was the trigger for this blog post is the PRODUCT operator, which I could not remember in Microsoft SQL Server ... so SQL Server is not minimally relational?!?

Blue Man Holding a Clipboard While Reviewing Employess Clipart Illustration

Here is the summary of my exploration:

Set Operator

Description

Pseudo Examples

U/C

MS SQL Server

SELECT

Returns all rows in a table that match a certain criteria

SELECT from A where C2 is equal to 1 = R-5

image image

 

SELECT clause

PROJECT

Returns all values for selected attributes, showing a vertical view of a table.

PROJECT C1 for table A = R-6

image image

 

SELECT clause

JOIN

Combines two or more tables, using natural, equi, theta, left outer or right outer joins.

A JOIN E ON C1 and C3 (natural) = R-7

image image image

A JOIN E (left outer) = R-8

imageimage image

A JOIN E (right outer) = R-9

image imageimage

 

JOIN operator

UNION

Combines all rows in one table with all rows in another table, without including duplicates.

A UNION B = R-1

imageimage image

Yes

UNION [ALL] operator

 

ALL: If defined, duplicate rows are included.

INTERSECT

Compares two tables and combines only the rows that appear in both tables

A INTERSECT B = R-2

imageimageimage

Yes

INTERSECT operator

DIFFERENCE

Compares to tables and returns all rows that are found in the one, but not the other table.

A DIFFERENCE B = R-3

imageimageimage

 

EXCEPT operator

PRODUCT

Create all possible pairs of rows from two tables, resulting in the Cartesian Product

A PRODUCT E = R-10

imageimageimage

 

CROSS JOIN operator

DIVIDE

Weird operator, where the one table has two columns and the other table one column. Returns value of Column 2, which is associated with every value of Column 1 in both Table 1 and 2. Weird ...

C DIVIDE D = R-4

image image clip_image002[60]

 

No clue ...

In other words, MS SQL Server is minimally relational and more, except that the PRODUCT operator is implemented with the JOIN. Although I have no clue what the DIVIDE operator is supposed to be good for, the quick DB exploration was fun.

Posted by willy with no comments
Filed under: ,

Honorary List ... it is time to thank a lot of people for their efforts in the SA Community for 2008!

It is unfortunate that most heroes are never mentioned or known to the world, with them operating under cover, deep behind enemy lines and often unselfishly fighting for everyone but themselves. I am, however, not nostalgic and talking about the war heroes of the many wars that have raged on planet Terra, instead I am referring to the heroes in the information technology world, making a huge difference to the South-African IT communities.

My definition for a hero is a person who goes beyond the expectations, shows relentless passion and energy and is willing to push the boundaries, for the good of the community.

Aftermat ... often the Heroes are the last left, when the going gets tough!

The list is long and I am likely to omit someone ... but as it is more important to start the list and add names until the list is complete, I herewith present my list of heroes in the "South-African" IT communities I am exposed to, listed in no specific order:

Name

Nomination

Almero Steyn

He created all the artwork for our interoperability drive, relentlessly making changes as we requested more and more changes.

Charles Sterling “Chuck”

Located in Redmond, “Chuck”, has supported us in hard times, downloading huge amounts of software, bits and pieces, which we needed but were unable to download in time for local community initiatives.

Henk Du Plessis “Mumbles”
interop

Our very own interoperability “Mumbles”, defending neither the open-source or other trenches, but standing in the middle of no-man’s land and helping us bridge the troubled interoperability environments and making seamless and invaluable integration and interoperability a possibility. He is very active in the academic community and hosting technology readiness sessions, available to SA Architect members. 

Hilton Giesenow
MVP

One of our architecture champions, sharing experience and knowledge with the professional and academic communities.

Jeff Beehler
image 

Located in Redmond, Jeff has supported SA by managing the “stage coach” disk drive we exchange on a regular basis to solve our limited bandwidth problems. He also publically wore the MVP Interoperability jacket, demonstrating the support for interoperability and giving our initiative unbelievable credibility.

Martin Woodward
image 

Located in the UK, Martin has supported us and our academic  initiatives, allowing us to realise our interoperability vision and bringing the amazing TeamPrise technology to the students of today and IT professionals of tomorrow. Thanks to Martin, we recently received an amazing sponsorship of $20,000 for TeamPrise technologies, which we are able to share with the academic community and promote the development environment in the real world ... an integrated one q;-)

Nicolas Blank
MVP

No event is complete without Nicolas’ smile and enthusiasm. He assisted us with Exchange issues in his own time with so much enthusiasm and professionalism, that one would like to

Robert MacLean

Everyone will know him in the BizTalk and SharePoint communities ... he is freely sharing his brain storage and is actively hosting technology readiness sessions, available to SA Architect members.

Ruari Plint 
P8040206 

Our very own MVP Program manager, making the impossible, possible, worrying about politics, taking care of the MVPs and allowing us to focus on what is important, the communities. Also known to arrange strange competitions at TechED, i.e. hunt the MVPs, which can lead to stressful times ...

Ryan CrawCour

Having a problem with BizTalk? This is the champ to talk to and the pillar behind the BizTalk community in South-Africa.

Willie Roberts

The dude that motivates his students in class, is active in the communities, relentlessly manages the community stand at TechED and more recently busy in bringing the numerous IT communities together ... a difficult, but essential mission. TechED without Willie would not be worth going to if you are part of the communities and next time please visit his community lounge!!!

Zayd Kara 
IMAGE_052 (Henk & Zayd)

Active as the “server dude”, evangelist of automated builds and most recently our very own certified scrum master. He is active in the academic community and hosting technology readiness sessions, available to SA Architect members.

Zlatan Dzinic “Bulldog”
MVP
P8040203

Infamous “Bulldog” ... not only does he write widgets in his spare time for the communities, not only does he host amazing technology sessions and discussions, but he is active in both the professional and academic communities.

People to watch ... will likely join the heroes list soon:

Name

Nomination

Herman Nolte
P8060256 

Our very own UI, WPF and Silverlight evangelist ... if only he would start sharing his wealth of knowledge and information in a blog. Nudge, nudge, ...

Garret Besser

The dude with immense energy and knowledge ... where are you Garret?

Paulo Fereira

The chap at Microsoft South-Africa, supporting us with the interoperability drive and ensuring that the mind set in terms of integration and interoperability evolves with many of the vendors and standards bodies in South-Africa.

"Heroes", thank you for all your efforts, for unselfishly sharing information, for investing an incredible amount of personal time, for caring about the communities and for making South-Africa a better and stronger "IT place".

We bow in front of you! 

If we went beyond the South-African borders we would need to list all of the TFS/VSTS MVPs and the VSTS Product Group members, both of which "rock!",  but for the time being, I will constrain the list to South-Africa.

Posted by willy with 3 comment(s)
Filed under:

Have you also forgotten the SUBST command by any chance?

I have been busy debugging and implementing workarounds for a toothache I experienced with Visual Studio and had to create a few directories on the D drive ... which I do not have on my laptop. Being pragmatic, I attached my external drive and created the directories ... fortunately Philip Kelley dusted off a few of my spider webs by saying "It’s easier to use the subst command".

Blue Einstein Man Pointing a Stick at a Presentation of a Flying Saucer Clipart Illustration

In case you have also forgotten this useful command, let me demonstrate its use:

  1. Assume you need a path d:\silly\cool\command ... Note to Herman, this is an arbitrary, non-meaningful path, used for demo purposes only.
  2. Problem is that you only have a c: drive.
  3. Fire up the command line, Start -> Run -> Cmd -> Enter
  4. Type in the following command: Mkdir c:\demo\silly\cool\command
    image
  5. Type in the following command: Subst d: c:\demo
    image
  6. Now for the acid test, run the command dir d: /s /ad, which would have failed before step 5.
    image Blue Businessman Standing by a Large Exclamation Point Clipart Illustration

To summarise:
image

Thanks for pointing out this great DOS command Philip! We should spend far more time on the command line ... there is so much power we take for granted these days and a lot of power we have unfortunately forgotten.

Posted by willy with no comments
Filed under: ,

SAArchitect - News and request for member registration!

image Traveling Blue Business Man Sitting Under an Umbrella at a Table Using a Laptop Computer Clipart Illustration

If you have been, are or would like to become a member of the SA Architect community, then please register yourself on our new community site (see point 3 above). The site can be found at http://www.saarchitect.net.

We are displaying the SA Architect hosted events or events that SA Architect members have access to on the home page of the new site (see point 2 above). Please keep an eye on the events and advise as to what is good, bag or ugly ... q;-)

Lastly if you are in the academic world, please have a look at our latest academia initiative (see point 1 above) and download the academia program flyer for more information.

Posted by willy with 5 comment(s)