Data.SQL.Saturday.LA

Add JSON to the list of tools in your SQL Server tool-belt by Elaena Bakman (@elaena_bakman) 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.

Add JSON to the list of tools in your SQL Server tool-belt by Elaena Bakman (@elaena_bakman) 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.

Introduction to MongoDB by Nuri Halperin (@nurih) 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.

The Future of Containers Is Here! by Marsha Pierce (@MarshaPierceDBA) 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. Prerequisites: Basic understanding of Architectural principles for Databases and containers.

The Future of Containers Is Here! by Marsha Pierce (@MarshaPierceDBA) 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. Prerequisites: Basic understanding of Architectural principles for Databases and containers.

Faster Transactions: Query Tuning for Data Manipulation by Jeff Iannucci (@DesertDBA) 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.

Case Study: How I used SharePoint, Power Automate, Power Apps, and Forms to build a Speaker Database by Sarah Patrick (@sarahepatrick) 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.

3 Ways for Getting Data from SharePoint : SSIS, Excel and Access by David Patrick (@DavidEPatrick) 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. Prerequisites: Experience and basic understanding of SharePoint. Basic understanding of SSIS, Access, and Excel.

SQL Server 2019: Top Features That Every DBA Should Know by Marcelo Adade (@marceloadade) 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!

SQL Server 2019: Top Features That Every DBA Should Know by Marcelo Adade (@marceloadade) 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!

New SQL Server Features for Developers and Analysts by Hasan Savran (@SavranWeb) 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

New SQL Server Features for Developers and Analysts by Hasan Savran (@SavranWeb) 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

How Intelligent Query Processing improves T-SQL performance by Andy Yun (@sqlbek) 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.

How Intelligent Query Processing improves T-SQL performance by Andy Yun (@sqlbek) 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.

Agile data preparation with ADF: Wrangling data flow by Sergiy Lunyakin (@slunyakin) 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.

Agile data preparation with ADF: Wrangling data flow by Sergiy Lunyakin (@slunyakin) 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.

Get Your Optimizer to Give up All Its Secrets by Brian Hansen (@tf3604) 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.

Get Your Optimizer to Give up All Its Secrets by Brian Hansen (@tf3604) 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.

Google BigQuery ML: Machine Learning with SQL by Mark Mucchetti 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.

Google BigQuery ML: Machine Learning with SQL by Mark Mucchetti 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.

Azure SQL: What to use When by Anna Hoffman (@AnalyticsAnna) 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)

Azure SQL: What to use When by Anna Hoffman (@AnalyticsAnna) 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)

#TikTok and #DaftPunk inspired

#TikTok and #DaftPunk inspired