Jax Data

### Context Profile for Jax Data

1. **Organization Mission & Cause**:
   - **Mission**: Jax Data is dedicated to fostering a community around data technology, specifically through events like SQL Saturday. Their goal is to provide educational opportunities, networking, and resources for professionals in the data field.
   - **Cause**: The organization focuses on enhancing knowledge and skills related to the Microsoft Data Platform, aiming to make such learning accessible and free to the public.

2. **Type of Activities**:
   - **Events**: The primary activity is the SQL Saturday event, which is an annual conference that includes sessions led by industry experts, networking opportunities, and community engagement.
   - **Fundraising Campaigns**: They offer sponsorship opportunities for their events, which help sustain the free nature of the conference.
   - **Community Programs**: Involvement of volunteers is crucial, indicating a strong community-driven approach.

3. **Tone of Voice**:
   - The tone is **professional yet friendly**, aiming to be inclusive and engaging. The language is straightforward and informative, with an emphasis on collaboration and community support.
   - The content is structured to be clear and accessible, appealing to both sponsors and attendees.

4. **Emoji Usage**:
   - The website and recent communications do not prominently feature emojis. The tone remains formal and professional, focusing on clarity and information delivery without the use of casual elements like emojis.

5. **Key Facts**:
   - **Founding Info**: Jax Data is a 501(c)(3) nonprofit organization, indicating a commitment to charitable purposes.
   - **Scale**: The organization has hosted SQL Saturday events since 2006, with significant growth in attendance, making it one of the largest SQL Saturday events in the U.S.
   - **Impact Metrics**: The 2022-2024 events were noted as the largest SQL Saturdays globally, with over 750 attendees and 50+ sessions each year.
   - **Volunteer Info**: The organization relies heavily on volunteers to run events, highlighting community involvement and support.

6. **Writing Guidelines**:
   - **Style**: Maintain a professional and informative style, focusing on clarity and engagement. Use straightforward language that is accessible to a wide audience.
   - **Structure**: Use clear headings and bullet points where appropriate to enhance readability.
   - **Engagement**: Encourage community involvement and support, highlighting the importance of sponsors and volunteers in communications.
   - **Personalization**: Incorporate personalized greetings in emails, as seen in the thank-you email template, to create a more engaging experience for recipients.

This context profile provides a comprehensive overview of Jax Data, enabling AI assistants to generate tailored and effective content that resonates with the organization's mission and audience.

LXCL:1 Precon Ticket for Erik Darling

PreCon: Erik Darling - 1

You&rsquo;ve seen it before: the procedure that looks like it was generated by an AI trained on Stack Overflow and despair. It&rsquo;s got MERGE. It&rsquo;s got RIGHT JOINs. It&rsquo;s got logic so tangled you&rsquo;d need a flowchart, a flashlight, and a therapist to debug it. And now&hellip; it&rsquo;s your problem.<br style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" id="isPasted" fr-original-style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><br style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">In this full-day festival of query-fixing, Erik Darling leads you through the real world mysteries of advanced T-SQL: the strange, the slow, and the occasionally cursed. You&rsquo;ll tackle tangled paging logic, rescue window functions and indexed views from spools and spills, and finally learn when to keep a CTE and when to yeet it. We&rsquo;ll refactor data modifications that block like linebackers, decode procedural patterns, and write dynamic SQL that&rsquo;s powerful and polite.<br style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><br style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">You&rsquo;ll learn when to CROSS APPLY, dig into views vs. inline TVFs, and discover why RIGHT JOIN is not simply LEFT JOIN&rsquo;s syntactic twin. We&rsquo;ll uncover when user-defined functions wreck your query execution plans&mdash;and how to rewrite them with flair. If you&rsquo;ve ever been curious about why that query sometimes takes SO long and how to best rewrite it without just guessing, this is your playground.<br style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><br style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" fr-original-style="box-sizing: inherit; color: rgba(6, 19, 17, 0.75); font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Avenir Next&quot;, Avenir, &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, &quot;Helvetica Neue&quot;, Helvetica, &quot;Fira Sans&quot;, Roboto, Noto, &quot;Droid Sans&quot;, Cantarell, Oxygen, Ubuntu, &quot;Franklin Gothic Medium&quot;, &quot;Century Gothic&quot;, &quot;Liberation Sans&quot;, sans-serif; font-size: 17px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">Expect fast demos, big laughs, and a glorious cheat sheet to take home. Because refactoring SQL isn&rsquo;t just necessary&mdash;it&rsquo;s super fun when you&#39;re in the right party. Speaker Erik Darling started using SQL Server after a dispute with Excel over a vlookup. He enjoys public arguments with the optimizer, and wine photography.

<span contenteditable="false" data-custom-variable="{{firstname}}" fr-original-class="fr-deletable styled-tag-chip" fr-original-style="" style="background-color: rgb(248, 248, 255); border: 1px solid rgb(191, 191, 255); border-radius: 4px; color: rgb(42, 42, 196); padding: 1px 8px; font-size: 11px; display: inline-block; margin: 0px; overflow-wrap: anywhere; user-select: none; box-sizing: inherit;">First name, Thank you so much for registering for the Day of Data Jacksonville Pre-con!&nbsp; If you have any questions or need further information, please feel free to reach out.&nbsp; -The Jax Data Team

You’ve seen it before: the procedure that looks like it was generated by an AI trained on Stack Overflow and despair. It’s got MERGE. It’s got RIGHT JOINs. It’s got logic so tangled you’d need a flowchart, a flashlight, and a therapist to debug it. And now… it’s your problem. In this full-day festival of query-fixing, Erik Darling leads you through the real world mysteries of advanced T-SQL: the strange, the slow, and the occasionally cursed. You’ll tackle tangled paging logic, rescue window functions and indexed views from spools and spills, and finally learn when to keep a CTE and when to yeet it. We’ll refactor data modifications that block like linebackers, decode procedural patterns, and write dynamic SQL that’s powerful and polite. You’ll learn when to CROSS APPLY, dig into views vs. inline TVFs, and discover why RIGHT JOIN is not simply LEFT JOIN’s syntactic twin. We’ll uncover when user-defined functions wreck your query execution plans—and how to rewrite them with flair. If you’ve ever been curious about why that query sometimes takes SO long and how to best rewrite it without just guessing, this is your playground. Expect fast demos, big laughs, and a glorious cheat sheet to take home. Because refactoring SQL isn’t just necessary—it’s super fun when you're in the right party. Speaker Erik Darling started using SQL Server after a dispute with Excel over a vlookup. He enjoys public arguments with the optimizer, and wine photography.

Jax Data

Pre-con: Advanced T-SQL Triage: The Art of Fixing Terrible Code - Erik Darling - Day of Data - Jacksonville, 2026

1 UNF Dr. building 51

PreCon: Erik Darling - 1

$225