Menu Register

Event Date: February 10, 2018 7:30 am - 5:45 pm

SQL/BI - Room 2081


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


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 2018-02-09.xlsx


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

Santosh Hari Bio
Twitter LinkedIn

CosmosDB 101: Basics and quickstart

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

During Build 2017, Microsoft may have revealed one of its most far-reaching products ever—Azure Cosmos DB. With global distribution, multi-model support. and numerous APIs for accessing your data including SQL, JavaScript, Gremlin, MongoDB, and Azure Table Storage, CosmosDB offers a wide array of solutions for data storage on a global scale. This talk will cover a high level look at the various features and capabilities of CosmosDB and resources on getting started.

Hiram Fleitas Bio
Twitter LinkedIn

SQL PASS Summit 2017 - 30 Minute Summary (1 of 3 presentations)

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

Description: This is a summary of the sessions I attended at PASS Summit 2017. Out of the week-long conference, I put together these slides to summarize the conference and share with you what I learned. The slides are about the sessions that I found had the most value and include demos I personally developed and tested, alike the speakers at the conference. Agenda: Schedule Keynotes Session notes and take-aways Demos Follow-up resources Raffle (2x Amazon Gift Cards - $50 value each) – Must attend and submit an evaluation ( to participate. Topics: Columnstore Indexes Performance 2017 vs 2016 Automatic Tuning Docker / SQL Operations Studio / GitHub (DevOps) Power BI Security (Hack & Secure: Encryption / Dynamic Data Masking / Row-Level-Security) Cosmos DB Predictive Analytics (Machine Learning and AI) Previous Recording: Slides: Speaker Bio:

Frank Quintana Bio
Twitter LinkedIn

"OLTP OLAP, Big Data and the Languages and Paradigms of MICROSOFT BI"

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

Using Visual Studio Data Tools we are able to answer questions in two contradictory worlds, the OLTP and the OLAP. In order to do that, VSDT offers three services: SSIS, SSRS, SSAS and a variety of languages, such as, SQL, T-SQL, MDX, DMX, etc. It is impossible to explain the main components of the MS BI stack SSIS, SSAS, and SSRS in a single presentation. To add insult to injury, “The Big Data and Data Science Revolution”, plus the convoluted Cloud technology, are disrupting and revolutionizing the relatively calm world of the Data Warehouse and the Database field in general, making the job of the BI architects extremely complex. So, in this presentation we will attempt to explain the mind set of those three services and paradigms from the perspective of the problems they intend to solve.

Kevin G. Boles Bio
Twitter LinkedIn

Know What Your Code is Doing to SQL Server!

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

ORMs - oh how I LOVE them! As a consultant when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance and concurrency you will get from that code"! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.

Kevin G. Boles Bio
Twitter LinkedIn

Common TSQL Mistakes

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

We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some pretty subtle and some downright sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance and concurrency. I have given this talk over 70 times now and it is always very highly rated!

Sam Mesel Bio

InMemory OLTP - SQL 2017 (What's new in SQL 2017 for Memory Optimized objects)

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

Session will start with a demo comparing regular (disk-based) table and a MemoryOptimized table, a second demo follows covering transaction processing, then we will discuss additional benefits MemoryOptimized objects bring to the table. We will touch on the new type of index to use, and memory considerations. Session will cover the feature improvements from 2014 to 2016 to 2017