sqlsathistory

Nr: 1000

Back to Main list

SQLSaturday #1000 – Oregon – Virtual 1000

Start Time (24h) Speaker Track Title
06:00:00 David Patrick BI Platform Architecture Administration Intro to Power BI
06:00:00 Amit R S Bansal Enterprise Database Administration Deployment How to Troubleshoot a Slow Running Query in SQL Server
06:00:00 Joshua Higginbotham BI Platform Architecture Administration Common ETL Patterns using Azure Databricks
06:00:00 Ben Weissman Enterprise Database Administration Deployment SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything
06:00:00 William Assaf Learning, Certification and Career Development Certification Exams Inside Out
06:00:00 Edward Pollack Application Database Development Dynamic SQL: Writing Efficient Queries on the Fly
06:00:00 Wagner Crivelini BI Development, Modeling and Visualization First Steps to Work with Graphs in AZURE SQL DB
06:00:00 Dennes Torres Enterprise Database Administration Deployment SQL Server 2019: More Intelligent than ever
07:30:00 Steve Jones Application Database Development A Tour of Azure DevOps and TFS
07:30:00 Andrea Mascher Learning, Certification and Career Development SELECT Questions FROM Diversity.Inclusion WHERE AfraidToAsk = 1
07:30:00 David Klee Enterprise Database Administration Deployment 10 Cloudy Questions to Ask Before Migrating Your SQL Server
07:30:00 Deepthi Goguri Enterprise Database Administration Deployment SQL Engine: Its Working Style
07:30:00 William Assaf BI Development, Modeling and Visualization Ethics in Modern Data
07:30:00 Hugo Kornelis Tuning and Optimization Execution plans ... where do I start?
07:30:00 Jose Manuel Jurado Diaz Cloud Application Development Deployment Azure SQL Managed Instance - Experiences from the Field
07:30:00 Adam Saxton BI Platform Architecture Administration Power BI QA/AMA with GuyInACube Microsoft Leaders
09:00:00 David Klee Enterprise Database Administration Deployment Modern SQL Server CPU Architectures for Performance
09:00:00 Jared Poché Enterprise Database Administration Deployment Every Millisecond Counts
09:00:00 Reid Havens BI Development, Modeling and Visualization Guiding User Experiences With Advanced Reporting Features
09:00:00 Rui Romano BI Platform Architecture Administration Power BI Tips, Tricks Hacks from the Trenches
09:00:00 Rob Sewell Enterprise Database Administration Deployment Jupyter Notebooks for DBAs
09:00:00 Wagner Crivelini Cloud Application Development Deployment Implementing Cryptography in AZURE SQL DB with Geo-Replication
09:00:00 Dennes Torres BI Platform Architecture Administration Why Synapse Analytics is beyond Azure SQL Datawarehouse
09:00:00 Vern Rabe Application Database Development Proper Data Type Usage=Guaranteed Better Performance and Accuracy
16:00:00 Jason Horner BI Platform Architecture Administration Real-World Data Movement and Orchestration Patterns using Azure Data Factory
16:00:00 Rahat Yasir Application Database Development Automated machine learning with Azure AutoML
16:00:00 Javier Villegas Enterprise Database Administration Deployment Monitoring SQL Server using Community solutions (Free)
16:00:00 Patrick Gallucci Cloud Application Development Deployment Build a Complete Azure Data Platform in 1 Hour
16:00:00 Erin Dempster Application Database Development Navigating Row Level Security
16:00:00 Rie Irish Enterprise Database Administration Deployment 10 DBA Tasks for Azure SQL: Whats Different from On-Prem
16:00:00 Paul Turley BI Development, Modeling and Visualization Data Modeling Solutions for Challenging BI Data Modeling Problems
16:00:00 Ondrej Aubrecht Learning, Certification and Career Development Can you trust the intelligence of Application tracking systems with your CV?
17:30:00 Andrew Kalik Application Database Development Python: Turn your SQL ETL up to 11
17:30:00 Tracy Boggiano Learning, Certification and Career Development Mental Health in IT: Safeguarding our most precious resource
17:30:00 Ramesh Satya Application Database Development Understanding SQL Server Views - The Right Way
17:30:00 Julie Koesmarno Enterprise Database Administration Deployment Notebooks 101 for SQL People
17:30:00 Mark Runyon Learning, Certification and Career Development The Countless Benefits of Mentoring
17:30:00 Michael McKinley BI Platform Architecture Administration Basic Data Modeling for BI Reporting
17:30:00 Will Velida Cloud Application Development Deployment Developing Cosmos DB for the Enterprise
17:30:00 Jamey Johnston Advanced Analysis and Machine Learning Power BI dataflows and How to Leverage for Data Science
19:00:00 Kevin Boles Tuning and Optimization Common TSQL Mistakes
19:00:00 Ramesh Satya Application Database Development Understanding NULLs in SQL Server
19:00:00 Gaston Cruz BI Platform Architecture Administration New waves to Processing Tabular Models
19:00:00 Harry Chandra Enterprise Database Administration Deployment Intro to PowerShell for the DBAs
19:00:00 Armando Lacerda BI Platform Architecture Administration Azure Synapse back to back
19:00:00 Itshak David Application Database Development Data virtualization with SQL Server 2019 PolyBase and integration with Power BI .
19:00:00 Matt Gordon Learning, Certification and Career Development From Stutterer to Speaker: Overcoming Your Fears
19:00:00 Scott Klein Enterprise Database Administration Deployment The ins and outs of securing SQL Server traffic

