San Antonio SQL Server User Group

 

Welcome to SALSSA 

San Antonio League of SQL Server Administrators

Our regular monthly meetings occur on the 3rd Wednesday of each month from 6pm - 8pm. Pizza and drinks are provided at the beginning of the meeting. We meet at New Horizons Computer Learning Center located at

New Horizons Computer Learning Center

2727 NW Loop 410
San Antonio, TX 78230

For any questions please email salssa@sqlpass.org 


Next Meeting

Wednesday,

April

19

April Meeting

  • In-Person @ 2727 Northwest Loop 410 #103 San Antonio, Texas, United States (map)
  • 18:00 - 20:00 Central Daylight Time
  • Language: English

Speaker: Thomas Higginbotham

Bio: 

Thomas is a data engineer with an independent oil and gas exploration company in San Antonio. He got started as a Navy Data Processing Technician in 1988. After a decade working in PC support, he began working with reports. He has been working with SQL Server since 2005, and the R language since 2015.

Topic:

SQL Server R Services – What It Is and Why You Want It

You can do a lot of things with T-SQL but it can be difficult to do some things that ought to be very simple. For example, making several changes to a result set without having to re-run the query repeatedly. Or pivoting a result when you don’t know exactly what the column labels should be. Or generating a history with start and end dates for each row. Some things just haven’t been possible with T-SQL, like scraping data from websites into a table.

In SQL Server 2016, Microsoft introduced SQL Server R Services. R is an excellent language for data manipulation. This presentation will introduce the R language, compare some SQL and R data wrangling techniques, and show how to run R scripts in SQL stored procedures.

• Pizza and soft drinks provided

• RSVP is not necessary but nice so we know how much food to get, please come if you can 

Featured Presentation:

SQL Server R Services – What It Is and Why You Want It

Thomas Higginbotham, Data engineer Cardinal Data

You can do a lot of things with T-SQL but it can be difficult to do some things that ought to be very simple. For example, making several changes to a result set without having to re-run the query repeatedly. Or pivoting a result when you don’t know exactly what the column labels should be. Or generating a history with start and end dates for each row. Some things just haven’t been possible with T-SQL, like scraping data from websites into a table. In SQL Server 2016, Microsoft introduced SQL Server R Services. R is an excellent language for data manipulation. This presentation will introduce the R language, compare some SQL and R data wrangling techniques, and show how to run R scripts in SQL stored procedures.

About Thomas:
Thomas is a data engineer with an independent oil and gas exploration company in San Antonio. He got started as a Navy Data Processing Technician in 1988. After a decade working in PC support, he began working with reports. He has been working with SQL Server since 2005, and the R language since 2015.

Supplementary Materials

The following event attachments are available to you:

PASSChapterLogo.jpg

sql_micro_sm.gif

SQL Watchmen

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids