Solving Common DBA Problems With Uncommon Uses Of R, Part 2

Abstract:
With SQL Server 2016, external script languages were introduced to SQL Server, starting with R and continuing with Python in SQL Server 2017. Each R session that I attended was about statistics, anomaly detection, or forecasting. We won't be talking about any of those things! What can R do to make the average DBAs life easier? How about telling you which row and column of data is causing that "String or Binary data will be truncated" error, or easily determining where non-printable and control characters are embedded in your data? This session will have several demos, and will open your eyes to the many uses of R.

Speaker Bio:
Steve Williams is a data platform and analytics professional that runs the data and analytics department at a local phoenix company. He started his career in support of applications running on SQL Server, then became a Microsoft certified database administrator. After doing DBA work for many years, he moved more into the analytics/bi space. His unique ability to understand both business and technical requirements helped elevate his career. In his spare time he enjoys golf, boating, and camping.
Agenda:

• 5:30-6:00pm: Sign-in & network
• 6:00-6:15pm: Announcements & Intro
• 6:15-7:15 Presentation
• 7:15pm-7:30 Q&A, wrap-up, clean-up

Sponsor: International Cruise and Excursions

Parking Options:
The visitor parking is the first parking lot on left.