SessionID: 105524

Intro to Power BI

Back to calendar

Event Date: 24-10-2020 - Session time: 06:00:00 - Track: BI Platform Architecture Administration

Speaker: David Patrick

Title: Intro to Power BI

Abstract:

For anyone new to Power BI, we'll cover all the main features and walk through getting data into the tool (using both the desktop and online versions), creating visualizations, turning them into reports and adding them to dashboards. When we're through we'll have several BI components available to share via the Cloud!

SessionID: 105571

How to Troubleshoot a Slow Running Query in SQL Server

Back to calendar

Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Amit R S Bansal

Title: How to Troubleshoot a Slow Running Query in SQL Server

Abstract:

You always wanted to troubleshoot a slow running query. But you just don’t know where to begin. In this demo-heavy session, I will show you how to troubleshoot a slow running query. You will see an end-to-end query tuning example with a slow running workload. We will capture important metrics while the workload is running and then use the captured data to troubleshoot query performance issues. The technique you will learn can be applied to production straight away. This will be a 100% demo session.

SessionID: 107559

Common ETL Patterns using Azure Databricks

Back to calendar

Event Date: 24-10-2020 - Session time: 06:00:00 - Track: BI Platform Architecture Administration

Speaker: Joshua Higginbotham

Title: Common ETL Patterns using Azure Databricks

Abstract:

Are you an ETL Developer still working on-premises and trying to figure out where some of the cloud options fit, then come to this session where we will cover some of the common ETL patterns we find on-premises in Azure Databricks.

SessionID: 107610

SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything

Back to calendar

Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Weissman

Title: SQL Server 2019 Big Data Clusters: Make SQL Server your Data Hub for everything

Abstract:

In the realm of data storage and processing, there are two major technologies which we deal with every day. On one side, we have relational data that is stored inside SQL Server, and on the other side, non-relational or very large datasets that do not fit the relational model which are stored on big data clusters like Hadoop or Spark.

This introduces challenges when having to combine datasets across both these technologies. SQL Server was never built to process huge datasets in a distributed fashion or to handle non-relational data very well, meaning that in many cases you would have to resort to bringing your relational data into Hadoop or Spark clusters. SQL Server 2019 has the answer with Big Data Clusters: it combines SQL Server with HDFS and Spark!

In this session we are going to explore the capabilities of the exciting new feature. How does it work and how can we work with datasets that are non-relational?

SessionID: 107635

Certification Exams Inside Out

Back to calendar

Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Learning, Certification and Career Development

Speaker: William Assaf

Title: Certification Exams Inside Out

Abstract:

Preparing for Microsoft certification? Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination? We'll go through the process of item creation from an item writer's viewpoint, what rules item writers must follow, and why questions sometimes have strange phrasing. For any technical skillset pursuing certification, we'll review non-technical sample questions and walk through the process of using information at your disposal. You'll better understand how to deconstruct the problem statement. We'll leave time for QA with a veteran of the Microsoft certification exam writing process.

