sqlsathistory

Nr: 978

SQLSaturday #978 - Los Angeles – Virtual 2020

Start Time (24h)	Speaker	Track	Title
09:00:00	Buck Woody	Professional Development and Personal Branding	Presentation Skills for the Technical Professional
09:00:00	Dan Mallott	Database Administration, Deployment, and Development	Secure SQL Server Database Design: Tactics and Technology
09:00:00	Dustin Vannoy	Private and Public Cloud Architecture and Infrastructure	Data Lakes with Azure Databricks
09:00:00	Andy Yun	Database Administration, Deployment, and Development	How Intelligent Query Processing improves T-SQL performance
09:00:00	Mark Mucchetti	Private and Public Cloud Architecture and Infrastructure	Google BigQuery ML: Machine Learning with SQL
10:15:00	Bob Ward	Database Administration, Deployment, and Development	Inside SQL Server on Kubernetes
10:15:00	Elaena Bakman	Data Presentation, Visualization, and Analytics	Add JSON to the list of tools in your SQL Server tool-belt.
10:15:00	Oleg Ulyanov	Private and Public Cloud Architecture and Infrastructure	Architecting SQL Server on VMware vSphere - Doing it Right!
10:15:00	Oleg Ulyanov	Private and Public Cloud Architecture and Infrastructure	Microsoft SQL Server workloads on VMware Cloud on AWS: Design, Migration and Configuration
10:15:00	Dennes Torres	Database Administration, Deployment, and Development	Synapse Analytics: Beyond the Basics
10:15:00	Dennes Torres	Database Administration, Deployment, and Development	SQL Graph Databases: Beyond Relational
10:15:00	Javier Villegas	Database Administration, Deployment, and Development	Monitoring SQL Server using Community solutions (Free)
11:30:00	Anna Hoffman	Private and Public Cloud Architecture and Infrastructure	Azure SQL: What to use when
11:30:00	David Patrick	Database Administration, Deployment, and Development	3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
11:30:00	Andy Yun	Other	Going Beyond Monitoring With SentryOne
11:30:00	Eugene Stepanov	Private and Public Cloud Architecture and Infrastructure	Running SQL Server workload on AWS
11:30:00	Marsha Pierce	Database Administration, Deployment, and Development	The Future of Containers Is Here!
13:00:00	Adrian Sullivan	Other	Building your own million dollar SQL Practice
13:00:00	Jason Horner	Data Presentation, Visualization, and Analytics	Data Lake Design Patterns
13:00:00	Sean McCown	Database Administration, Deployment, and Development	Loading SQL Server Data with Powershell
13:00:00	Arvind Shyamsundar	Private and Public Cloud Architecture and Infrastructure	DevOps for Azure SQL
13:00:00	Brian Hansen	Database Administration, Deployment, and Development	Get Your Optimizer to Give up All Its Secrets
14:15:00	Armando Lacerda	Database Administration, Deployment, and Development	SQL Server 2019 is not your dad's DBMS
14:15:00	Brodie Brickey	Data Presentation, Visualization, and Analytics	Basic Work-Flow with SQL Server Standard SSRS
14:15:00	Jeff Iannucci	Database Administration, Deployment, and Development	Faster Transactions: Query Tuning for Data Manipulation
14:15:00	Nuri Halperin	Private and Public Cloud Architecture and Infrastructure	Introduction to MongoDB
14:15:00	Nuri Halperin	Database Administration, Deployment, and Development	Document Design for Document Oriented Databases
14:15:00	Hasan Savran	Database Administration, Deployment, and Development	New SQL Server Features for Developers and Analysts
15:30:00	Vitor Fava	Data Presentation, Visualization, and Analytics	Implementing AI solutions using Azure Machine Learning Services
15:30:00	Marcelo Adade	Database Administration, Deployment, and Development	SQL SERVER 2019: top features that every DBA should know
15:30:00	Sergiy Lunyakin	Data Presentation, Visualization, and Analytics	Agile data preparation with ADF Wrangling data flow
15:30:00	Sarah Patrick	Data Presentation, Visualization, and Analytics	Case Study: How I used SharePoint, Power Automate, Power Apps, and Forms to build a Speaker Database
15:30:00	Denzil Ribeiro	Database Administration, Deployment, and Development	Azure SQL Hyperscale Deep Dive

