Hasan Savran

Information & Communications Technology

Databases Azure CosmosDB GeoSpatial Data SQL Server Programming IoT Iot Edge

Akron, Ohio, United States

Hasan Savran

BI Manager

Hasan Savran is Microsoft Data Platform MVP and Microsoft Certified Solutions Developer. He works at Progressive Insurance as a Business Intelligence Manager. He spends his days architecting cutting edge business solutions by using the latest Web and Database technologies.
Hasan has spoken at many SQL Saturdays, Code Camps and User groups. He is an active member of the HTML5 and WebAssembly W3C groups. He likes to write about SQL, CosmosDB, C#, and Front End development on his blog.

Current sessions

Starting with Azure SQL Edge on Raspberry Pi

Azure SQL Edge is a containerized application that runs on either an ARM64 or an x64-based processor. SQL Database Edge is optimized specifically for IoT and edge workloads running on resource-constrained interactive devices such as cameras, scanners, IoT gateways, and light-weight edge servers.

You need to be familiar with many different technologies to make Azure SQL Edge work. We will start with the history of IOT and continue with available Azure IOT features you need to use to install Azure SQL Edge into an IOT device. We will explore Linux tools and command that you need to know to enable IOT functionalities of your device.

Hasan will share his experience with installing and connecting Azure SQL Database Edge to Raspberry Pi.


A to Z Cosmos DB

Azure Cosmos DB is battle tested non-relational database service by Microsoft. It is used by many mission critical applications, including Xbox, Office 365, Azure and Skype.

This workshop will help you take a more in-depth look at Azure Cosmos DB's architecture, features and tools. We will start with an overview of Azure Cosmos DB's infrastructure and architecture, then explore its main features and benefits. Additionally, we will use Cosmos DB Emulator for development purposes. In addition, we will look at the Data Migration tool to import and transform data as well as cover stored procedures, available SDKs, and Rest API of Cosmos DB. For the closing of this session we will configure Change Feed functionality using Azure Functions.



Contents:

History, Infrastructure and Architecture of Cosmos DB
What does Multi-Model mean?
Understanding Consistency Levels
Why Partitioning is crucial?
Managing Indexes in Cosmos DB.
Cosmos DB Constraints
Pricing
Using Cosmos DB Emulator
Querying Cosmos DB with SQL API
Setting up TTL


Data Type Problems of JSON
Creating Stored Procedures
How to Import&Transform Data
Available SDKs and Rest API
Spatial Data in Cosmos DB
Configuring Change Feed
Using Vs Code extension with Cosmos DB
Connecting to Cosmos DB From Sql Server 2019


How does Azure Cosmos DB work under the hood?

To master any technology, you need to understand the foundation of how it works on the back-end first. In this session; We will explore Azure Cosmos DB's infrastructure. I will explain you how Azure Cosmos DB works and handles data in the back-end. We will cover the basics and some of the most misunderstood features of Azure Cosmos DB.
Learning new technologies make you a better leader and collaborator. Join me to learn more about this new Cloud Database technology.


What do Graph Tables bring to the table

There are many ways to represent data. Most of us stuck with Relational Database Data Models and we don't feel comfortable when data gets represented in different ways.

Graph Processing Tables is yet another way to represent data, it can change the way you look at the data. Relational Databases don't adapt well to changes. Adding a new domain or relation to your data model should not be that difficult. You want to create flexible data models that evolve with your business process.

Join me to learn how to create flexible data models with Graph Database tables.

Join me to learn what can Graph Database Tables can do for your projects.


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 demo’s. 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.

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


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


Second Look: Azure Cosmos DB

You know what Azure Cosmos DB is and you want to learn more about its features and functionalities. We will start with importing data from SQL Server to CosmosDB Emulator. Then, you will learn how to interact with the CosmosDB Emulator by using the Cosmos DB SDK 3.0, REST API by using POSTMAN, and SSMS.
We'll look closely at Time To Live function, execution metrics and query processor engine.
We'll examine the index policies and create a custom index policy to save you money(R/U)!
At the end of this talk, you will have a better idea how to handle and use available CosmosDB features.


Unexplored Features of SQL Server

Every new version of SQL Server adds new features, some of these features are rarely highlighted. Join me for this practical session which focuses on some of the less-popular but useful features of SQL Server.
We will start with exploring the hierarchyid, geometry and geography data types of SQL Server. Next, we will look at the Temp tables and teach you how to cache Temp tables for better performance. We will cover sparse, rowversion columns and finish the session off by showing you how to remove ORM from web applications by utilizing JSON functions in SQL Server.


Past and future events

datasaturdays.com Pordenone 2021 #0001

26 Feb 2021

Azure Houston

Starting with Azure SQL Database Edge on Raspberry Pi
25 Feb 2021
Houston, Texas, United States

Boston Azure

How does Azure Cosmos DB work under the hood?
23 Feb 2021
Boston, Massachusetts, United States

Triangle SQL Server User Group

Starting with Azure SQL Edge on Raspberry Pi
9 Feb 2021
Durham, North Carolina, United States

SQL Server Virtual Conference

29 Jan 2021 - 30 Jan 2021

Data Platform Summit

