Indy.Code() Sessions tagged database

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

Hey, You Got Your TDD in my SQL DB!

When should we test our data? From an application development perspective, a unit test against a database isn't a unit test at all. Which makes sense -- connected systems introduce overhead and dependency, both of which reduce stability and decrease productivity during test-driven development (TDD). But if we wait for integration testing, critical functionality can get missed. In this session, we will discuss strategies for filling the data testing gap, directly within a Microsoft SQL Server environment. If you do a lot of work in T-SQL but aren't familiar with TDD, you'll learn the why and how of test-first development. If you're accomplished with unit tests, but never tried them in your database, you'll learn how to apply familiar concepts like setup, mocking, and assertion. We'll spend most of our time walking through a solution based on a real-world project, specifically using the open source tSQLt database unit testing framework.

Speaker

Jeff McKenzie

Jeff McKenzie

Practice Manager, Applications & Infrastructure, Insight Digital Innovation