Build Schedule

Advanced Filters:
  • Track

    clear all














  • Speaker


  • Level


  • Session Type

Sessions Found: 56
To understand the present and get a glance to the future you have to look at the past.
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?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: June 08

Time: 2:55 PM - 3:55 PM

Room: Room K - 3047

I pretend to show how our profession has been changed in the last 50 years the impact of these new techniques, models, the raising of new job descriptions and the skills necessary to function in the data profession realm in the 21st Century. 
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
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 08

Time: 4:00 PM - 5:00 PM

Room: Room K - 3047

AlwaysOn Availability Groups have become the most common High Availability technology used with SQL Server. It provides protection at the database group level, and it stores a separate copy of each database on each node, eliminating storage from being a single point of failure.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: June 08

Time: 4:00 PM - 5:00 PM

Room: Room L - 3048

These days, Using AI is not limited to writing R or Python codes. There are different API that allows developers, business intelligence consultant and others to create an AI application or report without writing any single code. Microsoft Cognitive service is a toolkit that allows this for all Microsoft users. In this session, an overview on cognitive service will be provided, and attendees will see how to create an OCR (image to text application) to take a photo from an image in Power Apps, then how to use a combination of Microsoft flow and Cognitive service to convert the taken image to text.
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Artificial Intelligence

Level: Intermedia

Session Code:

Date: June 08

Time: 9:45 AM - 10:45 AM

Room: Room G - 2072

This session provides an introduction to the use of Power BI for Data Science. It covers the use of Power BI as part of the Data Science process; including EDA (Exploratory Data Analysis), Data Visualization along with its integration with Python, Scikit-Learn and SQL Server Machine Learning Services.

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: June 08

Time: 1:40 PM - 2:40 PM

Room: Room J - 3046

Ever wonder what insights you can gain from your own data? This presentation will take you through use cases like fitness data and web traffic monitoring from day to day life and explains how to turn data into powerful visuals and interactive analytics using Power BI. It's an interactive session that is best suited for beginners and intermediate users of Power BI Desktop and Cloud Service.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 08

Time: 11:00 AM - 12:00 PM

Room: Room D - 2077

Power BI has new features that democratizes (makes accessible to all)  AI capabilities. You don’t need to be a Data Scientist or write complicated Machine Learning scripts/routines to take advantage of AI with Power BI. Joe takes you on a demo rich learning experience of how all levels of users can implement AI capabilities in Power BI. These demos will include how to integrate both Amazon Web Services and Microsoft Azure Machine Learning packaged APIs into Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: June 08

Time: 11:00 AM - 12:00 PM

Room: Room I - 3045

Cognitive Services provides intelligent algorithms to see, hear, speak, understand and interpret user needs. Azure Machine Learning performs highly specialized tasks such as feature selection, algorithm selection or hyper-parameter optimization. These two AI tools can now be integrated with Power BI. Hector will show and demo some original use cases with Cognitive Services, Azure Machine Learning and other new AI features recently available in PowerBI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: June 08

Time: 2:55 PM - 3:55 PM

Room: Room J - 3046

In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB.  There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 08

Time: 9:45 AM - 10:45 AM

Room: Room C - 2078

Data Warehousing has been traditionally deployed via on-prem MPP solutions, and due to cloud modernization, and datacenter reduction footprint initiatives, organizations are looking out to establish a relationship with a cloud solution that can help them get off the traditional storage and compute licensing scheme, to easily scale their workloads without spending millions in newly acquired hardware, and to reduce their database administration operational tasks. 
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 08

Time: 2:55 PM - 3:55 PM

Room: Room H - 3044

Windowing functions are when you add a "window" to which rows a function will look at using the OVER clause. We'll start by learning how to add the OVER clause to the commonplace COUNT, SUM, AVG, MIN, and MAX aggregate functions, since the OVER clause is optional. From there, we'll learn some ranking functions, which do require the OVER clause. You'll see examples that use the ROW_NUMBER function to identify and delete duplicate rows. Finally, we'll close with the RANK and DENSE_RANK functions that help you report on the grouping of your data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 08

Time: 2:55 PM - 3:55 PM

Room: Room F - 2073

Learn how Amazon Relational Database Services (RDS) helps SQL Server DBAs focus their time where it matters most and why thousands of customers have chosen Amazon Web Services for their Microsoft Windows and SQL Server workloads. We will cover the benefits of running SQL Server on Amazon EC2 and Amazon RDS along with best practices for storage, monitoring, availability, security, backup, and recovery.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code: AWS

Date: June 08

Time: 12:30 PM - 1:30 PM

Room: Room E - 2074

Researchers are gaining amazing insights into positioning a brand by using the science of neuromarketing. Let's talk about What’s neuromarketing? and how this science will help us to light up people's brains and positioning our brands.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: June 08

Time: 1:40 PM - 2:40 PM

Room: Room K - 3047

A data warehouse (DW) is a core component of business intelligence and a central data repository for different sources. This poses many challenges as the schema definition for those sources may be completely different from one another. In this presentation, we discuss how to create a data warehouse model that can support data from multiple systems. Oscar Garcia shows how to build a dimensional model which can enable us to import the data with different shapes into a data warehouse. We then create processes to transform and load the data using Apache Spark. We finally use Power BI to visualize the data from our data warehouse and Spark.


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
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 08

Time: 1:40 PM - 2:40 PM

Room: Room D - 2077

What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we'll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We'll also discuss how the design of our dimensional model affects a semantic modeling technologies like SQL Server Analysis Services or Power BI and how the choices we make during the data warehouse design phase can make or break our reports.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 08

Time: 9:45 AM - 10:45 AM

Room: Room E - 2074

Do you understand what does it take to build end-to-end Cloud solutions that leverage Artificial Intelligence (AI) and Machine Learning (ML) to empower users and customers to achieve more? Which AI technologies to choose and when? Which skills does a traditional DBA or developer need to learn in order to work with AI? Come and join this session to find the answer to these questions.

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure Cloud

Level: Intermedia

Session Code:

Date: June 08

Time: 11:00 AM - 12:00 PM

Room: Room F - 2073

Databases are growing.  The way we use data is changing and growing.  When you have a lot of change, it has to be managed, or bad things happen to your data and your job!  A common problem with database change management is... database change management.  This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy.  There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be.  Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 08

Time: 2:55 PM - 3:55 PM

Room: Room I - 3045

You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 2:55 PM - 3:55 PM

Room: Room D - 2077

This session is designed to introduce you or to re-engage your interest in all the options we have for setting constraints in a database. From datatypes to nulls to checks, defaults, foreign keys, and triggers we have a LOT of options, so it's important to know the options and also have a bit of a professional philosophy on when to use each of them - we will do a brief look at each of them. We'll talk about why getting them right on day 1 is so important, how to add them to existing tables (the syntax is the least interesting part!), and some patterns and anti-patterns you can look for when you get to the office on Monday.  Constraints aren't glamorous, but they matter, and they require an advocate - you! A good session for DBA's, developers, and yes, even managers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 08

Time: 1:40 PM - 2:40 PM

Room: Room A - 2082

You've heard about docker, but haven't found that use case for it yet or simply just don't have the time to learn it.  This session will start off showing you what docker is at a high level, and its many simple use cases.  You'll leave with enough knowledge to either use someone else's docker image or build your own.  All if this without needing to install docker on your machine. We'll go into how to spin up an environment using a cloud resource in minutes.  After that, we'll install a graphical interface for docker in a docker image to help speed up your learning.  From there, we will even spin up an SQL Server in a container that can start and stop in little to no time.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 08

Time: 2:55 PM - 3:55 PM

Room: Room G - 2072

Sessions Found: 56
Back to Top cage-aids
cage-aids
cage-aids
cage-aids