A to Z Azure Cosmos DB PreCon
What does Graph Tables bring to Table
2 Dec 2020 - 7 Dec 2020
Bengaluru, Karnataka, India

SQL Saturday Montreal

How does Azure Cosmos DB work under the hood
21 Nov 2020
Montréal, Quebec, Canada

Momentum 2020

16 Oct 2020
Cincinnati, Ohio, United States

Data Platform Virtual Symposium

How does Azure Cosmos DB work under the hood
8 Oct 2020
Bengaluru, Karnataka, India

Tech Con '20

30 Sep 2020 - 1 Oct 2020
Detroit, Michigan, United States

SQL Bits

A to Z Azure Cosmos DB Workshop
New features of SQL Server for Developers
29 Sep 2020 - 3 Oct 2020
London, England, United Kingdom

SQL Saturday Denmark

How does Cosmos DB works
26 Sep 2020
Copenhagen, Capital Region, Denmark

Baltimore Database User Group

New SQL Server Features for Developers
17 Aug 2020
Baltimore, Maryland, United States

Sql Saturday New Zealand

How does Azure Cosmos DB work under the hood?
8 Aug 2020
Auckland, New Zealand

LightUp

14 Jul 2020 - 15 Jul 2020

Boston Business Intelligence User Group

CosmosDB Under The Hood!
7 Jul 2020
Boston, Massachusetts, United States

CFS - Global 2020 Summer Azure DataFest

2 Jul 2020
Reston, Virginia, United States

Data Architecture Day 2020

16 May 2020

SQL Saturday Nashville

CosmosDB is the missing piece to your Data puzzle!
18 Jan 2020
Nashville, Tennessee, United States

Global AI Bootcamp

14 Dec 2019

dev up Conference 2019

14 Oct 2019 - 16 Oct 2019
St. Louis, Missouri, United States

SQL Saturday NYC

Unexplored Features of SQL Server
5 Oct 2019
New York City, New York, United States

SQL Saturday Boston

Unexplored Features of SQL Server
14 Sep 2019
Boston, Massachusetts, United States

Music City Tech 2019

5 Sep 2019 - 7 Sep 2019
Nashville, Tennessee, United States

SQL Saturday Sacramento

How to use GeoSpatial Data in SQL Server
Cosmos DB was the missing piece to my Data puzzle!
17 Aug 2019
Sacramento, California, United States

SQL Saturday Louisville

Cosmos DB was the missing piece to my Data puzzle!
3 Aug 2019
Louisville, Kentucky, United States

SQL Saturday Austin

CosmosDB is the missing piece to your Data puzzle!
13 Jul 2019
Austin, Texas, United States

SQL Saturday Dallas

How to use GeoSpatial Data in SQL Server
1 Jun 2019
Dallas, Texas, United States

SQL Saturday Atlanta

Title : Not your Dad's SQL Server; Contemporary twist on a classic standby.
I spoke about the new features of SQL Server 2017 & 2019
11 May 2019
Atlanta, Georgia, United States

Indy.Code

New SQL Server 2017 Features you need to know.
Using Spatial Data in SQL Server
24 Apr 2019 - 26 Apr 2019
Indianapolis, Indiana, United States

SQL Saturday Orange County

Not your dad's SQL server; Contemporary twist on a classic standby.
13 Apr 2019
Huntington Beach, California, United States

SQL Saturday Chicago

Not your dad's SQL server; Contemporary twist on a classic standby.
23 Mar 2019
Chicago, Illinois, United States

SQL Saturday Cleveland

Building Scalable, Globally Distributed Systems with Cosmos DB
2 Feb 2019
Cleveland, Ohio, United States

SQL Saturday Nashville

Reasons to upgrade to SQL Server 2017
12 Jan 2019
Nashville, Tennessee, United States

SQL Saturday Washington DC

What's new in SQL Server 2017
8 Dec 2018
Washington, D.C., United States

Code Camp NYC

Building Scalable, Globally Distribued Systems with Cosmos DB
20 Oct 2018
New York City, New York, United States

SQL Saturday Pittsburgh

Introduction to Spatial Data with the help of SQL Server 2016/17
29 Sep 2018
Pittsburgh, Pennsylvania, United States

SQL Saturday Boston

What's new in SQL Server 2017
22 Sep 2018
Boston, Massachusetts, United States

SQL Saturday Indianapolis

Intoduction to Spatial Data with the help of SQL Server 2016/17
11 Aug 2018
Indianapolis, Indiana, United States

SQL Saturday Sacramento

What's new in SQL Server 2017
28 Jul 2018
Sacramento, California, United States

SQL Saturday NYC

What's new in SQL Server 2017
19 May 2018
New York City, New York, United States

SQL Saturday Wheeling

What's new in SQL Server 2017
28 Apr 2018
Wheeling, West Virginia, United States

SQL Saturday Rochester

What's new in SQL Server 2017
How to use Spatial Data in SQL Server
24 Mar 2018
Rochester, New York, United States

SQL Saturday Cincinnati

What's new in SQL Server 2017
17 Mar 2018
Cincinnati, Ohio, United States

SQL Saturday Cleveland

What's new in SQL Server 2017
3 Feb 2018
Cleveland, Ohio, United States