sqlsathistory

Nr: 1012

Back to Main list

SQLSaturday #1012 – Montreal – Virtual 2020

Start Time (24h) Speaker Track Title
08:30:00 Sandeep Arora Cloud Application Development Deployment The Battle of DBAAS – RDS vs Cloud SQL vs SQL Azure
08:30:00 Christophe Laporte Application Database Development From Docker to Big Data Clusters: a new era for SQL server
08:30:00 Cédric Charlier BI Platform Architecture, Development Administration Mijotez de bonnes petites analyses et soyez le cuistot des données grâce à Kusto
09:45:00 Guy Glantser Cloud Application Development Deployment Modernizing Your Data Platform
09:45:00 André Melancia Application Database Development SQL Curiosities: Curiosity Killed The Kitten
09:45:00 Benni De Jagere BI Platform Architecture, Development Administration Power BI dataflows? Why you need to implement it!
11:00:00 Chris Hyde BI Platform Architecture, Development Administration Python in SQL Server 2017 and 2019
11:00:00 Dennes Torres Application Database Development Why Synapse Analytics is beyond Azure SQL Datawarehouse
11:00:00 Warner Chaves Cloud Application Development Deployment Introduction to Snowflake on Microsoft Azure
12:30:00 Taiob Ali BI Platform Architecture, Development Administration Need to Monitor Any Azure Resource? Must Learn Kusto Query Langua
12:30:00 Amit R S Bansal Application Database Development Real-World Query Tuning Examples
12:30:00 Sam Nasr Cloud Application Development Deployment Data Time Travel with SQL Server Temporal Tables
13:45:00 Itshak David Application Database Development Data virtualization with SQL Server 2019 PolyBase and integration with Power BI .
13:45:00 John Miner Cloud Application Development Deployment The search for Spark within the modern data platform.
13:45:00 Edward Pollack BI Platform Architecture, Development Administration Improving Analytics Performance With Columnstore Indexes
15:00:00 Wagner Crivelini BI Platform Architecture, Development Administration First Steps to Work with Graphs in AZURE SQL DB
15:00:00 Kevin Feasel Cloud Application Development Deployment Data Virtualization with PolyBase
15:00:00 Karen Lopez Application Database Development Who's Pissing in Your Data Lake?
16:15:00 Hugo Kornelis Application Database Development Debugging without debugger: investigating SQL Server’s internal structures
16:15:00 Hasan Savran Cloud Application Development Deployment How does Azure Cosmos DB work under the hood?
16:15:00 Diponkar Paul BI Platform Architecture, Development Administration Moving data from NoSQL database to Cloud via Azure Data Factory

SessionID: 107262

The Battle of DBAAS – RDS vs Cloud SQL vs SQL Azure

Back to calendar

Event Date: 21-11-2020 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Sandeep Arora

Title: The Battle of DBAAS – RDS vs Cloud SQL vs SQL Azure

Abstract:

The public cloud is making a huge impact on the way enterprises host, manage, and scale their database operations. They can provision new infrastructure at the click of a button, without a lengthy hardware procurement process. Through a range of Database as a Service (DBaaS) options, public cloud vendors now make it easier than ever for organizations to migrate and maintain their databases. But while these solutions address many of the headaches involved in database management such as migration, provisioning, and administration, there are significant differences between the various DBaaS offerings on the market. In this session, we explore these DBaaS solutions provided by the leading cloud platforms, AWS, GCP, and Azure, and compare key features such as the types of the Database Engines on offer, Infrastructure Design Challenges, DR and HA capabilities, Performance Indicators, Pricing and Database Security.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/177801133 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/177801133

SessionID: 107782

From Docker to Big Data Clusters: a new era for SQL server

Back to calendar

Event Date: 21-11-2020 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Christophe Laporte

Title: From Docker to Big Data Clusters: a new era for SQL server

Abstract:

