Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
---|---|---|---|---|
03-04-2019 18:00 | Devin Knight | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Power BI Streaming Datasets with Microsoft Flow |
03-04-2019 19:00 | Pam Lahoud, Pedro Lopes | 24 Hours of PASS (60 minutes) | Database Administration and Development | Modernizing SQL Server the Right Way |
03-04-2019 20:00 | Taiob Ali | 24 Hours of PASS (60 minutes) | Database Administration and Development | Performance Optimization with Azure SQL Database |
03-04-2019 21:00 | Alessandro Goncalves, Eman Yarlagadda | 24 Hours of PASS (60 minutes) | Database Administration and Development | Deep Dive into Optane Storage and Memory Technology |
03-04-2019 22:00 | Erin Ostrowsky | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Intro to Data Storytelling with Power BI |
03-04-2019 23:00 | Rick Heiges | 24 Hours of PASS (60 minutes) | Database Administration and Development | Constant Change and Community |
04-04-2019 00:00 | Paresh Motiwala | 24 Hours of PASS (60 minutes) | Professional Development | How to Get and Nail Your Interviews |
04-04-2019 01:00 | Allen White | 24 Hours of PASS (60 minutes) | Professional Development | Prepare for Change, Because It's Coming |
04-04-2019 02:00 | Melody Zacharias | 24 Hours of PASS (60 minutes) | Advanced Analytics | Not Your Grand Mother's AI |
04-04-2019 03:00 | Rob Farley | 24 Hours of PASS (60 minutes) | Database Administration and Development | Indexes - Are Things That Different to Twenty Years Ago? |
04-04-2019 04:00 | Hasham Niaz | 24 Hours of PASS (60 minutes) | Advanced Analytics | Dashboard Designing – From 0 to Hero |
04-04-2019 05:00 | Anupama Natarajan | 24 Hours of PASS (60 minutes) | Advanced Analytics | Introduction to Cognitive Search |
04-04-2019 06:00 | Reza Rad | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Power BI for Enterprises; Robust, Reliable, and Scalable Solution |
04-04-2019 07:00 | Jose Manuel Jurado Diaz | 24 Hours of PASS (60 minutes) | Application Development | Azure SQL Database - Lessons learned from the trenches |
04-04-2019 08:00 | Markus Ehrenmueller-Jensen | 24 Hours of PASS (60 minutes) | Advanced Analytics | From Power BI to Power AI – Enrich your Business Intelligence |
04-04-2019 09:00 | Sriharsh Adari | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Modernize Data Platform - A Detailed Case Study |
04-04-2019 10:00 | Carlos Robles | 24 Hours of PASS (60 minutes) | Database Administration and Development | Exploring SQL Server containers on Docker & Kubernetes |
04-04-2019 11:00 | Raj Pochiraju, Pedro Lopes | 24 Hours of PASS (60 minutes) | Cloud Solutions | Transforming your Data Estate - Beating the End of Support for SQL Server 2008/R2 |
04-04-2019 12:00 | Andy Leonard | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Faster SSIS |
04-04-2019 13:00 | Cathrine Wilhelmsen | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Pipelines and Packages: Introduction to Azure Data Factory |
04-04-2019 14:00 | Allan Hirt | 24 Hours of PASS (60 minutes) | Database Administration and Development | A Look Into the Past and the Future of Availability and Infrastructure for SQL Server Deployments |
04-04-2019 15:00 | Lord Richard Douglas, Kevin Kline | 24 Hours of PASS (60 minutes) | Database Administration and Development | Baselining and Alerting for Microsoft SQL Server |
04-04-2019 16:00 | Gail Shaw | 24 Hours of PASS (60 minutes) | Database Administration and Development | The Real Self-Tuning Database |
04-04-2019 17:00 | Paresh Motiwala | 24 Hours of PASS (60 minutes) | Cloud Solutions | My Company is Going to Azure, What Can I do? |
Event Date: 03-04-2019 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 03-04-2019 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
We will also discuss the merits and caveats of following a database compatibility-based upgrade along with the tools Microsoft is building to ensure customers have a smoother upgrade and migration experience.
After this session, you will be able to: • Position Database Compatibility as a real alternative to support complex modernization projects as critical moments like 2008 End-of-Life. • Leverage Microsoft SQL Server features and tools to support a DB Compat based upgrade or migration.
Event Date: 03-04-2019 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
In this session I will show you 4 of those tools. You will learn how these tools can provide Performance overview of a database and recommendations that can improve workload performance. Find top resource consuming queries, deeper insight into your databases resource (DTU) consumption and learn when to let Azure automatically optimize your database. At the end of this session you will walk out knowing how to identify and tune Azure SQL database performance issues with built in tools in Azure Portal.
Event Date: 03-04-2019 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 03-04-2019 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 03-04-2019 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 04-04-2019 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development
In this session I'll share personal and some real-life stories. You’ll learn techniques for finding new opportunities in a competitive job market. I’ll also share how to exploit the social media to your advantage (they are not bad if used judiciously).
What can you do once you get that rare and elusive interview? There are several things we need to take care of like, overall appearance, food habits, arrival, sitting posture, small talk or ice-breakers and humor. The most important parts of the limited interviewing opportunities are closing and follow up. I’ll share my own experience and notes from the field. You will also learn the importance of interview logs.
Never stop looking!
Event Date: 04-04-2019 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development
Event Date: 04-04-2019 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics
Event Date: 04-04-2019 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 04-04-2019 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics
Event Date: 04-04-2019 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics
Event Date: 04-04-2019 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 04-04-2019 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application Development
Event Date: 04-04-2019 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics
No matter if you are a business user, analyst or data scientist – Power BI has AI capabilities tailored to you. In this session we will cover how you can integrate and leverage the use of language R, how to integrate an Azure Machine Learning Service when loading data, what kind of insights Power BI is capable of delivering automatically, how you can create a complex new column without typing a single formula/function, how you can explore your data by asking questions in plain English, ... and more!
Sounds like a lot of content? I omitted most of the slides in favor to spend the time in live demos instead.
Event Date: 04-04-2019 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 04-04-2019 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 04-04-2019 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Solutions
Event Date: 04-04-2019 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.
Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Event Date: 04-04-2019 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
But wait! You have already invested years and millions in a comprehensive SSIS solution? No problem! You can lift and shift existing packages into Azure Data Factory to modernize your solution while retaining investments already made.
In this session, we will go through the fundamentals of Azure Data Factory and see how easy it is to build new data pipelines or migrate existing SSIS packages. Then, we will explore some major improvements in Azure Data Factory v2, including the new Mapping Data Flows. Finally, we will look at best practices for development to speed up productivity and keeping costs down.
Event Date: 04-04-2019 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 04-04-2019 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
This session describes techniques and procedures to monitor important performance metrics you can use to define as a baseline for “normal” performance. From there, we will show you how to use these baseline metrics to identify and alert on abnormal circumstances. In addition to the main objectives, this session will help you:
• Learn about the major metrics that quantitatively define the performance baseline for an instance of SQL Server • Learn how to collect baselines and, on a live SQL Server, compare and alert when performance metrics are outside of normal • How to best utilize your newly freed time once you start to utilize baselines as a regular part of your workday
Baselining is a skill that separates junior DBAs from senior DBAs. Take the leap to learn this important skill today!
Event Date: 04-04-2019 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
In this presentation, we’re going to look at the self-tuning aspects of SQL Server 2019, specifically the adaptive query processing features and Query Store’s automatic plan regression fixes.
Event Date: 04-04-2019 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Solutions
You possibly know of the "Plane Effect". It means that your CIO or CTO possibly picked up the phrase "Cloud" in a tech magazine on one of his/her expensive trips to wherever. Now the whole company is running around it.
In this session we'll cover what points should you consider before going to Azure. Here's a short list:
Should you even really care or just look for another job?
We will learn how simple to use is the Azure portal. We will make a couple of VMs, Databases along the way.