Menu Register

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

SQL/BI - Room 2067


Tracks:

AI/Virtual and Augmented Reality | ASP .Net/Core 1 | ASP .Net/Core 2 | Auditorium | Azure/Cloud 1 | Azure/Cloud 2 | Azure/Cloud 3 | Career / Business Dev | DevOps | IoT 1 | Open Topics 1 | Open Topics 2 | Open Topics 3 | SQL/BI | 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:

PLEASE NOTE: This agenda is subject change! Updates will be posted to the web site. Check for updates on the day of the event.
South Florida Code Camp Schedule 2019-03-02.xlsx

Schedule:

7:30am - Registration - North 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 3061 - Speaker Lounge


Hiram Fleitas Bio
Twitter LinkedIn

Real-time Sentiment Prediction in SQL Server

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

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


Kevin G. Boles Bio
Twitter LinkedIn

SQL Server Defaults SUCK!!

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

If you just click next-next-next and think you have a good-to-go SQL Server THINK-AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from data and log file growth factors to Windows power settings and many useful items in between.


Kevin G. Boles Bio
Twitter LinkedIn

SQL Server Query Plan Deep Dive

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

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.


Jorge Besada Bio
LinkedIn

PowerShell From The Trenches - Jobs Demystified

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

Let's be honest: how many times you tried to setup concurrent jobs in Powershell and browsed gazillion scripts the web and just left your scripts executing one-after-the-other because of all the trouble, utter confusion and increased feeling of diminished self worth? If this is something you can relate to,
THIS SESSION IS FOR YOU
And if you are a jobs expert, please also come and give suggestions This an entry level session, so don't be afraid to show up


Hector Villafuerte Bio
Twitter LinkedIn

PowerBI for Large and Diverse databases

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

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.