Starting with version 2017, SQL server was supported on Docker and Linux. With SQL Server 2019, you will be able to run a container, or a whole AlwaysOn Availability Group on Kubernetes.

This session will drive DBAs on their path to modernize their skills. Starting with a single container on a Docker host, the session will also cover Big Data Cluster creation and usage though T-SQL and basic Python scripts.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/977458245 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/977458245

SessionID: 108255

Mijotez de bonnes petites analyses et soyez le cuistot des données grâce à Kusto

Back to calendar

Event Date: 21-11-2020 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Cédric Charlier

Title: Mijotez de bonnes petites analyses et soyez le cuistot des données grâce à Kusto

Abstract:

Comment découvrir les petits secrets des time-series? Grâce à Azure Data Explorer et son langage de requête dénommé Kusto Query Language, il est maintenant facile d'explorer ces données. Azure Data Explorer permet de vous concentrer sur l'analytique et pas sur l'infrastructure, grâce au Data Analytics Service. En plus de ce service, le Kusto Query Language est un langage en lecture-seule pour processer des données et retourner des résultats d'une façon intuitive. Pendant cette session, vous apprendrez ce qu'est Azure Data Explorer et comment il se connecte avec d'autres services Azure tels que mais aussi les bases de ce langage afin de vous montrez comme il peut se relever puissant surtout avec les times-series. Cette session comprend de nombreux use-cases et des démos!

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/323672997 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9373

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/323672997

SessionID: 107146

Modernizing Your Data Platform

Back to calendar

Event Date: 21-11-2020 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Guy Glantser

Title: Modernizing Your Data Platform

Abstract:

Technology is advancing in an exponential rate, and data is becoming more critical than ever for the business. If you have old on-premise servers running old versions of SQL Server, then you have very good reasons to modernize your data platform. You can improve availability, scalability, performance and security of your databases and applications. You can leverage new features and technologies, and provide a lot more value to your customers and end users. And at the same time, you have the potential to reduce your operational costs.

In this session, we will learn about a structured approach for such a modernization project. We will focus on the Microsoft data platform. We will cover the latest versions of SQL Server as well as Azure SQL Database and Azure Managed Instance. We will learn about migration tools and techniques, such as the Data Migration Assistant (DMA), the Azure Database Migration Service, Transactional Replication, Log Shipping, and more.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/918164221 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9373

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/918164221

SessionID: 107402

SQL Curiosities: Curiosity Killed The Kitten

Back to calendar

Event Date: 21-11-2020 - Session time: 09:45:00 - Track: Application Database Development

Speaker: André Melancia

Title: SQL Curiosities: Curiosity Killed The Kitten

Abstract:

There are weird things in life. Even weirder for developers... "It should work!"... What you see is NOT what you get... There's a bug, a feature, a workaround...

Disclaimer: No feline was harmed in the making of this session. Please do not report it to the Montreal SPCA

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/742865317 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/742865317

SessionID: 107730

Power BI dataflows? Why you need to implement it!

Back to calendar

Event Date: 21-11-2020 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Benni De Jagere

Title: Power BI dataflows? Why you need to implement it!

Abstract:

Not so long ago, Power BI dataflows have been added to the Power BI landscape. It is showing great promise, as they have the potential of becoming key in every (large) implementation of a Power BI or Hybrid BI Architecture.

During this session, the core concepts of Power BI dataflows will be explained, and we'll discuss how Power BI dataflows could alleviate some of the specific problems you might be experiencing in your current architecture.

How this feature ties into some other cool concepts, like Azure Data Lake Storage Gen2 or the Common Data Model, obviously can't be missing from this speech.

Expect to walk out of this session with a decent grasp on the underlying architecture, and some key takeaways to take home with you.

Please join my meeting from your computer, tablet or smartphone.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/975765429 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9373

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/975765429

SessionID: 107909

Python in SQL Server 2017 and 2019

Back to calendar

Event Date: 21-11-2020 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chris Hyde

Title: Python in SQL Server 2017 and 2019

Abstract:

SQL Server 2017 and 2019 have arrived, bringing with them a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/174831773 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/174831773

SessionID: 107962

Why Synapse Analytics is beyond Azure SQL Datawarehouse

Back to calendar

Event Date: 21-11-2020 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Dennes Torres

Title: Why Synapse Analytics is beyond Azure SQL Datawarehouse

Abstract:

Synapse Analytics is being announced as the new name of Azure SQL Datawarehouse, but it's not only that. There is a broader view in Synapse analytics, beyond Azure SQL Datawarehouse. Let's see in this session what was improved, what changed, and how synapse analytics fits in the data platform.

Please join my meeting from your computer, tablet or smartphone.

https://global.gotomeeting.com/join/785444557 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9373

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/785444557

SessionID: 108084

Introduction to Snowflake on Microsoft Azure

Back to calendar

Event Date: 21-11-2020 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Warner Chaves

Title: Introduction to Snowflake on Microsoft Azure

Abstract:

Snowflake is the only fully managed petabyte scale data platform solution that is compatible across the main three cloud providers: Amazon Web Services. Google Cloud and Microsoft Azure.

With a laser focus on user friendliness and a cloud-first development approach, the Snowflake Cloud Data Platform can fit transparently into your business data strategy and leverage already existing and familiar development and management skills. All this while providing massive scale, zero maintenance and one single source of truth.

Azure is a great place to run Snowflake with full integration of Azure Active Directory, seamless data movement with Azure Data Lake Storage and even ways to integrate with services like Azure Data Factory and Synapse Analytics!

In this session we will introduce Snowflake and its value proposition, why it makes sense to run it on Azure and demos to give the attendees a tour of the products main capabilities.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/774435989 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9373

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/774435989

SessionID: 107152

Need to Monitor Any Azure Resource? Must Learn Kusto Query Langua

Back to calendar

Event Date: 21-11-2020 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Taiob Ali

Title: Need to Monitor Any Azure Resource? Must Learn Kusto Query Langua

Abstract:

Kusto is a service for storing and running interactive analytics over Big Data, easy to query using Kusto Query Language (KQL). As we make progress in our migration to the cloud, we are learning new ways to monitor and alert on resources and services. Microsoft has consolidated many services under the umbrella of ‘Azure Monitor.’ Whether you are ‘detecting and diagnose issues across applications,’ ‘correlate infrastructure issues for VMs,’ ‘drill into your SQL database monitoring data with Log Analytics,’ you will be using ‘Azure Monitor.’ Azure Monitor uses a version of the KQL that is suitable for simple log queries but also includes advanced functionality such as aggregations, joins, and smart analytics. Going forward, KQL is your only choice for querying the Azure Monitor log.

In this 95% demo session, I will show you some ‘getting started’ tips and a few sophisticated queries using KQL. Come and learn about the future of monitoring and investigations of Azure services.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/478623477 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/478623477

SessionID: 107701

Real-World Query Tuning Examples

Back to calendar

Event Date: 21-11-2020 - Session time: 12:30:00 - Track: Application Database Development

Speaker: Amit R S Bansal

Title: Real-World Query Tuning Examples

Abstract:

Query Tuning is easier said than done. Here is an opportunity to learn some real-world query tuning examples. In this 100% demo, deep-dive session you will learn to identify query performance issues using execution plans, re-write queries to improve execution time, use new T-SQL constructs for better performance, re-define indexes deal with statistics to improve query performance. You will also learn many advanced concepts and true to the session title, you are going to see bad query vs good query, all real-world. This session will be an eye-opener for you and you will learn things that Google cannot find for you. Assured. (The content demonstrated will only be relevant to SQL Server 2012 and onward including 2019)

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/817460941 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/817460941

SessionID: 108213

Data Time Travel with SQL Server Temporal Tables

Back to calendar