SessionID: 108098

Dynamic SQL: Writing Efficient Queries on the Fly

Back to calendar

Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Application Database Development

Speaker: Edward Pollack

Title: Dynamic SQL: Writing Efficient Queries on the Fly

Abstract:

Dynamic SQL is a powerful tool that allows for the creation of fast and efficient queries when the specifics may not be known until run-time. This tool can be used to automate complex processes, facilitate reporting on an unknown number of targets, or perform tasks that would otherwise be time-consuming to develop.

This is an often misunderstood tool that is underused in areas where it can provide immense value or abused by applications that it was never intended for. Well-written dynamic SQL can solve seemingly impossible problems while being easy to read and understand.

Applications that will be demonstrated include: mapping database relationships, schema searching, generating large volumes of TSQL, and much more. Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it!

SessionID: 108305

First Steps to Work with Graphs in AZURE SQL DB

Back to calendar

Event Date: 24-10-2020 - Session time: 06:00:00 - Track: BI Development, Modeling and Visualization

Speaker: Wagner Crivelini

Title: First Steps to Work with Graphs in AZURE SQL DB

Abstract:

This is an introductory presentation over Graph concepts: modeling, querying, and presenting data in POWER BI. A demo will present how to implement the model in AZURE SQL DB, basic notions of querying data and how to visualize Graphs in a dashboard.

SessionID: 108322

SQL Server 2019: More Intelligent than ever

Back to calendar

Event Date: 24-10-2020 - Session time: 06:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Dennes Torres

Title: SQL Server 2019: More Intelligent than ever

Abstract:

After Adaptive Query Processing in SQL Server 2017 now we have Intelligent Query Processing on the preview versions of SQL Server 2019.

What is it? What benefits it brings to us? What's the relation with Adaptive Query Processing, from SQL Server 2017?

Attending this session you will discover these answers and more

SessionID: 105926

A Tour of Azure DevOps and TFS

Back to calendar

Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Application Database Development

Speaker: Steve Jones

Title: A Tour of Azure DevOps and TFS

Abstract:

Learning how to orchestrate your software development process can be a challenge, and many people don't know where to start using the tools available. For Microsoft stack developers, Azure DevOps and TFS provide cloud and on-premises tooling to manage your code.

In this session we will look at the integration of work tracking with Scrum templates and Kanban boards with version control for your code. We will discuss and demonstrate pull requests to help manage the flow of work within a team and explain the build, test, and release tools available for your database and application code.

At the end of this session, attendees will be more comfortable getting started with their own project in Azure DevOps and using the tools with their own team.

SessionID: 107357

SELECT Questions FROM Diversity.Inclusion WHERE AfraidToAsk = 1

Back to calendar

Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Learning, Certification and Career Development

Speaker: Andrea Mascher

Title: SELECT Questions FROM Diversity.Inclusion WHERE AfraidToAsk = 1

Abstract:

In the past several years Diversity, Equity, Inclusion (DEI) have become more important and visible in the workplace. Studies have shown that organizations are often more successful when they are more diverse, yet the tech sector is moving slowly to improve representation and inclusion. Many IT professionals want to improve but don't know where to start.

This session will cover key concepts in DEI and how they apply to data practitioners.

SessionID: 107451

10 Cloudy Questions to Ask Before Migrating Your SQL Server

Back to calendar

Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: 10 Cloudy Questions to Ask Before Migrating Your SQL Server

Abstract:

SessionID: 107621

SQL Engine: Its Working Style

Back to calendar

Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Deepthi Goguri

Title: SQL Engine: Its Working Style

Abstract:

Many DBA's and Developers work with SQL Server but don’t fully understand how it really works behind the scenes. Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server. This session will cover ACID properties, key components of the Relational Engine, Storage engine, Cache and the Transaction manager. We will also cover what happens under the covers during read and write operations within SQL Server.

Deepthi will show you how the SQL engine thinks – enabling you to think like it!

SessionID: 107634

Ethics in Modern Data

Back to calendar

Event Date: 24-10-2020 - Session time: 07:30:00 - Track: BI Development, Modeling and Visualization

Speaker: William Assaf

