Introduction

This short article is basically just a list of Ronen Ariely's best TechNet Wiki articles. At this time there is no way to automatically generate a list of all articles created by specific user. This article is intended to help to organize and monitor articles  by Ronen Ariely in a simple way.

.

Best Articles by Ronen Ariely

• Using Bulk Insert to Import Inconsistent Data Format (Using Pure T-SQL)
• Shrink SQL Database During Restore  
• SQL Server: Create Random String Using CLR
• T-SQL: Random String   
• Crazy TSQL Queries play time
• Installing SQL Server 2014 Step by Step Tutorial
• Split Date Range into Months
• Convert VBA Code to Transact-SQL
• Same Query on Different SQL Server Versions
• Wiki: Article List for Proofreading Grammar
• C Sharp: Multi-Types Application
• Transact-SQL: Join Order
• Transact-SQL: Return DBCC output in a View
• INSTEAD OF Triggers
• SQL Server: Representing List of Values Using a Single Value
• SQL Server Books Online.
• Free E-Books about SQL and Transact-SQL.
• T-SQL: Sort data by multiple languages
• T-SQL: Dynamic Data Masking
• Database Engine: Dynamic Data Masking
• Free tools and services available to Microsoft Most Valuable Professionals (MVPs)
• SQLCLR: Percentage User-Defined Aggregate Functions
• TechNet WIKI Images gallery
• List of forums by Languages, categories, and field of discussions
• SQL Server - Exposing masked data
• Wiki Governance: Community Council - Facebook Groups
• Forum Ninjas Interviews - administration
• Wiki Governance: Guru Contest Judges
• שער הכניסה למערכת הטקנט ויקי בעברית (he-IL)
• קווים מנחים לכתיבת מאמרים (he-IL)
• תבנית ויקי למאמרים בעברית (he-IL)
• כיצד לתרגם מאמרים (he-IL)
• Transact-SQL: Convert VARBINARY to Base64 String and vice versa

TechNet Gallery - resources for IT professionals

• Presentation: Volume Shadow-Copy Service & SQL Server VSS Writer [he-IL]
  • Volume Shadow Copy Service (VSS) is a group of COM interfaces. COM components Implement on running environment to perform system backups while applications continue to write to the volume and lock files.In this presentation we will explain what Shadow Copy is and how to use it.
• C Sharp: Multi-Types Application
  •  Executing one application in variety ways, on variety interfaces. For example: (1) command line (with or without parameters), or by (2) double click the exe file, or (3) from command shell / PowerShell. Moreover, using variety of Graphical user interfaces...
• SQL Buffer Pool Extention
  •  Buffer Pool Extension or Short Name BPE is a new addition to the Standard and Enterprise versions of SQL Server 64 Bit. Theoretically, this extension can significantly improve the ability of memory-intensive systems such as OLTP. Let's go Step by Step using the BPE
• Transact-SQL: Join Order
• C Sharp: Multi-Types Application
• Transact-SQL: Return DBCC output in a View
• INSTEAD OF Triggers
• SQLSaturday #360: SQLCLR From 2005 to 2015, Presentation
• TNWIKI 2015, The power of INSTEAD OF Triggers, by Ronen Ariely
• TNWIKI 2015, Wiki Ninjas Social Media
• T-SQL: Sort data by multiple languages (Codes for the article)
• INSTEAD of TRIGGER (he-IL)
• SQL Server 2016 - New features from the developers' point of view
• Built-in JSON support in SQL Server 2016 and tips to improve performance
• New Security Features in SQL Server 2016 - Presentation & Demo
• IMPLEMENTING (and Cracking) NEW SECURITY FEATURES IN SQL SERVER 2016 - part 1: Dynamic Data Masking
  
  • Recording: https://www.youtube.com/watch?v=6yjSL9_SBhg
  • Download demo code and the presentation files
• IMPLEMENTING NEW SECURITY FEATURES IN SQL SERVER 2016, Part 2: Row-Level Security and Always Encrypted
  
  • Recording: https://www.youtube.com/watch?v=jIB77xkAESs
  • Download demo code and the presentation files
• SQL Server Non-deterministic Elements
• TechNet WIKI gallery 2017
• SQL Server Internals - Stored Values on Disk
• JSON Support in SQL Server 2016 Tips to Improve Performance
• Under the (hood of a) project
• SQL Server Stretch Database demo

More can be read in at http://ariely.info/
Contact: https://www.facebook.com/ronen.ariely