Sessions & Content

Search
Content Type
Conference
Tags
10 Productivity tools in 20 minutes Rob Sewell
You are busy, we are busy, everyone is busy. These are the tools that two busy consultants use to improve their productivity. We want to tell you about the tools that we use; that maximise our time, simplify our life, reduce our key strokes and generally make us appear more amazing. So that you can use them too. We have 20 minutes, so we wont go into much detail but we have some good quick stories to tell.
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.
3 things you don’t want to store in a database (but sometimes have to) Gianluca Sartori
Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
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.
Automagic Tuning in SQL Server Joey D'Antoni
Understand the automatic performance changes in Azure SQL and SQL Server
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.
Database Projects 101 in ADS Warwick Rudd
Database Projects 101 in ADS is an introductory session on how to incorporate Database Projects in Azure Data Studio into a Data Professionals toolkit.
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
Dedicated SQL Pools : How some stuff 'really' works Mark Pryce-Maher
Session covering table distributions, partitioning , RSC and materialised views.
Developer Enhancements in SQL Server 2022 Kendal Van Dyke
SQL Server 2022's latest developer enhancements from the Product Group.
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.
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.
Field Testing Ola Hallengren’s Maintenance Solution Joe Pollock
Learn how to best configure and use Ola's Maintenance Solution, based on years of experience using this on thousands of SQL Server instances.
Fragmentation Explained in 20 Minutes Brent Ozar
What do index rebuilds and defrags really do?
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.
Fundamentals of Stored Procedures Brent Ozar
How to write stored procedures that have a high likelihood of performing well and are easy to troubleshoot.
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?
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
Is HTAP the future? Scott Bell
Hybrid Transactional Analytical Processing solve the age old problem of integrating operational processes with analytical capabilities within a single system. Find out what they're and how they deliver value
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.
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.
Partitioning for Beginners Uwe Ricken
Introduction of areas for partitioning for Beginners
Protect databases with Microsoft Defender for Cloud David Trigano
Learn what's new in Microsoft Defender for Cloud for data store
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.
Stop Doing Stupid $%^--How Not to Secure Your Environment Joey D'Antoni
Most data breaches happen becasue of stupid configuration mistakes. Learn how to stop doing that.
The modern Cloud Data Warehouse - Snowflake on Azure Koen Verbeeck
Intro to Snowflake
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
Top Five Disasters we've dealt with in our time as DBAs Gethyn Ellis
Come and hear our top five disasters and how we managed them (or not)
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.
Using WorkloadTools to analyze your workload Gianluca Sartori
In this session I will show you how to use WorkloadTools to connect to a SQL Server database, on-premises or in the cloud, and analyze all the queries that are run against it.
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.
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.
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.
A Distributed Availability Groups Primer Allan Hirt
A distributed availability group is not your mother's availability group. Want to know more? Attend this session.
Advanced Plan Explorer Usage for Tuning Execution Plans Andy Yun
Users of Plan Explorer often only utilize the basic capabilities to tune execution plans. This session will cover more advanced techniques to get the most out of SentryOne's FREE execution plan analysis tool.
Azure SQL and SQL Server: Path to an Intelligent Database Pedro Lopes
Come join us in the intelligent database world that started with SQL Server 2017 and takes a leap forward with the upcoming SQL Server 2019 and Azure SQL DB.
Azure SQL Database Edge-Optimized SQL Engine for Edge/IoT Sourabh Agarwal
Azure SQL Database Edge has taken the same SQL database engine you know and optimized it for the Edge. This session explores popular customer implementations, along with new product features for the Intelligent Edge
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.
Building a Better Backup Strategy Paul Randal
Learn how backup and restore work and how to put together an effective backup strategy.
Can SQL Server 2019 auto-magically fix my bad T-SQL code? Andy Yun
Come to this session to see how SQL Server 2019 mitigates two common performance killers: scalar functions and table variables!
Deadlocks: Lets Do One, Understand It, and Fix It Brent Ozar
You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. Brent Ozar will show one, use sp_BlitzLock to analyze it, then fix it.
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.
Designing Azure Data Disaster Recovery Strategies John Morehouse
Unfortunately, disasters can affect cloud technologies and if you are't prepared for it, the results can be painful. Let's discuss ways to implement Azure SQL disaster recovery techniques to help protect your data!
Docker Deep Dive Andrew Pruski
Played around with SQL Server in containers and want to delve further into the platform? This session is for you! In this session we'll dive straight into the Docker platform and investigate its internals.
Dynamic Data Masking in 20 Minutes David Postlethwaite
In this 20 minute session we will have an overview and demos of Dynamic Data Masking which allows us to obfuscate data in real time
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.
Execution plans ... where do I start? Hugo Kornelis
Execution plans are key to understanding bad query performance. But they can be overwhelming to the new user. Where to start? This session will show the basics!
<<12>>