Sessions & Content

Search
Content Type
Conference
Tags
2 Fast 2 Furious - designing for speed, concurrency, and correctness (20 min edition) Mark Broadbent
Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
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.
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.
Automagic Tuning in SQL Server Joey D'Antoni
Understand the automatic performance changes in Azure SQL and SQL Server
Automate management tasks using elastic jobs in Azure SQL Database Mikey Bronowski
Introduction to Azure Elastic jobs
Azure Data Factory, Azure Logic Apps and Power BI for everyone Alpa Buddhabhatti
As above
Azure DevOps Release Pipelines for SQL Databases, Azure Data Factories, and Analysis Models Mike Diehl
How to deploy SQL databases, data factories, and tabular data models to Azure using Azure DevOps release pipelines.
Azure SQL Network Security Steve Morgan
An overview of VNets, Service Endpoints & Private Endpoints for Azure SQL DB & Managed Instance
Benefits of Using Version Control In Database Development Grant Fritchey
Version control provides benefits beyond DevOps automation.
Data Governance with Azure Purview - Theory, Customer Insights and Demos Bernhard Engleder
This data governance session guides you through the organization processes, policies and roles that are required for a successful data governance adoption. In addition to demos showing the possibilities of Azure Purview (the MS data governance service), we will share about experiences from our data governance workshops and adoption projects with our customers.
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
Deep Inside Azure SQL High Availability Joey D'Antoni
Want to have a deep dive into how SQL Server and Azure SQL service maintain high availablity? This is your session.
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.
Enterprise Row Level Security in SQL Server and Power BI Jamey Johnston
Learn how to and why you should protect your data with Row Level Security in SQL Server and Power BI.
Enterprise Scale Analytics - What's in it for me Oliver Engels
Reality Check on Microsofts Enterprise Scale Analytics Framework
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.
From Housekeeping to Data Engineer - My journey to find my passion Jean Joseph
Only the curious will learn and only the resolute overcome the obstacles to learning.
Github and Azure DevOps Duet - SQLBits edition Kevin Chant
A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.
Handle Azure SQL Auditing with Ease Josephine Bush
Auditing options for Azure SQL offerings
Here’s the execution plan … now what? Hugo Kornelis
You know where to find an execution plan. You have taken your first steps reading them. But how are you going to apply this knowlledge to real world problems?
How to Build Secure, Scalable, and Highly Available Applications with Azure SQL Database Bob Ward
This session will show you how to develop your code with .Net and C# using the latest Microsoft tools to launch quickly in the cloud while ensuring you meet the requirements of security, performance, and availability of your application. You will learn how to ensure your application is optimized with Azure SQL Database including Serverless and Hyperscale tiers, Azure Active Directory, retry and error handling, connection abstraction, automated indexing, and Intelligent Query Processing.
How to solve common data security requirements Pieter Vanhove
In this session, you will learn how to solve common security requirements for new or existing applications using Azure SQL Database and Azure SQL Managed Instance. We will cover Authentication and Authorization, Data Protection, Auditing and Security Management. After completing this session, you will understand how to meet specific security compliance standards and best practices.
Intelligent Query Processing Kathi Kellenberger
Learn how enhancements to the SQL Server optimizer improve performance without code changes.
Introduction to Bicep for the Cloud DBA Frank Geisler
In this Session MVP Frank Geisler and first time speaker Timur Dudhasch will give an introduction to Bicep for the Cloud DBA. As more and more systems are migrated to the cloud and as the sheer number of systems rises continuously Frank and Timur will demonstrate how to ease the process of creating and maintaining resources in the cloud via bicep
Introduction to continuous integration and delivery with Azure DevOps (20 min edition) Mark Broadbent
Learn how to use Azure DevOps for your development and CICD processes
Jamstack Foundations: Building Scalable API from the Ground Up Davide Mauri
In this session, we'll see an end-to-end demo of how we can build a Jamstack site in Azure, using Azure Static Web Apps and Azure Functions, and taking advantage of well-known and less known features of Azure SQL that will make you – the developer – productive and efficient as never before. From Graph Models to JSON, from REST to GraphQL, this code-heavy demo packed session will show all you need to build end-to-end modern, scalable, solutions. CI/CD included.
Less Clicking, More Coding! Data Platform Development Using Infrastructure as Code Heini Ilmarinen
In this session we will go through the concepts that you need to grasp in order to get started with infrastructure as code for Azure. We will look at how the process for managing resources in Azure changes compared to the way we've previously done it, and finally we will explore a complete workflow of deploying your Azure data platform architecture as code using Terraform and how to work on that code with your team.
Lightning Talk - Friday Various Speakers
A variety of 5 minute sessions to include:
Microsoft Database Innovations: SQL Server, Azure SQL, open-source and beyond Anna Hoffman
For over 30 years, Microsoft has been leading the charge with innovations in the database spaced based on YOUR feedback and requirements. In this session, learn about the more recent innovations and customers, and how we're aiming to build the best operational database on the planet, anywhere you are. Database services covered include SQL Server, Azure SQL, Cosmos DB, Azure Database for PostgreSQL, MySQL, and MariaDB, and Azure Arc.
Migration to Azure Customer Experiences & Best Practices Bradley Ball
How to create a roadmap to migrate to Azure, best practices, and using Azure Migrate to start, & customer stories
Modern database design (anti)patterns Margarita Naumova
We must realize that patterns which were valid 10 years ago are less likely to work now, like cursor logic, xml usage, or storing all in db v/s using NoSQL. From global industry trends to specific database patterns, this session is a combination of best practices, good and bad patterns, tips, and tricks which I give to customers in my work as a consultant.
Network Security & Connectivity features for SQL Data Services Srdan Bozovic
Join us for a tour of Network Security & Connectivity features that work towards securing your data on Sql Server and Azure Sql
Networking unlocked for the Azure Data Services Heini Ilmarinen
Are you trying to make sense of how to secure your Azure Data Service to your private network, but can't just seem to make sense of service endpoints, private links and private endpoints, as well as when to use which approach? Join this session to understand networking for the Azure Data services and the differences of these methods for integrating your Azure Data Services to a virtual network. You will learn what are the benefits of each approach and what challenges you can solve with them.
Options for Proactively Managing Statistics in SQL Server Erin Stellato
I often recommend that folks proactively manage statistics, but I always seem to run out of time to talk about HOW to do that...this session will cover exactly that.
Protect databases with Microsoft Defender for Cloud David Trigano
Learn what's new in Microsoft Defender for Cloud for data store
Protecting data integrity with ledger Jakub Szymaszek
Join this session to learn how ledger tables in Azure SQL Database and SQL Server 2022 work and why you should use them in your databases and applications.
Run your SSIS packages in Azure Data Factory Piotr Mucha
Do not be afraid to move your onprem SSIS packages to Azure. Come and learn how lift and shift them to the cloud
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.
Selecting the correct Azure Data Solution for your application Denny Cherry
There are several different data platform solutions for use within your application. Selecting the right option can make the difference between a well-performing application and a poorly performing one; not to mention the cost aspect of choosing the wrong solution.
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.
Testing! We're Talking About (Unit) Testing! Dan Mallott
Is the business logic in your database tested? It should be, and in this talk, we'll talk about how.
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.
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.
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.
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.
"Stop that!": What does compliance mean for development? Christopher Unwin
In this session you'll learn some of the key data privacy problems facing database developers and DBAs and 10 steps to help your database team build a "defensible position" through development.
10 DBA Tasks for Azure SQL: Whats Different from On-Prem Rie Irish
In this session, we'll cover the 10 most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Prem installs.
10 reasons to look at using Azure Data Studio Robert French
Yet another new tool from Microsoft ! Why should you consider using it? Thats a good question. In this session we will explore at least 10 reasons to use the tool, and maybe a few more.
<<123>>