Indy.Code() Sessions tagged sql server

New SQL Server Features for Developers

Latest SQL Server versions added many new features and services to its database engine. I will cover the latest features of SQL Server 2017 and 2019 for developers in this session. Don't miss it!

Here is the list of features I will cover in this session.

  • Using Graph Tables in SQL Server
  • Temporal Tables for Auditing
  • How to run R Script, Python and Java in SQL Server
  • Using Clustered Columnstore Indexes
  • Using Memory Optimized Tables
  • jSON in SQL Server

Speaker

Hasan Savran

Hasan Savran

BI Architect, Progressive Insurance

How to use GeoSpatial Data in SQL Server

If you are interested in learning more about Spatial Data but don’t know where to start, this session is for you. We will begin by focusing on what Spatial Data is through examples and interactive demos. The goal is to show how Spatial Data can improve your professional experience and serve as an asset to your business.

I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017.

Join me as we explore how to use SQL server to handle your Geospatial data needs.

Speaker

Hasan Savran

Hasan Savran

BI Architect, Progressive Insurance