Hasan Savran
Ms Data Platform MVP, Owner of SavranWeb Consulting, Sr. Business Intelligence Manager at Progressive Insurance
Akron, Ohio, United States
Hasan is an expert in Azure Cosmos DB and has been honored as a Data Platform MVP by Microsoft. He is the proprietor of SavranWeb Consulting and holds the position of Senior Business Intelligence Manager at Progressive Insurance. His work involves designing advanced business solutions with the newest technologies in web and databases. With more than two decades of experience in software as a developer, architect, and manager, Hasan is a seasoned professional. He is a global conference speaker and enjoys blogging about SQL, Azure Cosmos DB, C#, and front-end development.
Links
Area of Expertise
Topics
SQL Server vs Azure Cosmos DB
Do you need to move your legacy application to the cloud? or maybe you need to select a database for a new cloud project. This session will help you by comparing the functionalities of Azure SQL and Azure Cosmos DB in detail.
We will start the session by explaining the differences between distributed databases and centralized databases. We will compare indexing, stored procedures, partitioning, constraints, and scaling in these two great products. Next,
We will explore the available tools and languages to query and maintain the Azure Cosmos DB. Finally, we will compare the query optimization engine and execution plans between the two database engines.
This session will help you to understand and make the right decision for your upcoming cloud projects.
This session brings SQL Server and Azure Cosmos DB side-by-side and compares the two products in detail.
Caching Data in SQL Server with In-Memory and JSON
Caching data is an important concept of successful projects. If your data does not change that much, cache it! Do not try to select same data repeatedly. There are many products can help you with caching. Usually, these products are not free, and you may need to learn a new language or technology to use them.
You can easily create powerful cache system by using JSON and In-Memory tables of SQL Server. Please join me as we create a NoSQL Cache solution by using only SQL Server.
Azure Cosmos DB Partitioning 101
If Azure Cosmos DB were a car, partition key would be its oil. You better pick the correct one if you want a smooth ride. Choosing wrong partition key is one of the most common mistakes which produces high-cost solutions.
In this session, we will cover Physical and Logical partitions of Azure Cosmos DB. You will learn how to select the correct partition key for your projects.
Ways to connect Azure Cosmos DB and cache data
Azure Cosmos DB is a fully managed service that takes database administration off your hands. Fully Managed Database sounds good, but developers end up with some of the database administration work anyway.
Selecting a connection type is one of the database administration work you need to do. We will explore different ways to connect Azure Cosmos DB in this session. The goal is to show you the advantages of each connection type. Next, we will cover couple of SDK tips to keep your Azure Cosmos DB solutions fast.
Please join me as we explore how to keep your Azure Cosmos DB solutions fast.
Cost cutting strategies for Azure Cosmos DB
It is often assumed that Azure Cosmos DB is an expensive database. However, the cost of using Azure Cosmos DB is determined by how you configure your database and data model.
Your expenses are based on the amount of Azure resources your application uses for your Azure Cosmos DB account. Partitioning, Indexing Policies, and data models control your database power and your expenses.
This session will help you gain a full understanding of Azure Cosmos DB's partitioning and indexing features with several demonstrations. The first half of this session will focus on partitioning, with a few real-life examples. You will learn about physical and logical partitions and how to balance the number of physical partitions.
The second half of the session will focus on indexing policies. You will learn how to manage indexing policies to include or exclude properties of your data models.
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
Serverless vs Provisioned throughput
Using Cosmos DB Emulator
Querying Cosmos DB with SQL API
Setting up TTL
Azure Cosmos DB Connection Types
Caching Data in Cosmos DB
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
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 to 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 makes you a better leader and collaborator. Join me to learn more about this new Cloud Database technology.
Learning new technologies makes 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 are stuck with relational database data models, and we don't feel comfortable when data is represented differently.
Graph Processing Tables are another way to represent data; they can change how 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.
Thanks to SQL Server, you can integrate the knowledge gained in this session into your business without investing in new or unapproved technologies.
Please 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.
Performance tuning for Azure Cosmos DB
Azure Cosmos DB is a fully managed database service, freeing developers from database management tasks. However, as a developer, you still have important responsibilities, such as changing indexing policies, configuring connections, estimating workloads, and selecting the right throughput options. All of these tasks have a direct impact on the performance and cost of your application.
To keep your application running smoothly and fast, we'll explore the .NET/SDK settings, connection types, and indexing types. We'll also focus on selecting the right throughput options, using Query Execution Metrics and server-side programming.
Join me as we explore how to optimize your Azure Cosmos DB solutions for the best performance.
Azure Cosmos DB is a fully managed service that takes database administration off your hands. A fully Managed Database sounds good, but developers end up with some database administration work anyway.
Please join me as we explore how to keep your Azure Cosmos DB solutions fast.
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.
Exciting new features in SQL Server for developers
We get more and more features with every new version of SQL Server. Microsoft developed these new features to keep SQL Server modern, competitive, and developer-friendly.
SQL Server can help you keep your software architecture diagram simple and powerful with all its new features.
We will explore the new features from the latest versions (2017,2019,2022) of SQL Server, including Azure SQL.
We will cover the following features :
- Saving data as JSON in SQL Server.
- Using Graph Tables for interconnected data and relationships.
- In-memory tables for caching.
- New Functions.
Data Modeling Guidelines for Distributed NoSQL Databases
Having a NoSQL database doesn't mean that data modeling is unnecessary. A well-designed data model is crucial for NoSQL databases, as it determines scalability, performance, and cost.
We will begin the session by reviewing the JSON format specifications required for creating data models in NoSQL databases. After that, we will work together to create a sample NoSQL data model and understand how to manage NULL and undefined values in the data models.
In distributed databases, an important task is to select a property that evenly distributes data and traffic. You will learn the consequences of choosing a suitable or unsuitable partition key for your data models. We will conclude the session by creating materialized views that may assist you with cross-partition queries.
If you are working or planning to work on a project with a NoSQL database, this session is for you!
Having no schema database doesn't mean that you no longer need data modeling.
Building Intelligent Search Experiences with Azure Cognitive Search: A Developer's Guide
Imagine you can offer full-text search, vector search, image search, and AI features to users without worrying about database performance issues. Thanks to Azure Cognitive Search, Developers can now access cutting-edge technologies like image processing, machine translations, and language processing without learning extensive machine-learning knowledge.
In this session, you will learn how to set up and use Azure Cognitive Search utilizing data from the Azure Cosmos DB. You can easily add built-in skills to detect, recognize, or translate data from your data source. We will explore built-in skills such as entity recognition, full-text search, image analysis, and search options.
With all the information you will learn from this session, you can take your applications to the next level and provide your users with even better experiences. Whether you are a seasoned developer or just starting, this talk will surely be a valuable resource you won't want to miss. Please join me and take your applications to the next level!
Help! I need to select a cloud-based database.
You shouldn't blindly select a technology just because it's the latest trend or because a few people on social media endorse it. Your employer is counting on you to make an informed decision that will benefit the company in the long run.
In this session, we will discuss the factors to consider when choosing a cloud database. Then, I will introduce you to Azure Cosmos DB, a service that combines PostgreSQL, MongoDB, Cassandra, Gremlin, and Azure Table. Your projects require a robust and scalable database to handle all your needs.
Please join me to learn what to look for in a cloud database and discover Azure Cosmos DB, which provides multiple database engines within one service.
You shouldn't blindly select a technology just because it's the latest trend or because a few people on social media endorse it. Your employer is counting on you to make an informed decision that will benefit the company in the long run. Please join me to learn what to look for in a cloud database and discover Azure Cosmos DB, which provides multiple database engines within one service.
AI without a proper database is like a chef without ingredients - all sizzle, no steak!
Selecting the appropriate database for your project can be a difficult task. To achieve business success, it is crucial to have a scalable and easy-to-analyze operational database that incorporates AI capabilities.
Join Hasan for an exciting exploration of Azure Cosmos DB from multiple angles, covering topics such as creating scalable solutions, vector-based data modeling, and meeting the AI demands of today's businesses. Don't miss this opportunity to gain valuable insights and stay ahead of the competition.
Best free and open-source tool to have in your Data Toolbelt.
If you're in need of a migration tool that can move or generate data from various data sources, then this session is perfect for you. I'm excited to introduce you to a free, open-source application that can migrate data from a wide range of sources, including SQL Server, Azure Tables, Azure Cosmos DB, Mongo DB, PostgreSQL, Azure Blob, AWS S3, CSV, JSON, and Parquet.
The Microsoft Cosmos DB Data Migration Tool has been developed by the community and is here to simplify data migration for you. Join us to make this tool even better!
Utilizing Azure OpenAI with enterprise data.
Using enterprise data is the best way to demonstrate the success of a new service such as Azure OpenAI to your managers, and business leaders.
This session will help you better understand how to work with this new technology using enterprise data. You will learn how to create vectors from your enterprise data and export them to a modern database like Azure Cosmos DB for MongoDB Vcore, which can query vectors. Then, you will learn how to connect Azure OpenAI with your new vectorized database. This will allow you to analyze your enterprise data in a new and improved way that your business leaders will appreciate.
By the end of this session, you will be equipped with the tools and insights to implement Azure OpenAI into your organization's workflow effectively.
Tunisia Dev Days 2024 Sessionize Event Upcoming
Data Céilí 2024 Sessionize Event Upcoming
NDC Oslo 2024 Sessionize Event Upcoming
SQL Saturday Jacksonville #1068 Sessionize Event Upcoming
SQL Saturday Atlanta 2024 Sessionize Event Upcoming
Microsoft Fabric Conference
How to Model and Partition Data to Build Cloud Scale Applications in Azure
Orlando Code Camp 2024 Sessionize Event
Update Conference Prague 2023 Sessionize Event
2023 SQL Saturday Silicon Valley (SQLSatSV) Sessionize Event
SQLSaturday Orlando 2023 Sessionize Event
dev up 2023 Sessionize Event
Developer Week '23 Sessionize Event
SQL Saturday New York City 2023 Sessionize Event
SQLBits 2023 - General Sessions Sessionize Event
NDC London 2023 Sessionize Event
CodeMash 2023 Sessionize Event
Devintersection & Azure Data Conference Fall 2022 Sessionize Event
PASS Data Community Summit
Performance Tuning for Azure Cosmos DB
Update Conference Prague 2022 Sessionize Event
Data Saturday Atlanta Sessionize Event
Future Data Driven Summit 2022 Sessionize Event
Data Platform Virtual Summit
Performance Tuning for Cosmos DB
SQL Saturday New Jersey 2022 Sessionize Event
NDC Porto 2022 Sessionize Event
Microsoft Azure + AI Conference Spring 2022 Sessionize Event
SQLBits 2022 Sessionize Event
datasaturdays.com Pordenone 2022 Sessionize Event
CodeMash 2022 Sessionize Event
Update Conference Prague 2021 Sessionize Event
PASS Data Community Summit 2021 Sessionize Event
Azure Community Conference 2021 Sessionize Event
Tech Con '21 Sessionize Event
Future Data Driven Sessionize Event
Music City Tech 2021 Sessionize Event
Azure Summit Sessionize Event
Data Geeks Saturday Conference Sessionize Event
Virtual 2021 Data.SQL.Saturday.LA Sessionize Event
Data Saturday Southwest US Sessionize Event
Cloud Lunch and Learn Marathon 2021 Sessionize Event
Azure Cosmos DB Conf Sessionize Event
Global AI Night 2021 - Cleveland Sessionize Event
Data Saturday #5 Redmond 2021 Sessionize Event
datasaturdays.com Pordenone 2021 #0001 Sessionize Event
Azure Houston
Starting with Azure SQL Database Edge on Raspberry Pi
Boston Azure
How does Azure Cosmos DB work under the hood?
Triangle SQL Server User Group
Starting with Azure SQL Edge on Raspberry Pi
SQL Server Virtual Conference Sessionize Event
Data Platform Summit
A to Z Azure Cosmos DB PreCon
What does Graph Tables bring to Table
SQL Saturday Montreal
How does Azure Cosmos DB work under the hood
Momentum 2020 Sessionize Event
Data Platform Virtual Symposium
How does Azure Cosmos DB work under the hood
Tech Con '20 Sessionize Event
SQL Bits
A to Z Azure Cosmos DB Workshop
New features of SQL Server for Developers
SQL Saturday Denmark
How does Cosmos DB works
Baltimore Database User Group
New SQL Server Features for Developers
Sql Saturday New Zealand
How does Azure Cosmos DB work under the hood?
LightUp Sessionize Event
Boston Business Intelligence User Group
CosmosDB Under The Hood!
CFS - Global 2020 Summer Azure DataFest Sessionize Event
Data Architecture Day 2020 Sessionize Event
SQL Saturday Nashville
CosmosDB is the missing piece to your Data puzzle!
Global AI Bootcamp Sessionize Event
dev up Conference 2019 Sessionize Event
SQL Saturday NYC
Unexplored Features of SQL Server
SQL Saturday Boston
Unexplored Features of SQL Server
Music City Tech 2019 Sessionize Event
SQL Saturday Sacramento
How to use GeoSpatial Data in SQL Server
Cosmos DB was the missing piece to my Data puzzle!
SQL Saturday Louisville
Cosmos DB was the missing piece to my Data puzzle!
SQL Saturday Austin
CosmosDB is the missing piece to your Data puzzle!
SQL Saturday Dallas
How to use GeoSpatial Data in SQL Server
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
Indy.Code
New SQL Server 2017 Features you need to know.
Using Spatial Data in SQL Server
SQL Saturday Orange County
Not your dad's SQL server; Contemporary twist on a classic standby.
SQL Saturday Chicago
Not your dad's SQL server; Contemporary twist on a classic standby.
SQL Saturday Cleveland
Building Scalable, Globally Distributed Systems with Cosmos DB
SQL Saturday Nashville
Reasons to upgrade to SQL Server 2017
SQL Saturday Washington DC
What's new in SQL Server 2017
Code Camp NYC
Building Scalable, Globally Distribued Systems with Cosmos DB
SQL Saturday Pittsburgh
Introduction to Spatial Data with the help of SQL Server 2016/17
SQL Saturday Boston
What's new in SQL Server 2017
SQL Saturday Indianapolis
Intoduction to Spatial Data with the help of SQL Server 2016/17
SQL Saturday Sacramento
What's new in SQL Server 2017
SQL Saturday NYC
What's new in SQL Server 2017
SQL Saturday Wheeling
What's new in SQL Server 2017
SQL Saturday Rochester
What's new in SQL Server 2017
How to use Spatial Data in SQL Server
SQL Saturday Cincinnati
What's new in SQL Server 2017
SQL Saturday Cleveland
What's new in SQL Server 2017
Hasan Savran
Ms Data Platform MVP, Owner of SavranWeb Consulting, Sr. Business Intelligence Manager at Progressive Insurance
Akron, Ohio, United States