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 to Z Azure SQL Security Concepts Deepthi Goguri
Planning to move your databases to the cloud but seriously doubt if your data is 100% secure? No matter if you are on-prem or in the cloud, making sure your data is protected in every angle possible is the most crucial and important step in building a secure data tier of an application. Let's dedicate this session to knowing the different multi-layer defense-in-depth security techniques and strategies available to armor your Azure SQL database. let's dive deep into each of these layers starting with the network security, Azure role-based access control (RBAC), data security at the row level, auditing, advanced threat protection, different layers of encryption, monitoring, and more. By the end of this session, you will have the knowledge to make the right security decisions for your environments and implement these techniques in securing your data. 
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.
Azure SQL MI End-to-end Demo Party for DBAs and Devs Dr. Dani Ljepava
Join us for a pure, demo-driven journey of a dozen incredible features for Azure SQL Managed Instance showing you the greatest and latest innovations enabling Database Administrators and Developers to achieve more. Whether you’re a DBA, Azure Administrator, Developer, Business Intelligence developer, or of course any other data professional, these demos will show how you can achieve more with the exciting features that are available to you. Some of the topics we will cover are hybrid scenarios, performance and scale, application compatibility, workload modernization, compliance, data mobility/migration & business continuity/disaster recovery - and several more - in this fast-paced, demo-only session.
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.
Building an Azure Data Analytics Platform End-to-End Paul Andrew
Based on real world experience let’s think about just how far the breadth of our knowledge now needs to reach when starting from nothing and building a complete Microsoft Azure Data Analytics solution.
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.
Code repos and automated deployment Jens Vestergaard
Join this session if you want to get a guided tour into an example of how you could implement Azure DevOps in your organisation or team. We will be complete the journey from idea to running code
The video is not available to view online.
DataOps 101 – A Better Way to Develop and Deliver Data Analytics John Kerski
Power BI has revolutionized the industry by accelerating our ability to deliver Data Analytics solutions. But how do we ensure the code we build is reliable and the data is produced in a timely and trustworthy manner? Enter DataOps, a better way to develop and deliver Data Analytics Solutions. In this session, I’ll cover the concept of DataOps, why it matters to Power BI, and the principles that can drive you to continuously improve.
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.
Ground to Cloud: Your Migration Success Checklist Matt Gordon
Cloud migration projects are often massive projects with sprawling scopes. Don't you want some help sorting through this enormous pile of work? Join an experienced cloud migration consultant for a targeted walkthrough of their cloud migration success checklist so you can make sure your project gets off to a good start and reaches a successful completion.
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.
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.
Migrating data solutions to the cloud - a checklist. Kristina Mishra
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.
Performance Tuning Azure SQL Database Monica Rathbun
Have you moved to a cloud database like Azure SQL Database and are having performance issues? While the Azure SQL services running in Azure are similar to SQL Server, they are key differences in performance tuning methodologies. In this session, you will learn about monitoring options, changes in cloud DMVs, and additional cloud tuning tools like Azure SQL Analytics and Performance Insights that can allow you quickly get to performance data across a number of instances. You will learn about what you need to keep in mind when choosing between scaling-out to readable secondaries and scaling-up to higher tier solutions. Discuss with Microsoft MVP Monica Rathbun the challenges and benefits of tuning, what to keep in mind, and what to expect in the cloud.
The video is not available to view online.
Query Store Best Practices Erin Stellato
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.
Replacing SQL Agent In Azure Neil Holmes
Moving from traditional SQL Server to Azure SQL Database can be a challenge! There's already lots to think about before you make the move, but this session can help you with one of those considerations: What do I do with my old SQL Agent Jobs?
The video is not available to view online.
Security is not a feature Robert Hartskeerl
You should not have to wait for a spefic feauture to be secure. A lot of the security features are not limited to the latest versions. Let's go back in time and match modern day security features in a SQL version from way back when.
The video is not available to view online.
<<123456789>>