March 15, 2023 Meeting

By with 0 Comments

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

Anything But: Troubleshooting When it’s Not SQL Server

Here we go again: the SQL Server is slow but where is the problem? Is there a large blocking chain or a high number of deadlock events? Maybe it is a slow query using a large number of resources? Does the query have a non-optimal execution plan? Many times as a DBA, we ask these same questions and answer NO to all of them because the performance issue is outside of SQL Server. In this session, we will focus on troubleshooting all of the typical issues that are not SQL Server-related but impact SQL Server. We will explore troubleshooting virtualization, storage, memory, CPU, OS, and networking issues.

Ben DeBow

Ben DeBow is the Founder and CEO of Fortified and has more than 25 years of experience designing, scaling, and implementing on large data implementations around the world. At Fortified, Ben is responsible for the Product Strategy and being an industry thought leader around data platforms. He is an author and speaker at many industry conferences in his spare time, he volunteers with many environment organizations and is a part time BBQ judge.

February 15, 2023 Meeting

By with 0 Comments

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

SQL Server Authentication and Authorization In-Depth

Authentication and authorization – better known as logins, users, roles, and permissions – are foundational concepts in SQL Server security. While simple in nature, their flexibility can make them complex to implement, leading many DBAs and developers to take shortcuts that compromise their databases’ security. We’ll dive deep into this topic in this session so you can get to know these basic building blocks better and learn how to avoid some common mistakes. We’ll also take a look at the latest innovations in SQL 2022 that finally close some long-time gaps in the security model.

Ed Leighton-Dick

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including roles as regional mentor, chapter leader of I-380 PASS SQL Server User Group, and organizer of SQLSaturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.