Ronen Ariely is a senior consultant in the fields of data bases and applications developing, focusing on Architecture, Projects management, Performance improvements, Troubleshooting, and developing. He has more than 20 years' experience in variety programming languages and technologies, leading development teams, and software companies, BI & SQL Server enterprise level solutions.
Ronen is active in communities in the field of Programming, SQL Server, T-SQL, and he serve as Moderator at MSDN communities (aka pituach), both in the Hebrew interface and in the global interface. Ronen is one of the Microsoft TechNet WIKI communities' leaders. He is the founder of the Microsoft TechNet WIKI Ninjas groups on Facebook, and serve as co-admin at the global group and several local groups (Persian, Turkish, Spanish, etc'). Ronen writes technical blogs and TechNet articles in the field of SQL Server and .Net.
Table of Contents
Note: This is a "User Page" (click for a list of all user pages on TechNet Wiki). User pages on TechNet Wiki exist for the following reasons: (1) To link to these pages from various online profiles, blog posts, etc. (2) To allow collaboration on filling out such information. (3) To allow easy editing for filling out such information. (4) To act as an aggregation or collection of links that help define what a person does.
Forums
Ronen passionate to support others reflected most of all in his activities in forums. Ronen's first activities in forums as Moderator started at 1999, at 2001 he finish developing, his first forum interface from scratch (using classic asp which was converted to ASP.Net later). This interface as well as others (developed by him) were given freely to community use and used by projects like "key for school" (K4school.com), Various educational institutions including Tel-Aviv University (tau.ac.il), and more.
Today Ronen serves as Moderator and Answerer at several interfaces in the field of SQL Server and developing (programing), both in the Israeli comunities and the global communities.
MSDN/TechNet forums:
- SQL Server [he-IL]
- Transact SQL forum [en-US]
- Getting started with SQL Server [en-US]
- Azure and SQL Azure [he-IL]
- SQL Server Express [en-IL]
- C# and .NET Framework [he-IL]
- Web Development [he-IL]
3rd Party forums
- Tapuz's Databases forum [he-IL]
WikiNinjas - Microsoft Official Facebook groups
Ronen is the founder of the Microsoft TechNet WIKI groups on Facebook, and Serves as admin at the global group as well as at several local groups. The first idea of creating Facebook groups for the Microsoft TechNet WIKI was raised by Ronen Ariely (aka pituach) on several occasions till he started an official discussion regarding the issue with the title “Should there be a page or group on Facebook for Wiki Ninjas”. Ed Price, Peter Geelen, Saeid Hasani, and Naomi, supported the idea and Facebook Groups were created with this first step.
Today Ronen serves as Admin at the global group (English language), and several Local groups like the Turkish, Persian , and Spanish languages.
TechNet Wiki Ninjas global group
TechNet Wiki Ninjas - Local groups:
- Turkish language.
- Persian language.
- Spanish language.
- Italian language.
- Portuguese language.
- french language.
Other Communities groups
Besides the above communities, publishing blogs, articles, code, and activities under Microsoft TechNet, Ronen is also an active member at the following communities where he shares his knowledge through speaking engagements, articles, and answers to questions.
Facebook group
- Microsoft Israeli SQL Server User Group.
- SQL Server Tips & Tricks.
- SQL Server Network.
- Microsoft Israel BI & Big Data User Group.
- SQL Server Blog.
- Israeli Dot Net Developers.
- ALT.NET Israel.
- Microsoft IL Tech Community Leaders.
List of all Facebook groups can be seen here.
User Groups
- Microsoft Israeli SQL Server User Group.
- Microsoft Israeli BIG DATA User Group.
- Israel MongoDB User Group.
- NoSQL Tel Aviv.
- Microsoft Israeli Dot Net Developer User Group (IDNDUG).
- Israeli Dot Net Developer User Group.
Blogs
Ronen's personal blogs, centers mostly around SQL Server and .Net technologies (both vb.net and C#):
List of my top 5 latest favorite blog posts
You can use the links above, in order to get the full list of blogs
- SQL Server Bitwise Operators - T-SQL
- Examine how DateTime2 type stored in the data file - SQL internal
- Date displaying format, vs Date storing format - SQL internal, T-sql
- SQL Server: Who deleted my record last time?!? - Log file internal
- SQL Server Tricks: Return DBCC output in a View [he-il] - Tricks
Ronen joined the TechNet blogers, centers mostly around featuring key technologies on TechNet Wiki
Articles
TechNet WIKI Best Articles, which written by Ronen Ariely
Books and White Papers
Ronen published several books, white papers, and Scientific Researches in the field of SQL Server and Geophysics. More Scientific Publications can be seen in his website.
- Transact-SQL by TechNet Wiki Community - This book was put together by Saeid Hasani with the help of Durval Ramos Junior, Naomi Nosonovsky and Ronen Ariely (aka pituach).
- Quaternary transform kinematics constrained by sequence stratigraphy and submerged coastline features: The Gulf of Aqaba - Makovsky, Yizhaq; Wunch, Assaf; Ariely, Ronen; Shaked, Yonathan; Rivlin, Assaf; Shemesh, Aldo; Ben Avraham
Z
Earth and Planetary Science Letters, Vol. 271, Issue: 1-4, July 15, 2008. pp. 109-122
Code sample - Galleries
Ronen publish different codes under the cooperative's license. Some of these related to blogs, articles, and other publications.
Code on Microsoft TechNet Gallery
Open Conferences & Lectures to the community
- Transact-SQL: The Power of INSTEAD OF Triggers, presenter, Israel SQL Server PASS Chapter
- Under the (hood of a) project, presenter, Israel Dot NET Developers User Group (IDNDUG)
- The International TechNet Wiki Summit 2015, Conference organizer
- Transact-SQL: The power of INSTEAD OF Triggers, presenter, The International TechNet Wiki Summit 2015
- Wiki Ninjas Social Media, presenter, The International TechNet Wiki Summit 2015
- SQL CLR from 2005 to 20015, Not how, but why and when, presenter, SQLSaturday #360
Profiles
Ronen is member at several communities, where he shares his knowledge through speaking engagements, organizing meetings online & offline, supporting, or articles. These are some of the public profiles:
Do you want to know more about Ronen Ariely?
Some Blogs & article mentioning Ronen Ariely (aka Pituach) activities
- Ronen Ariely personal Website.
- Interview with Ronen Ariely - many times TechNet Guru Competition winner, by Naomi N
- The TechNet Wiki Ninjas are Now on Facebook!, by Ed Price
- Sunday Surprise:TechNetWikiNinjasES (Spanish TN Wiki on Facebook), by Davut EREN
- Council Spotlight: TechNet Wiki Facebook Heroes and Heroine, by Davut EREN
- Council Spotlight: So here's how we're going to help you proofread your grammar on TechNet Wiki, by Ed Price
- Wiki Life: Are you right in making it a rite to write?, by Matthew Yarlett
- SQL Server Radio [he-IL]
- Interview with Jayakumaur(JK) - Who has impressed you in the Wiki community, and why?, by SathyanarrayananS
- Sunday Surprise - Introducing new Transact-SQL eBook!, by Naomi N
- Wiki Life: Smart Tags, by Matthew Yarlett
- #TNWikiSummit15 Day 2 Presentation: Wiki Ninjas Social Media, Presented by by Ronen Ariely aka Pituach, Peter Geelen and Sandro Pereira
- TechNet Wiki Summit 2015, personal point of view, day 1 and 2 (by Ronen Ariely, aka pituach), by Peter Geelen - MSFT
- Who are the Top 20 TechNet Guru Award Winners?, Ed Price
- ...
* A list of blogs at Microsoft website in English can be seen here.