Sessions & Content

Search
Content Type
Conference
Tags
(Almost) all about Azure Arc - in 20 Minutes Ben Weissman (he/him)
Join me on a journey through the different offerings in Azure Arc and how they can benefit you as a data professional!
10 tips for a successful migration from Databricks and ADF to Synapse Dave Ruijter
Are you planning a migrating of your data platform to Azure Synapse Analytics? Is it currently based on Azure Databricks, Azure Data Factory, and Azure Data Lake Storage? Make sure to grab these 10 tips! We'll talk about Spark compatibilities, orchestration pitfalls and solution deployment differences.
Analyzing Azure Monitor Log data in Azure Data Studio Taiob Ali
In this 100% demo session, I will show you kql magic, kql kernel, and the recently released Azure Monitor Logs extension for Azure Data Studio to consume event logs of the Azure SQL database.
Apache NiFi 101: Introduction and Best Practices Timothy Spann
Using open source apache nifi to integrate and ingest data at scale
Applying a Security Mindset to Lockdown Azure SQL Database Surbhi Pokharna
I will show you demos for how to implement each layer of defense. This way, if one layer is breached, you aren’t left defenseless. We will start at the outer layer with network access. Next, we will cover the authentication and authorization using Azure RBAC. Finally, we will protect the innermost layer with Data At Rest and Data In Transit encryption. Once these protections are in place, we’ll see how to monitor Azure SQL security ecosystem for intrusions with Advanced threat protection.
Architectural blueprints for the Modern Data Warehouse Just Blindbæk
This session will walk you through three different ways to set up an affordable Azure based Data Warehouse solution. Covering pros and cons with each of the architectures.
Azure Arc-enabled SQL MI – More than just another kind of SQL Server Ben Weissman (he/him)
Join us, as we explore the capabilities of Azure Arc-enabled SQL Managed Instances.
Big Data Implementation in AWS Cloud through the lens of Security and Privacy Shinduri Srinatha Reddy
This session will introduce you to "What and why you should care about", and discuss "how" to apply the Security and Privacy lens for Big Data on AWS.
Bringing Data Lakes to your Purview Simon Whiteley
A short, fast dive into the specific elements of Azure Purview that work well with Data Lakes, and how you implement them yourselves
Creating a Metadata Driven Orchestration Framework Using Azure Data Integration Pipelines Paul Andrew
We'll explore delivering this framework within an enterprise and consider an architect’s perspective on a wider platform of ingestion/transformation workloads with multiple batches and execution stages.
Dba toolset - Getting things done when the pressure is on martin croft
DBA/Developer Toolset to get you out of that hole and save you some time
Different dimensions of monitoring and tuning performance for Azure SQL Surbhi Pokharna
Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.
Embedding SQL security practices in your pipelines Stuart Moore
Automate checking your database security model
Erin & Monica’s Favorite SQL Stuff Monica Rathbun
Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.
Handle Azure SQL Auditing with Ease Josephine Bush
Auditing options for Azure SQL offerings
Let's Talk Storage! Anthony Nocentino
In this session, you will learn where data lives in a computer system, and the key performance metrics used to understand the health and performance of your storage subsystem.
Limiting permissions in Dynamic SQL with Execute As Russ Loski
Dynamic SQL is great, until it is used to hack your site. In this session we demonstrate how using the T-SQL "Execute AS" command can limit what can be run using dynamic SQL.
Overview of Azure Synapse Analytics Dave Ruijter
Curious what Azure Synapse Analytics brings to the table? Bring your scuba gear, as we take a dive and explore everything it has to offer!
Power BI Governance: 6 steps to success Rishi Sapra
Learn how to deploy Power BI at scale within a large Enterprise. The mantra behind this is “discipline at the core, flexibility at the edge” - we will cover deploying appropriate guardrails/controls whilst still retaining the notion of “self-service” within the organization.
Roche's Maxim of Data Transformation Matthew Roche
As far upstream as possible. As far downstream as necessary. In 20 minutes.
Scaling SQL for your Peak Database Load Ben DeBow
Scaling SQL Servers is complex and is more relevant today as the transactional and data growth rates continue to grow. In this session, we will talk about what it takes to scale SQL Server to meet the peak workload.
SQL Assessment - Microsoft's Best Practices Checker Taiob Ali
Do you want to get the current 232 suggested best practices from the Microsoft SQL Server Team and evaluate your environments? In this all demo session (Yes, no slides), I will show you both the "what" and "how" to do the same using the SQL assessment API and Azure Data Studio 'SQL Assessment' extension.
The Cloud Never Goes Down, Right? Anthony Nocentino
In this session, we'll set you on the right path towards high availability and disaster recovery for common data architectures in the cloud by the end of this session.
The SQL Server Performance Tasting Menu Erik Darling
Delicious Demos For Doubting Developers
There is a time and a place for everything Rob Sewell
There is a time and a place for everything. John and Rob, being consultants, often say "Well, it depends" Lets talk about some of the times when the "rules" may not fit
Troubleshoot and Triage Like a Pro Matt Gordon
Let us walk you through our steps to triage and troubleshoot issues as they come in to make sure things get fixed in the right order at the right time and we all stay sane.
Troubleshoot Real-World Scenarios with Extended Events Tomáš Zíka
Start learning Extended Events today to help you solve your issues in SQL Server.
VertiPaq Analyzer crash course Marco Russo
Introduce VertiPaq Analyzer features in DAX Studio and as a library available in other tools.
What is Azure Purview and Why Do I Need It? Angela Henry
This session will introduce you to Azure Purview, what problems it was designed to solve for, and show you how to create a Purview Account in your Azure tenant.
What SQL Server database can tell us about application issues? Denis Reznik
This session will be about database load patterns that show the application design issues and solutions to those issues.
Why You Need Query Store Erin Stellato
I can spend an entire day talking about Query Store and all it can do, but in 20 minutes I can convince you that it should be a feature you start using today.
Your Performance Tuning Check List Monica Rathbun
Everyone needs a list of what to double check in your environment to ensure your servers and databases are optimized in order to make SQL Server run faster, better and more efficiently. In this session you will learn about what you need to review and implement to get a performance and configuration improvements.
Advanced analytics features in Power BI Chris Webb
In this session you’ll learn about some of these advanced analytical features in Power BI, including: the Analytics pane on visuals; the Key Influencers visual and other AI features.
An administrators guide to SQL Server 2019 BDC Buck Woody
Join this session if you are interested in the administration scenarios of the big data clusters, including tooling for monitoring, how to deploy and secure the environment, and to learn about the latest improvements.
Azure AI, Power new possibilities for every organization Lindsey Allen
AI and data is at the center of the digital feedback loops. We have invested in a comprehensive portfolio of AI tools, infrastructure and services. Come to this session to get an update of Azure AI with demos.
Azure Cost Management Dustin Dorsey
Learn the tools and techniques you can use to create governance and insights around your Azure spend
Azure data services on Azure Arc Umachandar Jayachandran
In this session you’ll learn more about Azure data services on Azure Arc
Azure Machine Learning and the Python SDK Robin Lester
Understand how to create, train and operationalize your data science projects in Azure Machine Learning.
Baking Extended Events recipes without breaking a sweat Gianluca Sartori
In this demo intensive session I will show you how to tackle the most challenging tasks with Extended Events without writing a single line of code.
Baselining Performance with DEA Dustin Dorsey
Learn what the Database Experimentation Advisor is and how you can start using it to baseline performance from a target and source server when new changes are introduced.
Battle tested project planning with Azure Devops boards Kevin Chant
Azure boards within Azure DevOps give you the capability to organise your project and analyse the it’s progress. Do you want your manager to stop bugging you about your project’s progress, come to this session?
Building a secure data solution using Azure Data Lake Carmel Eve
In this session we'll focus on the benefits of using Azure Data Lake. We will cover how we use ADLS in real projects to produce a security architecture which is adaptable, scalable and provides monitoring capabilities.
Creating Custom Visuals in Power BI with TypeScript and D3.j Mihail Mateev
This presentation is about how to create custom visuals (components) for your PowerBI reports. Power BI reporting features could be extended with custom components, that developers can implement.
De-risk Your Azure SQL Migration: 5 Critical Considerations Kevin Kline
The session takes you through the most critical considerations for moving your on-premise data and databases into the Azure cloud, with a focus on the steps leading to the migration and immediately afterwards.
DevOps 101 for Data Folks Alex Yates
An introduction to the principles that underpin DevOps and the practices that are derived from those principles. This session is mostly theoretical, although it finishes with a brief overview of an Azure DevOps pipeline.
Elementary! The Curious Case of Deceptive Query Optimizer Pinal Dave
We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will together with carefully investigate inside the query optimizer understand the reason.
Faster SSIS Andy Leonard
Learn tips and tricks to make SSIS perform better.
First Dates: AI & DBAs. Any Chance to be a perfect match? Sascha Lorenz
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
Getting Started with Learning Azure Monica Rathbun
Join three Microsoft Data Platform MVPs to discuss the best approach with building your Azure skills. You will learn the best approaches to gaining the skills you need to function in a cloud world.
Hidden Gems of SQL Server 2019 Denis Reznik
SQL Server 2019 is full of new features. Some of them are very interesting and useful, but unfortunately not well-known. So far.
<<12>>