Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 42
This session will give you a solid foundation for learning more about AI. During this session, we will cover the 5 questions data science answers for us. We will explore the nuances between AI vs. ML, Cognitive Services vs. Data Science, how they are used, and what that means to your career. AI is intertwining its way into many things we do in technology. This expanding ecosystem is already in our workplace, let's understand how we can leverage it. 

We will explore the business use cases that can be solved using Machine Learning and how that can prepare you to be ready to take the next step. We will consider some of the latest releases from Microsoft and how they impact the way we work with AI. 

By exploring and explaining the ecosystem, we will gain a deep-rooted understanding to set you on your way to discovering all that AI has to offer.

This session is the first session in the AI for Everyone Learning Pathway at Summit 2019
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data Science: Analytics; Machine Learning, Python, R, R Server,

Level: Beginner

Session Code:

Date: November 02

Time: 1:00 PM - 2:15 PM

Room: 026

Have you ever thought what would it be like to run SQL Server engine in a small footprint? Well, wait no more. 

Running on Arm and x64 architecture with a reduced footprint, the proven performant and most secure Microsoft SQL engine is coming to the Edge in interactive devices and edge gateways. Combining new capabilities on data streaming and time-series, with in-database machine learning (ML), Azure SQL Database Edge is optimized for low-latency analytics right on the Edge. This session will showcase the scenarios Azure SQL Database Edge can enable.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Az

Level: Beginner

Session Code:

Date: November 02

Time: 4:15 PM - 5:30 PM

Room: 006

Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean. We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favourite: auditing. There's even a bit of In-Memory OLTP. There might even be time for demos!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBDev: Development, Tools, Scalability, Query Tuning and Indexin

Level: Beginner

Session Code:

Date: November 02

Time: 1:00 PM - 2:15 PM

Room: 231

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion.  Unlike a session on concepts, this session surrounds itself with a real-life situation and how automation was used with DevOps practices to build a solution.
The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Data: Architecture, Platform, Managed vs. VM, CosmosDb, Az

Level: Intermedia

Session Code:

Date: November 02

Time: 10:15 AM - 11:30 AM

Room: 217

2 text transaction files, a pivoted excel budget file, 20 Power Queries, 6 dimensional tables, and one interactive Excel dashboard = mind blowing awesomeness in under 60 minutes.  But while the analysis is important, the real value in the refresh.  Can your model pull in another 22 text files and next year's budgets in less than a minute?  This model can.
Come and see how Excel 2016 gives us the ability to not only rapidly create business intelligence, but also allows us to build engaging and interactive models that can be quickly updated and shared via Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Arch/Admin: Design, ETL, SSIS, EDW

Level: Beginner

Session Code:

Date: November 02

Time: 10:15 AM - 11:30 AM

Room: 034

Common Data Model as the foundation of Power BI Dataflows and as part of the Open Data Initiative with SAP and Adobe, seems to be a pretty good move from Microsoft. We want to take a closer look to this approach. In this session we show how the Common Data Model will allow you to combine Self-Service ETL and Corporate Data Engineering. We will show you how Power BI and more specialised tools like ADF, DataBricks etc. can work together on the Azure Data Lake with one common model. We than extend this and show, what opportunities this standard brings to you, when we unleash the possibilities you have on managing Data Quality and Governance. We also will have a look in how you integrate CDM in a DataOps  Methodology.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Arch/Admin: Design, ETL, SSIS, EDW

Level: Intermedia

Session Code:

Date: November 02

Time: 8:30 AM - 9:45 AM

Room: 217

Continuous Intelligence combines the terms of Continuous Integration and Business Intelligence and aims at defining and implementing processes to keep your implementation and deployment processes for your BI applications flexible and as seamless as possible.
Even in the near past, support for CI processes of BI projects was almost not there. But, the last few years brought some changes to the perception of this topic and shifted the mindset.
Let's look at advantages and challenges for CI in BI and at possibilities to implement such a process for Analysis Services.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DevOps: Agile Processes between Dev and Ops

Level: Beginner

Session Code:

Date: November 02

Time: 1:00 PM - 2:15 PM

Room: 015

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Arch/Admin: Design, ETL, SSIS, EDW

Level: Intermedia

Session Code:

Date: November 02

Time: 11:45 AM - 1:00 PM

Room: 034

Representing the data in a visual and catering it to specific roles is very critical for Data projects. We will discuss about the different approaches, best practices and challenges(and solutions).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data Science: Analytics; Machine Learning, Python, R, R Server,

Level: Beginner

Session Code:

Date: November 02

Time: 4:15 PM - 5:30 PM

Room: 217

New advances in technology coupled with the rate of change in the data-driven world are placing the issue of Privacy and Ethics at the forefront of public consciousness – forcing a discussion around the ethical use of data within business and the role that each data professional must play in ensuring that the highest standards are reached, maintained, and constantly evaluated. Technologies such as machine learning, artificial Intelligence, and big data processing are providing new business opportunities that must also account for privacy and ethics issues while maintaining a balance with compliance, security, and integrity of data. 
But what are the issues that individual data professionals should be aware of to avoid reputational damage to their companies and themselves? And what are the tools that can help them in their endeavors? 

This session will take a close look at some of these challenges and the tools that are available to help mitigate these issues and risks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Professional Development: Career, Skills, Interviewing, Managing

Level: Beginner

Session Code:

Date: November 02

Time: 8:30 AM - 9:45 AM

Room: 231

Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy.  This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data Science: Analytics; Machine Learning, Python, R, R Server,

Level: Beginner

Session Code:

Date: November 02

Time: 8:30 AM - 9:45 AM

Room: 015

Determining how to efficiently design database structures for a given application has always relied on the same old answer: "It depends!" So, how do you determine what level of normalization your data requires?  This session will review the principles of data normalization, show the impact that normalization can have on performance and data integrity, and just as importantly, show you when it's OK to break the rules and denormalize.  We will cover some case situations where it's better not to be normal!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Essentials: SQL Basics: Object/Data types, Best Practices, Query

Level: Beginner

Session Code:

Date: November 02

Time: 8:30 AM - 9:45 AM

Room: 034

Data breaches abound! Do you want to keep your company out of the headlines? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt? What else can you do to protect your sensitive data? 

In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption, and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings. This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption. Also, let’s learn how to classify data which should be protected and how to audit sensitive data usage. 

You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. Also, you will gather information on how to fully protect and review your sensitive data usage.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBDev: Development, Tools, Scalability, Query Tuning and Indexin

Level: Beginner

Session Code:

Date: November 02

Time: 4:15 PM - 5:30 PM

Room: 214

When your development team is up to a certain size and often no matter what size it is you want to start following best development practices. These include things like source control, multiple environments, deployment processes and governance.

As Power BI content is developed using Power BI Desktop and not Visual Studio as most Microsoft BI solutions are these things can get tricky. 

In this session we will look at what Power BI has to offer when it comes to development lifecycle. We will look at the different options available to the developer when it comes to source control, dev, test and production and deployment of Power BI content. We will then look at the different options when it comes to distribution of content to the end user. Lastly, we will look at governance and see how it is possible to secure the content and audit the usage of Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Design: Delivery: Power BI, SSRS, Visualization

Level: Intermedia

Session Code:

Date: November 02

Time: 2:45 PM - 4:00 PM

Room: 026

The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/2017/2019 and Azure SQL DB/DW with predicate based RLS and in Power BI, as well. This session will show how organizational & asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/2017, Azure SQL Database and Power BI without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations. 

Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Design: Delivery: Power BI, SSRS, Visualization

Level: Intermedia

Session Code:

Date: November 02

Time: 4:15 PM - 5:30 PM

Room: 206

Have you ever felt passed up for a promotion or a stretch assignment because you identify as a woman, non-binary and/or as BIPOC (black, indigenous, or a person of color)? Have you ever had a chance to reach for the proverbial brass ring but did not or was prevented from doing so? 
Many workplaces endeavor to create an inclusive and equitable workplace but end up missing the mark by perpetuating systemic biases that impact the ability for folks to realize their fullest career potential, or even get access to the game at all. 
Join a panel of prolific speakers from PDX Women In Tech who will address topics like what to do when gender and/or race set the tone for the environment, and what to do when leadership doesn’t recognize an opportunity to promote equity. 
Audience (all are welcome) will be able to learn new ways to approach self-advocacy (or, in the case of allies, advocacy) and tips and techniques to further the conversation around equity and inclusion in their workplace.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Professional Development: Career, Skills, Interviewing, Managing

Level: Intermedia

Session Code:

Date: November 02

Time: 10:15 AM - 11:30 AM

Room: 231

The Query Store houses valuable information on performance of your queries, as well as gives you great insights into your query workload and plan changes. This presentation will take a look at what's new in the 2017 Query Store, the new adaptive query processing features, and how to incorporate Query Store queries into the new SQL Operation Studio for monitoring slow running queries and analyzing waits. You'll learn how to use the Query Store to quickly find plan changes, analyze performance issues and find the waits that caused them. Both DBAs and developers can increase their performance-tuning skills by attending this session.

You will learn:

How to quickly find plan changes and analyze performance issues
How to use the new wait classifications in order to get clues on how to tune your statements
About the new adaptive query processing features and SQL Operation Studio
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBDev: Development, Tools, Scalability, Query Tuning and Indexin

Level: Intermedia

Session Code:

Date: November 02

Time: 4:15 PM - 5:30 PM

Room: 015

Azure Data Studio, keeping in line with Microsoft's ethos of tooling that works on many platforms this one runs on Windows, macOS and Linux.

This session is to give you an introduction to the product give you an idea of where/how it can be used in the Data Platform space. We will also cover some of the main features (code snippets, widgets, extensions) and time permitting Notebooks.

Hopefully by the end of the session you will be aware of Azure Data Studio and be ready to give it a go!

Level: Beginner Level 100
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Essentials: SQL Basics: Object/Data types, Best Practices, Query

Level: Beginner

Session Code:

Date: November 02

Time: 2:45 PM - 4:00 PM

Room: 006

Getting started with GitHub can at times be overwhelming.  Especially when you've been working with other source control and project management systems your whole career.  In this session, we will overview the below tasks to ensure your success with GitHub.
* Initial setup of a Repository in GitHub.
* Build Issue templates for new features, bugs, or custom tasks.
* Securing the check-in/merge process to your root branch.
* Integrating GitHub with other productivity tools to keep on top of changes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBDev: Development, Tools, Scalability, Query Tuning and Indexin

Level: Beginner

Session Code:

Date: November 02

Time: 1:00 PM - 2:15 PM

Room: 006

When Microsoft released SQL Server 2017 it allowed data professionals to run SQL Server on Linux and in containers, providing a wider and more open platform to deploy and run SQL Server.

This session will reveal the parts of SQL Server on Linux that will be familiar for data professionals, and also highlight and discuss the differences. The top Linux commands that SQL Server DBAs should know will be discussed and demonstrated as well as a close look at the Linux file system.

This session will incorporate a demonstration that will showcase the fundamentals of Linux management and demonstrate how to install, configure, manage, and monitor SQL Server on it.

This session will help you understand the basics and will present the exciting future of SQL Server on Linux.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBAdmin: Administration, Deploy, Manage, Repair, Server and Data

Level: Beginner

Session Code:

Date: November 02

Time: 4:15 PM - 5:30 PM

Room: 034

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