The PASS Application Development VG is a developer community with free training and information for developers working with data.

Welcome & Updates

Welcome to the Application Development Virtual Group!
We are delighted to share expert teachings and knowledge with our community. Please join us! There is no cost to join. We offer free training at your fingertips.

Please subscribe to our YouTube channel, connect with us on LinkedIn, follow us on Twitter or reach out to us via email.

View past recordings to brush up on a skill or to learn new skills. Our presenters typically share their presentation content and code examples after the presentation. Presentations are demo heavy for our technical audience of mostly developers.  We welcome novice, expert and no-code developers.  We encourage you to get hands-on with the code examples and share your findings.

Upcoming Events

How to Use Parameters Like a Pro and Boost Performance

Mon, Jul 28 2014 18:00 UTC

How to Use Parameters Like a Pro and Boost Performance

Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren't aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance. In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.


Guy Glantser

Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS local group and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids