In this new world we're all developers! Whether we're writing application code or describing our infrastructure using bicep or terraform we need to keep it safe. Git and source control is our best option for developing on our own and as part of a team… but git is scary! In this 20 min session we'll go through just enough to git you comfortable with source control.
The video is not available to view online.
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.
Introduction to AutomatedLab PowerShell module that enables you to set up test and lab environments on Hyper-v or Azure in seconds.
The video is not available to view online.
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.
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.
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.
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.
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.
Auditors are not fun to deal with and proving your systems meet requirements is a PITA. Come to this session to learn how to leverage dbachecks to check your SQL Servers for security compliance.
The video is not available to view online.
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.
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.
Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed. No matter if it's an Offline or Online migration, dbatools can make your life easier.
The video is not available to view online.
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.
So you’re the data person in your company and you need to look to the sky. Maybe you've been wanting to do it for a while, maybe it's a mandate coming from the top. What are the steps you need to think about? Where do you even start? What are the risks? How can you begin to wrap your head around all the different things you have to coordinate? Companies don't just need the IDEA that they should move to cloud, but a guide on how-to-do it. This session will not only give you that guide to get you going, but a foundation to take to your bosses to show just how awesome you really are.
The video is not available to view online.
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.
We'll provide a balance perspective of the benefits and limitations of the new Parameter Sensitive Plan Optimization feature in SQL 2022 to help you decide if it's right for your environment.
The video is not available to view online.
This session is a live demo on how to call a REST endpoint and parse the resultant JSON in Power BI.
The video is not available to view online.
Want to use Query Store and not sure how to make sure everything is "correct"? Tried Query Store and had issues? In this session we'll cover what you MUST know to successfully use Query Store in a production environment.
The video is not available to view online.
This session will demonstrate PowerShell's abilities to validate and load data to fill potential gaps in data acquisition process.
The video is not available to view online.
Security is given too little attention in the database environment and many times more rights are given than are necessary. Especially with CROSS DATABASE access, the goal is often overshot. Learn how to securely access data in other databases without breaking the bank.
The video is not available to view online.
<<12345>>