Speaker Series - January 2022 - Advanced SQL Server Database Topics

Advanced SQL Server Database Topics

Presentation Outline:

Building on the past presentation, Enterprise Database Tips and Tricks, this presentation will be a deeper dive into the following topics and will include many code templates and examples:

1. Triggers -
   • Rules, uses, tips and considerations accompanied with a demonstration in ArcGIS Collector
2. Spatial and non-spatial Views
   • Creating a spatial view in SQL Server
   • Creating non-spatial views
   • Use case examples
3. Integrating your GIS data with SQL Server Reporting Services
   • Using the Visual Studio shell
   • Simple report design
   • Calling a report from your GIS data

John May started his GIS career with the US Forest Service in 1989. Since that time he has started a GIS lab for the University of Georgia, been a corporate GIS director for a national engineering firm, and operated as a hired gun for many different clients and projects.

REMINDER: URISA TX OFFERS 1 CREDIT HOUR PDH CERTIFICATES FOR PARTICIPANTS WHO REGISTER AND ATTEND THE MONTHLY SPEAKER SERIES WEBINARS!

To Join:

Zoom info will be available upon registration.

In order to receive a PDH certificate each participant must register for the event.
Certificates will not be issued to those who have not.

A Big THANK YOU to our sponsors!

The Speaker Series would not be possible without you!

ALLTERRA

ATMOS ENERGY

Presentation Chat Questions: Questions Answered 

Presentation Slide Deck: Slide Deck

Presentation Video: Video Link