Hasan Savran | SpeakerHub

Personal Details

Bio

Hasan Savran is a BI Architect at a major Insurance company in USA. He has a unique 15+ year background in Information Technology and Business Intelligence systems. He is a Microsoft Certified Solutions Developer and the Vice President of PASS North Ohio Local Group. Hasan is a frequent speaker at SQL Saturdays and he is active member of the HTML5 and WebAssembly W3C groups. Hasan likes to write about SQL Server, Cosmos DB, C#, and CSS in his blog.

Current position (1)

BI Architect

Progressive Insurance

Degrees (1)

Computer Science

Kent State University

1998 to 2000

Presentations

Presentations (4)

What's new in SQL Server 2017

I cover the following features.
Linux Support
Graph Tables
Intelligent Query Processing
Resumable Online Index Rebuild
How to run R/Python with Machine Learning Services
In-Memory Tables (NoSQL in SQL Server)

Using Spatial Data in SQL Server

Agenda
What is Spatial Data
Available SQL Server Spatial Data types/Objects
Common SQL Server Spatial Functions
Definition of Spatial Reference Identifier.
Selecting right Spatial Data type
How to find distance between two points in SQL Server
How to search by radius in SQL Server
Common Spatial Formats
How to import Spatial Data into SQL Server Database free
Use SQL Server 2016 to create GeoJSON
Use SQL Server 2017 to cache Spatial Data

Building Scalable,Globally Distributed Systems with CosmosDB

Agenda
Why do we need another database system?
How to setup Cosmos DB
How much does it cost?
Multi-Model Apis
Cosmos DB vs SQL Server
How to Import Data
How to use Cosmos DB Emulator
Cosmos DB Limitations

The Evolution of Database

Evolution is happening all around us. The next version of SQL Server is just around the corner and it comes with a lot of new features and changes. The gap between capabilities of SQL Server and knowledge of data professionals about SQL Server capabilities is widening.

I cover the following topics in this session :

What triggers evolution in technology?

Columnstore Indexes with LOB support

NoSql in Sql Server with JSON

Graph Databases

In-Memory tables

Machine Learning Services

Query Processing Engine upgrades

What is Azure Cosmos DB?

Cosmos DB vs SQL Server

Past talks (19)

How to use GeoSpatial Data in SQL Server