Brandon Tucker
Principal Solutions Architect, SolarWinds
Denver, Colorado, United States
Actions
Brandon Tucker is a data geek and has engaged SQL Server as an architect, developer, data engineer, and administrator over the last 18 years. He loves solving complex, real-world data problems, applying them in business situations, then sharing the knowledge to benefit the community. Brandon has served on the board for the Denver SQL Server User Group and presented at PASS Summit and numerous SQL Saturdays, User Groups, and Code Camps. Brandon is a Principal Solutions Architect for database products at SolarWinds, where he dives deep into technical challenges and drives product innovation.
When not wrangling data, Brandon can be found cycling/backpacking/skiing in his home state of Colorado, cheering on the Avalanche, or talking world travel over drinks.
Area of Expertise
Topics
A Beginner’s Guide to Query Store
Like many others, you installed SQL Server 2022, created a new database, and suddenly saw this new “Query Store” node. Where did that come from and what do I do with it?! Fret not, Microsoft wouldn’t put it in there if it wasn’t helpful for us? Right? Right! Even though Query Store was introduced in SQL Server 2016, SQL Server 2022 took it a step further for it to be enabled for new databases. Because of this, every DBA and DB developer will want to have a cursory knowledge of what it is and what value it can provide.
In this talk, we’ll teach you how to work with Query Store and begin to leverage the treasure trove of information that it contains. We’ll start by introducing the high-level concepts of Query Store and how it works in your SQL Server 2022 databases. Once we set the foundation, a straightforward UI demo will walk through how Query Store can be configured and optimized. Lastly, we’ll explore the variety of reports and queries available to us to dive into the high-value data that’s being collected.
Come join us to level up on your SQL Server 2022 knowledge by understanding how Query Store can help understand your environment better!
High Availability Alphabet Soup - FCI, AG, DAG, & RSAG
SQL Server has amazing tools for business continuity. The variety and scope of these tools can be overwhelming to even seasoned database administrators and architects, but the implementation has only gotten better/easier over the years.
In this talk, we’ll introduce the solutions available from both a high availability and disaster recovery perspective. After the introduction, we’ll set up a variety of sample environments to demonstrate value of the solution. Lastly, we’ll discuss the pros, cons, and use cases for the specific technologies available.
Come join us as we explore the wide world of high availability / disaster recovery (HADR) technologies in the world of SQL Server.
Building Your First Clusterless Availability Group On Metal, VMs, Cloud, Or All Three!
Building your first availability group can seem like a daunting task. Terms such as “Windows Server Failover Cluster”, “quorum”, “file share witnesses”, and “database containment” weren’t taught to us in DBA school. Enter SQL Server 2017+. We can now put those scary terms aside and create availability groups that don’t have to reside on a cluster.
In this talk, we’ll teach you how to create your first availability group without having to buy your server admins* a meal. We’ll start by teaching you how to “talk the talk” of availability groups. Once we set the foundation, a straightforward UI demo will walk through the steps needed to create your first availability group. After the databases are flowing, we’ll discuss how on-prem/bare metal, virtual/VM, and cloud offerings can all be leveraged to support your hybrid deployment.
Come join us for a fun, light-hearted, and welcoming approach to the world of high availability/disaster recovery on SQL Server!
*Disclaimer: you might enjoy this session so much that you might want to make good friends with your server admins.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top