Event Date: 21-11-2020 - Session time: 12:30:00 - Track: Cloud Application Development Deployment

Speaker: Sam Nasr

Title: Data Time Travel with SQL Server Temporal Tables

Abstract:

Many times developers have to support users by answering the “What happened to the data?” The task of retrieving data from a specific point in time is not an easy one. Often this involves retrieving a backup and restoring the data in question (hopefully!). SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve data from a specific point in time, without backups. With a few TSQL commands a historical table can be created, automatically updated, and readily accessed.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/697618877 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/697618877

SessionID: 107381

Data virtualization with SQL Server 2019 PolyBase and integration with Power BI .

Back to calendar

Event Date: 21-11-2020 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Itshak David

Title: Data virtualization with SQL Server 2019 PolyBase and integration with Power BI .

Abstract:

In this session we will learn about the improvements to PolyBase in SQL Server 2019, which allows you to extend the querying capability to data sources like SQL Server, Oracle, MongoDB, Redis, Hadoop CDH, and other data sources. You also get insights on the design, capabilities, and performance advantages of PolyBase, save ETL Processes as follows:

• Installing and Configuring PolyBase Windows Linux • Connecting to Hadoop • Using Predicate Pushdown to Enhance Query Performance • Packet Capture With\Without Predicate Pushdown • When to use Predicate Pushdown • Limitations on Pushdown with Complex Filters • Built-In Integrations: Oracle, MongoDB , Radis and More Integrating via ODBC : Apache Spark , Apache Hive, Microsoft Excel Monitor PolyBase with Dynamic Management Views . • PolyBase Query Tuning , Execution Plans and Statistics PolyBase Scenarios : ETL VS ELT jobs This is a demo session only with minimum theory lessons from the fields !

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/682859693 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/682859693

SessionID: 107905

The search for Spark within the modern data platform.

Back to calendar

Event Date: 21-11-2020 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: John Miner

Title: The search for Spark within the modern data platform.

Abstract:

The genesis project was supposed to terraform an empty planet into a livable environment. If you are a Star Trek fan, you might have seen this 1984 movie at the cinemas. However, similarities do exist with Databricks being able to transform cloud storage into a living data lake.

Today’s talk will center on how the Databricks service makes it easy for the average developer to work with Apache Spark. A working knowledge of the Python language and Spark data frames is necessary to clean up and aggregate data in the lake. The introduction of the delta file format, has brought database ACID properties to the storage (file) system. Furthermore, the central hive metadata store allows developers to use Spark SQL to query the files like actual tables. Last but not least, a persistent cluster can be used as the data source for Power BI reporting.

Attend this talk to learn how to create a modern data platform with the Azure Databricks service.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/132707237 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/132707237

SessionID: 108095

Improving Analytics Performance With Columnstore Indexes

Back to calendar

Event Date: 21-11-2020 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Edward Pollack

Title: Improving Analytics Performance With Columnstore Indexes

Abstract:

Administrators and analysts often struggle with the storage and maintenance of reporting and analytics data. Traditional rowstore tables do not scale well when data is measured in billions of rows.

Columnstore indexes provide a speedy and convenient way to store OLAP data within SQL Server. Compression allows the data to be much smaller than other storage methods, allowing for faster reads. Column metadata provides the tools needed for SQL Server to be able to service queries over massive data sets quickly and efficiently.

The basics of columnstore indexes allow an administrator to improve the performance of analytics, but there is much more to learn! Understanding the internals of columnstore indexes allows querying to be even more efficient.

Columnstore indexes have evolved greatly since their introduction in SQL Server 2012. This presentation explores this feature in SQL Server 2017 and SQL Server 2019 and how its newest features can turbo-charge your analytics workloads!

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/172418221 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/172418221

SessionID: 107879

First Steps to Work with Graphs in AZURE SQL DB

Back to calendar

Event Date: 21-11-2020 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Wagner Crivelini

Title: First Steps to Work with Graphs in AZURE SQL DB

