RDX will be returning to and exhibiting at the PASS Summit from November 5 to November 8, 2019, at the Washington State Convention Center in Seattle. The PASS Summit is the SQL Server community's biggest gathering of professionals and features hundreds of conference sessions centered around Application & Database Development, Business Intelligence, Cloud Application and Development, and Enterprise Database Administration and Deployment.
We are excited to announce that RDX will have two speakers at this year's Summit:
RDX's SQL Server BI and Data Warehousing Manager, Jeremy Frye, will be presenting:
PowerApps and AI: A Flow of Location Events - 2:15-3:15 PM, Friday, November 8th- Room Yakima 1
The Microsoft Power Platform has become an innovative bridge between data interaction, visualization, and analytics. The possibilities have become almost endless for businesses to engage with their data in amazing ways.
In this session, we will create an application using PowerApps and location services to track latitude and longitude coordinates on Bing maps. Attendees will learn how to configure and demonstrate it on a mobile device.Jeremy will also show two approaches using AI within the application by using Azure SQL Database, Cognitive Services and Flow. An end-user will be able to leverage Bing Search for location-aware web searches, while an administrator will be able to leverage the Azure SQL Database and Flow to send alerts based on predefined metrics.
SQL Server BI Developer, Russel Loski, will be presenting:
Managing ETL Change Using BIMLScript - 2:15-3:15 PM, Friday, November 8th- Rooms 615-617
Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn't it be nice to simply document the structure of the file, the file's metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata.
During his session, Russel will import US census data to exemplify this methodology. He'll then create the SSIS package using BIMLScript and metadata. Additionally, he'll demonstrate how to generate an Azure Data Factory pipeline from the same metadata.
Attendees can also find us at our booth during show floor hours. We'll be ready to talk about how we help DBAs gain free time and peace of mind with our SQL Server DBA, Microsoft BI, G5 and Azure SQL DB solutions.
Information about booth promotions and giveaways will be available as the conference gets closer, so check back soon!