Performance Tuning Azure SQL Database
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.
Click Here to Download PDF: Performance Tuning Azure SQL Database
Your Performance Tuning Check List
Click Here to Download PDF: Your Performance Tuning Checklist
Mastering TempDB
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.
Click Here to Download PDF: Mastering Tempdb
Performance Tuning, Getting the Biggest Bang for Your Buck
Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.
Click Here to Download PDF: Performance Tuning, Getting the Biggest Bang for Your Buck
I’m It – Survival Techniques for the Lone DBA
Abstract : Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 16 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Click Here to Download PDF: I’m It – Survival Techniques for the Lone DBA
Listen to the session via PASS Summit 2019 Live Stream on PASS TV: http://bit.ly/PASSLoneDBA
Performance Tuning SQL Server on Crappy Hardware
Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking. Let’s see how compression, statistics, and indexes bring new life into your existing hardware.
Click Here to Download PDF: Performance Tuning SQL Server on Crappy Hardware
Always Encrypted for Beginners
One of the biggest challenges to successful implementation of data encryption has been the back and forth between the application and the database. You have to overcome the obstacle of the application decrypting the data it needs. Microsoft tried to simplify this process when it introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database. In this demo intense session, you will learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt. You will also learn about the current limitations of the feature and what your options are to work around them.
Click Here to Download PDF: Always Encrypted for Beginners
Listen to the session via SQLBits 2020 on YouTube https://www.youtube.com/watch?v=Pc63Jrxo6kY
Automatic Performance Tuning on Prem and In the Cloud for DBAs
Starting with SQL Server 2017, Microsoft introduced automatic tuning features that provide insight into potential query performance problems, recommend solutions, and automatically fix those identified problems. With each new version of SQL Server, they are building in more and more of these offerings. It’s important to understand where automatic tuning helps, what problems it still doesn’t solve, and how DBAs who have been query tuning for years should approach it and incorporate it into their toolbox. In this sessions, we dive into what is offered with the traditional on-prem installs as well as what Azure offers in the cloud. Throughout the session we will examine each of these features, touching on what they are, how they are used, and how to implement them. We will conclude with diving into Intelligent Query Processing and how it can help you obtain the maximum performance from your queries with minimal effort. Join me as we take performance tuning to the next level.
Social Networking: Making or Breaking Your Career
Social Networking has been a huge stepping stone that helped many of our careers. The SQL Community is built on it. MVPs use Twitter to help solve problems. User Groups, Virtual groups and various other training events use Facebook & Twitter to promote themselves. Let’s talk about how using Twitter, Slack, LinkedIn and even Facebook cannot only enhance your career but make you better at your job. We’ll also discuss the pitfalls & risks that sometimes accompany these tools to help you avoid professional trouble. Managing your social presence is essential in today’s business world. Learn how to take advantage of the tips & tricks that have worked for me & so many others.
Query Store: The simplest way to Troubleshooting Performance
Introduced in SQL Server 2014, the Query Store feature provides you with insight on query plan choice and performance. It gives you more control over which execution plans the optimizer will utilize and insights into plan regressions. In this session, we’ll discuss what the Query Store is, how it works, how you should configure it for your environment, and how to get even more information by using the underlying DMVs that support it. We’ll learn how to quickly find performance differences caused by query plan changes. Using a combination of discussion and demos, we’ll cover how you can use the Query Store to answer the question “Why was my query slow?”
