| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:45:00 | Mike Byrd | Application Database Development | Indexing Like a Rocket Scientist |
| 09:45:00 | Brent Ozar | DBA Beginners | What to Do When SQL Server is Unusually Slow |
| 09:45:00 | Leveat Ruse | Professional Development | Interviewing-Be So Good They Can’t Ignore You |
| 09:45:00 | Dustin Ryan | Application Database Development | Building a Data Warehouse from the Ground Up |
| 09:45:00 | Satya Jayanty | Cloud Application Development Deployment | Azure Cosmos DB - What you need to know to build globally distributed apps? |
| 09:45:00 | Cecilia Brusatori | Analytics and Visualization | Power BI: From Ground to the Cloud (Getting started) |
| 09:45:00 | Mike Burek | Application Database Development | Is Azure Data Studio Better Than SSMS? |
| 09:45:00 | Audrey Hammonds | Data Science | How AI Saved My Great-Grandma's Cookbook |
| 09:45:00 | Leila Etaati | Artificial Intelligence | AI Application for everyone: Microsoft Power Apps, Cognitive Service, and Flow |
| 09:45:00 | Dave Noderer | IoT | My IOT Journey |
| 09:45:00 | Ibis Fonte | Analytics and Visualization | eCommerce Strategies found through usage data |
| 11:00:00 | Brent Ozar | Enterprise Database Administration Deployment | What's New in SQL Server 2019: 100% Demos |
| 11:00:00 | Vishal Pawar | Business Intelligence | Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice |
| 11:00:00 | Vigi Kuruvilla | Professional Development | Vision, Mission, Goals Strategies |
| 11:00:00 | Joe Homnick | Business Intelligence | Artificial Intelligence (AI) Democratized with Power BI |
| 11:00:00 | Darius Liktorius | Cloud Application Development Deployment | SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS) |
| 11:00:00 | Santosh Kanthety | Analytics and Visualization | Are you Running on Insights? |
| 11:00:00 | Eddy Djaja | Enterprise Database Administration Deployment | Tips of Running a Well-Oiled Database Team |
| 11:00:00 | Hiram Fleitas | Cloud Application Development Deployment | The Power Platform Game Changer |
| 11:00:00 | Pankaj Satyaketu | Analytics and Visualization | Say what now? SQL Server 2019 + Spark + HDFS??? |
| 11:00:00 | Jay Rajendran | Analytics and Visualization | Run Like Google: Server-less Data warehousing and Analytics on Google Cloud Platform |
| 11:00:00 | Eumar Assis | Azure Cloud | Building AI-powered Solutions with Microsoft Azure |
| 11:00:00 | Diana Betancourt | Azure Cloud | Exploring Big data technologies and how unlock everything you thought you knew about your data! |
| 12:30:00 | Diane Schuster | Business Intelligence | CozyRoc: Dynamic Data Flows in SSIS Without Programming |
| 12:30:00 | SQL Saturday South Florida | Cloud Application Development Deployment | DELL Gold Sponsored Session |
| 12:30:00 | Tom Staab | Cloud Application Development Deployment | Best Practices for SQL Server on AWS |
| 12:30:00 | Janis Griffin | Enterprise Database Administration Deployment | Database Performance Monitoring |
| 13:40:00 | Andy Warren | Application Database Development | Constraints are the Key (to Data Integrity) |
| 13:40:00 | Dustin Ryan | Business Intelligence | Power BI Governance 101 |
| 13:40:00 | Eddy Djaja | Enterprise Database Administration Deployment | What Is Clogging Your Database Performance? |
| 13:40:00 | Adriano da Silva | Data Science | An Introduction to Power BI for Data Science With Python |
| 13:40:00 | Patricia Monica Ojeda | Professional Development | Branding and Neuro-Marketing |
| 13:40:00 | Hiram Fleitas | Application Database Development | Real-time Sentiment Prediction in SQL Server |
| 13:40:00 | Satya Jayanty | Enterprise Database Administration Deployment | DevOPS for DBAs - Where is your magic wand? |
| 13:40:00 | Maximo Trinidad | Application Database Development | PowerShell Core - Fundamental on How-To Persist Data in a SQL Server Container |
| 13:40:00 | Ernest Libertucci | Application Database Development | Hadoop, Hive, and Big Data For MSSQL Professionals |
| 13:40:00 | oscar garcia | Analytics and Visualization | Build a Modern Data Warehouse from disparate sources and visualize the data with PowerBI |
| 13:40:00 | Audrey Hammonds | Cloud Application Development Deployment | Into the Deep End with Azure Data Lake Store Generation 2 |
| 13:40:00 | Alex Funkhouser | Professional Development | For Love or Money, Your Tech Career |
| 14:55:00 | Mike Byrd | Application Database Development | Climbing the SQL Server Index B-Tree |
| 14:55:00 | Oscar Zamora | Cloud Application Development Deployment | Azure SQL DW. Redefining MPP, how it stacks against Snowflake and RedShift |
| 14:55:00 | Daniel Shrader | Cloud Application Development Deployment | Containerize your learning - a docker introduction |
| 14:55:00 | Dmitri Korotkevitch | Enterprise Database Administration Deployment | Intro Into Index Analysis |
| 14:55:00 | Travis Page | Enterprise Database Administration Deployment | Look, over there, your permissions are showing! |
| 14:55:00 | Hector Villafuerte | Business Intelligence | Artificial Intelligence (AI) for Business Intelligence |
| 14:55:00 | Alexander Fleming | Application Database Development | Why You Should Consider Implementing Indexed Views |
| 14:55:00 | William Wolf | Application Database Development | Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry |
| 14:55:00 | James McAuliffe | Enterprise Database Administration Deployment | Changing Data Is Easy, Managing Data Change is Hard! |
| 14:55:00 | Dale Sullenberger | Application Database Development | Temporal Tables: Creation, Use, and Optimizing |
| 14:55:00 | Mike Burek | Application Database Development | Basic Windowing Functions |
| 14:55:00 | Frank Quintana | Professional Development | “Past, Present, and Future of the Data Profession" Part 1- "Relational Databases Vs. NoSQL" |
| 16:00:00 | Dale Sullenberger | Enterprise Database Administration Deployment | Temporal Tables - Managing Large Data Sets and Their Effects on Performance |
| 16:00:00 | Hiram Fleitas | Application Database Development | Hack / Protect SQL Server - Come learn both. |
| 16:00:00 | Frank Quintana | Professional Development | “Past, Present, and Future of the Data Profession“ Part 2- "Data Profession in the 21st Century" |
| 16:00:00 | Dmitri Korotkevitch | Enterprise Database Administration Deployment | 5 Availability Groups Issues That May Ruin Your Day |
| 16:00:00 | SQL Saturday South Florida | Analytics and Visualization | PowerBI Challenge |
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Application Database Development
performance. As a SQL Developer, do you understand the difference between a clustered and non-clustered index or what a covering index is? What is different between OLTP and data warehouse databases when it comes to indexing? This session is a deep dive into Clustered indexes Non-clustered indexes B-Tree traversal Primary Keys Covering indexes
This session will feature live query demos illustrating index utilization and performance using statistics and query plans. Understand indexing like a rocket scientist by attending this session!
Some knowledge of T-SQL and Management Studio is recommended.
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: DBA Beginners
There’s gotta be a better way, right?
Good news – there is, and you’re about to learn how the pros do it. In one all-demo session, you’ll watch Brent Ozar use sp_WhoIsActive, sp_BlitzFirst, and sp_BlitzCache to solve several common emergencies. You’ll walk away with a written checklist to solve typical performance emergencies.
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Professional Development
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Cloud Application Development Deployment
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Analytics and Visualization
We will go on a quick tour of the different options offered by the tool, basic concepts, followed by demos and best practices that will let you to start your journey creating fantastic and interactive visualizations. Attendees will have the opportunity to learn how to get and shape data from different sources, create Reports, publish to the cloud and create dashboards.
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Application Database Development
Despite the name, Azure Data Studio works for both on-prem and cloud versions of SQL Server. You might have heard its previous name, SQL Server Ops (Operations) Studio.
Updates are coming out every month, making it easier to use, fixing bugs, and adding exciting new features. Come see some if these new features deserve a spot in your daily toolbox to make your work day easier.
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Data Science
This session demonstrates how you can use both the built-in and custom AI in Cognitive Search. Cognitive Search ingests your data from almost any data source and enriches it using a set of cognitive skills that extracts knowledge and then lets you explore the data using Azure Search. I'll show you how to use this framework to index and search documents, photos, and hand-written text. The public GitHub repo is available at: https://github.com/Microsoft/AzureSearch_JFK_Files
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Artificial Intelligence
Moreover, the process of how to create a face recognition application (to detect the face,location in the picture, age, gender, emotion, hair color and so forth) using the Microsoft cognitive service, Power Apps and Microsoft Flow.
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: IoT
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Analytics and Visualization
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
I'm Brent Ozar, and I'll give you the whirlwind tour. I'll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I'll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.
No slides here - not even an about-me slide. Let's dive into some queries!
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Business Intelligence
In this session Vishal will go over Power BI Ecosystem with Example, PBI RS evolution from its inception Architecture of Enterprise Power BI Report Server and usage through various tool available to publish -SSDT SSRS, Power BI Desktop(Optimized Version), Report Builder and mobile report builder and various Best Practices for PBI Report Server.
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Professional Development
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Business Intelligence
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Cloud Application Development Deployment
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Cloud Application Development Deployment
We'll have time for QA. Maybe we'll even ask Cortana a few questions. I look forward to seeing you there!
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization
This is a completely different architecture that brings together a unified experience for SQL Server, Spark and HDFS.
Come join me for and overview and demonstration of the capabilities this platform can deliver.
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization
This session will provide a walk-through of Google's approach to Server-less Data warehousing, analytics and architectural patterns to address your needs.
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Azure Cloud
On this session, Eumar Assis, Microsoft Technology Strategist will review and demo the different technology options to create Intelligent applications that are powered by Microsoft Azure. Attendees will learn how to use state-of-the-art Azure services such as Power BI Embedded, Azure Cognitive Services, Azure Cognitive Search, and Azure Machine Learning Service that help augment human capabilities. At the end of this presentation, attendees will understand the Azure AI portfolio and what to use when. Attendees will also learn about some real-world applications that have been built using AI on Azure.
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Azure Cloud
Event Date: 08-06-2019 - Session time: 12:30:00 - Track: Business Intelligence
Event Date: 08-06-2019 - Session time: 12:30:00 - Track: Cloud Application Development Deployment
Event Date: 08-06-2019 - Session time: 12:30:00 - Track: Cloud Application Development Deployment
Event Date: 08-06-2019 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Business Intelligence
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Data Science
This is an introductory session designed for those with basic Power BI skills; as well as, minimal or no Python and/or Data Science experience. This is an applied session focusing on the utilization of the tools, technologies and machine learning libraries; such as Pandas, Numpy, Scipy, etc. The demos are centered around Power BI and its integration with Python, ML engine and Data Science processes.
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Professional Development
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Application Database Development
In this session, I'll 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).
I look forward to seeing you guys there!
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Based on my experience DBA is left out in the key element of DEVOPS, this is unfortunate. DBAs have a lot to offer . In this session let us overview where exactly DBAs can make miracles with their magic wand, let's talk about process and procedures. To evaluate each change request to ensure that it is well thought out, is compliant with organizational best practices. Also review what Azure DevOps is offering to manage your cloud deployments.
Take away best practices associated in DEVOPS and DBA world.
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Analytics and Visualization
Learning Objectives:
Challenges when using disparate data sources (different models)
Define a common model to support the different model shapes
Apache Spark Overview
Strategy for loading the different data-sets into the common model
Data analysis and visualization with Power BI
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Cloud Application Development Deployment
Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Professional Development
Maintaining a steady job with biweekly direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other technology professionals are using the latest, most marketable technologies?
In this highly interactive group session, you will learn multiple career strategies for maximizing both the Love and the Money of your multidimensional technology career.
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development
when it comes to indexes. Some of the things you have probably heard are: keep clustered index width small unique indexes perform better keep non-clustered index width small compressed indexes have fewer logical reads add one index for each column
But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice. Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about performance, and the right indexes will give your application a big performance advantage.
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Cloud Application Development Deployment
Snowflake, RedShift and Teradata provide a path to migrate workloads into the cloud and allows a very reduced utilization expense for both compute and storage. That is at least, what the marketing says as it has a tacit disclaimer around it. Azure SQL Data Warehouse offers scalability, pay-as-you-go compute solutions, with data contained within the database boundaries. The presentation shows a side by side comparison, with pros and cons of each platform and debunks some of the myths that have surfaced.
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Cloud Application Development Deployment
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment
In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Business Intelligence
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development
To understand how Deadlocking occurs, we must understand what caused the fight . Learning about basic locking and blocking of SQL Server is a great place to start.
By the end of this session you will walk away with the knowledge of how the locking/blocking mechanism works, the basics of deadlocking, and what Isolation Levels are . You will know how these can help or hurt your situation. Finally you will have the power to capture, report, and stop the family fighting.
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Professional Development
What are the differences between relational and NoSQL Databases? What is Data Science, Data Engineering and Data Analysis? What skills are necessary to keep been competent? How Universities and Business could reduce the deficit of talents in today market place? Part 1- "Relational Databases Vs. NoSQL" My objective of this session is to explain the evolution of the Data Profession from flat files, hierarchical, Network and Relational Databases, DWH, SQL, NF, Business Intelligence, etc. to Hadoop, Big Data NoSQL, ML, AI I also would like to introduce my model of the Intelligence Life Cycle and use it to clarify the advantages and disadvantages of Schema on-read and schema on-write which are the main difference between RDBMS and Big Data ("NoSQL"). What are the advantages and disadvantages of Big Data Compare to RDBMS? Are Data warehouses obsolete? Are Big Data models real schemaless?
Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Application Database Development
We'll have plenty of time for QA. I hope to see you there!
Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Professional Development
Part 2- "Data Profession in the 21st Century" In Part 2 I will concentrate on the skills and composition of Data Drive enterprises and teams and the challenges they are facing My objective of this session is to explain how Hadoop, Big Data NoSQL, ML, AI, and the IoT have influenced and transformed the Data profession. What is a Data Scientist? What is a Data Engineer? What do they do? What is the composition of ML and AI Team? What skills are necessary to keep themselves competitive today and in the near future? How Universities and Business could reduce the deficit of talents in today market place? And what is the future of the data profession? These are some of the main topics at this presentation
Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
While Availability Groups help to achieve required High Availability, they may also introduce issues in the system. In this session, Dmitri will discuss several less-known problems associated with them. You will learn how Availability Groups may impact transaction log truncation and contribute to the blocking in the system, how readable secondaries may increase CPU and I/O load on primaries among a few other things. Dmitri will also discuss how to properly setup monitoring for Availability Group infrastructure in your environment.
Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Analytics and Visualization