The Triad SQL Server Users Group (TSSUG); is a forum where Microsoft SQL Server database administrators and developers meet to learn more about the product, share ideas and make contact with other similar individuals. Our group is run by SQL Server professionals for the benefit of anyone interested in participating in the group.
 
All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Our meetings are generally held on the last Tuesday of every other month, unless otherwise noted. Food is no longer being provided, however you are welcome to bring in your own.
 Announcements
Discount Code for Summit 2016 - Sunday, April 17, 2016

Going to Summit this year?  Use our chapter discount code to get a $150 discount on your registration fee.  Our discount code this year is

LC15NHK8 

http://www.sqlpass.org/summit/2016/welcome.aspx

 
 EventDisplay

Next Meeting: Tue, Sep 27 2016

Kevin Feasel presents APPLY yourself

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://www.meetup.com/Triad-SQL-Server-Users-Group/events/231361934/

Bi-Monthly Meeting

When

iCal
UTC : Tue, Sep 27 2016 22:00 - 00:00
Event Time : Tue, Sep 27 2016 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Tue, Sep 27 2016 22:00 - 00:00

Where

4821 Koger Blvd
Greensboro, North Carolina

Direction: None

Featured Presentation

APPLY yourself

Speaker: Kevin Feasel, Database Engineer Catallaxy Services

Summary: 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 Kevin: Kevin Feasel is a Data Platform MVP and database engineer with Catallaxy Services, where he specializes in T-SQL and SSIS development, performance tuning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (curatedsql.com) and a contributing author to Tribal SQL (www.tribalsql.com). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

Attachments