Enjoy session recordings from previous years of PASS Summit
Indexes are one of the most important pieces in performance tuning - they can help queries seek to find a small number of records, efficiently scan for sets, use batch mode processing for large scale aggregates / join. Or, sadly, they can be a complete MESS! The basic problem is that EVERY SINGLE query *can* be indexed. But, not every query *should* be indexed. I'll start with a quick review of row-based and column-based indexes but I'll primarily focus on strategies that will help your server perform! We'll start with the ever-important "query tuning" aspect to indexing but also cover the many considerations overlooked before applying those indexes in production (what I call "server tuning with indexes"). This will be a fast-paced session with lots of demos, get your caffeine first!
SQL Server 2022 is here! In this session, I'll go over all the new capabilities in SQL Server 2022 including how to connect with Azure for disaster recovery, near real-time analytics, and security. I will show you innovations in the database engine for security, performance, and availability including SQL Server Ledger. You will learn about enhancements to Query Store and the next generation of Intelligent Query Processing allowing you to gain performance with no code changes. You will love the demo for this one! I'll also show you new extensions for the T-SQL language including data virtualization object storage, JSON functions, and time-series. Experts from the SQL Server engineering team will join me live to answer all of your questions. This is the session you won't want to miss at the PASS Data Community Summit to learn about SQL Server 2022.
You have learned the relevance of execution plans. You know where to find them, and you’ve been taught the basics of how to read them. You’ve looked at some of the clean, simple execution plans that presenters used in classroom training, or at conferences, and you feel confident that you can work with them. And then you get your first problem query at your workplace, you look at its execution plan, and you just want to crawl under a rock and cry. Real code is much more complicated than demo code. Real code translates to large, complex, and often messy execution plans. The principles of reading execution plans still apply, but the plan is large and messy and you struggle where to even begin. If your query uses a lot of I/O, then which operators are to blame? If your query uses a lot of memory, then what area is responsible? What are some things you should always look at? Knowing the root cause of a problem can help find a cure. Knowing where to look in a large execution plan can help you find that root cause faster!
Troubleshooting performance issues and tuning queries can be easier with some level of understanding about statistics. Something you may hear people talk about as part of query tuning are "bad cardinality estimates". If you’ve wondered what that means, and you want to understand how the optimizer uses statistics when creating a query plan, then join me for this session. We’ll set the stage with a review of what statistics are, then see how the optimizer uses them and where to find that “cardinality estimate” information in a plan. We’ll also cover the various ways statistics can be updated, explore what happens to plans when those updates occur, and ultimately you will see why understanding how it all works is critical when you’re troubleshooting performance problems. Expect lots of demos so you can truly understand what statistics are, how they're used, and why their management is so essential for good performance.
Succeeding as a data professional is all about placing the right bets at the right times. The more you know about what's happening around you, the better bets you can place. I'm Brent Ozar, and I've been working with databases for over two decades. In this session, I'll invite you into my home to have a frank, honest discussion about where our industry has been recently, and where it's heading next. We'll look at how that will impact the available jobs in our industry, and how it impacts where you focus your spare training time. We'll even look at job ads and resumes in an effort to help you stand out. In one hour, I can't make you a pro at everything - but I can help you understand where you need to be a pro, and how to make your resume reflect that.
T-SQL supports four kinds of named table expressions: derived tables, CTEs, views and inline table valued functions. From a query tuning perspective, SQL Server treats table expressions very differently compared to persisted tables. This session provides query tuning tips concerning table expressions, and shows you how to apply those tips to address common query tuning needs.
I will begin with a brief overview of SQL. Then the five major topics a data scientist should understand when working with relational databases: basic statistics in SQL, data preparation in SQL, advanced filtering and data aggregation, window functions, and preparing data for use with analytics tools.
Machine learning is one of the hottest trends on the market. According to the popular belief, machine learning will help you do everything from water your plants to running your multi-million dollar company. Some of the hype is true, much of it is false. But what IS machine learning - really? How can it be used? What questions can it answer? Har hard is it to get started? Join Alexander for a session that will give you a thorough overview of what machine learning tools is available in Azure, how to actually find any use for machine learning, what preconceptions are wrong and how to get started on your first machine learning project.
Have you ever found yourself in need of making queries go faster but didn't know where to begin? In this session, you will learn multiple ways to find your top offending statements. You will learn three key tips to help you understand execution plans. Finally, you will learn a framework to help you create indexes to help performance.
Azure SQL is becoming more and more popular and there are many options available within that umbrella. In this session we’ll talk through our options when it comes to SQL Server in Azure. We’ll strive to understand the differences, and when each offering might be a good fit for our needs and workloads. Once we have a good understanding of the differences between the various PaaS and IaaS offerings we’ll have a look at the tools we have in our toolbox that can be used to deploy these resources.
When a database is slow, 90% of the time bad SQL is the culprit. The underlying issue can be either poor design or inefficient SQL coding. Knowing what common issues to avoid can make life more enjoyable.
Find out about the future of Summit, what the teams at Redgate are working on, and what they're looking forward to most during this year's Summit. Join Steve Jones as he takes you on a journey with Redgaters old and new.
Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! Now join us to find about what's coming next in this new intelligent database world!
There are a lot of people talking about PowerShell and they should be. Where are you in the PowerShell continuum? As one of the original PowerShell DBAs, I have been using PowerShell from the start and using SMO and automation since version 9 (SQL 2005). I want to show you how you can get started and begin your Learning Pathway (LP), so that you can leverage this tool in your work. It is not hard, but with this primer you will be able to get stuff done more simply and begin your journey to using this powerful tool in your daily work. I will begin with environment and then move in to syntax and tricks to know as a DBA and then finish with some simple tools putting together basic knowledge and steps so that it becomes real. It is a journey not an event for most people. Join me in my quest to be the best PowerShell DBA out there.
We've all written queries that have generated Missing Index Recommendations. Perhaps you've just implemented the recommendation and moved on with your day. Or maybe you've been told to not trust these recommendations at all. Should you use them or not? How do you navigate between these conflicting viewpoints? Join me to learn how to properly interpret these recommendations. We'll explore the pros and cons of SQL Server's Missing Index Recommendations. And while these recommendations are generated for individual queries, you'll learn how to leverage their insights wisely to benefit your entire on-prem and/or Azure SQL workload. Your queries will thank you!
Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why your TempDB is suddenly 3 TB? In this session, you will learn about all the various components of SQL Server that use TempDB. Whether it be AlwaysOn Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB. Once you understand all the ways SQL Server uses this critical resource, and how to proper configure it, you'll be better prepared for your workloads whether it be an Azure VM, a physical server, or a container.
DevOps has fundamentally changed the way we manage IT. Those practicing DevOps well aren't just outpacing their competitors, they are annihilating them. DevOps brings a whole host of new practices, tools and buzzwords. It has made some roles and tasks redundant, while new opportunities have been created. Whether we have days or decades of career experience behind us, we all need to learn to thrive in this new reality. In this session we'll cut through the hype and look at the key concepts and findings from the Puppet State of DevOps Reports, The DevOps Handbook and Accelerate. We will finish with an overview of a public database project, that you can use to provision and deploy a SQL Server database in AWS for under one dollar per day.
In this session, I'll show you 5 principles that might be holding you back from getting things done. Warning: Just by knowing these you might be able to relate to previous situations, recognize them and start taking action, making yourself more confident, productive, and happier.
What is source control? What is version history? What are unit tests? What do CI and CD even mean, and what the heck is an Artifact?? In this new era of Agile development, DevOps, DataOps and other weird buzzwords, we the DBAs gotta learn to keep up. It's time to add our monstrous database into the continuous integration pipeline. But first, we need to know what we're going into and need to familiarize ourselves with the terms and methodologies of the world of software development lifecycles.
Sign up to stay up to date with news, special announcements and educational content.
Redgate will only contact you about PASS Data Community Summit (in line with our Privacy Policy) unless you separately request emails about Redgate. You can unsubscribe from these updates at any time.