• Top Contributors Awards!! Excel in SSIS, Bing Maps, Hybrid Clouds, SQL Database Snapshots, Gurus & SQL DATA ANNIHILATION! D:

    Welcome back for another analysis of contributions to TechNet Wiki over the last week.

    First up, the weekly leader board snapshot...

     

    Congratulations to Benoit and Durval for leading the charts this week!

     

    As always, here are the results of another weekly crawl over the updated articles feed.

     

    Ninja Award Most Revisions Award  
    Who has made the most individual revisions

     

    #1 Benoit Jester - MTFC with 233 revisions. Excellent work as always monsieur!

      

    #2 Durval Ramos with 92 revisions. Hello Durval, lots of translation, rating and commenting, much appreciated! 

      

    #3 Ed Price - MSFT with 50 revisions. Curating the content, for always and forever.

      

    Just behind the winners but also worth a mention are:

     

    #4 Maheshkumar S Tiwari with 40 revisions.

      

    #5 Naomi N with 37 revisions.

      

    #6 Pablo Martínez with 32 revisions.

      

    #7 Davut EREN with 28 revisions.

      

    #8 Hezequias Vasconcelos - MTFC with 27 revisions.

      

    #9 JoeyDj with 22 revisions.

      

    #10 i.biswajith with 21 revisions.

      

     

    Ninja Award Most Articles Updated Award  
    Who has updated the most articles

     

    #1 Benoit Jester - MTFC with 184 articles.

      

    #2 Durval Ramos with 42 articles.

      

    #3 Pablo Martínez with 27 articles.

      

    Just behind the winners but also worth a mention are:

     

    #4 Ed Price - MSFT with 24 articles.

      

    #5 Naomi N with 23 articles.

      

    #6 Richard Mueller with 12 articles.

      

    #7 Maheshkumar S Tiwari with 11 articles.

      

    #8 Davut EREN with 10 articles.

      

    #9 Hezequias Vasconcelos - MTFC with 8 articles.

      

    #10 Mehmet PARLAKYIGIT-MTTC with 6 articles.

      

     

    Ninja Award Most Updated Article Award  
    Largest amount of updated content in a single article

     

    The article to have the most change this week was How to use dynamic excel files with dynamic sheet names in SSIS, by Falah Nabeel

    This week's reviser was Falah Nabeel,

    Quite surprising that this should show as most content changed this week, as it isn't very long. It is all new, from Falah.

    As it is an SSIS article, I am wondering if he will be entering it in the November Guru contest? 

     

    Ninja Award Longest Article Award  
    Biggest article updated this week

     

    This week's largest document to get some attention is once again, Migrating Bing Maps v6.3 to v7, by Ricky_Brundritt and second was Wiki Ninjas Blog Authoring Schedule  by Ed Price - MSFT

    So I'll jump down to third place longest document to get some attention - Hybrid Cloud Infrastructure Design Considerations, by Thomas W Shinder - MSFT

    This week's reviser was Benoit Jester - MTFC

    This article is one big book for bedtime and manual of everything you ever needed to know about Hybrid Cloud design, but never knew you needed to know!

     

    Ninja Award Most Revised Article Award  
    Article with the most revisions in a week

     

    This week's most fiddled with article is SQL Server Database Snapshot, by JoeyDj. It was revised 21 times last week.

    This week's reviser was JoeyDj,

    A new article from Joey here and a very useful one too. Very well presented, and great step by step instructions.

    Love the spoiler!

     

    Ninja Award Most Popular Article Award  
    Collaboration is the name of the game!

     

    Yes it's the TechNet Guru Contributions for November 2013, by XAML guy (me) again.

    This week's revisers were Maheshkumar S Tiwari, dev hedgehog, Kev Riley, Nonki Takahashi, AyyappanSubramanian, Mr X, .paul. _, Deeptendra & Ed Price - MSFT

     

    So I'll highlight second most popularly edited article, SQL Server: Delete a Huge Amount of Data from a Table, by Uwe Ricken

    This week's revisers were Uwe Ricken, dplotnikov - mvp, Ed Price - MSFT & Naomi N

    This fine piece is also the proud winner of the October TechNet Guru competition, making Uwe a Microsoft TechNet Guru for October. Congratulations Uwe!

     

     

    Ninja Award Ninja Edit Award  
    A ninja needs lightning fast reactions!

     

    Below is a list of this week's fastest ninja edits. That's an edit to an article after another person

     

    Nice work Mr X!!

    Also in the top ten were:

     

     

    A big hug and high fives all round to our winners this week, another crop of prize picks most enjoyed by all in the TechNet offices, the world, and future generations!

     

    Best regards,
    Pete Laker

     

  • The last MTFC winner of 2013!

    Bonjour à tous, ( means "hello everybody in French"... )

    We’ve got a new winner today for the Microsoft Technical French Contributor. We aren’t so much ( 6 I guess ) on the WIKI but we all try to improve our French Community! My main focus still is the Turkish Community but I’ll  try to help Bruno Lewin and Philippe Levesque for the French Community.

    You all know Benoit Jester and he made great efforts to improve the WIKI. He can be proud to be named as the last MTFC of the year 2013! Congratulations Benoit! 
     
     
      
      
      
    He won this award thanks to his great “Site Mailboxes” series and got all the votes in our team. Well Done!

     

    Also a big huge and thanks to all our winners of the MTFC 2013!

    I cannot terminate the year 2013 without thanking Bruno Lewin and Philippe Levesque who made this Award a real success. Without them this Award couldn't be so popular!

    Thanks
    Bruno and Philippe!

    -         Ninja Gokan

  • Council Spotlight - The TechNet Wiki Turkish Blog is coming!!!

    Starting next week, you'll want to keep your eyes out for the TechNet Wiki Turkish blog!

     

    This began as a project where I saw that the Portuguese community was so vibrant that they could run their own blog about their community, and so we span one up:

    Wiki Ninjas Brasil blog

    These articles are about the Wiki Ninjas Brasil blog: http://blogs.technet.com/b/wikininjasbr/ 

    They have 9 authors now:

    1. Luciano Lima - MVP
    2. Jorge Barata - MVP
    3. Luiz Henrique Lima Campos - MVP
    4. Fernando Lugão Veltem - MVP
    5. Marcelo Sincic - MVP
    6. Daniel Donda - MVP
    7. Fabrício Sanchez - MVP
    8. Rover Marinho - MVP
    9. Hezequias Vasconcelos - MTFC

    Hezequias has been blogging a lot lately!

    Luciano has 36 total blog posts (on Wiki Ninjas and Wiki Ninjas Brasil), Luiz has 29 blog posts (on both blogs), and Hezequias has 22 blog posts (on both blogs). So Hezequias is catching up! Only 518 more and you'll catch up with me! =^o

     

    ... And that experience led to the next question: Are there any other language-based communities around TechNet Wiki that are also ready to run a blog?

    The answer was an astounding YES!!!

     

    Gokan Ozcifci (who was recently awarded MVP) put together a Turkish council that is ready to start blogging next week!

     

    Turkish Wiki Ninjas blog

    These articles are about the Turkish Wiki Ninjas blog: http://blogs.technet.com/b/wikininjastr/ 

    Similarly, they have 9 bloggers over there who are ready to go!

    1. Gokan Ozcifci - MVP 
    2. Mehmet Parlakyigit-MTTC
    3. Baris Aydogmusoglu 
    4. Asil Mutlu   
    5. Yavuz Tasci   
    6. Nihat Altinmakas
    7. Ozgur Duranlioglu  
    8. Mucahid Akcay
    9. Davut Eren

     

    So thank you to the Turkish community, and we look forward to what you'll have on your blog:

     

    http://blogs.technet.com/b/wikininjastr/ 

     

       - Ninja Ed

     

     

    P.S. Find the Wiki Ninja Stick Figure images here: Wiki Ninja Stick Figures

         

  • Wiki Life: How To Detect Missing Tags Without any Effort

    Hi, welcome to my first blog post. Lying is useless, I know you’re puzzled about this title.

    Here’s the story: a few weeks ago, I was discussing with Ed when he told me that a lot - sorry, A LOT - of articles in the TechNet Wiki don’t have any language tag (If you’re not aware of what a language tag or a tag is, I recommend you to read this Wiki page: Wiki: Common Tags).

    Then, I start thinking about a way to detect this missing tag, about a way to help everyone to update articles without having to browse the 15.000+ articles actually hosted on the Wiki.

    My initial plan

    My initial plan was simple: hire an assistant, who will detect the missing tag(s) and update the articles. I quickly found this person: he was not complaining about work conditions, was very motivated, and he was typing on keyboard as no one. But I had some communication problems with him, and after verifying tags he entered like “l_çùlp” and “ù;:;k;ioyjk”, I discovered they were not in the Wiki: Common Tags list.

    So, I had to forget this plan, as this guy named Marlon, Marlon Jester (my 11-months old son) was not reliable :)

    My final plan

    Finally, I decided to develop a tool for that: This tool - a PowerShell script - is also intended to detect missing tags on TechNet Wiki articles, and not only the language tags, but also the following tags:

    • Language missing (in the title - if not ‘en-US’- or in the tags list),
    • Has Comment,
    • Has Image,
    • Has Code,
    • Has Video,
    • Has TOC,
    • Has See Also,
    • Has Other Languages / Multi Language Wiki Articles.

    The articles list and the associated missing tags are exported into a csv file, so you can easily see which articles you have to update and which tags you have to add.

    The Brazilian, Chinese and Russian articles (hosted on their wiki or not) are excluded, as they have their own tagging rules.

    How to use it

    You will find a manual inside the zip file, so I will just explain here the major steps.

    Data sources

    The tool gathers data from 4 possible sources:

    • A specific URL,
    • The “ALL PAGES” tab,
    • The “NEW PAGES” tab,
    • The “UPDATED PAGES” tab.

     

    For the 3 last choices, you have to enter as parameter a range of pages.

    Export file format

    The articles list and the associated missing tags are exported into a csv file, which contains 4 columns:

    • Title,
    • URL,
    • TagsToAdd,
    • Comments.

    The “TagsToAdd” column contains the tags you should add to the article, here is an example for multiple articles (1 line = 1 article to update):

     

    The “Comments” column contains informations which are non-relative to tags, like:

    Things to keep in mind

    During the last 2 weeks, I had a lot of activities, finished first in the last contributor awards; you have now discovered my secret, as 95% of my updates were coming from the csv file(s), during the testing phase.

    What I want to tell you is not to consider this tool as a way to break records. You want to have more than 1.000 ‘activities completed’ in a week, you can do that ‘easily’ with the tool, but please remember that all of that is not and must never be a competition.

    Take your time, launch the tool with a reasonable amount of pages, and we will all enjoy the result !

    By the way, as Naomi told me yesterday: "when you are fixing the tags in the article using that list, don't forget to actually read the article and fix all other things that may need to be fixed".

    Download link

    The first version of this tool is available on the TechNet Gallery: Wiki TechNet: Detect Missing Tags.

    Enjoy !

    Benoît, The French Wiki Ninja

  • TNWiki Article Spotlight - Root Causes for Slow Boots and Logons (sbsl)

    Hi everyone !

    Today I will spotlight a really good article for any network administrator. It's the article Root Causes for Slow Boots and Logons (sbsl) !

    (Editor's note: SBSL is the acronym for Slow Boot, Slow logon.)

    It's an article with a lot of tips. It's an all-around article that lists any products and patches that can cause slowness with any Windows end-user OS. 

    What I like from the article is that it gets into the details about how to find the culprit of the slownes;
    - Applications, Hardware, Locator, Network, Operating System, Policy including Group Policy Preferences, Profiles, Readyboot , Remote Desktop, WMI  

    There are simple tips in that document that I used in the past to get a drop from 2 minutes to a 30-second login by tweaking some GPO... so if you extend that to an entire IT park, you gain a lot of productivity!! :)

    Here is a sample quote from the article:

    This article describes Microsoft Support experiences in troubleshooting boot and logon delays, specifically the root causes. Other related topics include:

    http://social.technet.microsoft.com/wiki/contents/articles/10128.tools-for-troubleshooting-slow-boots-and-slow-logons.aspx
    http://social.technet.microsoft.com/wiki/contents/articles/10123.troubleshooting-slow-operating-system-boot-times-and-slow-user-logons.aspx
    http://social.technet.microsoft.com/wiki/contents/articles/11341.the-windows-7-boot-process-sbsl.aspx

    The goal of this content is to create awareness among IT administrators, support professionals, and consultants, about the tools, causes, and resolutions for boot and user logon delays.The primary focus is on domain-joined clients and servers.The article does not pertain to slow boots and logons on consumer desktops in a workgroup, but some of the tools and methods would still apply, such as enabling verbose logging and noting the message and duration where the boot or logon hung.

    Written by: A. Conner, David Everett, and Joey Seifert

    Edited by: Justin Hall

    There is no shortage of root causes for boot and logon delays. Some delays are caused by code-defects in the OS or applications on the computer experiencing slow boot or logon. Other root causes lie with the underlying network, remote servers, or Administrator misconfiguration.
    Don’t worry about tracking the QFEs for Windows. We’ll be publishing a list of recommended fixes the near future.
    The following sections explain some of the problems that have been seen to date, and how to resolve them.

    Thanks for your time !

    P.S. That article is a really good example of a good collaboration with a Microsoft product team on TechNet Wiki!!

    Regards,
    Philippe