SessionID: 102146

Presentation Skills for the Technical Professional

Back to calendar

Event Date: 13-06-2020 - Session time: 09:00:00 - Track: Professional Development and Personal Branding

Speaker: Buck Woody

Title: Presentation Skills for the Technical Professional

Abstract:

Whether you're new to presenting or an accomplished professional, all of us need to learn more about presentation skills. In this real-world session, Buck Woody, a Data Scientist from Microsoft will show you how to:

Choose and develop a topic that draws in an audience
Create a story-line for your session
Understand the technologies and tools for delivering your session effectively
Deal with presentation disasters

SessionID: 102621

Secure SQL Server Database Design: Tactics and Technology

Back to calendar

Event Date: 13-06-2020 - Session time: 09:00:00 - Track: Database Administration, Deployment, and Development

Speaker: Dan Mallott

Title: Secure SQL Server Database Design: Tactics and Technology

Abstract:

When we design and build an application, do we think about security first or is it an afterthought? As we read about more and more data breaches, it is clear that we need to think security-first when designing and building our applications.

Where does design start for an application? It starts with the database layer. In this talk, we will discuss strategies for designing a more secure SQL Server database. We will start with simple design decisions for tables, views, stored procedures, and database roles that can improve security before moving on to talk about built-in SQL Server security technologies such as Always Encrypted, Row-Level Security, Dynamic Data Masking, Transparent Data Encryption, and SQL Server Audit. Lastly, we will finish up with some tips on how to retrofit security features onto existing databases and look at how data access from the application may need to change.

SessionID: 104008

Data Lakes with Azure Databricks

Back to calendar

Event Date: 13-06-2020 - Session time: 09:00:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Dustin Vannoy

Title: Data Lakes with Azure Databricks

Abstract:

The world of analytics and data warehousing has evolved rapidly in the last 10 years with the Data Lake as the backbone of modern data environments. Data Lakes are best built leveraging unique services of the cloud provider to reduce operations complexity. This session will explain why everyone's talking about data lakes, break down the best services in Azure to build a Data Lake, and walk through code for querying and loading with Azure Databricks.

Attendees will leave the session with a firm grasp of why we build data lakes and how Azure Databricks fits in for ETL and querying.

Agenda: - Why Data Lakes? - Data Lake best practices - Reference Architecture implemented with: ○ Azure Databricks ○ Azure Data Lake Storage (Gen 2) ○ Event Hubs for Apache Kafka

SessionID: 105155

How Intelligent Query Processing improves T-SQL performance

Back to calendar

Event Date: 13-06-2020 - Session time: 09:00:00 - Track: Database Administration, Deployment, and Development

Speaker: Andy Yun

Title: How Intelligent Query Processing improves T-SQL performance

Abstract:

Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019. This collection of new features is a game changer that will improve performance across the board. Come to this overview session to learn more about how these capabilities will benefit you.

SessionID: 105239

Google BigQuery ML: Machine Learning with SQL

Back to calendar

Event Date: 13-06-2020 - Session time: 09:00:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Mark Mucchetti

Title: Google BigQuery ML: Machine Learning with SQL

Abstract:

BigQuery is the data warehouse offering from Google Cloud Platform. It also has a powerful and increasingly growing machine learning integration. Using BQML, you can create, train, or import linear regression and classifier models directly into your dataset. You can then make predictions directly using SQL and integrate them into your reporting and dashboards. This session will cover BigQuery ML and a few example applications.

VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval

SessionID: 102266

Inside SQL Server on Kubernetes

Back to calendar

Event Date: 13-06-2020 - Session time: 10:15:00 - Track: Database Administration, Deployment, and Development

Speaker: Bob Ward

Title: Inside SQL Server on Kubernetes

Abstract:

Containers are the new "virtual machines" and one of the hottest technologies in the industry. While containers compliment virtual machines and provide consistency, portability, performance, and availability, how do you deploy containers at scale? For many, Kubernetes, an open-source system for automating deployment, scaling, and management of containerized applications, is the answer.