Title: Ethics in Modern Data

Abstract:

This session will explore a variety of considerations that modern data scientists and data practitioners must account for when gathering and presenting data, including topics on bias, construct analysis, and machine learning.

SessionID: 108056

Execution plans ... where do I start?

Back to calendar

Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Tuning and Optimization

Speaker: Hugo Kornelis

Title: Execution plans ... where do I start?

Abstract:

SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.

But sometimes it doesn’t. Sometimes a query takes too much time. You need to find out why, so you can fix it. That’s where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it’s slow.

However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?

In this session you will learn how to obtain execution plans. and how to start reading and understanding them.

SessionID: 108068

Azure SQL Managed Instance - Experiences from the Field

Back to calendar

Event Date: 24-10-2020 - Session time: 07:30:00 - Track: Cloud Application Development Deployment

Speaker: Jose Manuel Jurado Diaz

Title: Azure SQL Managed Instance - Experiences from the Field

Abstract:

In this pre-conference you will learn the best practices, tips and tricks on how to successfully use Azure SQL Managed Instance on production environments. You will learn how to monitor, configure, restore, backup, VNET, NGS, created a replication environment, etc for Azure SQL Managed Instance. These learnings are fruit of Microsoft CSS support cases, and customer field engagements.

SessionID: 108784

Power BI QA/AMA with GuyInACube Microsoft Leaders

Back to calendar

Event Date: 24-10-2020 - Session time: 07:30:00 - Track: BI Platform Architecture Administration

Speaker: Adam Saxton

Title: Power BI QA/AMA with GuyInACube Microsoft Leaders

Abstract:

SessionID: 107452

Modern SQL Server CPU Architectures for Performance

Back to calendar

Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Modern SQL Server CPU Architectures for Performance

Abstract:

Modern CPU architectures are complex and misunderstood, especially as they relate to SQL Server instance configuration and database usage patterns. Default values in virtualization and the SQL Server instance can cause misalignments and improper balance in the way the SQL Server lines up with the CPUs and memory, which results in an immediate (and silent) performance penalty. Come learn as we discuss topics such as physical and virtual NUMA, hyperthreading, query parallelism, public cloud CPU selection, and SQL Server instance settings, and show you how to validate your SQL Server architecture and improve the performance of your critical SQL Servers for both on-prem and cloud-based SQL Servers.

SessionID: 107497

Every Millisecond Counts

Back to calendar

Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jared Poché

Title: Every Millisecond Counts

Abstract:

Query optimization is relatively easy when you look at a plan and find table scans, hash match joins, and missing indexes. But how do you find opportunities when all the low hanging fruit has been picked?

This session is a case study on improving a procedure that runs 350 million times per day, so any improvement is greatly magnified. We will discuss where we found opportunities to improve a procedure running in 3.1 milliseconds; how effective our attempts were, what didn't work, and the results achieved.

SessionID: 107514

Guiding User Experiences With Advanced Reporting Features

Back to calendar

Event Date: 24-10-2020 - Session time: 09:00:00 - Track: BI Development, Modeling and Visualization

Speaker: Reid Havens

Title: Guiding User Experiences With Advanced Reporting Features

Abstract:

As Power BI continues to innovate with new features that enhance the user experience, it is more important than ever to understand what's available to configure for the report consumer experience. Learn about advanced features such as: bookmark capture states and uses, button configurations and formatting, report tooltip applications, and the wide applicability of measure based formatting.

SessionID: 107582

Power BI Tips, Tricks Hacks from the Trenches

Back to calendar

Event Date: 24-10-2020 - Session time: 09:00:00 - Track: BI Platform Architecture Administration

Speaker: Rui Romano

Title: Power BI Tips, Tricks Hacks from the Trenches

Abstract:

Power BI is an amazing BI platform out of the box, but there' is a lot of things that you can do with Power BI that probably you dont even imagine!

This session is a collection of my top tips, tricks hacks gathered over the years from simple tips to advanced hacks to boost your productivity.

SessionID: 107611

Jupyter Notebooks for DBAs

Back to calendar

Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Sewell

Title: Jupyter Notebooks for DBAs

Abstract:

Jupyter Notebooks were once the realm of Data Scientists. New releases of Azure Data Studio, Visual Studio Code, and .NET interactive tooling have brought this tooling into the Operational team's area. The biggest benefit of using Jupyter Notebooks is that you have your documentation, your code and your results in the same source controllable document.

I will share with you all of the knowledge I have gained over the past 12 months implementing Jupyter Notebooks for Data Operation teams.

You will leave

Enabling collaboration with your team, simplifying common tasks, improving Incident Wash-Up meetings, creating run-books, easily creating code for others to use are some of the benefits that you will take away. We will have fun as well.

SessionID: 108306

Implementing Cryptography in AZURE SQL DB with Geo-Replication

Back to calendar

Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Wagner Crivelini

Title: Implementing Cryptography in AZURE SQL DB with Geo-Replication

Abstract:

Geo-replication assumes you are going to use a redundant architecture to improve availability. This presentation shows what to consider when implementing Transparent Data Encryption (TDE) and Always Encrypted in this scenario.

SessionID: 108320

Why Synapse Analytics is beyond Azure SQL Datawarehouse

Back to calendar

Event Date: 24-10-2020 - Session time: 09:00:00 - Track: BI Platform Architecture Administration

Speaker: Dennes Torres

Title: Why Synapse Analytics is beyond Azure SQL Datawarehouse

Abstract:

Synapse Analytics is being announced as the new name of Azure SQL Datawarehouse, but it's not only that. There is a broader view in Synapse analytics, beyond Azure SQL Datawarehouse. Let's see in this session what was improved, what changed, and how synapse analytics fits in the data platform.

SessionID: 108371

Proper Data Type Usage=Guaranteed Better Performance and Accuracy

Back to calendar

Event Date: 24-10-2020 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Vern Rabe

Title: Proper Data Type Usage=Guaranteed Better Performance and Accuracy

Abstract:

It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types.

In this demo-heavy presentation I will show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.

SessionID: 104552

Real-World Data Movement and Orchestration Patterns using Azure Data Factory

Back to calendar

Event Date: 24-10-2020 - Session time: 16:00:00 - Track: BI Platform Architecture Administration

Speaker: Jason Horner

Title: Real-World Data Movement and Orchestration Patterns using Azure Data Factory

Abstract:

In this session, we will start with an overview of Azure Data Factory concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.

Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.

SessionID: 105797

Automated machine learning with Azure AutoML

Back to calendar

Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Rahat Yasir

Title: Automated machine learning with Azure AutoML

Abstract:

AutomatedML is the process of automating the time consuming, iterative tasks of machine learning model development. It allows data scientists, analysts, and developers to build ML models with high scale, efficiency, and productivity all while sustaining model quality. Automated ML democratizes the machine learning model development process, and empowers its users, no matter their data science expertise, to identify an end-to-end machine learning pipeline for any problem. In this session, we will talk about Automated Machine Leanring process and also will give step by step demo of Azure AutoML.

SessionID: 105900

Monitoring SQL Server using Community solutions (Free)

Back to calendar

Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Javier Villegas

Title: Monitoring SQL Server using Community solutions (Free)

Abstract:

In this session we will cover how to monitor and support any SQL Server Environment using free tools created by community members

SessionID: 107114

Build a Complete Azure Data Platform in 1 Hour

Back to calendar

Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Cloud Application Development Deployment

Speaker: Patrick Gallucci

Title: Build a Complete Azure Data Platform in 1 Hour

Abstract:

Migrating Data and Analytic workloads to Azure gives organizations the ability to innovate faster with the Azure Data Platform. To unlock the potential, it typically takes months to architect, engineer, and deploy a Modern Data and Analytics Platform in Azure. Even with a prescriptive approach for cloud adoption, many organizations are not equipped to take on the full scope of responsibility required to leverage the all-up capabilities they have acquired as a result of the project.

Patrick Gallucci will share a service delivery approach that helps organizations move large and small data platforms to Azure. He will show you how to leverage proven cloud adoption methodologies, tools, resources, and best practices to enable your organization to simplify and accelerate their move to the cloud.

SessionID: 107597

Navigating Row Level Security

Back to calendar

Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Erin Dempster

Title: Navigating Row Level Security

Abstract:

