• Finding Islands, Gaps, and Clusters in Complex Data by Edward Pollack

    Link visible for attendees

    #### Description

    Being able to group data into logical and meaningful sets can be extremely useful. When the data involved is a non-repeating sequence of integers, grouping is not too difficult. Most real data, though, is made up of dates, times, decimals, and rarely can guarantee non-repeating, non-null data sets.

    This is a fast-paced session that delves into methods that can be applied to any data. Want to know how many production incidents make up a single common problem? Can we track sales success by the number of consecutive weeks that an agent has exceeded their goal? How about the longest home run streak hit by Derek Jeter at night games on Tuesdays?

    Discussion will include performance, CTEs, recursion, set-based vs. iterative analysis, and some pretty hairy TSQL!

    ### Edward Pollack

    Sr. Database Administrator, Datto Inc.

    Ed Pollack has 20+ years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and security. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.

  • Locking Down Azure Synapse Analytics by Kevin Feasel

    Link visible for attendees

    #### Description

    Azure Synapse Analytics is a complex system, combining dedicated SQL pools, serverless SQL pools, Spark pools, and more. With such a broad scope, it can be difficult to understand what you need to secure and how you can lock it down. In this talk, we will first review the Azure Synapse Analytics surface area. Then, we will introduce settings and procedures to protect data at rest, in transit, and during processing. Finally, we will review several tools you can use to increase your security posture and reduce the risk of data exfiltration.

    ### Kevin Feasel

    CTO @ FareGame Inc

    Kevin Feasel is a Microsoft Data Platform MVP and CTO at FareGame Inc, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

  • Sensitivity labels - what do they look like by Heidi Hasting

    Link visible for attendees

    Like me you may have heard about sensitivity labels but what does that mean to your reports, data or documents. Some of the questions this session will answer;

    - what do they look like in Power BI
    - what do they look like in Azure Purview
    - what do they look like in 0365
    - how to maintain and manage them

    In this session we will go through setting up sensitivity labels and see them across multiple platforms (Power BI, Azure Purview).

    Bio
    Heidi Hasting is a Business Intelligence professional and former software developer with over seven years experience in Microsoft products. She is an ALM/DLM enthusiast and Azure DevOps fan and co-founder and organiser of the Adelaide Power BI User Group. Heidi is a regular attendee at tech events including Azure Bootcamps, DevOps days, SQLSaturdays, Difinity and PASS Summit.