17
Fri, May
7 New Articles

Rafael Victoria-Pereira

 

  Sort By:
  Display:
Published Title Category Hits
03 July 2019 RPG Academy - Database Modernization: Entity Relationship Diagrams General | IT Infrastructure - Other | IT Infrastructure 6,934
14 June 2019 SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 1 SQL | Programming 5,368
05 June 2019 RPG Academy - Database Modernization: A Bit of Database Theory General | IT Infrastructure - Other | IT Infrastructure 5,089
01 May 2019 RPG Academy - Modernization: Guidelines for Modernization Goals, Part 3 RPG | Programming 3,999
12 April 2019 SQL 101: Your First Embedded SQL Function SQL | Programming 4,887
03 April 2019 RPG Academy - Modernization: Guidelines for Modernization Goals, Part 2 RPG | Programming 3,940
15 March 2019 SQL 101: Embedding SQL in RPG Code, Part 2 SQL | Programming 5,162
06 March 2019 RPG Academy - Modernization: Guidelines for Modernization Goals, Part 1 RPG | Programming 4,166
06 February 2019 RPG Academy – Modernization: Setting Your Modernization Goals RPG | Programming 3,550
18 January 2019 SQL 101: Embedding SQL in Your RPG Code, Part 1 SQL | Programming 5,695
09 January 2019 RPG Academy - Modernization: Tips to Avoid the Pains of Modernization RPG | Programming 3,745
05 December 2018 RPG Academy - Modernization: Let’s Talk About the Benefits RPG | Programming 3,821
07 November 2018 RPG Academy—Modernization: Is Your Application Worth Modernizing? RPG | Programming 3,396
18 September 2018 3 Steps to Better Application Modernization RPG | Programming 3,954
14 September 2018 SQL MERGE Statement Tricks DB2 | Analytics & Cognitive 28,895
05 September 2018 RPG Academy – Modernization: Is Restructuring the Database the Way to Go? DB2 | Analytics & Cognitive 4,267
05 September 2018 Embedding SQL in Your IBM i RPG Code SQL | Programming 29,396
01 August 2018 RPG Academy – Modernization: Why, What, Where, and How RPG | Programming 4,705
11 July 2018 RPG Academy: Debug Done Right – Debugging Batch Jobs RPG | Programming 6,697
15 June 2018 Improve Your Database with Normalization DB2 | Analytics & Cognitive 4,423
16 May 2018 A Small Intro to Big Data, Part 4: Are Machine Learning and Artificial Intelligence the Same Thing? Business Intelligence | Analytics & Cognitive 4,471
02 May 2018 RPG Academy: Debug Done Right - A Step-by-Step Debug Session, Part 2 RPG | Programming 5,029
07 March 2018 RPG Academy: Debug Done Right - You Can Debug Anything! RPG | Programming 8,664
07 February 2018 Make Your IBM i Database More User-Friendly SQL | Programming 7,653
03 January 2018 RPG Academy: Debug Done Right - A Step-by-Step Debug Session, Part 1 RPG | Programming 5,718
01 November 2017 RPG Academy: Debug Done Right - Working with Watch Conditions RPG | Programming 8,719
31 October 2017 A Small Intro to Big Data, Part 3: HFDS and the MapReduce Algorithm Business Intelligence | Analytics & Cognitive 3,798
06 September 2017 RPG Academy: Debug Done Right - Working with Breakpoints RPG | Programming 11,200
31 August 2017 A Small Intro to Big Data, Part 2: Introducing the Hadoop Framework Business Intelligence | Analytics & Cognitive 4,912
20 July 2017 Book Review: 21st Century RPG: /Free, ILE, and MVC RPG | Programming 8,667
04 July 2017 RPG Academy: Debug Done Right - Starting a Debug Session RPG | Programming 6,564
23 June 2017 A Small Intro to Big Data, Part 1 Business Intelligence | Analytics & Cognitive 3,309
26 May 2017 C# for RPGers: Taking C# Loops for a Spin Programming - Other | Programming 4,312
17 May 2017 SQL 101: Tools of the Trade - Exploring SQuirreL’s SQL Editor SQL | Programming 8,510
03 May 2017 RPG Academy: Debug Done Right - Encrypting Your Debugging Views RPG | Programming 4,879
28 April 2017 TechTip: C# for RPGers: Making Stuff Happen, Part 2 - More Flow Control Structures Programming - Other | Programming 3,320
19 April 2017 SQL 101: Tools of the Trade - Installing SQuirreL SQL Client SQL | Programming 14,523
05 April 2017 RPG Academy: Debug Done Right - Choosing the Right Debug View RPG | Programming 7,403
17 March 2017 C# for RPGers: Making Stuff Happen, Part 1 - Introducing Flow Control in C# Programming - Other | Programming 3,672
15 March 2017 SQL 101: Tools of the Trade - The ACS Run SQL Scripts, Part 2 SQL | Programming 10,426
01 March 2017 RPG Academy: Debug Done Right - Introducing the ILE Debugger RPG | Programming 7,305
17 February 2017 TechTip: C# for RPGers - Easily Removing Duplicates, Sorting, and Reversing Lists General | Programming - Other | Programming 4,598
15 February 2017 SQL 101: Tools of the Trade - The ACS Run SQL Scripts, Part 1 SQL | Programming 9,376
27 January 2017 TechTip: C# for RPGers - More List Methods and a String Surprise General | Programming - Other | Programming 4,715
17 January 2017 SQL 101: Tools of the Trade - Installing the IBM i Access Client Solutions IBM i (OS/400, i5/OS) | Operating Systems | IT Infrastructure 14,100
04 January 2017 RPG Academy: Write Better Code - More on Commenting and Documenting Strategies RPG | Programming 6,134
21 December 2016 SQL 101: Tools of the Trade - i Navigator’s Run SQL Scripts SQL | Programming 8,486
09 December 2016 TechTip: C# for RPGers - Introducing Lists Analytics & Cognitive | 4,277
07 December 2016 RPG Academy: Write Better Code - Commenting and Documenting Strategies RPG | Programming 4,698
16 November 2016 SQL 101: Tools of the Trade – Old, Reliable STRSQL, Part 2 SQL | Programming 5,000
Rafael Victoria-Pereira