New to SQL Server 2016 (okay, it's a few years old already, but it still feels new) is Row Level Security, which allows database developers and architects to effectively lock down tables, giving users access to a defined subset of data in the table. It sounds easy enough, but there are a number of design considerations and pitfalls to be aware of. This session will work through a few demos to implement RLS and dive into those pitfalls that need to be avoided. For anyone considering implementing Row Level Security or have tried but have run into issues, this should be a session you want to attend.

SessionID: 107614

10 DBA Tasks for Azure SQL: Whats Different from On-Prem

Back to calendar

Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rie Irish

Title: 10 DBA Tasks for Azure SQL: Whats Different from On-Prem

Abstract:

Adoption of Cloud is at an all time high, with no end in sight. Managing a small fleet of databases on-premises was something you used to understand. In this session, we'll cover the 10 most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Prem installs. One of the great things about Azure SQL is that the skill set your team has developed over the years translates well. The tools and technologies you're familiar with are all there. So much is the same but some of the tasks that DBAs do are different. We'll familiarize everyone with ten of the tasks that are different including demo.

SessionID: 107915

Data Modeling Solutions for Challenging BI Data Modeling Problems

Back to calendar

Event Date: 24-10-2020 - Session time: 16:00:00 - Track: BI Development, Modeling and Visualization

Speaker: Paul Turley

Title: Data Modeling Solutions for Challenging BI Data Modeling Problems

Abstract:

Sorry to break the news but the world is not flat and neither is business data. Data modeling is an essential skill in Power BI design and hard problems require creative solutions. In this session, we will enumerate common challenges and demonstrate modeling techniques to resolve them. Session topics: implementing star and snowflake schema essentials, role-playing tables, many-to-many and bi-directional filters, working without relationships, disconnected lookup tables and calculation groups. We will also discuss the composite models and the future of BI data modeling.

SessionID: 108114

Can you trust the intelligence of Application tracking systems with your CV?

Back to calendar

Event Date: 24-10-2020 - Session time: 16:00:00 - Track: Learning, Certification and Career Development

Speaker: Ondrej Aubrecht

Title: Can you trust the intelligence of Application tracking systems with your CV?

Abstract:

An applicant tracking system (ATS) is a software application that enables to handle candidate profiles and could scan and analyse the Resumes (CV's).

This session will answer some of the unspoken questions:     - Can you trust ATS with your CV ?     - Can ATS analyse your Resume correctly (with Real examples) ?     - How ATS works?

Come along to this session and find out more about REAL DATA analysis and scanning mechanism by multiple ATS used in the job market and to find out if you can trust AI with your own CV.

SessionID: 104460

Python: Turn your SQL ETL up to 11

Back to calendar

Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Application Database Development

Speaker: Andrew Kalik

Title: Python: Turn your SQL ETL up to 11

Abstract:

SessionID: 104634

Mental Health in IT: Safeguarding our most precious resource

Back to calendar

Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Learning, Certification and Career Development

Speaker: Tracy Boggiano

Title: Mental Health in IT: Safeguarding our most precious resource

Abstract:

One in four Americans suffers from a mental health challenge each year. In the tech community, this number rises to 42%. The stigma associated with discussions around mental health, as well as how it can negatively impact your work and home life, make people reluctant to discuss the topic. Now is the time to start discussing mental health in tech and how to take advantage of the opportunity to safeguard our most precious resource: people. We'll discuss how mental health affects job quality, including sharing examples from my professional life. We'll discuss the four primary workplace factors which play a pivotal role in mental health challenges in the tech community. I'll provide tips on what is best to say and not say to people you know whose lives are being affected by their mental health. Lastly, we'll cover how to make your workplace a safe place where mental health can be talked about and how to encourage your company to offer resources to help maintain everyone's mental health.

SessionID: 105535

Understanding SQL Server Views - The Right Way

Back to calendar

Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Application Database Development

Speaker: Ramesh Satya

Title: Understanding SQL Server Views - The Right Way

Abstract:

VIEW is one of the programmable objects often used by Developers to build solutions to business problems but if not used without complete implications, there will be data inconsistency issues. This session focusses on how to create VIEWs, what are issues while doing DML operations through the VIEWS and how does INDEXED VIEWs help us.

SessionID: 105725

Notebooks 101 for SQL People

Back to calendar

Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Julie Koesmarno

Title: Notebooks 101 for SQL People

Abstract:

Are you a database developer, a DBA or a data analyst? Do you find spending quite a bit of time trying to reproduce analysis or reproduce issues and the troubleshooting techniques? This Notebooks 101 session is for you!

The lack of rigor in being able to reproduce analysis in business context or to reproduce data troubleshooting can lead to confusion and time wasted on work that had been previously done. With Notebooks, Data Professionals can share their techniques and data sources used for the data analysis or troubleshooting for code review and reproducible insights/troubleshooting.

Azure Data Studio Notebooks support SQL and KQL natively with intellisense; with easy to use charting capabilities. With Notebooks and Jupyter Book (collection of Notebooks) in Azure Data Studio, it’s also easy now for your team to build an onboarding guide (user manual) / documentation on data sources, useful sample scripts and tutorials.

SessionID: 105815

The Countless Benefits of Mentoring

Back to calendar

Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Learning, Certification and Career Development

Speaker: Mark Runyon

Title: The Countless Benefits of Mentoring

Abstract:

Mentoring offers countless benefits to the mentee, mentor and the organization as a whole. In this session, we will map out the benefits to each participant as well as talk about how to find a mentor or how to start a mentorship program in your organization.

SessionID: 105851

Basic Data Modeling for BI Reporting

Back to calendar

Event Date: 24-10-2020 - Session time: 17:30:00 - Track: BI Platform Architecture Administration

Speaker: Michael McKinley

Title: Basic Data Modeling for BI Reporting

Abstract:

We all start using business intelligence tools by using a single dataset, like a flat file. Then, we hit a plateau in our learning curve, or we add a second flat file into our BI product, and we get incorrect results. One reason is that we haven't modeled our solution correctly.

In order to move to the next level of our journey along the BI learning curve, we need to understand how a tool like Power BI works. Only then will we understand why we design our data models the way we do.

In this session, we will review how tools like Power BI work under the covers and how that impacts the way we construct our data models. This is an introductory level course, so we will not get too technical, just enough to get us to the next level and moving back up that learning curve!

SessionID: 107573

Developing Cosmos DB for the Enterprise

Back to calendar

Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Cloud Application Development Deployment

Speaker: Will Velida

Title: Developing Cosmos DB for the Enterprise

Abstract:

Azure Cosmos DB is an awesome multi-model database service that allows us to distribute our data on a global scale. It's fairly easy to get started with Cosmos DB, but when it comes to implementing it for use within our Enterprise applications, there are many things that you will want to consider when developing a Cosmos DB database.

In this session, I'll cover important topics that you'll want to consider when developing and administrating Cosmos DB for Enterprise use, including security considerations, partitioning, provisioning throughput for your databases and collections, distributing your data and much more.

By the end of this session, you should be able to take these learnings and apply them when developing Cosmos DB applications for your business.

SessionID: 108178

Power BI dataflows and How to Leverage for Data Science

Back to calendar

Event Date: 24-10-2020 - Session time: 17:30:00 - Track: Advanced Analysis and Machine Learning

Speaker: Jamey Johnston

Title: Power BI dataflows and How to Leverage for Data Science

Abstract:

This session will give you an introduction to Power BI dataflows and how to leverage the data for data science. Power BI dataflows allow for self service data migration into Azure Data Lake Services gen 2 utilizing Power Query.

This session will show how to use dataflows, setup Azure Data Lake Services gen 2 and dataflows and how to connect to the resulting data in the Azure Data Lake Services gen 2 to do Data Science with tools like Azure Databricks.

This session will use real data and analytics to demonstrate Power BI dataflows, Azure Data Lake Services gen2 and Azure Databricks utilizing DAX, M and Python.

SessionID: 105042

Common TSQL Mistakes

Back to calendar

Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Tuning and Optimization

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right 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. I have given this talk over 100 times now and it is always very highly rated!

SessionID: 105534

Understanding NULLs in SQL Server

Back to calendar

Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Application Database Development

Speaker: Ramesh Satya

Title: Understanding NULLs in SQL Server

Abstract:

SQL Server follows three-valued logic (3VL) (instead of Boolean logic) to evaluate any condition to True or False or Unknown. Unknown value in SQL Server is represented as NULL. NULLs in SQL Server are often misunderstood and causes data inconsistency issues. In this session, we will try to go through different test cases to understand NULLs properly.

SessionID: 105633

New waves to Processing Tabular Models

Back to calendar

Event Date: 24-10-2020 - Session time: 19:00:00 - Track: BI Platform Architecture Administration

Speaker: Gaston Cruz

Title: New waves to Processing Tabular Models

Abstract:

SessionID: 105721

Intro to PowerShell for the DBAs

Back to calendar

Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Harry Chandra

Title: Intro to PowerShell for the DBAs

Abstract:

SessionID: 105862

Azure Synapse back to back

Back to calendar

Event Date: 24-10-2020 - Session time: 19:00:00 - Track: BI Platform Architecture Administration

Speaker: Armando Lacerda

Title: Azure Synapse back to back

Abstract:

Azure Synapse provides a complete platform to ingest and process data at scale in the cloud. In this workshop we will be learning and applying its features to all stages of data processing and understanding best practices and pitfalls. From ingesting to data lakes to transform data in big data services to apply machine learning models, including data remodeling, this workshop will guide to through a full implementation of Azure Synapse all the way to presentation and reporting.

SessionID: 107199

Data virtualization with SQL Server 2019 PolyBase and integration with Power BI .

Back to calendar

Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Application Database Development

Speaker: Itshak David

Title: Data virtualization with SQL Server 2019 PolyBase and integration with Power BI .

Abstract:

In this session we will learn about the improvements to PolyBase in SQL Server 2019, which allows you to extend the querying capability to data sources like SQL Server, Oracle, MongoDB, Redis, Hadoop CDH, and other data sources. You also get insights on the design, capabilities, and performance advantages of PolyBase, save ETL Processes as follows:

• Installing and Configuring PolyBase Windows Linux • Connecting to Hadoop • Using Predicate Pushdown to Enhance Query Performance • Packet Capture With\Without Predicate Pushdown • When to use Predicate Pushdown • Limitations on Pushdown with Complex Filters • Built-In Integrations: Oracle, MongoDB , Radis and More Integrating via ODBC : Apache Spark , Apache Hive, Microsoft Excel Monitor PolyBase with Dynamic Management Views . • PolyBase Query Tuning , Execution Plans and Statistics PolyBase Scenarios : ETL VS ELT jobs This is a demo session only with minimum theory lessons from the fields !

SessionID: 107601

From Stutterer to Speaker: Overcoming Your Fears

Back to calendar

Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Learning, Certification and Career Development

Speaker: Matt Gordon

Title: From Stutterer to Speaker: Overcoming Your Fears

Abstract:

Are you terrified of public speaking? For 37 years of my life, I was too! That paralyzing fear of public communication held me back and kept me taking from taking advantage of career and community opportunities that came my way - and I've heard this story from many. Now, when I speak at community events, I'm often asked how I got into speaking and how I got over my fears of public speaking. In this free-wheeling session I'll tell you the tips and tricks that I took to heart to go from a kid in speech therapy to somebody that volunteers to speak in front of people and actually enjoys it. Most importantly, I'll talk about how improved personal and public communication can give your career a massive boost in this time of rapid growth in the data professional realm. I sincerely hope this session helps encourage people to overcome their fears of public and small group speaking - or that you at least enjoy making fun of pictures of 6-year-old me in speech therapy headphones!

SessionID: 107629

The ins and outs of securing SQL Server traffic

Back to calendar

Event Date: 24-10-2020 - Session time: 19:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Scott Klein

Title: The ins and outs of securing SQL Server traffic

Abstract:

We are frequently hearing of an enterprise-size business being hacked, data being stolen, or data being exploited. Data security has always been important, but it should not be taken for granted. Data is information, and one of the greatest assets to a business, and when it is compromised, things go south quickly.

While there are multiple levels of security (securing data at rest, data in traffic, etc.), this session will focus on securing data that is on the move; ie., securing traffic between a client and server. We'll discuss and look at two solutions: Certificates and IPsec, exploring them in detail, outlining the pros and cons of each, how to set up and configure them, and when to use what.