Steven Wright
SolarWinds Senior Database Solutions Architect
Charlotte, North Carolina, United States
Actions
Steve has over eighteen years of tenure with SentryOne/SolarWinds in roles with Solutions Engineering, Quality Assurance, Product Management, and Advanced Analytics. He has over twenty years of experience working with the Microsoft Data Platform with multiple certifications including,
Microsoft Professional Program, Data Science Certification and Azure Certified Data Engineer Associate.
Links
Area of Expertise
Topics
So you want to be a Tuner? An introduction to SQL Query Plans
This session is aimed at junior data professionals that are interested in leveling up from backups and index maintenance to query tuning and optimization. We'll walk through SQL Execution Plans, how to interpret them, how to find the best opportunities for performance gains, and how to achieve them.
Troubleshooting common issues with Synapse Dedicated SQL Pools
In this session, we'll walk through the basic MPP architecture of Azure Synapse Dedicated SQL Pools, formally known as Azure SQL Data Warehouse. We'll then describe some common performance issues that can impact effective use, how to identify them in your environment, and options to resolve them.
The Proper Care and Feeding of Columnstore Indexes
Columnstore indexes can provide a significant improvement in query performance over several use cases. In fact, when properly applied and maintained, they can provide up to 100x improvement in workload performance along with up to 10x better compression than rowstore indexes.
This session will give a brief review of the architecture of columnstore, along with ideal use cases. We'll then cover requirements to get the optimal performance from them, common issues to watch for, and how to prevent or resolve those issues.
Beyond SQL Server, we'll talk about how some of these principles can extend to Synapse, Power BI, and even SSAS!
Steven Wright
SolarWinds Senior Database Solutions Architect
Charlotte, North Carolina, United States
Links
Actions
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