Once registered you can log in to create your perfect agenda.
Have you ever had a consultant answer your question with the phrase “it depends”? In this session, you will learn the answers to the follow-up question—“What does it depend on?” about your data choices. One of the benefits and challenges of the cloud is that it can be much easier to move data between several types of data stores. While migrations are still challenging, one of the changes is separating storage from computing, which makes moving large volumes of data easier. At the same time, there has been a proliferation of Platform-as-a-Service database (PaaS) database services. While offering some benefits over on-premises solutions, these services often come with a higher price tag and less flexibility. In this session, you will learn how to separate marketing from technical requirements. You will learn about the following: • What are the different types of data workloads—operational, caches, analytics, AI- and their computing requirements? • The cloud economics of PaaS solutions and how they relate to choosing the right solution for your application. • The competitors in each of those types of databases and the strengths and weaknesses of those solutions. • How you can mix and match solutions to build a best-of-breed solution for your firm and reduce the risk of vendor lock-in. There is a lot of marketing hype around many of these services, which means customers can misuse them. You will learn the fundamental technologies that builds your best data infrastructure.
Whether you’re aiming to be the next great query tuning wizard or you simply need to tackle tough business problems at work, you need to understand what makes a workload run fast - and especially what makes it run slowly. Erik Darling and Kendra Little will show you the practical way forward and will introduce you to the internal subsystems of SQL Server with a practical guide to their capabilities, weaknesses and - most importantly - what you need to know to troubleshoot them as a developer or DBA. They’ll teach you how to use your understanding of the database engine, the storage engine, and the query optimizer to analyze problems and identify what is a ‘nothingburger’ best practice and what changes will pay off with measurable improvements. With a blend of bad jokes, expertise, and proven strategies, Erik and Kendra will set you up with practical skills and a clear understanding of how to apply these lessons to see immediate improvements in your own environments.
After giving you insight into the fundamentals of Security & Compliancy by design for your data platform, we'll take you on a daylong journey into the various topics that help you standardize, automate and report on your Security & Compliancy. We'll dive into Security Configuration Baselines, how to define them, and how to set them up in your environments, ensuring your platform is compliant. You'll receive examples of tools you can use and insights into processes around them. You'll learn how to set-up and manage your environments from a DevSecOps perspective in a way that keeps your infrastructure secure. We'll look into auditing and give you hands-on examples of how to protect your data. We will dive into the complexities of backup/restore that allows your DevOps way of working to be as self-serviced as possible, venturing into matters such as Quality Assurance and Testing. All of this is wrapped-up on the compliance questions that come with this way of working.
Let us show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community-developed modules dbatools and dbachecks. We will take you beyond ‘dbatools in a Month of Lunches’, into more advanced scenarios and show you how effective and efficient PowerShell can make you. Join Jess Pomfret and Rob Sewell, two of the ‘dbatools in a Month of Lunches’ authors, and take your dbatools and dbachecks skills to the next level. We will show you the skills, scripts, and tricks that we have learned with dbatools and dbachecks and tell you how they have rocketed our careers. There will be many practical examples of how dbatools and dbachecks can help to save time in DBA administration duties such as: • Finding SQL Instances on your estate • High Availability and Disaster Recovery scenarios • Working with Replication • Backup Testing • Instance migrations • Validating your estate with dbachecks • dbatools and dbachecks in DevOps processes • Using PowerShell in the cloud (i.e. working with Azure SQL Database, Azure SQL Managed Instance) • PowerShell coding for performance • Using dbatools and dbachecks in Azure Functions and Azure Runbooks Take your dbatools and dbachecks skills to the next level and become more effective in your role. Register now to reserve your spot!
The transition to AI from BI represents a climactic leap towards unlocking exceptional insights and capabilities. Examples will use marketing scenarios to help BI professionals deliver AI in their own organizations right away. The 'Springboard to Artificial Intelligence from Business Intelligence: AI Skills for BI Professionals' workshop is designed for BI professionals with a technical background. It aims to bridge the gap between traditional BI practices and the cutting-edge realm of AI, with a focus on Microsoft technologies. This intensive workshop will take BI professionals on a comprehensive journey, starting from the foundational principles of AI and machine learning (ML) and moving through the intricacies of integrating AI with existing BI frameworks. Participants will gain hands-on experience with Microsoft Azure AI services, including Azure Machine Learning and Azure Cognitive Services, and learn how to leverage these platforms to enhance data analysis, predictive analytics, and enterprise AI. Through theoretical sessions and practical labs, attendees will explore real-world scenarios where AI can transform BI tasks, such as generating AI-driven insights, and advanced data analytics. By the end of this workshop, BI professionals will have the essential AI skills and knowledge to innovate within their roles, drive business growth, and stay competitive. Join us to transform your BI expertise into AI prowess using Microsoft's leading technologies.
“Use version control and automate your deployments”, is what you hear. But for database development it isn't that simple. There are struggles over using a shared or personal database, questions over how to handle object conflicts, and the fight between choosing state or migration-based deployments. This is why two seasoned Database DevOps warriors will enter the ring to settle this ‘fight’. They'll share their hard-earned knowledge, equipping you with the tools and tactics to decide what to use, when to use it, and why. “Ladies and gentlemen, in the left corner, Team Migration, with the lineup of Flyway, Grate, and EF Core, guided by Coach Tonie. And in the right corner, representing Team State, we have SSDT, Database Projects, and schema comparing tools, all under the expert of Coach Olivier.” Step into our 4-round battle where we start by gearing you up with the essential concepts and tools. Round 1 sets the stage, showing you how to get your systems up and running, ready for hands-on combat. As Round 2 rings, we will intensify the action, demonstrating you the skills needed for collaborative database development. Round 3 reveals the contrasting deployment tactics of our contenders, while the final round focuses on mastering CI/CD automation with Azure DevOps and GitHub Actions, essential moves for any DevOps warrior. Does this sound like a fight for you? Sign up for our pre-con to be a contender, because “Every champion was once a contender who refused to give up.” – Rocky Balboa
You've been working with SQL Server for a few years, and you're comfortable writing queries and reading execution plans. Your company is now using SQL Server 2019 or 2022 in production, and you want your queries to go as fast as possible. You want to know what changes to make to your existing queries in order to speed them up dramatically. You don't want a "what's new" session - you want practical information you can use to identify T-SQL that used to work fine in older versions, but now needs attention in newer versions. In this 1-day session, Brent Ozar will use the same practical before-and-after techniques that he uses in his Query Challenges blog series in order to demonstrate what parts of your skills need to change as you modernize your databases.
T-SQL queries, stored procedures, and poorly written functions are the main contributors to performance degradation in SQL Server. SQL Server is optimized for set-based processing over procedural processing. The sad reality is that too much code is written from a procedural point of view because many database developers started as procedural programmers. Also, many applications use SQL Server as data storage and must take advantage of its incredible capabilities. This session will examine what set-based queries are, how to identify inefficient procedural processes, and how they can be rewritten as efficient set-based queries. Attendees who bring laptops will be invited to download and install SQL Server Developer's Edition and AdventureWorks to work with practical examples throughout the day.
Are you itching to get hands-on building solutions in Microsoft Fabric, but aren't quite sure where to start? If so, this workshop is for you! In just one day, you will learn everything you need to build a Microsoft Fabric Proof of Concept. We will start with an overview of Microsoft Fabric and its experiences, common architectures, and the most important factors that will help you decide which parts of Microsoft Fabric are appropriate for your project. When you have a plan and a few rough diagrams, it's time to dig into the details. After you've set up your own workspace, we will go through options for ingesting, transforming and storing data. By discussing your proposed solutions with each other, you will also gain valuable insight and learn from each other’s experiences. Once the data is ready for consumption, we will look at how to create beautiful visualizations and tell stories with our data using Power BI, how to empower business analysts to take action based on changing data, and how to roll out a fully governed solution in your organization. Throughout the day, we will cover security, CI/CD, the pricing model, best practices for development, and lessons learned from real-world projects. Don't miss this opportunity to experience Microsoft Fabric's game-changing potential firsthand and learn how it can revolutionize your analytical workflow. Bring your laptop and get ready for a day full of hands-on experience and engaging discussions!
For troubleshooting slow queries, looking at the execution plan is a good starting point. But sometimes, just looking at the plan does not help. Sometimes you need to dig deeper. In this full-day pre-con session, you will learn everything you need to take your understanding of execution plans to the next level. For almost every operator you can encounter in an execution plan, we will look at the inner workings, and look at properties that can affect their performance. We will also look at how operators in a plan interact with and affect each other. Aside from explaining all of the common operators, we will also touch on several operators that were introduced or modified in the newer versions of SQL Server. In short: After this pre-con, you will be better prepared to look at execution plans, find the spot where it hurts, and then rewrite your query to get a faster execution plan. If you have seen some execution plans but feel you need to bring your understanding to the next level, then this pre-con is for you.
Today, more and more SQL Server developers and DBAs are being asked to use their skills and experience across multiple database platforms. Among those platforms, PostgreSQL continues to be in high demand and is the go-to database for new projects. With the right introduction and foundation, transferring years of SQL Server knowledge to support PostgreSQL is attainable. With this pre-con, we’ll give you the introduction and tools you need to start that journey. Based on a new book from Redgate by Grant Fritchey and Ryan Booz, this pre-con will introduce you to the similarities and differences of PostgreSQL compared to SQL Server. From tooling, security, configuration, writing SQL and pl/sql, and query tuning, you’ll be equipped to start exploring PostgreSQL on your own and contributing to new projects and initiatives.
This training is designed for Power BI developers, data analysts, Power BI architects, data architects, BI developers, and anyone who is building or designing a Power BI solution or implementation. Reza Rad, author of the only Power BI Architecture book (now in its second edition), developed this pre-con content because, in his experience, the development skills aren’t what fails many Power BI projects - the lack of proper architecture is. In this pre-con, you will learn about architecting the strategy of a Power BI solution from end-to- end. You won’t learn how to create a visualization or write DAX expressions. You will, however, learn about all aspects of architecture for a Power BI solution. You will learn about Power BI service, different connection types in Power BI, and how to choose the right type of connection for your solution. You will also learn all the different ways of sharing a Power BI solution and the pros and cons of each. The content is categorized into sections of: Architecture for Development, Deployment and Collaboration. From multi-layer development architecture using Dataflow and the Shared Semantic model, to Fabric objects such as Lakehouse, deployment pipelines and licensing and finally sharing methods – they’re all covered in this pre-con workshop. This is recommended to anyone working with Power BI solutions at any level: development, administration, decision-making or architecture.
Picture this: a day crammed with fun, fascinating demonstrations for SQL Server and Azure SQL. This isn’t your typical training day; this session follows the mantra of “learning by doing,” with a good dose of the unexpected. Think of this as a SQL Server video game, where Erik Darling and Kendra Little guide you through levels of weird query monsters and performance tuning obstacles. By the time we reach the final boss, you'll have developed an appetite for exploring the unknown and leveled up your confidence to tackle even the most daunting of database dilemmas. It's SQL Server, but not as you know it—more fun, more fascinating, and more scalable than you thought possible.
Data fuels the world more than ever. When access to data is interrupted, businesses and end users are impacted. Long gone are the days where outages – planned or unplanned – can be dealt with by a simple “we’re temporarily down” web page. How do you achieve the maximum amount of up-time and minimize the impact of outages if you are responsible for SQL Server on-premises (physical or virtual), hybrid, or up in a cloud provider? This full-day session cuts right to the chase and covers both the technical and non-technical factors for availability success including, but not limited to: • How to determine availability and recovery objectives. • Understand the differences in the multiple kinds of Always On availability groups (AGs). • How to determine what features or techniques you should use – built-in, such as the Always On features (AGs, failover cluster instances), or external/third party tools. • How to plan for both local availability as well as disaster recovery, including the right backup and restore strategies, including storage-based snapshots. • Ensure technical debt and performance do not impact availability. • Minimize downtime during planned outages such as patching. • Where and when to automate/script. • Usable, real-world best practices, tips, and tricks. Whether you are a DBA, accidental DBA, developer, or just an IT pro looking for tips to enhance your SQL Server business continuity story, register today.
Do you know SQL but are trying to catch-up and learn about the new world of AI? In this workshop you will learn the fundamentals of Generative AI, how AI can apply to your data, and how AI integrates with SQL Edge to cloud. You will learn concepts like language models, prompt engineering, Retrieval Augmented Generation (RAG), vectors and embedding, AI services, and other concepts used to build AI applications including experiences with SQL in Microsoft Fabric. You will also learn how to use Microsoft Copilot experiences to build SQL applications and to manage and troubleshoot your SQL deployments. This workshop is designed for anyone who knows SQL and wants to learn AI - including developers, architects, administrators and IT professionals. This is the one-stop shop to learn all the latest for SQL and AI from the Microsoft engineering team.
Join us for breakfast and connect with the product teams behind your favorite Google Cloud database products. This is a great opportunity to share your feedback, ask questions, and learn about our latest developments across Cloud SQL and AlloyDB. Our product experts will be on hand to discuss: ● The latest features and updates to Cloud SQL and AlloyDB ● Best practices for migrating and managing databases on Google Cloud ● The future of databases and innovation on Google Cloud Google Cloud Speakers: Sailesh Krishnamurthy, VP of Engineering, Google Cloud Mohamed Kabiruddin, Product Manager, Cloud SQL Sunil Sayala, Engineering Manager, Cloud SQL Sridhar Ranganathan, Product Manager, AlloyDB Tabatha Lewis, Product Manager, AlloyDB This is a great opportunity to network with other PASS Summit attendees and connect with the experts. We hope to see you there!
Data is the fuel for innovation, driving the development of transformative AI applications. In this keynote, join Shireesh and the Microsoft engineering team as they explore harnessing the power of data across the Azure databases portfolio to drive groundbreaking advancements. Take your first step on the journey with vector search, multi-agent apps and more and learn to unlock new patterns like retrieval augmented generation (RAG). Explore the latest database innovations in SQL Server, Azure SQL, Azure Cosmos DB, Azure Database for PostgreSQL and Azure Database for MySQL that enhance operational efficiency, deliver personalized user experiences, and revolutionize the way we interact with technology.
There are very few who live on the bleeding edge or stay 100% up-to-date. That means the majority of technology deployments in the world – physical, virtual, or in the cloud – are behind. How much they lag is always the question. Is it a few updates? A few major versions? Something from the Jurassic era of computing? This phenomenon is not just a SQL Server problem; it affects everything SQL Server touches directly or indirectly (operating systems, hardware, applications, etc.). The alternative is not a place anyone should be; without updating or upgrading, you may be out of support, miss bug fixes, increase security risk, or more. This session will discuss how to approach this complex challenge for modern systems and solutions. You will understand how we got here, demystify scare tactics companies use versus reality, and learn practical tips on how to start untangling the web of dependencies to patching and upgrade success as well as reduce technical debt.
When it comes to automated database deployments, I've been on quite the journey, from home-grown scripting to SQL Server Data Tools, then Redgate SQL Change Automation and now Flyway. Through it all, a handful of principles have emerged – the “non-negotiables”, the secrets to our success. And I want to share them with you. We’ll touch on the high-level, like the difference between declarative and imperative deployment paradigms, and the reason declarative tooling is tricky against large datasets. We’ll look at how most automated deployment frameworks apply changes to their targets. And we’ll get into the nitty-gritty, like changing large indexes or handling bugs in your deployment scripts. Whether you’re deploying to SQL Server or PostgreSQL, whether you’re deploying through Octopus or Azure Devops, these principles are likely to be helpful.
Sign up to stay up to date with news, special announcements and educational content.
Redgate will only contact you about PASS Data Community Summit unless you separately request emails about Redgate.