In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. You will see how SQL Server can take advantage of Kubernetes for "built-in" high availability, easy to deploy patching, and integration with Always On Availability groups. We will discuss deploying SQL Server in various popular Kubernetes distributions including but not limited to Azure Kubernetes Service, OpenShift, and kubeadm. This session assumes a fundamental knowledge of both SQL Server and containers. We will move fast, and go deep using demos as a method to lea

SessionID: 103844

Add JSON to the list of tools in your SQL Server tool-belt.

Back to calendar

Event Date: 13-06-2020 - Session time: 10:15:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Elaena Bakman

Title: Add JSON to the list of tools in your SQL Server tool-belt.

Abstract:

If you are not sure why JSON is in SQL Server or how to use it, this is the session for you! We will start with the basics of what JSON is and learn all about extracting, querying, and even indexing JSON data. The goal of this session is to take the mystery out of working with JSON in SQL server and add JSON to the list of tools in your SQL Server tool-belt.

SessionID: 105133

Architecting SQL Server on VMware vSphere - Doing it Right!

Back to calendar

Event Date: 13-06-2020 - Session time: 10:15:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Oleg Ulyanov

Title: Architecting SQL Server on VMware vSphere - Doing it Right!

Abstract:

Let us connect DBAs and Infrastructure Admins providing to DBAs vital information how to get best SQL Server deployment on top of VMware virtual platform.

The session will cover both the design and the configuration of a SQL Server virtual machine with the special focus on:

vCPU allocation and deep dive in vNUMA

Memory allocation and configurations options

Storage configuration best practices including PMem/NFS/Snapshots

Network configuration myths and best practices

It all that you want to know about virtual platform configuration but hesitated to ask! Directly from the source with the tom of hands-on from the Professional Services VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval

SessionID: 105134

Microsoft SQL Server workloads on VMware Cloud on AWS: Design, Migration and Configuration

Back to calendar

Event Date: 13-06-2020 - Session time: 10:15:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Oleg Ulyanov

Title: Microsoft SQL Server workloads on VMware Cloud on AWS: Design, Migration and Configuration

Abstract:

We provide architectural guidelines to plan migration of SQL Server workloads to VMware Cloud on AWS, technical deep dive into execution of migration of SQL Server workload, along with configuration recommendations for FCI and AG and performance tuning options.

You will learn how to optimally use VMware Cloud on AWS to host mission critical SQL Server workloads

SessionID: 105169

Synapse Analytics: Beyond the Basics

Back to calendar

Event Date: 13-06-2020 - Session time: 10:15:00 - Track: Database Administration, Deployment, and Development

Speaker: Dennes Torres

Title: Synapse Analytics: Beyond the Basics

Abstract:

Synapse Analytics, which is way beyond the former Azure SQL Data Warehouse, is focused on MPP, Multi Parallel Processing, being a very powerful environment for Data Warehouse processing.

It's former name, Azure SQL Data Warehouse, usually pushed many DW and BI developers to use this powerful tool in order to build a Data Warehouse. However, just implementing the logical design of a Data Warehouse inside an MPP environment can be very deceiving, because many default settings for the MPP environment will not be at their best.

On this session you will see how to configure the MPP environment to achieve it's best performance for your Data Warehouse. You will understand the importance to understand and control the distributions by compute nodes, how critical are the correct choice of resource classes and users, the benefits to correct manage workload classification and much more.

SessionID: 105172

SQL Graph Databases: Beyond Relational

Back to calendar

Event Date: 13-06-2020 - Session time: 10:15:00 - Track: Database Administration, Deployment, and Development

Speaker: Dennes Torres

Title: SQL Graph Databases: Beyond Relational

Abstract:

Since SQL Server 2017 the Graph Database feature was released, enabling us to mix the relational model with a Graph model. Some existing flaws in this release are being fixed in SQL Server 2019, bringing graph objects closer to SQL Serve reality.

In this session, you will discover how Graph Databases in SQL Server works and what's new for them in SQL Server 2019

SessionID: 105185

Monitoring SQL Server using Community solutions (Free)

Back to calendar

Event Date: 13-06-2020 - Session time: 10:15:00 - Track: Database Administration, Deployment, and Development

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

Azure SQL: What to use when

Back to calendar

Event Date: 13-06-2020 - Session time: 11:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Anna Hoffman

Title: Azure SQL: What to use when

Abstract:

In this session, you'll learn from the Microsoft Product Group about the different options for your SQL deployments in Azure. After this session, you should be able to:

○ Articulate the key differentiators between SQL Server on-prem, in Azure VM, in Azure SQL DB (Single database, Elastic Pools, and Managed instance) ○ Explain the different service tiers within Azure SQL DB, and evaluate what is best for your workloads and business requirements (Serverless, Hyperscale, General Purpose, Business Critical, etc)

SessionID: 104996

3 Ways for Getting Data from SharePoint : SSIS, Excel and Access

Back to calendar

Event Date: 13-06-2020 - Session time: 11:30:00 - Track: Database Administration, Deployment, and Development

Speaker: David Patrick

Title: 3 Ways for Getting Data from SharePoint : SSIS, Excel and Access

Abstract:

Need to report on some data from SharePoint? We will look at three different techniques to pull data from a SharePoint Server. We will start with SSIS and the SharePoint List Source and Destinations. Next, We will use Excel to connect to various SharePoint lists (both online and on premise), and finally We will use Microsoft Access to do the same thing (and throw in the capability to do updates as well). At the end of the talk, We will have three different ways to get data from SharePoint.

SessionID: 105338

Going Beyond Monitoring With SentryOne

Back to calendar

Event Date: 13-06-2020 - Session time: 11:30:00 - Track: Other

Speaker: Andy Yun

Title: Going Beyond Monitoring With SentryOne

Abstract:

Hopefully, you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.

SessionID: 105379

Running SQL Server workload on AWS

Back to calendar

Event Date: 13-06-2020 - Session time: 11:30:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Eugene Stepanov

Title: Running SQL Server workload on AWS

Abstract:

Amazon Relational Database Service (RDS) supports six different engines and MS SQL Server is one of them. Bring your SQL Server workload to RDS and have AWS manage your hardware, OS, database engine, backups, High-Availability and scalability amongst other things. So, you can focus on application tuning and development.

VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval

SessionID: 105455

The Future of Containers Is Here!

Back to calendar

Event Date: 13-06-2020 - Session time: 11:30:00 - Track: Database Administration, Deployment, and Development

Speaker: Marsha Pierce

Title: The Future of Containers Is Here!

Abstract:

Spinning up a container is very simple but managing container infrastructure especially when it is on premises is quite complex. Learn about what it takes to mange an on premises deployment, Learn how Azure Arc can simplify your on premises container deployment, Leveraging containers with Arc can then allow you to quickly move back and forth between on Premises and Azure.

SessionID: 102576

Building your own million dollar SQL Practice

Back to calendar

Event Date: 13-06-2020 - Session time: 13:00:00 - Track: Other

Speaker: Adrian Sullivan

Title: Building your own million dollar SQL Practice

Abstract:

Would you like to get to $1m annual revenue in 5 easy steps?

Or, do you simply want to go from barely sustainable to profitable?

In this session I will touch on the 5 steps I considered when building and growing out a SQL Data Platform practice.

Choose a specialty.

How to decide what to do, and how to make it shine.

Pick your partners.

Why partnering is essential.
Augmenting your capabilities.

Defining services.

What are the differences between Managed Service and Professional Service.
How many services to offer.
How to pick a service and price point.
How long before you actually make money.

Market your offerings.

Yes, you have to sell, yourself.
When to give things away for free
The value of existing customers

Build your team.

You're making it, now you need to manage it
Bringing on the right people.

I'll also touch on how long it took me to achieve each of these, and how I measure success.

SessionID: 102813

Data Lake Design Patterns

Back to calendar

Event Date: 13-06-2020 - Session time: 13:00:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Jason Horner

Title: Data Lake Design Patterns

Abstract:

Data lakes have been around for several years and there is still much hype and hyperbole surrounding their use. This session covers the basic design patterns and architectural principles to make sure you are using the data lake and underlying technologies effectively. We will cover things like best practices for data ingestion and recommendations on file formats as well as designing effective zones and folder hierarchies to prevent the dreaded data swamp. We’ll also discuss how to consume and process data from a data lake. And we will cover the often overlooked areas of governance and security best practices. This session goes beyond corny puns and broken metaphors and provides real-world guidance from dozens of successful implementations in Azure.

SessionID: 103838

Loading SQL Server Data with Powershell

Back to calendar

