What we're about

Welcome to the Triangle SQL Server User Group (TriPASS)! We are an active group of SQL Server professionals that meet monthly for formal presentations on many SQL Server topics. We cover everything from database design, development, deployment, performance, and IT support. We also Business Intelligence topics like data warehousing, reporting, ETL and Big Data. Visit us at our monthly meetings where our sponsors always provide us with free food and beverages. Many times we will have a raffle for books and other items provided by our sponsors.

Upcoming events (2)

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.

Photos (54)