Sacramento SQL Server User Group

You’re staring at a query that’s slower than molasses uphill in January. Execution plans, cardinality estimates, indexes — where do you even start? In this session, we’ll walk through a real-world performance tuning triage process: from identifying slow queries to fixing the actual root cause. No theory, just sweat, execution plans, and the occasional optimizer tantrum.

As a former DBA with earlier experience in SQL, SPL, Unix shell scripting, Perl, and C, I was frustrated with the existing applications for logging my food intake. Overloaded interfaces, missing nutrients (e.g., phosphorus), inflexible inputs all made for a less-than-desirable user experience. Being inactive and rusty in development, I needed a bridge to allow me to bring my experience and vision to fruition using modern tools.

Turning to AI, I've created an app tailored for my needs. I'll walk you through my journey, highlighting the various areas/tools I used:

Development environment (Flutter + Dart)
Data modeling and storage
State management
UI

We'll go through a lessons learned and all the surprises that came along the way.