Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type



Sessions Found: 54
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:

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:

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:

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

To stay competitive in today’s world is to stay agile by making swift, intelligent, data-driven decisions. Join us to see how you can enable your organization to be data-driven with the fastest growing cloud-enabled data warehouse, Snowflake.
Especially if any of the following interests you:
•         Escaping the constraints of legacy technology.
•         Delivering insight from all your data to all your business users.
•         Creating your own data sharing economy.
You will also learn:
•         The ease of Snowflake’s intuitive user interface
•         How to easily load, integrate and query structured and semi-structured data
•         What it’s like to run large queries in a fraction of the time
•         How to effortlessly connect your BI/ETL tools
Speaker:

Accompanying Materials:

Session Type:
Do Not Use (75 minutes)

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

Level: Beginner

Session Code:

Date: November 02

Time: 11:45 AM - 1:00 PM

Room: 026

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:

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

The basic mechanism when we want to give users access to data or actions in SQL Server in a controlled way through stored procedure is ownership chaining. This is something we use everyday as SQL workers, although we may not be aware of it. Every once in a while, we run into situations where it seems that it is not sufficient to put a statement in a stored procedure, but that users need to be granted explicit permissions – something we may not always be comfortable with, because that would permit the users to do things we do not want them to be able to.

There are two additional mechanisms in SQL Server we can employ in these situations: certificate signing and the EXECUTE AS clause. In this session I will start by exploring how ownership chaining works and its limitations. I will then proceed to explore the other two options and I will particularly focus on certificate signing, as this is the preferred method. At first it may seem overly complex, but I will show how it easily can be automated. EXECUTE AS may seem simpler, but I will point out potential problems with it, not the least if you try to use it on server level and consider to set the database as TRUSTWORTHY.

This session is directed towards both developers and DBAs, as this session deals with problems you may face in either roles.
Speaker:

Session Type:
Regular Session (75 minutes)

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

Level: Advanced

Session Code:

Date: November 02

Time: 8:30 AM - 9:45 AM

Room: 026

You too can build a development Environment for Reporting Services and SQL Server with Azure completely in PowerShell without any GUI!!   Additionally, Frank Geisler will be discussing the ReportingServicesTools in PowerShell.
Speaker:

Session Type:
Regular Session (75 minutes)

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

Level: Beginner

Session Code:

Date: November 02

Time: 1:00 PM - 2:15 PM

Room: 206

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:

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

Continuous Intelligence is commonly used to describe approaches to constantly analyze data by applying machine-learning algorithms. But you can also understand it to be a combination of the terms of Continuous Integration and Business Intelligence. 
Support for BI projects in CI has been a field for improvement in even the near past. But why was that?
BI offers some special challenges for CI processes that we want to discuss during this session.
Speaker:

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:

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

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:

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:

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:

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:

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:

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:

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

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 showcase both the differences of SQL Server on Linux and the things that will be familiar for DBAs. The top Linux commands that SQL Server DBAs should know will be discussed and demonstrated.

This session will incorporate a demonstration that will showcase the fundamentals of Linux management for SQL Server as well as s sneak peek at SQL Server on containers.

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

Accompanying Materials:

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

Statistics are key to the selection of a good execution play. But statistics aren’t perfect, and they often require management over and above what the default SQL Server configurations supply.
In this session we’ll look into why statistics, and specifically the histogram, are so important to good query performance. We’ll see how they’re not perfect, and how that can result in an occasional bad execution plan (slow query). I’ll also present a few methods to resolve those statistics-caused performance issues. Of course there will be plenty of examples.
Speaker:

Session Type:
Regular Session (75 minutes)

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

Level: Intermedia

Session Code:

Date: November 02

Time: 1:00 PM - 2:15 PM

Room: 034

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:

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

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