Nr: 943
SQLSaturday #943 - St. Louis 2020
SessionID: 100385
Modern SQL Server CPU Architecture
Event Date: 08-02-2020 - Session time: 08:00:00 - Track: SQL Server
Speaker: David Klee
Title: Modern SQL Server CPU Architecture
Abstract:
SessionID: 100479
Python in SQL Server 2017 and 2019
Event Date: 08-02-2020 - Session time: 08:00:00 - Track: Business Intelligence
Speaker: Chris Hyde
Title: Python in SQL Server 2017 and 2019
Abstract:
SQL Server 2017 and 2019 have arrived, bringing with them a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
SessionID: 100527
SQL DevOps Simplified with Production Databases
Event Date: 08-02-2020 - Session time: 08:00:00 - Track: SQL Server
Speaker: Paul Stanton
Title: SQL DevOps Simplified with Production Databases
Abstract:
DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. "Near production data" is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.
SessionID: 100887
Microsoft's Modern Data Warehouse Architecture
Event Date: 08-02-2020 - Session time: 08:00:00 - Track: Data Warehousing
Speaker: Pierre LaFromboise
Title: Microsoft's Modern Data Warehouse Architecture
Abstract:
SessionID: 101099
ROI with Power BI: Do more than Excel
Event Date: 08-02-2020 - Session time: 08:00:00 - Track: Business Intelligence
Speaker: Erika Haase Nalley
Title: ROI with Power BI: Do more than Excel
Abstract:
Nifty tips and tricks to start taking your business from Point A to Point B2B using Power BI. We will use real world use case examples of combining supplier, syndicated, or retail data in Power BI in a way that can help you move the needle.
We will cover:
• Sales Dax/M: Options for measures and columns
• Real life examples of converting data to continual, common sense Business Intelligence
• Actionable items: Dashboards, Alerts, and KPIs
No matter what business you are in, we will cover the basics and benefits of advancing your company from emailing excel trackers to cloud collaboration.
SessionID: 101919
Introduction to Power BI
Event Date: 08-02-2020 - Session time: 08:00:00 - Track: Business Intelligence
Speaker: Mike Diehl
Title: Introduction to Power BI
Abstract:
This sessions will provide an introduction to Power BI Desktop and the Power BI Service.
With Power BI Desktop, we will import data from several sources, then perform some cleanup and transformation of the data. We will build a model from the data and then some visualizations of it. Then we will publish the model to the Power BI Service and build a dashboard from it, then look at how it can be used in collaboration scenarios and distribution in your organization.
SessionID: 99914
Moving Data to the Cloud (with Azure Data Factory)
Event Date: 08-02-2020 - Session time: 08:00:00 - Track: Enterprise Delivery
Speaker: Simon Kingaby
Title: Moving Data to the Cloud (with Azure Data Factory)
Abstract:
SessionID: 100556
PowerShell for the DBA
Event Date: 08-02-2020 - Session time: 09:10:00 - Track: SQL Server
Speaker: Amy Herold
Title: PowerShell for the DBA
Abstract:
In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
SessionID: 100608
Getting Started with Extended Events
Event Date: 08-02-2020 - Session time: 09:10:00 - Track: SQL Server
Speaker: Andy Galbraith
Title: Getting Started with Extended Events
Abstract:
Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events. Many DBAs continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?
Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then, it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.
Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
SessionID: 100844
Why You Need a Modern Data Warehouse
Event Date: 08-02-2020 - Session time: 09:10:00 - Track: Data Warehousing
Speaker: Gary Bell
Title: Why You Need a Modern Data Warehouse
Abstract:
What exactly is a modern data warehouse? How is it different from the data warehouse we already have? This session will attempt to deconstruct the marketing buzzword into its’ technical components, discuss common architectural patterns, migrations paths, and highlight the key advantages of a dynamic, scalable, cloud-based approach to analytics.
SessionID: 100875
Event Date: 08-02-2020 - Session time: 09:10:00 - Track: Enterprise Delivery
Speaker: Dan Guzman
Abstract:
Database development often lags behind modern Agile application development Continuous Integration and Delivery practices because it's harder. Unlike application changes, delivering database changes requires not only apply schema changes but preserving data as well.
This session will discuss guiding principles, strategies, and explore practices and tooling to support database development in the world of CI/CD. Common Agile development scenarios will be covered.
SessionID: 101100
Calculate: With great power there must also come...great responsibility
Event Date: 08-02-2020 - Session time: 09:10:00 - Track: Business Intelligence
Speaker: Erika Haase Nalley
Title: Calculate: With great power there must also come...great responsibility
Abstract:
We will cover:
• Calculate and advanced Switch True
• Variables
• Tools- the where, how to connect, and basics to look for
• Modeling Considerations and DAX for relationships
As data and models become more advanced, there are performance pitfalls that are easy to fall into when weighing the ever important 'Can I' vs 'Should I'. I am happy to share the learning resources I used to overcome these and how I fixed the many mistakes that I made along the way.
SessionID: 100384
Level Up Your Cloud Skills
Event Date: 08-02-2020 - Session time: 10:20:00 - Track: SQL Server
Speaker: David Klee
Title: Level Up Your Cloud Skills
Abstract:
Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure architecture skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? Should you use a database-as-a-service or provision a cloud-based VM? How many compute resources does your database consume during a given day? Can you secure it properly? Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!
SessionID: 100610
Intro to Powershell for the SQL Server DBA
Event Date: 08-02-2020 - Session time: 10:20:00 - Track: SQL Server
Speaker: Andy Galbraith
Title: Intro to Powershell for the SQL Server DBA
Abstract:
Many DBA's have the same outlook on Powershell - we all know we should use it, but we don't think we have time to learn one more tool that isn't even really part of SQL Server anyway. I was one of these DBA's for many years, but recently I have come to respect the power of Powershell. Come learn the basics of Powershell, how Powershell and SQL Server interact with each other, and finally how to use Powershell to automate common SQL Server tasks such as maintenance and SQL Server installations. If you need to interact with Windows or Active Directory, odds are Powershell is the right tool for the job - come learn how to use it!
SessionID: 100686
SQL Server Management Studio - Beyond the basics
Event Date: 08-02-2020 - Session time: 10:20:00 - Track: SQL Server
Speaker: Adrian Mee
Title: SQL Server Management Studio - Beyond the basics
Abstract:
Almost all of us use SQL Server Management Studio to interact with SQL Server, and thankfully it works right out of the box. But did you know there are so many tricks and shortcuts that hide just under the surface that can make working with SSMS feel like second nature?
In this session, I will take a fresh install of SSMS and step through customizing it. I will demonstrate features and help you become more efficient at utilizing SSMS to it's fullest potential - a lot of the time without using the mouse. Finally, I’ll show you some cool text editing tricks that will take your SQL skills to a whole new level.
SessionID: 100806
An Introduction to Azure Data Lake Gen2...
Event Date: 08-02-2020 - Session time: 10:20:00 - Track: Data Warehousing
Speaker: Pierre LaFromboise
Title: An Introduction to Azure Data Lake Gen2...
Abstract:
Microsoft's modern data warehouse strategy is centered around their latest generation of Azure Data Lake - it is the hub for Azure Synapse Analytics and more. This session will dive into Azure Data Lake generation 2 (ADLSg2) and provide an introduction to the technology. We will discuss a number of topics including: what is new with gen 2, how is ADLSg2 different than standard Azure Storage, how is security applied and managed, what APIs and SDKs are available, how does it fit into the larger picture, and what is the current state and where is it going. The session will also provide tips and tricks to help you get started and be more successful.
SessionID: 100890
Power BI Administration: Enabling true Self-Service BI for your organization
Event Date: 08-02-2020 - Session time: 10:20:00 - Track: Business Intelligence
Speaker: Jason Roy
Title: Power BI Administration: Enabling true Self-Service BI for your organization
Abstract:
What does your Power BI Tenant look like? Do you have a process in place for Administration? Are your BI Developers truly focusing on your organization's larger issues? This session will detail these questions and more.
Just like Power BI Development; Power BI Administration is rapidly evolving. It will detail poor practices in Power BI and how to fix them. These solutions can range anywhere from development, publishing datasets, to even teaching your end-users the basics. This session will show you the fundamentals to truly enable Self-Service BI for your end-users and allow your BI team to focus on the larger issues.
SessionID: 99915
Why Learn Python? A Microsoft DB/ETL/BI Developer's Answer
Event Date: 08-02-2020 - Session time: 10:20:00 - Track: Business Intelligence
Speaker: Simon Kingaby
Title: Why Learn Python? A Microsoft DB/ETL/BI Developer's Answer
Abstract:
SessionID: 100539
Data-Driven Diversity
Event Date: 08-02-2020 - Session time: 11:30:00 - Track: Business Intelligence
Speaker: LaShana Lewis
Title: Data-Driven Diversity
Abstract:
Data is all around us. From calculating projections to influencing meaningful decision-making, the impact data has on the way we live and work is increasing rapidly. But, what does this mean for data processes and the business world as a whole, when not everyone has a seat at the table? During this presentation, LaShana Lewis will outline the importance of diversity in business and how you can consider data through the lens of diversity and inclusion, using your skills as a data professional to raise awareness and make lasting change.
SessionID: 100521
Data Warehouse Cloud Service with Cloudera Data Warehouse
Event Date: 08-02-2020 - Session time: 12:40:00 - Track: Data Warehousing
Speaker: Scott Shaw
Title: Data Warehouse Cloud Service with Cloudera Data Warehouse
Abstract:
Leverage the power of Kubernetes, Docker, and Open Source all within your own Azure environment. With Cloudera Data Warehouse, data warehousing is made easy. You no longer need to worry about noisy neighbors and unreliable SLA's. Save cloud costs with auto-scaling both up and down all while owning your data in a secure and governed environment.
SessionID: 101071
Capturing SQL Server activity with SQL Server Audit
Event Date: 08-02-2020 - Session time: 12:40:00 - Track: SQL Server
Speaker: Ed Leighton-Dick
Title: Capturing SQL Server activity with SQL Server Audit
Abstract:
In this session, we’ll take a detailed look at the capabilities of SQL Server Audit, how to configure it, and how to use the data it produces. We’ll also look into the areas where SQL Server Audit falls short and how to supplement it with other SQL Server tools to provide a complete auditing solution.
This session is part of the Data Security Learning Pathway. For more information please visit our Learning Pathways page.
SessionID: 101684
Your User Feedback - in 2 Hours or Less - Part 1: Making Entry Mobile
Event Date: 08-02-2020 - Session time: 12:40:00 - Track: Business Intelligence
Speaker: Gary Polinsky
Title: Your User Feedback - in 2 Hours or Less - Part 1: Making Entry Mobile
Abstract:
Our users are constantly generating valuable data that we, as the business, could leverage. Unfortunately, capturing and analyzing this data has been a costly endeavor both from a development standpoint as well as being labor intensive from an entry point of view. That is until now.
Microsoft Power Platform now gives us the tools required to quickly development, store, and review our user’s data in 2 hours or less.
In part one of this two part session, we will review a proof of concept involving the development of a PowerApps for data entry.
SessionID: 101915
Azure Data Explorer: Bringing Visibility to the Data Lake
Event Date: 08-02-2020 - Session time: 12:40:00 - Track: Enterprise Delivery
Speaker: Mike Diehl
Title: Azure Data Explorer: Bringing Visibility to the Data Lake
Abstract:
Is your data lake a bit more like a swamp? Are your business analysts nearly drowning when you throw them into the deep end of the lake?
In this session, you'll see how to use Azure Data Explorer to create a more structured interface on the files in your data lake, so that your business analysts can consume it much more easily from tools like Power BI.
Azure Data Explorer (ADX) is a service that adds a query engine to various types of data, including raw files in a data lake. We'll look at the two ways you can add some structure and visibility to your data lake files using ADX, to eliminate the need for your data consumers to know the location and type of files in the data lake, and to add context such as entity names and data types. With a very small amount of simple code, you can add this structure to your data lake files and let the business analysts focus on the data.
This session uses Azure Data Explorer and Azure Data Lake Storage (ADLS gen2) as well as a bit of Power BI.
SessionID: 99919
Data Hub Automation with Databricks Delta
Event Date: 08-02-2020 - Session time: 12:40:00 - Track: Data Warehousing
Speaker: Sean Forgatch
Title: Data Hub Automation with Databricks Delta
Abstract:
Databricks Delta is the new standard for building a data lake as a part to your data warehouse. In this sessions we will learn how we can automate the development and ETL of a Data Hub\PSE in Databricks Delta that can process 1000's of tables with minimal code.
Agenda:
- Data Lake Design and the Modern Data Warehouse
- Databricks Delta
- Automating Databricks Delta
SessionID: 99964
Real-World PowerShell for SQL Administration
Event Date: 08-02-2020 - Session time: 12:40:00 - Track: SQL Server
Speaker: Brian Hansen
Title: Real-World PowerShell for SQL Administration
Abstract:
If you're like me, you've attended PowerShell sessions before. However, much of the practical usage of PS comes with rolling back your sleeves and digging into the nuances of syntax and how to get things done. We are going to focus specifically on using PowerShell within the SQL Server Agent to build out everyday jobs.
In this session, I'm assuming that you know the basics of PowerShell. What we're going to cover are some of the "gotchas" and nuances that I've run into when I've been working with the language, and particularly with the SQL Agent's flavor of PowerShell.
And then we'll spend the balance of our time looking at real-world, practical scripts that I use pretty much every day. PowerShell is an awesome way to automate so many processes and relieve some of the everyday monotony of SQL administration.
SessionID: 100232
Navigating Row Level Security
Event Date: 08-02-2020 - Session time: 13:50:00 - Track: SQL Server
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: 101051
A Beginners Guide to Transactions
Event Date: 08-02-2020 - Session time: 13:50:00 - Track: SQL Server
Speaker: John Deardurff
Title: A Beginners Guide to Transactions
Abstract:
This session is for the absolute beginner to learn the basics of Transactions and will answer questions such as, What is a Transaction? What are the ACID properties of a Transaction? How does the Transaction Log work to provide consistency to a database? What is a checkpoint? Are dirty pages bad or good? What is a lock? The session is led by an expert Microsoft Certified Trainer (MCT) and former Microsoft MVP who regularly teaches SQL Server certification courses.
SessionID: 101074
Principle of Least Privilege: The Key to Strong Security
Event Date: 08-02-2020 - Session time: 13:50:00 - Track: SQL Server
Speaker: Ed Leighton-Dick
Title: Principle of Least Privilege: The Key to Strong Security
Abstract:
A truly strong security model starts with no permissions and adds what is necessary to allow the user or application to do their assigned task - no more, no less. This is called the Principle of Least Privilege. It's a simple concept, but it can be quite difficult to implement in practice, especially if the prevailing practice has been much more permissive.
In this session, we'll talk about the Principle of Least Privilege in more detail, and we'll discuss ways to implement it for the three primary classes of users - general users, applications, and administrators. Each has their own set of needs that requires a separate approach to allowing the security to meet those needs. You'll leave with actionable ideas on ways that you can improve your company's security while minimizing the impact of the changes.
SessionID: 101685
Your User Feedback - in 2 Hours or Less - Part 2: Hunter Gatherer
Event Date: 08-02-2020 - Session time: 13:50:00 - Track: Business Intelligence
Speaker: Gary Polinsky
Title: Your User Feedback - in 2 Hours or Less - Part 2: Hunter Gatherer
Abstract:
Our users are constantly generating valuable data that we, as the business, could leverage. Unfortunately, capturing and analyzing this data has been a costly endeavor both from a development standpoint as well as being labor intensive from an entry point of view. That is until now.
Microsoft Power Platform now gives us the tools required to quickly development, store, and review our user’s data in 2 hours or less.
In part two of this session, we will develop the transmission of data via Flow, and develop reporting on the data leveraging Power BI.
SessionID: 99816
Learn How to Master DATETIME Functions Like a Boss in 59.5 Minutes or Less
Event Date: 08-02-2020 - Session time: 13:50:00 - Track: SQL Server
Speaker: Peter Doyle
Title: Learn How to Master DATETIME Functions Like a Boss in 59.5 Minutes or Less
Abstract:
- Do you know the dates of the 1st Monday, 2nd Tuesday, 3rd Wednesday, and 4th Thursday of any month between the 22 weeks and 47 weeks of any given year?
- Do you know the date that Daylight Savings starts in Nashville 4 years from now?
Those two questions may have been a trivial but there is nothing trivial about working within the complexity of dates and times. Trains, Planes, and sometimes at automobile races depend on precise and accurate date-time recordings.
In this demo-heavy presentation, we will answer the following questions and more:
- When to use DATETIME and DATETIME2 and why.
- How do you filter date ranges that will make SQL Server run faster?
- How language and date formatting affect EVERYTHING.
- What's the best way to work with functions relating to the current date and time.
- What's the best way to properly use SWITCHOFFSET, TODATETIMEOFFSET and AT TIME ZONE Functions.
So stop wasting time and get on board because it's about time for the plane to depart.
SessionID: 99947
Common TSQL Mistakes
Event Date: 08-02-2020 - Session time: 13:50:00 - Track: SQL Server
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 100874
Introduction to Database Containers
Event Date: 08-02-2020 - Session time: 15:00:00 - Track: SQL Server
Speaker: Dan Guzman
Title: Introduction to Database Containers
Abstract:
Some say database containers are the future of database virtualization. I largely agree with that, at least for some scenarios.
This session will review fundamental container architecture and concepts, discuss database containers use cases, and demo image and container management with Docker.
SessionID: 100983
What is DevOps and Why Should DBAs Care?
Event Date: 08-02-2020 - Session time: 15:00:00 - Track: Enterprise Delivery
Speaker: Kathi Kellenberger
Title: What is DevOps and Why Should DBAs Care?
Abstract:
SessionID: 101050
Inside the Database Engine
Event Date: 08-02-2020 - Session time: 15:00:00 - Track: SQL Server
Speaker: John Deardurff
Title: Inside the Database Engine
Abstract:
SessionID: 101907
Migrating to Azure Managed Instance
Event Date: 08-02-2020 - Session time: 15:00:00 - Track: SQL Server
Speaker: Jonathan Fite
Title: Migrating to Azure Managed Instance
Abstract:
This presentation will consist of essentially an after-action report of a successful migration from an on-premise environment to Azure. Although this focuses mainly on migrating our primary database to SQL Managed Instances we will be covering some details of classic SQL VM’s as well as SQL Database.
There are several phases that will be discussed, capacity planning, migration strategies and techniques, the big day and living with the cloud. This migration took place in August 2019 and we have been living with it ever since. Overall a positive experience, but I want to share what we learned so that the next person won’t stumble over the same steps that we did.
SessionID: 101918
Using tSQLt unit testing with SSDT Database Projects
Event Date: 08-02-2020 - Session time: 15:00:00 - Track: SQL Server
Speaker: Mike Diehl
Title: Using tSQLt unit testing with SSDT Database Projects
Abstract:
Unit testing is a key part of a DevOps process that helps to improve code quality (and increase your confidence).
Using tSQLt, a unit testing framework for SQL Server databases, you can create "mock" tables that contain test data and have powerful comparison assertions to validate your merge logic for more complex data change scenarios - beyond simple Type I and Type II Slowly Changing Dimensions.
This session will show how to write basic unit tests for a data warehouse/mart project, with a focus on unit tests for stored procedures that merge staging tables to dimensional and fact tables.
In this session we'll also see how to structure your database projects in Visual Studio (SQL Server Data Tools) to separate your test code from your database structures and the unit test framework (in this case, tSQLt).
SessionID: 99770
Become a T-SQL Pivoting Ninja in 59.9 Minutes Or Less
Event Date: 08-02-2020 - Session time: 15:00:00 - Track: SQL Server
Speaker: Peter Doyle
Title: Become a T-SQL Pivoting Ninja in 59.9 Minutes Or Less
Abstract:
Would you like to create Pivot Tables in SQL with ease?
Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.
Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris.
*Not Possible
SessionID: 100249
Code Smells - How to Keep Your Code From Stinking!
Event Date: 08-02-2020 - Session time: 16:10:00 - Track: SQL Server
Speaker: Pamela Mooney
Title: Code Smells - How to Keep Your Code From Stinking!
Abstract:
Maybe you’ve had some experience writing SQL, but no one’s ever told you what not to do. Or maybe you’re aware of some bad habits to avoid when writing SQL, but no one has ever shown you why a bad practice can hurt your query – or SQL Server. Perhaps you feel a little more confident with your TSQL, but don’t understand why your queries aren’t running as quickly as you would like.
Bad SQL coding practices are known in the SQL community as “code smells”. Sign up for this hour-long workshop where you will work with me through five common coding mistakes that can make performance stink. By the time we’re done, you’ll have a better idea of how to freshen up some problem queries.
SessionID: 100542
Introduction to T-SQL Windowing Functions
Event Date: 08-02-2020 - Session time: 16:10:00 - Track: SQL Server
Speaker: Kathi Kellenberger
Title: Introduction to T-SQL Windowing Functions
Abstract:
T-SQL windowing functions can simplify many complex queries. They are the best thing that has happened to the T-SQL language in years, but many database professionals and developers haven’t heard about them.
They were initially introduced with SQL Server 2005. In 2012, Microsoft added several new functions that let you do things like pull values from different rows without a performance penalty.
Attend this session to learn how T-SQL windowing functions apply to many real world examples.
SessionID: 99710
Test Driven Development (TDD) for T-SQL Database Development
Event Date: 08-02-2020 - Session time: 16:10:00 - Track: SQL Server
Speaker: Anthony Mendoza
Title: Test Driven Development (TDD) for T-SQL Database Development
Abstract:
SessionID: 99918
Azure Data Factory: Ingestion Framework
Event Date: 08-02-2020 - Session time: 16:10:00 - Track: Data Warehousing
Speaker: Sean Forgatch
Title: Azure Data Factory: Ingestion Framework
Abstract:
You're going to learn how to design an Ingestion Framework capable of scaling multiple sources without additional pipelines to populate Azure Data Lake. We will walk through Ingestion Strategy, the Ingestion Model, and the Ingestion Pipelines that fully automate data lake ingestion.
Ingestion Strategy - First, we will lay the foundation for best practices when it comes to ingesting data and storing data within Azure Data Lake.
Ingestion Model - Second, we will learn how to design a metadata model framework built using Data Vault techniques to capture and store data from across the business.
Ingestion Pipelines - Finally, we will build two Data Factory pipelines that read from the framework and does that actual data ingestion, these are built so that we only ever have to build these two pipelines when scaling to a new source type.
SessionID: 99946
SQL Server Defaults SUCK!!
Event Date: 08-02-2020 - Session time: 16:10:00 - Track: SQL Server
Speaker: Kevin Boles
Title: SQL Server Defaults SUCK!!
Abstract:
SessionID: 99965
Get Your Optimizer to Give up All Its Secrets
Event Date: 08-02-2020 - Session time: 16:10:00 - Track: SQL Server
Speaker: Brian Hansen
Title: Get Your Optimizer to Give up All Its Secrets
Abstract: