Name: Explore your data lake with Synapse Serverless Pools
Start: 2024-01-24T19:00:00-05:00
End: 2024-01-24T21:00:00-05:00

Hi Friends
Happy 2024.
On Jan 24, 2024 7PM EST we are pleased to bring
**Explore your data lake with Synapse Serverless Pools**

**Details:**
Many organizations are consolidating all their informational assets into data lake.
This is a great idea since all the data is located in one place, both structured and unstructured data can be stored, and many different types of users can access the data.
Traditionally, a SPARK cluster is used to manipulate the data stored in the lake via quality zones. This data engineering batch process can be scheduled at night. The more powerful the SPARK cluster is, the more costly is the AZURE bill. Since most data is written once and read many times, how can we reduce the cost of our companies read activities?
Azure Synapse Serverless SQL pools allows the architect to replace the
interactive SPARK cluster with a lower cost service. The OPENROWSET and EXTERNAL TABLE commands have been the traditional way to use POLYBASE to read schema on demand. However, this syntax can be time consuming to setup.
Recently, Microsoft has released the LAKE DATABASE that abstracts this underlying mechanism via the Azure Portal and/or SPARK engine.
To recap, having high powered SPARK clusters waiting to satisfy read operations against the data lake can be costly. A better alternative is to use Azure Synapse Serverless SQL pools that only charge you when you run queries. Today we will explore the different ways to setup a Serverless SQL pool.

Warmest Regards
Paresh Motiwala

Paresh Motiwala

Boston Business Intelligence

Technology

Data Visualization

SQL Server

Business Intelligence

Machine Learning

Microsoft Azure

Predictive Analytics

Data Mining

Power BI

Business Analytics

Big Data

Data Science

Business Intelligence & Data Warehousing

***Biography:***
John Miner is a Senior Data Architect at Insight Digital Innovation helping
corporations solve their business needs with various data platform solutions. He has over thirty years of data processing experience, and his architecture expertise encompasses all phases of the software
project life cycle, including design, development, implementation, and
maintenance of systems.
His credentials include undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Also, he has earned certificates from Microsoft for Database Administration (MCDBA), System Administration (MCSA), Data Management & Analytics (MCSE) and Data Science (MPP).
John has been recognized with the Microsoft MVP award seven times for his outstanding contributions to the Data Platform community.
When he is not busy talking to local user groups or writing blog entries on new technology, he spends time with his wife and daughter enjoying outdoor activities.
Some of John’s hobbies include wood working projects, crafting a good beer, and playing a game of chess.

John Miner

Explore your data lake with Synapse Serverless Pools

Online event

Share

Explore your data lake with Synapse Serverless Pools

Boston Business Intelligence

Details

Members are also interested in