Steven Wright
STEM, Data, and AI Educator and Consultant
Charlotte, North Carolina, United States
Actions
Steven Wright is a seasoned technology professional with over two decades of experience in the software and data industry. As a former Field CTO, Steven has built his career at the intersection of database performance, artificial intelligence, and STEM education. Now in a post-retirement phase, he focuses on helping others navigate technological change and discover new opportunities in evolving job markets.
An active mentor and supporter of startups, Steven is deeply committed to community initiatives. With a knack for making complex topics accessible and a genuine enthusiasm for helping others succeed, Steven’s presentations are both insightful and inspiring.
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
STEM, Data, and AI Educator and Consultant
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