This week on the podcast, Kyle and Dan talk about the benefits of blogging for yourself, a fun SQL murder mystery game, and then they dive into the changes in the DPK for PeopleTools 8.58.
This week on the podcast, Kyle and Dan revisit the ACM (Automated Config Management). We discuss what the ACM is, how ACM works with the DPK, building custom ACM plugins and how to share ACM plugins.
- Revisiting ACM @ 1:00
- Using ACM with the Search Framework @ 5:00
- ACM and the DPK @ 9:00
- Building ACM Plugins @ 13:30
- Plugins that are missing @ 21:45
- GitHub Repository to Share ACM Plug-ins @ 30:00
- IDEA – More options for “Copy to File”
This week on the podcast, Kyle and Dan revisit Fluid Navigation and why they are fans of the new navigation model. Kyle shares his experiences working with the DPK and his method for managing the YAML and Puppet files on servers. Dan shares a top-notch “Dad Joke”.
- Location-based Event Mapping @ 1:30
- Classic UI for Admin’s/Power Users @ 2:45
- Linked-in Style Notifications @ 7:30
- SQL Turns 43 @ 11:15
- SQL Notebook @ 13:00
- Creating patch tarballs for the DPK @ 14:00
- Kyle’s DPK Experience @ 22:00
- DPKFiles Setup @ 28:45
- How do you do it? – Dad Joke Style @ 45:45
- Embracing Fluid Navigation @ 46:45
This week on the podcast, Dan and Kyle talk about Elasticsearch, using Powershell with SSH libraries, why the DPK doesn’t merge Hiera data, and how they format SQL files. Then Dan explains a new REST-based web service he built with new features in PeopleTools 8.55.
We want to make this podcast part of the community discussion on PeopleSoft administration. If you have comments, feedback, or topics you’d like us to talk about, we want to hear from you! You can email us at firstname.lastname@example.org, tweet us at @psa_io, or use the Twitter hashtag #psadminpodcast.
- Elasticsearch is Here! @ :30
- Powershell POSH-SSH Library @ 7:45
- Beyond Compare SQL Diffs @ 12:45
- psautolog.cmd @ 14:30
- Hiera Lookups and Merging Data @ 17:45
- How do you do it? Formatting SQL @ 32:00
- Looking at Past Code @ 41:30
- REST-based, Query-based Web Services @ 46:15
- REST-based Inbound (POST) Web Service @ 56:30
- Future Improvements to REST Services @ 64:00
TraceMagic is a utility that gives PeopleSoft system administrators, programmers and support engineers the ability to quickly isolate performance bottlenecks in SQL Statements and/or PeopleCode functions. It accomplishes this by turning the text-based, time-ordered tracesql file into a sortable-grid display, allowing the user to quickly locate system performance issues.
TraceMagic is a great tool for reading
.tracesql files. The ability to group SQL by SELECT statements and see all the tables queried in the trace are great for debugging issues.