talk-data.com
People (1 result)
Activities & events
| Title & Speakers | Event |
|---|---|
|
APPLY Yourself ~ Kevin Feasel
2023-07-11 · 16:00
WHEN: Tuesday, July 11, 2023, 1600 GMT (Change from our standard Wednesday meeting) DESCRIPTION of TALK APPLY Yourself Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator. ABOUT THE SPEAKERS 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. |
APPLY Yourself ~ Kevin Feasel
|