• TNWiki Article Spotlight - Getting Started with the Windows Azure HDInsight Emulator

    Hello and welcome everybody to our TNWiki Article Spotlight on Tuesday.

    Two weeks ago we talked about how you can get started with Microsoft's Hadoop implementation for Windows Azure, Windows Azure HDInsight. Today I want to take the next step. From time to time I have a look at the Microsoft Web Platform Installer to see if I missed something cool I can play around with. Since the GA of Windows Azure HDInsight Services there were a lot of things to install. My personal favorite is the Windows Azure HDInsight Emulator. As I played around with HDInsight I had to submit jobs via PowerShell or via code to my HDInsight cluster and I thought wouldn't it be cool to have a small cluster running on my PC without setting up a Hyper-V VM and going through the whole installation process, which isn't fun actually. Here the HDInsight Emulator jumps in. Similar to the Windows Azure emulators we are using for years now this one helps you to develop your jobs locally. But what is usually the problem if you want to get started with something new? Right, finding a good introduction that helps to get started. A site which prevents that you have to find all things out on your own, which can be really time-consuming.

    Today's spotlight, as the last time, comes from Brad Severtson and answers to the name "Getting Started with the Windows Azure HDInsight Emulator". It shows you how you can run normal MapReduce jobs, but also shows how you can run Pig and Hive jobs. So, enjoy!

    - German Ninja Jan (Twitter, BlogProfile)

  • Interview with Saeid Hasani - many times TechNet Guru Competition winner

    Today I want to introduce Saeid Hasani - a Transact-SQL MSDN forum regular and many times T-SQL TechNet Guru Competition winner. I enjoyed several of his TechNet articles. My favorites are Structured Error Handling Mechanism in SQL Server 2012 and All-at-Once Operations in T-SQL.

    With his family

     

    Let's start the interview:

     

    Who are you, where are you, and what do you do? What are your specialty technologies? 

    My name is Saeid Hasani and I am 32 years old. I am from Iran. I was born and currently live in Tehran (Iran’s capital). I work for an ERP software company as a Senior Database Developer. My focus is T-SQL Programming and Query Tuning.

     

    What are your big projects right now? 

    I have three projects. I spend a lot of time to finalize the next generation of our ERP solution. I also prepare new articles for Wiki and participate in the MSDN forums. My biggest project is writing a book about MS SQL Server. 

                                                    

    What is TechNet Wiki for? Who is it for? 

    TN Wiki is a multi-purpose solution to provide great knowledge for wide variety of users from novice to experts. TN Wiki community is full of bright people who contribute perfect articles as well as they usually are the best in their companies. The main idea is sharing high quality knowledge provided by experienced experts.

     

    What is it about TechNet Wiki that interests you? 

    I love the guru of the month competition. It’s wonderful program. I found that it forces me to work more on my articles. The comments by judges are the most interesting part of this program. I always review their feedback and try to apply their suggestions in next articles. 

     

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

     I usually spend a lot of time to research about the subject. I also dedicate continues, non-stop time to prepare article format until it satisfies me, because this is very important to keep the readers enthusiastic. I spend a lot of time to make it better after first publish. But the hardest subject to write about was Error Handling. I spent the most time to prepare this article:

    Structured Error Handling mechanism in SQL SERVER 2012

     

     What are your favorite Wiki articles you’ve contributed? 

    My last article is about one of the most important concepts in T-SQL. My favorite article is:

    All-at-Once Operations in T-SQL

     

    Who has impressed you in the Wiki community, and why? 

    Naomi Nosonovsky with no doubt.

    For her efforts, high quality articles and fantastic participating in MSDN forums!

     

    What interests you more in SQL Server and how did you find your passion there?

     I love T-SQL Set-based nature. If imagine T-SQL like your mother tongue, Set-based programming is like writing a poem in this language. Whether I didn’t write one Set-based query, I also enjoy reading it like listening a poem. To stay at the high-level in Set-based programming I always read discrete mathematics and related books to create better solutions. It’s a part of my daily job.

     

    Thanks Saeid for this great interview and I am sure you have more questions you can ask in the comments to this blog.

    ---------------------------------------------------

    Now, if you would like to be interviewed by me for our Monday's interview column, please also add a comment to this article and a way to contact you (or just email me).

  • 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

     

  • Interview with Ronen Ariely - many times TechNet Guru Competition winner

    Today I want to introduce Ronen Ariely - long term SQL Server developer and winner of several TechNet Guru Contributions.  

    Sailing with a friend 20 years ago...

     

    Let's start the interview:

    Who are you, where are you, and what do you do? What are your specialty technologies? 

    My name is Ronen Ariely, I am from Israel. I am over 40 years old and playing with computers from 1983 as a child, when I first learned programming.

    I'm a senior consultant & developing architect, a professional programmer, architecting SQL & BI enterprise level solutions. I have more than 12 years of experience in variety of programming languages and technologies, leading and managing development teams and BI projects.

    My passion is designing complex applications and troubleshooting. I like challenges and I do not like being told that something is impossible. I am using Microsoft's Technologies. I write blogs for several years, and working on the next blog all the time. I help in several forums and communities in the fields of SQL Server, T-SQL and Programming in general and Dot.Net specifically since 2001. My nickname on the internet communities in the last several years is PITUACH or PITOACH. "PITUACH" is the word DEVELOPMENT in Hebrew. I started to use this nickname a few years ago, after I got sick of seeing every child calls himself in the virtual world (like forums) "genius" or "king" or "The King" or "the best" and so on... So I decided to choose simplest nickname as I can, and I chose to say: I am just a "developer" :-)

    In early January, I'll open the new year of the Israel SQL Server Group with my lecture on VSS. So if you are in Israel, I'd love to see you.

    http://isug138.eventbrite.com/ 

    Please tell a bit about Israel SQL Server Group, and Israel TechNet Wiki members and who do you plan to bring to Wiki.

    The best way to describe our group will be by explaining why I am going there at all. At first I went to hear lectures on subjects which interested me professionally. I soon found myself enjoying it socially, I found that I enjoy the conversations during breaks and after the sessions, not less than the lectures themselves. At that time I found myself Hooked :-) coming regularly each month.

    Some members in US user groups need to travel more than two hours to get to the nearest user group meeting. In Israel you can travel half of the country in that time. I understood there are some Users Group with more than 1500 members that come to each meeting. In Israel everything is a bit smaller, I think this is an advantage. The core members know each other personally, so the Israel SQL Server Group is more than just a professional group, it is a members group.

    Unfortunately, there are not many Israeli Wiki members, as far as I know. There are several reasons I can point. But mostly, there is just need for more writers in Hebrew. The WIKI interface is not easy to work with languages ​​written from right to left. The transition between writing code (using left to right text), to plain Hebrew text (using right to left) is very uncomfortable. I suggested several times to add RTL/LTR buttons, to switch between directions, as there are in most text editors. Meanwhile, this is not yet done.

    I can certainly see the potential of the system. Perhaps in the future I will try to focus on writing articles in Hebrew (in addition to articles in English), in order to bring more audience.

    Also tell us more about your interests.

    Mmmm... It is a tricky' question :-)

    I grew up in Eilat. Eilat is a seaside city with everything that implies. In the past I used to write that my interests include: software development, playing open source strategy games (like Freeciv or Wesnoth), sailing and diving. OK… it is true that I have a diving license from the age of 15 and I had hundreds of dives to date, and it is true that I have extensive experience sailing sails, including in competitions. But seriously... I do not remember the last time I went out to sea :-(

    I think that I spent most of the day near the computer these days. When I work on an application that I develop, I can forget myself. I do not have schedule. Sometimes I work (or play) all night and quite possible I'll sleep during the day. 

    What is TechNet Wiki for? Who is it for?

    TechNet Wiki is probably one of best platforms where Developers, IT people and DBA people can meet together in the virtual world for co-learning and sharing. This is a Unique platform, where an article can be written by everyone together (not like a book or a blog) and bring us one article with different perspectives of technology.

    I want to thank all the people who contribute their time to communities at forums and writing blogs and articles on WIKI in order to help others. I am glad to be part of a great community. 

    What are your favorite Wiki articles you’ve contributed?

    Shrink SQL Database During Restore
    http://social.technet.microsoft.com/wiki/contents/articles/18481.shrink-sql-database-during-restore.aspx

    Everyone knows that we always remember our first… this is my first WIKI article, and it gave me a good starting point when it won the gold medal at the TechNet Guru contest, July 2013. This article was actually very simple to write, since it is written as a "step by step" tutorial. There is no long discussion, it includes mostly short explanation and code.

     

    Do you have any comments for product groups about TechNet Wiki?

    Yes, as I mentioned before I highly recommend to add RTL/LTR buttons, to switch between directions, as there are in most text editors. In addition I think that Microsoft should combine several learning interfaces like asp.net site with the TechNet WIKI, the Hebrew Interface (like the blogs) with the English one, and so on. Sometime less is more :-)

     

    Do you have any tips for new Wiki authors?

     Oh… yes… I can think about some:

    • Remember you can edit the article… don’t try to write it all at once. Check the article if you are not sure and then edit it to continue the writing.
    • At the start of the article add "[toc]" (without the Quotation marks). This will add an index to the article base on heading (titles).
    • Using code: don’t add line numbers to the code. It might be pretty but it make it very hard to copy the code without the line number.
    • Format the code using the build in "code block" and choose width 97%
    • A Wiki is not a personal blog. Use less "I" and more "we". Writing a personal story like "I went to…" might look strange after the WIKI article will be edited by someone else. Remember a WIKI is a Joint article.
    • Add pictures and codes… it is always good
    • Always add References and Resources

    What is it about TechNet Wiki that interests you?

    About a decade ago I wrote Wikipedia articles. I really liked the idea of ​​collaborative articles. The concept has not changed and my interest has not declined. As I see it, now is the time to do the same with Tech articles.

     

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

    Due to the fact that I started writing TechNet WIKI articles as a result of Naomi's posts and Ed's posts, at the T-SQL forum, I spent most of my time on articles which handle topics about Microsoft SQL Server, and later on I read some articles of C#. I commented on some and edited others. The final step will be writing… maybe my next article will be on C#...  

     

    Thanks, Ronen, for this great interview and very interesting answers. If you have more questions for Ronen or just want to tell him something, please, don't hesitate to add comments to this blog post.

  • Interview with BizTalk Wiki Ninja: Mohit Gupta, MCC and TechNet Guru Medal Winner

    Namaste All!!

    Today the interview will be with Mohit Kumar Gupta. Mohit is a MCC and TechNet Guru Winner . So far Mohit  has written 8 articles and is been active  on forums since Nov 2009.

    Mohit's  Profile:http://social.technet.microsoft.com/profile/mohit%20kumar%20gupta/


    Mahesh: Who are you, where are you, and what do you do? What are your specialty technologies?
    Mohit: My Name is  Mohit Kumar Gupta .I am 25 years old, live in Noida (near Delhi, India)  with my family (mother, father and Wife).
    I have been in the IT industry for more than 4 years. I started my professional career with BizTalk server. Since then, I have been working with Biztalk, C#, Dynamic Ax, and WCF.

    Currently working as a Senior BizTalk developer at Zones Inc.



    Mahesh: What are your big projects right now?
    Mohit: One of my great project is replacing the legacy EDI system with BizTalk 2010. Our company is migrating their legacy system to BizTalk Server.
    I am an active on MSDN Forum.I  have a blog where I share my knowledge of EDI, BizTalk Server, and also plan to do certification in Microsoft technologies. 

    Mahesh: What is TechNet Wiki for? Who is it for?
    Mohit: TechNet Wiki is a universe of knowledge  where community members share and discuss about various Microsoft products and technologies.
    On TechNet Wiki you can write your thoughts on something then other people help in making your articles perfect. TechNet Wiki is growing very drastically, with the help of a great team.
     
    Mahesh: What do you do with TechNet Wiki, and how does that fit into the rest of your job?
    Mohit: It allows me to share my knowledge; it allows me to find out the best solution. Whenever I get time, I share my knowledge with the community.

    Mahesh: What is it about TechNet Wiki that interests you?
    Mohit: What engages me about the wiki is to collect and share knowledge about new concepts.
     
    Mahesh: On what Wiki articles do you spend most of your time?
    Mohit: I spend most of my time on BizTalk related articles.
     
    Mahesh: What are your favorite Wiki articles you’ve contributed?
    Mohit:

    Complex FlatFile parsing using Biztalk Schema and Map (This was a TechNet Guru winning article)
    muenchian grouping using custom Xslt 

     
    Mahesh: What are your top favorite Wiki articles?

    Mohit:

    Biztalk server Resources
    Biztalk server 2010 - begineers guide 
    Biztalk List of Pipelines Component

     
    Mahesh: Who has impressed you in the Wiki community, and why?
    Mohit: I would like to say thank to all  TechNet Wiki contributors who share their knowledge.

    My special thanks to 

    M.R.ASHWIN PRABHU
    Saravana Kumar
    Richard Seroter
    Sandro Pereira
    Steef-Jan Wiggers
    Leonid Ganeline
    Nino Crudele

    ...for their incredible contributions for BizTalk Server .
     
    Mahesh:  What does success look like for TechNet Wiki?
    Mohit: Writing more articles, writing more solutions, and including best practices and knowledge from Microsoft MVP’s for all products will lead to success in TechNet Wiki.

     

    Thanks Mohit for all your contributions, and welcome to the community again.

    ____________________________________________________________________________________________________

     Feel free to ask questions to Mohit!!!!!!!

     

    --Wiki Ninja Mahesh