Event Date: 13-06-2020 - Session time: 13:00:00 - Track: Database Administration, Deployment, and Development

Speaker: Sean McCown

Title: Loading SQL Server Data with Powershell

Abstract:

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

Prerequisites: Basic understanding of Powershell syntax.

SessionID: 105225

DevOps for Azure SQL

Back to calendar

Event Date: 13-06-2020 - Session time: 13:00:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Arvind Shyamsundar

Title: DevOps for Azure SQL

Abstract:

"But... it worked on my computer!" A good DevOps practice and implementation will help eliminate that unwelcome phrase! Come to this session to learn how to use tools and platforms like Visual Studio Code, Git, Azure DevOps, GitHub Actions for a modern, secure and easy-to-use database DevOps experience for Azure SQL. We will use demos to show and evaluate two approaches: first, a code-centric migration-based approach (using DbUp and GitHub Actions), and second, a more complex project/state-based approach (using Visual Studio SQL Projects and Azure DevOps and a locked-down Azure SQL DB) to understand some of the many possibilities for implementing DevOps for Azure SQL.

SessionID: 105376

Get Your Optimizer to Give up All Its Secrets

Back to calendar

Event Date: 13-06-2020 - Session time: 13:00:00 - Track: Database Administration, Deployment, and Development

Speaker: Brian Hansen

Title: Get Your Optimizer to Give up All Its Secrets

Abstract:

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details of the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We'll do just that, and then take it a step further with a free unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.

VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval

SessionID: 102242

SQL Server 2019 is not your dad's DBMS

Back to calendar

Event Date: 13-06-2020 - Session time: 14:15:00 - Track: Database Administration, Deployment, and Development

Speaker: Armando Lacerda

Title: SQL Server 2019 is not your dad's DBMS

Abstract:

SQL Server 2019 is more than the database engine, it is a data solution platform. This release introduces multiple new features that will give you new ways to implement better and faster multi platform data solutions. Armando will demo many of these features on processing high data volume from multiple data sources and data formats without leaving SSMS.

SessionID: 102612

Basic Work-Flow with SQL Server Standard SSRS

Back to calendar

Event Date: 13-06-2020 - Session time: 14:15:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Brodie Brickey

Title: Basic Work-Flow with SQL Server Standard SSRS

Abstract:

Many companies have small tasks that need to be accomplished regularly. Sometimes these tasks require a number of steps to be successful. Need a basic workflow app but aren't a .Net developer? We have a solution for you.

This session will be demo intensive, focusing on how to use SSIS, SSRS, and SQL Server standard edition to stitch together a process that emulates a proper workflow.

SessionID: 102835

Faster Transactions: Query Tuning for Data Manipulation

Back to calendar

Event Date: 13-06-2020 - Session time: 14:15:00 - Track: Database Administration, Deployment, and Development

Speaker: Jeff Iannucci

Title: Faster Transactions: Query Tuning for Data Manipulation

Abstract:

Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session, we examine common pitfalls for any SQL professional who manipulates large sets of data with INSERT, UPDATE, and DELETE statements. We discuss potential issues involving data pages, locks, and the transaction log, as well as techniques you can use to improve performance.

SessionID: 104188

Introduction to MongoDB

Back to calendar

Event Date: 13-06-2020 - Session time: 14:15:00 - Track: Private and Public Cloud Architecture and Infrastructure

Speaker: Nuri Halperin

Title: Introduction to MongoDB

Abstract:

Getting started with MongoDB is not always easy. This gentle introduction goes heavy on the demo to show you what it feels like to use MongoDB as a developer. Rather than relying on extra frameworks and such, we'll access MongoDB directly from the shell and Node, and see how you achieve both simple and complex data manipulation tasks.

Along the way, we'll cuts through some myths and misunderstandings surrounding MongoDB. You will learn what's unique about this database, how best to leverage its capabilities, and be well positioned to decide if this is a good fit for application.

SessionID: 104231

Document Design for Document Oriented Databases

Back to calendar

Event Date: 13-06-2020 - Session time: 14:15:00 - Track: Database Administration, Deployment, and Development

Speaker: Nuri Halperin

Title: Document Design for Document Oriented Databases

Abstract:

