Storage 101 for Azure SQL and SQL Server Engineers | Data Exposed: MVP Edition

Storage 101 for Azure SQL and SQL Server Engineers | Data Exposed: MVP Edition

Why is storage so important for Data Engineering? Learn how storage impacts the performance of your database solution. In this episode with MVP Argenis Fernandez, we will go over the basics of I/O, what the different access patterns are for the database engine and how to tell when there is an issue with underlying storage for your database.

Why is storage so important for Data Engineering? Learn how storage impacts the performance of your database solution. In this episode with MVP Argenis Fernandez, we will go over the basics of I/O, what the different access patterns are for the database engine and how to tell when there is an issue with underlying storage for your database.

  • 0:00 Introduction
  • 0:34 About Argenis Fernandez
  • 1:23 Why is storage so important for data engineering?
  • 2:12 Latency
  • 3:04 IOPS
  • 4:17 Bandwidth
  • 8:45 Different IO Block Sizes
  • 12:03 SQL Server I/O Patterns
  • 18:19 Getting started

Resources: Argenis’ blog on IO Block Size: https://blog.purestorage.com/purely-technical/what-is-sql-servers-io-block-size/?WT.mc_id=dataexposed-c9-niner Gianluca’s WorkloadTools MVP Edition episode: https://youtu.be/LgVHK9IBXSc?WT.mc_id=dataexposed-c9-niner

sql azure database

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

How to set up Azure Data Sync between Azure SQL databases and on-premises SQL Server

In this article, you learn how to set up Azure Data Sync services. In addition, you will also learn how to create and set up a data sync group between Azure SQL database and on-premises SQL Server.

Sourcing data from Azure SQL Database in Azure Machine Learning

In this tutorial, we will show how to source data from Azure SQL Database to use in a Machine Learning workflow.

Migrating SQL workloads to Microsoft Azure: Databases Trip to Azure SQL Database

In this article, we will discuss how to migrate an on-premises SQL Server database to Microsoft Azure SQL Database.

How to access an Azure SQL database from Azure Data Lake Analytics

In this article, we will learn to access data in an Azure SQL database from Azure Data Lake Analytics.