Abstract:

This is an introductory presentation over Graph concepts: modeling, querying, and presenting data in POWER BI. A demo will present how to implement the model in AZURE SQL DB, basic notions of querying data and how to visualize Graphs in a dashboard.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/472354869 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9373

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/472354869

SessionID: 108030

Data Virtualization with PolyBase

Back to calendar

Event Date: 21-11-2020 - Session time: 15:00:00 - Track: Cloud Application Development Deployment

Speaker: Kevin Feasel

Title: Data Virtualization with PolyBase

Abstract:

PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage. As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances. In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous

sources. We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down. Finally, we will look at several interesting use cases for PolyBase in the modern data environment.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/167277685 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/167277685

SessionID: 108410

Who's Pissing in Your Data Lake?

Back to calendar

Event Date: 21-11-2020 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Karen Lopez

Title: Who's Pissing in Your Data Lake?

Abstract:

The new data terms of Data Lake, Data Reservoir, and Data Swamp have left me with more questions than answers. In this presentation, Karen discusses the types of data anomalies that organizations can run into when they use external data, the wrong datasets for the right reasons and the right datasets for the wrong reasons.

These errors in design, oversights and old school, traditional practices can impact the success of your projects, even if you don't use any data lakes.

We'll look at end-to-end processes, data capture issues, impractical designs, balancing performance against data quality. I'll be using examples from my own personal data to show you just how my data has been mistreated in IT systems. Plus we'll talk about your data and your data stories.

We will build a list of good pracitices and tools to use to spare you from a flood of data issues in your organization. Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/397782085 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/397782085

SessionID: 107438

Debugging without debugger: investigating SQL Server’s internal structures

Back to calendar

Event Date: 21-11-2020 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Hugo Kornelis

Title: Debugging without debugger: investigating SQL Server’s internal structures

Abstract:

Have you ever wanted to know exactly how SQL Server stores data for temporary structures, such as for instance the spooled data in a Table Spool or Index Spool operator? No? I don’t blame you. It’s a bit like wanting to know who watered the rubber tree that produced the rubber your tires are made off before you get in the car to drive to work. You really don’t need it.

But you might still WANT to know. I did. And I figured it out. Without ever touching the debugger (I’m a simple soul, that stuff is much too complex for me!), I figured out how I could look at the exact storage structures SQL Server creates and uses to store data in Table Spool and Index Spool operators. If you are willing to commit to a fast-paced and deep internals session that is guaranteed to teach you exactly zero actually useful information, then this is the session for you.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/229291357 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9373

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/229291357

SessionID: 108378

How does Azure Cosmos DB work under the hood?

Back to calendar

Event Date: 21-11-2020 - Session time: 16:15:00 - Track: Cloud Application Development Deployment

Speaker: Hasan Savran

Title: How does Azure Cosmos DB work under the hood?

Abstract:

To master any technology, you need to understand the foundation of how it works on the backend first. We will explore Azure Cosmos DB's infrastructure, I will explain you how Azure Cosmos DB works in the backend in this session. We will cover the basics and some of the most misunderstood features like Partitioning, Multi-Model APIs and Consistency Levels 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.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/794824997 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9373

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/794824997

SessionID: 108406

Moving data from NoSQL database to Cloud via Azure Data Factory

Back to calendar

Event Date: 21-11-2020 - Session time: 16:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Diponkar Paul

Title: Moving data from NoSQL database to Cloud via Azure Data Factory

Abstract:

NoSQL database have grown popularity in recent years due to the flexibility of data modeling and scaling up capabilities. NoSQL database also have been using in big data landscape. The demo rich session will elaborate difference between SQL and NoSQL. And end to end solution for data moving capabilities from NoSQL database MongoDB by using Azure data factory.

Please join my meeting from your computer, tablet or smartphone. https://global.gotomeeting.com/join/575160197 You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) Canada: +1 (647) 497-9391

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/575160197