Join for free and connect with our local tech scene

Stay on top of the latest companies and upcoming events with our weekly newsletter, and be counted among the people building the future of your local tech community.

Cleveland, OH /

"Query Tuning Without Admin Access" By Bert Wagner

Auditorium 5990 West Creek Road , Independence , oh 44131 (map)

Description: The perennially frustrated Bert Wagner ("What do you mean I can't add an index?!") will show you how to identify query patterns that are suitable for rewriting in order to improve query performance. We will look at how changing ORs to UNION ALLs, subqueries to derived tables, and many more refactoring patterns can help you achieve faster query executions without modifying existing database objects.

Bio: Bert Wagner teaches data-focused developers how to use SQL Server efficiently every week on his YouTube channel “SQL with Bert.” When not filming episodes, he gains inspiration for his content through his work as a Principal Business Intelligence Developer for Progressive Insurance in Cleveland, OH. Starting his career as an SSIS and SSRS developer, Bert fell in love with SQL Server query writing and performance tuning. Nowadays he focuses on full stack web development and uses his database tuning skills to ensure that his applications run at peak performance.

Contact: Sam Nasr ([masked])

Cost: Free (Open to the public). Feel free to invite a friend!

Refreshments: Food and drinks courtesy of Inedo (https://inedo.com)

Networking: Feel free to join us afterwards at Slyman's Tavern (6901 Rockside Rd, Independence, OH 44131) for some refreshments while talking shop and socializing.

Submitted by

Sadukie Sarah Dutkiewicz

Comments

Sign in to comment.