Menu Register

Event Date: March 2, 2019 7:30 am - 5:45 pm

SQL/BI - Room TBD


Tracks:

AI/Virtual and Augmented Reality | ASP .Net/Core 1 | ASP .Net/Core 2 | Azure/Cloud 1 | Azure/Cloud 2 | Career / Business Dev | DevOps | IoT 1 | Open Topics 1 | Open Topics 2 | SQL/BI | TBD 2 | TBD 3 | Web Development 1 | Web Development 2 | Xamarin/Mobile | All

Timings:

8:30AM-9:40AM | 9:50AM-11:00AM | 11:10AM-12:20PM | 1:20PM-2:30PM | 2:40PM-3:50PM | 4:00PM-5:10PM | All

Agenda download:

TBD

Schedule:

7:30am - Registration - South Entrance
8:00am - Keynote - Lobby
8:30am - 9:40am - Session 1
9:50am - 11:00am - Session 2
11:10am - 12:20pm - Session 3
12:20pm - Lunch - Lobby
1:20pm - 2:30pm - Session 4
2:40pm - 3:50pm - Session 5
4:00pm - 5:10pm - Session 6
5:10pm - Wrap-Up - Lobby
6:00pm - After Party! - TBD

Room 2082 - Speaker Lounge
Room 1049 - IOT Lab - All day


Nicolas A Perez Bio
Twitter LinkedIn

Apache Spark Structured Streams

8:30AM-9:40AM, SQL/BI - Room TBD

Apache Spark is a leading processing engine mostly used to process huge data set in batch and / or streaming mode. The new streaming engine offers a way to query live streaming data using SQL while keeping running aggregates on the streams. We are going to explore these capabilities and the related APIs and at the same time we will show real use cases of the new Structured streams.


Hiram Fleitas Bio
Twitter LinkedIn

Real-time Sentiment Prediction in SQL Server

9:50AM-11:00AM, SQL/BI - Room TBD

In this session, I'm very excited to show you from start to finish how to use Machine Learning to predict a sentiment in real-time with Python and SQL Server (On-Premise). - AGENDA: 1. Add ML Features 2. Grant Access 3. Config 4. Install Retrained & Open-source ML Models 5. Code in Python and T-SQL 6. Real-time scoring 7. Review Sentiment Results


Sam Mesel Bio
LinkedIn

Intro to Databricks

11:10AM-12:20PM, SQL/BI - Room TBD

< to be developed >


Kevin G. Boles Bio
Twitter LinkedIn

SQL Server Query Plan Deep Dive

1:20PM-2:30PM, SQL/BI - Room TBD

Another in TheSQLGuru's Deep Dive series! Query plans - the roadmaps of how your query will be handled by the engine. They contain TONs of information for the astute SQL Server user. Lets dig into them and see what we can learn about and from them and also talk about how they can be used to aid our query tuning efforts.





TBD

2:40PM-3:50PM, SQL/BI - Room TBD



Hector Villafuerte Bio
Twitter LinkedIn

PowerBI for Large and Diverse databases

4:00PM-5:10PM, SQL/BI - Room TBD

Today's enterprise business analytics requires run complex analytic queries against large datasets stored in different sources like Azure SQL Database, Azure Analysis Services, DynamoDB, MongoDB and others. In this session, BI Architect and Microsoft Certified Professional, Hector Villafuerte focuses upon the design, architecture and best practices that allows Power BI to offer the best functionality and performance combination. Throughout the session, we explore live demos of various large and diverse datasets and take advantage of Power BI latest features to achieve high performance and visual capabilities.