When designing your documents for databases such as MongoDB, CosmosDB, or DocumentDB you should not be following old normalization rules. What rules it should your follow? This session will give you a good foundation for figuring this out. I'll be surveying some common use cases and how to model them. We'll discuss some rules of thumb, and discover both how and why certain designs work better than others. Relationships, entities, indexes, memory, working sets - all the familiar concepts in an all new light.

VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval

SessionID: 105027

New SQL Server Features for Developers and Analysts

Back to calendar

Event Date: 13-06-2020 - Session time: 14:15:00 - Track: Database Administration, Deployment, and Development

Speaker: Hasan Savran

Title: New SQL Server Features for Developers and Analysts

Abstract:

Latest SQL Server versions added many new features and services to the database engine. I will cover the latest features of SQL Server 2017 and 2019 for developers in this session. Don't miss it!

Here is the list of features I will cover in this session.

Using Graph Tables in SQL Server Temporal Tables for Auditing How to run R Script, Python and Java in SQL Server Using Clustered Columnstore Indexes Using Memory Optimized Tables jSON in SQL Server

SessionID: 102257

Implementing AI solutions using Azure Machine Learning Services

Back to calendar

Event Date: 13-06-2020 - Session time: 15:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Vitor Fava

Title: Implementing AI solutions using Azure Machine Learning Services

Abstract:

Artificial Intelligence (AI) is bringing big changes in the way people and businesses relate to technology.

As well as the arrival of the personal computer, the cloud computing, and smartphones, the AI is the artificial technology that takes you to where you're going so much faster, intuitive and smart. In this session, we will discuss the basics of IA and how we can apply it in our business using the Azure Machine Learning Services

SessionID: 102364

SQL SERVER 2019: top features that every DBA should know

Back to calendar

Event Date: 13-06-2020 - Session time: 15:30:00 - Track: Database Administration, Deployment, and Development

Speaker: Marcelo Adade

Title: SQL SERVER 2019: top features that every DBA should know

Abstract:

SQL SERVER 2019 is a game changer with the Big Data Clusters and all of its improvements! But what about the good old DBA features? There's lots of them! And in this presentation, we'll show some of them like: Memory Optimized Tempdb metadata, Transparent Database Encryption enhancements, Accelerated Database Recovery, Data virtualization and of course: SQL SERVER on your platform of choice!

SessionID: 103411

Agile data preparation with ADF Wrangling data flow

Back to calendar

Event Date: 13-06-2020 - Session time: 15:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Sergiy Lunyakin

Title: Agile data preparation with ADF Wrangling data flow

Abstract:

Data Wrangling is becoming more and more popular in BigData and Enterprise world. Data Lake stores tons of different data and it is not easy to get value from it. To prepare data we need to write and test code that could take a while. But, business requires to have results immediately and reduce time to market. In this session, I invite you together look at Self-Service Data Prep and show how to use Power Query Online in Azure Data Factory Wrangling data flows for code-free data transformations via spark execution.

VMware Room - https://tinyurl.com/2020sqlsatla-vmware Feedback - https://tinyurl.com/2020sqlsatla-eval

SessionID: 105228

Case Study: How I used SharePoint, Power Automate, Power Apps, and Forms to build a Speaker Database

Back to calendar

Event Date: 13-06-2020 - Session time: 15:30:00 - Track: Data Presentation, Visualization, and Analytics

Speaker: Sarah Patrick

Title: Case Study: How I used SharePoint, Power Automate, Power Apps, and Forms to build a Speaker Database

Abstract:

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Power Automate, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.

SessionID: 105337

Azure SQL Hyperscale Deep Dive

Back to calendar

Event Date: 13-06-2020 - Session time: 15:30:00 - Track: Database Administration, Deployment, and Development

Speaker: Denzil Ribeiro

Title: Azure SQL Hyperscale Deep Dive

Abstract:

The Azure SQL Database Hyperscale tier is SQL architected for the cloud and allows applications that encountered limits of prior tiers to be unshackled. Will deep dive into the architecture of Hyperscale and discuss the components of hyperscale and iteraction between each component and the internals of each component. We will cover scaling aspects and the new application patterns it enables. Last but not the least best practices during migration as well as new diagnostics introduced in Hyperscale that help in performance troubleshooting and bottleneck identification.

This site is open source. Improve this page.