• Friday with International Community Update – Articles about Microsoft Licensing and Certification from Brazil

    Hello Community, Luciano Lima here today to update you on the latest news in the TechNet Wiki international community from Brazil.

    The highlight of this week goes to Ana Paula de Almeida who wrote several of articles about Microsoft Licensing and Certification.

    Site: http://anapdealmeida.com

    Twitter: https://twitter.com/anapdealmeida

    Listed below you can see the latest articles about Troubleshooting written by her:

    Great work!

    Big hugs go to the TechNet Wiki community, keep up the contribution, have a great Friday and don’t forget to tweet #TNWIKI and follow us:

    @WikiNinjas

    @WikiNinjas_BR

  • Community Win: How to Ban or Report a TechNet or MSDN User Account

    Hello and welcome everybody to our Thursday - Community Win.

    Today I don't want to talk about an article with a lot of peoples working on it and many contributions.

    But it is Thursday! It is time for a community win!

    I know and in my opinion the following wiki article already has a lot of unseen contributors and is one of the biggest community wins ever. But let me explain that.

    Do you love soccer? Or do you like spam?
    What has one thing to do with the other?

    If you are an active user of the MSDN/TechNet forums or a contributor to the TechNet wiki you could probably guess what I mean. In the last couple of weeks we have seen a lot of spam posts in the forums. Especially in the last days, where in many countries the new soccer season has begun. And what did you see? A lot of advertising for sites, where you can watch the games live. Also in the TechNet wiki we see spam/advertising articles about other topics/products every day.

    What can we do against these posts and articles?

    What I normally do is to report every post/article as abuse or mark it as spam. But that's a lot of work. How can you help to identify the appropriate users and ban them from our loved wiki and forums (at least for some time)?

    Ed Price wrote an article in the MSDN/TechNet Forums article series: How to Ban or Report a TechNet or MSDN User Account. In a perfect world there is no need for an article like that, but hey ... that is real life. If you want to help to make our (online) life a little bit better help to keep our wiki and forums clean.

    - German Ninja Jan (Twitter, Profile)

  • Wiki Life: Reusable Parts

    Hello everyone, and welcome to the Wednesday - Wiki Life series again!

    Screenshots are useful, aren't they? Giving a visual example in the middle of the explanation of a more or less complex technical feature makes understanding easier for the readers.

    But what can you do when you have (or someone else has) a nice screenshot or image somewhere in a TechNet Wiki page, which should be displayed in other articles as well? Especially, when you need the same formatting - border width, image width and height settings, and so on? Uploading the image and setting its properties multiple times, hoping that there will be no mistakes... - there is an easier way in TechNet Wiki! Just reuse the code of the images!

    To give at least one example: compare the HTML code of SSIS Pivot Transformation (en-US) and SSIS Pivot transzformáció (hu-HU). You can do it by visiting both pages, clicking on "EDIT" after logging in, and switching to HTML edit mode with the "<> HTML" button at the bottom of the editor (next to the Design button):

    You will see the same references in the src property of the <img> tags (in case of the same screenshots, of course):

    If  you copy this part of the original page and insert to your new one, you'll have the same image with the same formatting in seconds.

    Of course, when you're translating, you can start with copying and pasting the whole HTML code of the source page, and edit the text only in Design mode - but don't forget that you reused all images in this case, too! :) Next time, when you have to update a reused image (note to myself, the screenshots of the SSIS transformation pages should be updated to SSIS 2012 now), I'm sure that you will update them this way - uploading a new one, and reusing its HTML code piece. It will save you a lot of time.

    Have fun with TechNet Wiki!

    Zoli

  • TNWiki Article Spotlight: Apache Hadoop on Windows

    Welcome to Tuesday's Article Spotlight!

    Check out the full version of the article here:

    Hadoop-based Services For Windows (en-US)

     

    This blog post is a preview of the content in that article (you'll find 3-5 times more information in the TNWiki article). The article (and many others about Hadoop) is written by Wesley McSwain, SQL Server technical writer.

    Hadoop Overview

    Apache Hadoop is an open source software framework that allows for the distributed processing of large data sets across clusters of computers using a simple programming model. It consists of two primary components: Hadoop Distributed File System (HDFS), a reliable and distributed data storage, and MapReduce, a parallel and distributed processing system. A Hadoop cluster can be made up of a single node or thousands.

    HDFS is the primary distributed storage used by Hadoop applications. As you load data into a Hadoop cluster, HDFS splits up the data into blocks/chunks and creates multiple replicas of blocks and distributes them across the nodes of the cluster to enable reliable and extremely rapid computations.

    Getting Started with Hadoop-based Services for Windows

    The links in this section provide information on deploying Apache Hadoop to Microsoft Windows Platforms. All these articles are on TechNet Wiki:

    LinkDescription
    Getting Started with Hadoop-based Services for Windows An overview of the Getting Started guides currently available.
    Getting Started a Hadoop cluster on the Elastic Map Reduce Portal.  A walkthrough for provisioning and using a temporary Hadoop cluster on the Elastic Map Reduce Portal (EMR) Portal.

     

    Using Hadoop with other BI Technologies

    This section contains information on using Hadoop with other BI technologies. All these articles are on TechNet Wiki:

    Link Description
    How to Connect Excel to Hadoop on Azure via HiveODBC Explains how to use Excel 2010 to access data in the Hive data warehouse running on Windows Azure by using the Hive ODBC Driver.
    How to Connect Excel PowerPivot to Hive on Azure via HiveODBC Explains how to use PowerPivot to access data in the Hive data warehouse running on Windows Azure by using the Hive ODBC Driver.

     

    How To

    This section contains a list of Hadoop-related how-to articles. All these articles are on TechNet Wiki:

    LinkDescription
    Hadoop-based Services on Windows Azure How-Tos and FAQs  A collection of common How To topics along with FAQs. 
    How to Run a Job on a Provisioned Hadoop on Windows Azure Cluster  Information about creating Map Reduce jobs on a cluster that has been provisioned on the Elastic Map Reduce (EMR) portal
    How To FTP Data to Hadoop on Windows Azure A walkthrough for using FTPS to send file data to the cluster
    How to create a mapper and reducer in C# (Hadoop Streaming) A walkthough for creating a mapper and reducer in C# using Hadoop Streaming
    Use SQL Azure database as a Hive metastore Information about using SQL Azure database as a Hive metastore

     

     

    Check out the article and add to it here (it's a log bigger than the sections I featured in this blog post):

    Hadoop-based Services For Windows (en-US)

     

    Jump on in. The Wiki is warm!

       - Ninja Ed

  • Monday interview with content contributors from Southeast Asia (3/3) - Somkiat Foongkiat and Aris Lesmana

    Today is the last of a 3-part interview (Part 2 & 3 on 20/aug, 27/aug) and the we are honoring an energetic group of content contributors from Southeast Asia.
    They are the MVPs from Indonesia, Thailand, Vietnam and Sri Lanka.

    In part 3 of this trilogy, Tiffena interviews Thailand MVP Somkiat Foongkiat and Indonesia MVP Aris Lesmana

     

    Thailand MVP Somkiat Foongkiat (TechNet Profile) 

    Who are you, where are you, and what do you do?

    My name is Somkiat Foongkiat and I’m based in Bangkok, Thailand. Since 1996, I have been an Excel instructor, writer, and problem solver via my courses, web articles, and forum at www.ExcelExpertTraining.com.
    After graduating with a MBA-Finance from University of Wisconsin in 1986, I have had experiences in system development at The Siam Commercial Bank PCL and in business planning at Charoen Pokphand Group.
    Before becoming an Excel instructor at the Technology Promotion Association (Thailand-Japan) which was a non-profit organization, my last position was a Senior Vice President in a property business.
    These qualifications have enabled me to be able to apply Excel more compatibly and thoroughly with various business needs from lower to upper level of management.

    What are your big projects right now?

    I am planning to write articles in each series which will be posted to Wiki as many short mini articles. Right now is about “What’s a must in Excel”. It should take 2-3 months to complete a series. I also have hundreds of my old articles posted in my blog that I will selectively post into Wiki.

    Besides your work on TechNet Wiki, where do you contribute?

    I have a blog at http://www.excelexperttraining.com/forums/content.php?r=3. When I write any new articles for wiki, I will also have them reposted in my blog.

    What is it about TechNet Wiki that interests you?

    Wiki from Microsoft should be the international library for the world and more reliable than my blog. When I die, Wiki is still available for the public.

    On what Wiki articles do you spend most of your time? And what are your favorite Wiki articles you’ve contributed?

    Designing Excel Calculation Module. My favourite wiki articles as follow:

    Part 1 - http://social.technet.microsoft.com/wiki/contents/articles/3603.aspx
    Part 2 - http://social.technet.microsoft.com/wiki/contents/articles/3605.aspx
    Part 3 - http://social.technet.microsoft.com/wiki/contents/articles/3606.aspx
    Part 4 - http://social.technet.microsoft.com/wiki/contents/articles/3607.aspx

    It took me almost 6-9 months to complete.

     

    Indonesia MVP Aris Lesmana (TechNet Profile)

    Who are you, where are you, and what do you do?

    My name is Aris Lesmana, an Office System MVP in Indonesia.

    I'm currently working as an IT Technical Trainer for general desktop application (including Microsoft Office System), and Windows
    Server System. To support my activities as trainer, I'm holding several IT certifications, such as MCT, MCDST, MCSA, MCITP, MOS, CEI, CEH, CEP, and
    CompTIA A+. 

    Why Microsoft Office?

    In my opinion, Microsoft Office is a must have application for everyone.
    There are a lot of features in Office which will make us work faster and more productive.
    So I’m always trying to make people more aware and more realize about the benefit by using Microsoft Office in their daily activities.

    Besides your work on TechNet Wiki, where do you contribute?

    Writing in my personal weblog, contributing in TechNet Indonesia forums, discuss anything related to Microsoft Technologies in various Microsoft Community Facebook Groups (MUGI, WSS-ID, and Office Certified), and speaking in various IT / Technical events.

    I write articles too for several computer magazines in Indonesia, and already published 2 books about Microsoft Office titled ”Buku Pintar Microsoft Word (EN: Microsoft Word Smart Book)” and ”3 Jam Mahir Microsoft Office (EN: Learn Microsoft Office in 3 Hours)”.

    What is TechNet Wiki for? Who is it for?

    TechNet Wiki is a learning portal or platform for everyone that has a passion to share and to learn about all things related to Microsoft products and technologies.

    What do you do with TechNetWiki, and how does that fit into the rest of your job?

    It’s nearly impossible to memorize all things about Microsoft technologies, so if I forget about something then I’m just opened TechNet Wiki and search what I need.
    And if I didn't find what I am looking for, then I’ll try to write it. This really helps my job as an IT trainer.

    What is it about TechNet Wiki that interests you?

    People can write articles and share to anyone else. And if there’s a mistake in the article, another people will contribute to fix it, or even add some additional information to make the
    article more complete than the original one.

    On what Wiki articles do you spend most of your time?

    Mainly for articles related to Office System and Windows Live.

    What are your favorite Wiki articles you’ve contributed?

    Introduction to Silent Installation Method for Microsoft Office 2010 (ID: Mengenal Metode Silent Installation pada Microsoft Office 2010).
    This article will help us to install Office in a faster way as compared to traditional installation method.

    What are your top 5 favorite Wiki articles? 

    What does success look like for TechNet Wiki?

    We get to learn through writing :)

    Do you have any other suggestions for TechNet Wiki?

    Is there any plan to support authoring article by using Windows Live Writer?
    I’m really waiting for this application because it’s more simple and easy to write technical content by using Live Writer rather than using web-based editor.

     

    Interview by: Tiffena Kou
    Edited & published by: Peter Geelen