Blog Posts

• What is Database Sharding? An Architecture Pattern for Increased Database Performance, PingCAP Blog (February 2, 2024)
• Decoding Serverless Databases: How They Transform Application Development, PingCAP Blog (November 14, 2023)

YouTube Videos

• PingCAP Certified TiDB Practitioner. A Quick Primer for Acing the Exam. PingCAP YouTube Channel.
• Quick Demo – TiDB and Snowflake E-commerce App. TiDB Learning Channel.
• See the TiDB Learning Channel for more examples. There are too many to list here.

Conference Papers

The following conference presentations include full papers:

• An Insider’s Guide to SAS/ACCESS Interface to Snowflake, SAS Global Forum (2020).
• An Insider’s Guide to SAS/ACCESS Software on SAS9.4M5 in the Cloud, SAS Global Forum (2018).
• An Insider’s Guide to Fine-Tuning Your CREATE TABLE statements Using SAS Options, SAS Global Forum (2017)
• An Insider’s Guide to SAS/ACCESS Interface to Impala, SAS Global Forum (2016).
• An Insider’s Guide to SAS/ACCESS Interface to Hadoop, Hands-On Workshop, SAS Global Forum (2016) – Delivered as a SAS employee.
• An Insider’s Guide to SAS/ACCESS Interface to ODBC, SAS Global Forum (2014).
• The SQL Tuning Checklist: Making Slow Database Queries a Thing of the Past, Primary Author. SAS Global Forum (2013).
• Teradata Parallel Transporter: Loading Your SAS Data Just Became Easier, SAS Global Forum (2011).

Conference Papers and Presentations

The following are all my conference presentations (including the conference papers listed above):

• A Gentile Introduction to TiDB. HTAP Summit, HTAP Summit (2023). PingCAP Marketing posted the video on the PingCAP YouTube channel. PingCAP Certified TiDB Practioner. A Quick Primer for Acing the Exam.  
• TiDB Cloud Quick Start (Hands-on Workshop), HTAP Summit (2022)
• 10 Reasons Why the TiDB Database Should Power Your Next Development Project, Percona Live (2022)
• An Insider’s Guide to SAS/ACCESS Interface to Snowflake, SAS Global Forum (2020).
• An Insider’s Guide to SAS/ACCESS In the Cloud, SAS Analytics Experience (2018).
• An Insider’s Guide to SAS/ACCESS Software on SAS9.4M5 in the Cloud, SAS Global Forum (2018).
• An Insider’s Guide to Fine-Tuning Your CREATE TABLE statements Using SAS Options, SAS Global Forum (2017)
• Getting Started With SAS and Hadoop. SAS Analytics Experience (2016)
• SuperDemo: Supercharge Your SAS/ACCESS Queries One Option at a Time. SAS Global Forum (2018).
• An Insider’s Guide to SAS/ACCESS Interface to Impala, SAS Global Forum (2016).
• An Insider’s Guide to SAS/ACCESS Interface to Hadoop, Hands-On Workshop, SAS Global Forum (2016) – Delivered as a SAS employee.
• An Insider’s Guide to SAS/ACCESS Interface to Hadoop, Hands-On Workshop, SAS Global Forum (2015) – Delivered as a Cloudera employee. SAS demanded that Cloudera allow me to do it.
• An Insider’s Guide to SAS/ACCESS Interface to ODBC, SAS Global Forum (2014).
• Bigger Data Analytics with SAS® Access for Aster, Teradata, and Hadoop, co-presenter, Momolue Kiadii, Teradata Partners Conference (2013).
• The SQL Tuning Checklist: Making Slow Database Queries a Thing of the Past, Primary Author. SAS Global Forum (2013).
• Teradata Parallel Transporter: Loading Your SAS Data Just Became Easier, SAS Global Forum (2011).
• Load Doesn’t Mean Load: A Guide to Understanding Your SAS Users, Teradata Partners Conference (2010).
• Publish SAS Formats in Your Teradata Server, SAS Global Forum (2009).
• SAS Anti-Money Laundering and DB2: Lessons Learned, SAS AML Forum (2004).

stack overflow mention – “Look into [this] paper by Jeff Bailey if you want to know everything about SAS and Teradata data movement”. This is mentioned in a comment by Kiran.

Community Articles and Participation

You will notice a common theme here. If I notice people having problems with my product line, I take action. Most of these SAS Communities articles were specifically designed to solve specific problems. Others were used to let folks know about new products that were coming out. The common theme is – help SAS users. 

• A Quick Guide to Connecting to Oracle from SAS, SAS Communities (2017). 54,445 views (as of 6/8/2022).
• Getting Started with Snowflake database – Making it Faster, SAS Communities (2018).
• An Insider’s Guide to SAS and Database Support Information, SAS Communities (2019).
• Meet the Worst Oracle Error Ever – ORA-3113, SAS Communities (2020).
• DELETE Your Teradata Data Fast!, SAS Communities (2014)
• An Insider’s Guide to Using Teradata Stored Procedures with SAS/ACCESS, SAS Communities (2018).
• DBIDIRECTEXEC: GOFAST=YES for Database Processing, SAS Communities (2017).
• Reading Data from a Database into a SAS Macro Variable is EASY, SAS Communities (2018).
• Dataflux Expression Engine Language Tutorial and Tip Sheet, SAS Communities (2018)
• How does SAS Support Amazon Redshift?, SAS Communities (2015)
• Sneak Preview – SAS/ACCESS Interface to Google BigQuery, SAS Communities (2019).
• Sneak Preview – SAS/ACCESS Interface to Snowflake, SAS Communities (2019).

My SAS Communities Badges

White Papers

• Effectively Moving SAS Data into Teradata
• Troubleshooting SAS and Teradata Query Performance Problems
• DataFlux Expression Engine Language Tutorial – This link will download the document to your Downloads folder.
• Tip Sheet: DataFlux Expression Engine Language Programming – This link will download the document to your Downloads folder.

Public Workshops

• TiDB Cloud Quick Start (Hands-on Workshop), HTAP Summit (2022)
• An Insider’s Guide to SAS/ACCESS Interface to Hadoop, Hands-On Workshop, SAS Global Forum (2015) – Delivered as a Cloudera employee. SAS demanded that Cloudera allow me to do it.
• An Insider’s Guide to SAS/ACCESS Interface to Hadoop, Hands-On Workshop, SAS Global Forum (2016) – Delivered as a SAS employee.

SAS Talks

• How to Integrate SAS and Teradata, SAS Talks Webinar (2013)
• Getting Started with SAS and Hadoop, SAS Talks Webinar (2013)
• SAS Integration with Hadoop: Part II, SAS Talks Webinar (2013)

SAS Days Presentations

• Working with a DBMS using Enterprise Guide, SAS Day at Geico (2017), 1 hour at Geico
• Leveraging Teradata Using SAS, SAS Day at The Hartford (2017), 1 hour via WebEx
• An Insider’s Guide to SAS/ACCESS to Hadoop, SAS Day at Visa (2017), 3.5 hours at Visa

Magazine Articles

• Expand Your World with a Tweet. Toastmaster magazine (July 2010).
• Shrinking Your World. Toastmaster magazine (April 2010).
• Face-to-Face with Facebook. Toastmaster magazine (November 2010).
• Finding Tweeple. Toastmaster magazine (July 2011).