Rafael Victória-Pereira has more than 20 years of IBM i experience as a programmer, analyst, and manager. Over that period, he has been an active voice in the IBM i community, encouraging and helping programmers transition to ILE and free-format RPG. Rafael has written more than 100 technical articles about topics ranging from interfaces (the topic for his first book, Flexible Input, Dazzling Output with IBM i) to modern RPG and SQL in his popular RPG Academy and SQL 101 series on mcpressonline.com and in his books Evolve Your RPG Coding and SQL for IBM i: A Database Modernization Guide. Rafael writes in an easy-to-read, practical style that is highly popular with his audience of IBM technology professionals.

Rafael is the Deputy IT Director - Infrastructures and Services at the Luis Simões Group in Portugal. His areas of expertise include programming in the IBM i native languages (RPG, CL, and DB2 SQL) and in "modern" programming languages, such as Java, C#, and Python, as well as project management and consultancy.


MC Press books written by Rafael Victória-Pereira available now on the MC Press Bookstore.

Evolve Your RPG Coding: Move from OPM to ILE...and Beyond Evolve Your RPG Coding: Move from OPM to ILE...and Beyond
Transition to modern RPG programming with this step-by-step guide through ILE and free-format RPG, SQL, and modernization techniques.
List Price $79.95

Now On Sale

Flexible Input, Dazzling Output with IBM i Flexible Input, Dazzling Output with IBM i
Uncover easier, more flexible ways to get data into your system, plus some methods for exporting and presenting the vital business data it contains.
List Price $79.95

Now On Sale

SQL for IBM i: A Database Modernization Guide SQL for IBM i: A Database Modernization Guide
Learn how to use SQL’s capabilities to modernize and enhance your IBM i database.
List Price $79.95

Now On Sale