Our September meeting will again be online. NOTE: you MUST RSVP to this Meetup (https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/272490472/) to view the Zoom URL!
Our September guest speaker is Mindy Curnutt!
Topic: An Introduction to using the Spatial Data features within SQL Server
Over a decade ago Microsoft added the capability to store and work with geometry and geography data types. (Wait…what’s this you say?!?) Well, yes…it’s been there for quite some time now. You can actually store spatial data in SQL tables (in the form of points, lines and polygons). There are also many powerful, built-in functions that allow the manipulation and calculation of results around this data. This is a powerful, but sadly underused feature of the product given that IoT tends to be so focused around the location of things.
Come to this session to learn about:
- The two elusive data types (geography and geometry)
- How to load spatial data
- Where you can get lots and lots of free spatial data to supplement your existing systems
- See an example of real-world Spatial data in use (aggregating truck positions for tax calcs)
- Write a SQL query from a bitmap picture (pure amusement)
You will learn:
About two special data types, geography and geometry
- Understand the different spatial routines and functions, what they do, what type of result they return, and how you would use each
- Watch a real world business case where using spatial data made things so much easier
Mindy Curnutt is 7X Microsoft Data Platform MVP, Friend of Redgate and Idera ACE Alumni. She has been actively involved in the SQL Server Community for nearly two decades, presenting at various User Group Meetings, SQLPASS Summits, as well as Conferences & SQLSaturdays across North America. For two years, she was a Team Lead for the SQLPASS Summit Abstract Review Process and for years served as one of the 3 SQLPASS Summit Program Managers. She was a SME for SQL 2012 & 2014 MS SQL Server Cert Exams and helped to author the MS Press Book “SQL Server 2014 – Step by Step”, co-authored “Voices from the Data Platform” and “SQL Server 2017 Administration Inside-Out” and in 2018 was featured in the book “Data Professionals at Work”. In 2018 Mindy was the VP of Strategic Partnerships for the Non-Profit Girls+Data (www.girlsanddata.org) which strived to bring awareness about careers in Data Science and Analytics to young women in Junior High School (ages 10-14). She was the President of the N Texas SQL Server User’s Group from 2017-2020. In 2020 she was elected to serve on the Board of Directors for PASS.
Mindy serves as a mentor to others, (particularly the Transportation & Logistics industry), helping to educate and promote scalable and sustainable SQL Server architecture and design. She is passionate about Data Security, Accessibility, Usability, Scalability, and Performance. Mindy Curnutt is an Independent Consultant. You can follow Mindy at her blog, curnuttdatasolutions.com and on Twitter where she’s known as @sqlgirl
Our online meeting schedule is as follows:
6:00: General chat, discussion, and announcements
We usually wrap up between 7:30 PM and 8:00 PM.
Please RSVP to this Meetup, then use the online event URL to join (note: you MUST RSVP for the URL to be visible). We will send out a meeting password as we get closer to the event.