Sessions & Content

Search
Content Type
Conference
Tags
A Crash Course in Deploying your Database Neil Holmes
So you've heard that automating deployments to your databases are all the rage, not least because you don't have to wake up at 2am to perform them. But how do you get from having a database with no automation to having your DB in code, and deploying changes automatically using Azure DevOps?
The video is not available to view online.
A Practical Starter Guide to SQL Notebooks Deborah Melkin
Have you been hearing about SQL Notebooks in Azure Data Studio but haven't worked with them yet? Or have you played around with notebooks but not been able to figure out how to make them work for you? Let's jump into SQL Notebooks together as we figure out how we can use them in our day-to-day work!
The video is not available to view online.
Advanced Power BI refresh with ADF/Synapse Mathias Halkjaer
After this session, you will be able to conceptualize and implement different Power BI refresh scheduling patterns in ADF/Synapse. You’ll learn what limitations in Power BI you can overcome with an “external” orchestration tool as well as the different building blocks available. Finally, we will go through an example implementation as well as a step-by-step demo of how you can set this up yourself.
The video is not available to view online.
Applying effective Source Control to your Database System Karim Ourtani
How can you everage SSDT in order to deploy DB changes as part of your CI/CD pipeline
The video is not available to view online.
Architecting for High Performance SQL Server on Virtual Machines Anthony Nocentino
Misconfigurations and default settings in your virtual machine base SQL Server environment can be causing you the performance issues you are having. Learn what you need to build to design and build a high performance virtual machine environment for your SQL Server.
The video is not available to view online.
Azure Networking Fundamentals for DBAs – Everything you need to know in 20 minutes! Marc Dunbar
Why do you need subnets? What addresses can we use? And what is the difference between a /16 and a /24 subnet anyway? Virtual Networks and subnets can be daunting in Azure, yet they are fundamental to so many resource types. In this session we'll cover everything you need to know to get started with creating your own virtual network are carving it up into subnets of various sizes to meet your needs. So next time you need to create a subnet to join your Azure SQL VM to, you'll know exactly how to plan for this and implement accordingly.
The video is not available to view online.
Banishing Slow Queries with Intelligent Query Processing John Morehouse
An overview of the performance enhancing Intelligent Query Processing features in SQL Server 2019 as well as including some new SQL Server 2022 items,
The video is not available to view online.
Beware of nondeterministic T-SQL code Itzik Ben-Gan
Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.
The video is not available to view online.
Break five common myths about SQL Server backup Taiob Ali
In this session, I will discuss five common myths about SQL Server backup and demo each to show you the correct answer.
The video is not available to view online.
Business Continuity for Hybrid and Cloud Native SQL Server Deployments Allan Hirt
With more and more deployments of SQL Server becoming hybrid or cloud native, how do you need to think about availability? This session will give you the foundation on how to approach availability in the new world.
The video is not available to view online.
Chaos Engineering for SQL Server Andrew Pruski
How can we test potential weaknesses in SQL Server? In this session we will explore the concept of Chaos Engineering, its core concepts, and the methodologies behind it.
The video is not available to view online.
Columnstore Index Compression in a Nutshell Edward Pollack
Improve analytic queries by unlocking the secrets of columnstore compression!
The video is not available to view online.
Fundamentals of Git Grant Fritchey
Learn the fundamentals of how to work within Git in this 20 minute session.
The video is not available to view online.
Hear me out - Don't go offline because of your index deployment strategy Cláudio Silva
Want to avoid downtimes or big blocking operations when managing indexes on busy systems? In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.
The video is not available to view online.
Keep the Integrity of your Database with Azure SQL Ledger Rui Carvalho
Data integrity is a huge concern for every business, especially when it comes to protecting your company's most valuable information and Azure SQL Ledger can be the way to go.
The video is not available to view online.
Keeping historical data in tables forever – mission (im)possible! Margarita Naumova
Let’s discover some solutions for keeping historical data in the database when you receive near to impossible requirements like storing data in same tables forever and being able to edit and query them at the same time, of course keeping the response at its best. Based on a real project case the session walks you through the design process from the start to the reaching of the final solution and making the client (and developers) happy.
The video is not available to view online.
Lessons learned from refactoring multi terabyte databases for the last 10 years Sergey Olontsev
Database refactoring could be tricky sometimes. To learn more about it come to my session, where I will tell you about different situations and scenarios I've came across during the last 10 years. I will share my experience; traps, you easily can get into, and what solutions did I choose to come over it.
The video is not available to view online.
Managed Instance Link - Seamless migration to Azure Manish Kumar
We cloud solutions architects from Microsoft, will be demonstrating all the use cases with demos of the newly available (currently in public preview) Azure SQL Managed Instance Link. We will talk about all the available migration tools like DMA, DMS, Azure Migrate, ADS and why you may want to use MI Link to migrate on-prem SQL Server to Azure SQL Managed Instance as compared to other available migration tools.
The video is not available to view online.
Microsoft Defender for SQL: Advanced Threat Protection Rie Merritt
Microsoft Defender for SQL is part of the Azure Defender family and it protects SQL Server in two main ways. We'll cover the first way, Advanced Threat Protection. This is a feature with advanced security capabilities that detect anomalous activities that might access or exploit sql server, like SQL Injection.
The video is not available to view online.
Never ETL again, thanks to Synapse Link. Really? Ben Weissman (he/him)
Let's take a look at Synapse Link - it's capabilities and restrictions! Synapse Link is Microsoft's new solution to push your OLTP data in near-real time to Azure Synapse for analytical purposes.
The video is not available to view online.
<<1234>>