HOPE YOU'RE ALL HAVING A GOOD DAY.
KEYNOTE WHERE WE HEAD START ON AZURE
ON THE COSMOS DB TEAM. BEFORE WE
OF THE GREAT THINGS ABOUT THIS BUILD
FOR YOU. PLEASE ASK A LOT OF QUESTIONS
FROM SYNAPSE DB TEAMS READY TO ANSWER
FROM ROHANN KUMMER FROM AZURE. IN
DB LINK IS. HOW TO RE- BUILD ACU
IF YOU TAKE A LOOK AT THE TWO DECADES
AND NEEDS OF APPS AND SERVICES HAVE
SCALE. IT'S OPTIMIZED FOR WORKLOADS
I NUT AVAILABILITY AND TURNKEY DISTRIBUTION.
STORY. IN TODAY'S DATA WORLD ALL
RUN NEAR WORLD ANALYTICS IN THEIR.
ANALYTICS. THE FIRST ONE YOU CAN
DB DATABASE. THIS MEANS YOU'RE GOING
AND OVER SEVERAL YEARS RUNNING ANALYTICS
IF YOU LOOK AT A AT THIS POINT TYPICAL
HAVE AN IMPACT ON YOUR MISSION CRITICAL
WHAT WE SEE CUSTOMERS THEY SET UP
ACUDB PERIODICALLY AND TRANSFORM
YOU HAVE THE DATA IN THE DATA LAKE
AND SPARK TO CLEAN THIS DATA, TRANSFORM
TO DO ANALYTICS OR TO DO DEPORTING
CHALLENGE OF HAVING A PERFORMANCE
THIS IS CERTAIN LATENCY. JUST BECAUSE
FEW HOURS OR EVERY FEW DAYS THERE'S
YOUR INSIGHTS IS MUCH HIGHER. TO
THIS PROCESS EVEN SIMPLER WE'RE
AZURE SYNAPSE LINK IS A CLOUD ANYWAY
DOWN THE BREAKS BETWEEN OH LAP SYSTEMS.
ANALYTICS ON TOP OF YOUR OPERATIONAL
ANY IMPACT PERFORMANCE ON YOUR WORKLOADS
WORKLOADS. HOW DO THIS WORK? LET'S
DB TODAY AS YOUR OPERATIONAL DATA
THIS TRANSFORM STORE IS OPTIMIZED
READS, WRITES AND OPERATIONAL QUERIES.
STORE IS SEPARATE FROM THE TRANSACTIONAL
STORE. WHAT THIS MEANS AS YOUR DATA
COSMOS DB WILL AUTOMATICALLY CONVERT
MINUTES WHEREAS PREVIOUSLY IT TOOK
I HAVE MY DATA IN THE ANALYTICAL
I'M READY TO RUN ANALYTICS ON THIS.
SYNAPSE LINK BETWEEN COSMOS DB AND
SPARK CLUSTER USE SYNAPSE SQL. WITH
TO MACHINE PIPELINES TO BIG DATA
INCAS MOW DB AND WITHOUT HAVING
INTO A DEMO 6789 FOR TODAY'S DEMO
WE HAVE A RETAILER WHO'S LOOKING
ON TOP OF THE COSMOS DB. THIS SUPPLY
THOUSANDS OF STORES AROUND THE GLOBE
PRODUCTS USED. TO SHOW THE POWER
PIPELINE AND ALSO HOW WE CAN BUILD
LINES ON TOP OF YOUR OPERATIONAL
USED COSMOS DB MOST YOU ARE FAMILIAR
WE'VE MODELED OUR ACROSS THREE DIFFERENT
I HAVE A RETAIL SALES CONTAINER
MUCH ALL OF MY TRANSACTION SALES
THOUSANDS OF STORES. IF I LOOK AT
INFORMATION WHAT IS THE PRODUCT.
QUANTITY AND SO FORTH. AND IT HAS
SIMILARLY THE STORE CONTAINERS HAVE
THE STORE DEMOCGRAPHICS CONTAINER
FROM DATA WAREHOUSE AND SO FORTH.
QUESTION IS HOW DO I RUN ANALYTICS.
NEW CONTAINER YOU HAVE AN OPTION
TAKES IS A SINGLE CLICK. WITH A
-- WITH A SINGLE CLICK NOW YOU'RE
AND ALL OF YOUR DATA FROM YOUR TRANSACTION
STORE TO RUN ANALYTICS ON TOP OF.
WE'RE DEALING WITH. 600 TERABYTES
AND WE CAN SEE THAT WE HAVE ABOUT
PER SECOND AND COSMOS DB IS ABLE
AND IN COMING REQUESTS. SO NOW WE
STORE ON THIS PARTICULAR -- SORRY,
ENABLED ANALYTICAL STORE OVER MY
INTO MY SYNAPSE WORKSPACE AND I
EITHER USING SPARK ORSER HAVE YOUSLESS.
SYMBOL, AND KEEP CLICKING CONNECT.
WITH THREE CONTAINERS AND SINCE
DO THAT I CAN SEE ALL OF MY CONTAINERS
STORE DEMOGRAPHICS AND THE CONTAINERS
ACTIONS I CAN PERFORM. I CAN DO
LET'S TAKE A HOW I CAN CREATE REALTIME
SO IF YOU SEE I CAN CREATE A VIEW.
DONE I'VE JUST CREATED IN THE INTEREST
A SQL SCRIPT. SO IF YOU SEE WHAT
DATABASE. AND I'M CREATING A PRODUCT.
VIEW. RETAIL SALES VIEW AND SO FORTH.
YOU GO BACK TO YOUR DATABASE, IF
SEE THE DATABASE YOU HAVE THE RETAIL
YOU CAN SEE THE VIEWS WE JUST CREATED.
CAN RUN THESE BEER -- QUERIES. PREVIOUSLY
HAVE THIS VIEWS WHAT I WANT TO POWERBI
POWERBI ACCOUNT. FROM WITHIN THE
THAT SAYS POWERBI. USING THE VIEWS
SOME TWO SAMPLE REPORTS. SO THE
REVENUE OVER A FEW WEEKS. THE SECOND
IF YOU LOOK AT VISUALIZATIONS AND
THINGS YOU CAN DO HERE. YOU'RE ABLE
NOW I WANT TO MENTION POW POWERBI
REALTIME REPORTS ON TOP OF YOUR
YOU LOOK -- IF YOU GO BACK TO THE
TAB WHEN YOU RIGHT CLICK ON YOUR
THE SQL SCRIPT YOU CAN CREATE A
COMMON GESTURE WHAT YOU'LL BE ABLE
DATA FORM. GOING BACK TO DEVELOP
ALSO CREATED A NOTEBOOK WHICH DOES
NOTEBOOK IT'S COSMOS DB DATABASE
IF YOU LOOK AT MY PARTICULAR SET
TABLE OVER MYCONTAINER AND SIMILARLY
FOR DEMOGRAPHICS CONTAINER AND FOR
CREATED THESE CONTAINERS WE'RE ABLE
QUERY I'M JOINING THE THREE CONTAINERS
ONCE I HAVE THIS RICH SET OF DATA
SCIENTIST WHO CAN THEN TRAIN MACHINE
YOUR SYNAPSE WORK WORKSPACE. WE'VE
GOING INTO TOO MUCH DETAILS. WHAT
OUR DATA FROM THE ANALYTICAL STORE
MODEL. WHAT I'M DOING HERE I'M TRANSFORMING
IS AUTO ML. HEY I WANT TO DO FORECASTING
DATA SET A CROSS MULTIPLE MODELS.
HAS RUN 30 DIFFERENT MODELS AND
PICK THE BEST MODEL FOR AND IT IN
IF IT PICKED RANDOM REGRESS YOU
BEST. NOW WE'VE TRAINED THE MODEL
PERFORMS AND TO SHOW YOU THE VERBALIZATIONS
FOR FORECASTING BASED ON THE TRAINING
TO RUN AGAINST OUR TEST DATA SET.
WE'RE RUNNING MODEL AGAINST OUR
A VISUALIZATION HOW THE MODEL IS
IS ACTUAL SALES AND THE BLUE DOTS
MANNER YOU'RE ABLE ENDS TO END FORECASTING
WITH TOP OF YOUR STORAGE WITH A
IS GIVEN YOU AN IDEA OF HOW TO BUILD
YOU CAN ALSO BUILD RECOMMENDATION
THERE'S SO MANY USES FOR SYNAPSE
EXCITED TO BRING THIS CAPABILITY
CAN NOW BUILD. WITH THAT I'M GOING
DO SOME Q & A. >> I'LL GIVE YOU
-- I'M GOING TO TAKE A SIP OF WATER
ON CHAT. I'VE PICKED SOME INTERESTING
I'M GOING TO READ THEM OUT. SO THE
ALLOCATE ARGUES SEPARATE FROM THE
WHO'S LISTENING INNED AUDIO IF YOU'VE
UNIT AS CURRENCY FOR THROUGHPUT
YOU'RE USED TO DEALING WITH YOUR
STORE ITSELF THERE'S NO PROVISION
A LITTLE BIT DIFFERENT. FOR THE
BASED MODEL AND YOU WILL BE ONLY
AND FOR THE TRANSACTIONS AGAINST
MORE DETAILS ON THE AZURE PRICING
DOES IT TAKE TO REPLICATE THE DATA
THE ANALYTICAL STORE ON COSMOS DB.
SINK NAHIZATION FROM THE TRANSACTION
ALL OF IS FULLY MANAGED BY COSMOS
GOING TO BE WITHIN FIVE MINUTES.
TO HAVE ALL OF YOUR DATA IN A COLUMN
TAKE TWO DAYS TRADITIONAL ETL PIPELINE
HAVE YOUR DATA READ'S FOR ANALYTICS.
READY IN JUST A FEW MINUTES. >>
HERE. YOU CAN RUN ANALYTICS WHEREVER
DB IS KNOWN FOR ITS GLOBAL DISTRIBUTION.
OF SYNAPSE LINK. FOR THE USER COSMOS
DISTRIBUTION. SO THE IDEA IS ABLE
THEY ARE. IF YOU'RE USING A MULTI-
SET-UP AND YOU HAVE MULTIPLE REGIONS.
YOUR ANNAL LIT CULL DATA THAT EACH
WILL HAVE A LOCALLY REPLICATED TRANSACTION
USING SYNAPSE ANALYTICS AND RUN
DATA >> AWESOME. SO SO YOU SAID
DIRECTLY. WHAT IF I WANTED TO JOIN
SOURCES WITHIN MY SPARK OR SQL SER
THAT'S TOTALLY POSSIBLE WITH SYNAPSE
ADD DIFFERENT DATA SOURCES AND HOW
ABLE TO ADD YOUR DATA LAKE OR BLOB
DATA SOURCES YOU CAN PULL OUT OF
SOURCES. THIS IS A VERY POWERFUL
A COSMOS DB ANALYTICAL STORE AND
DATA LAKE THAT'S TOTALLY POSSIBLE.
US IN THE KEYNOTE. IT'S NOT JUST
AND YOU CAN ENRICH YOUR DATA FOR
OF SYNAPSE LINK. >> I GUESS ANOTHER
DATA CAN I WRITE THE RESULTS POST
THE ANALYTICAL STORE INTO COSMOS
IN SYNAPSE. WHERE DO I WRITE BACK
YOU PULL OUT THIS DATA FROM YOUR
EITHER USING SPARK OR SQL SERVICE
OF THE NATIVE INTEGRATION BETWEEN
DIRECTLY WRITE THE AGGREGATION RESULTS
STORE AS A SERVING LAYER: TO KIND
TO YOUR ANALYTICAL STORE BUT YOU
CAN SERVE THE DATA. >> THAT MAKES
STORE HAS THIS TIME CAPABILITY.
STORE AS WELL? >> YEAH. AGAIN IF
DB YOU MIGHT KNOW ABOUT THIS CONCEPT
YOUR A NOT. USING THE TIME ITERATIVE
FOR A COUPLE OF DAYS OR COUPLES
OF YOU ARE FAMILIAR WITH. NOW WITH
STORE WILL HAVE ITS OWN TTL KNOB.
RETENTION PAUL SEEDS OF YOUR ANALYTICAL
STORE. LET'S SAY IF YOU WANT TO
YOU ALWAYS HAVE A COPY OF YOUR DATA
CAN INDEPENDENTLY MANAGE YOUR THE
>> THAT MAKES TOTAL SENSE. I WOULD
LARGER DATA SET. >> EXACTLY. JUST
STORE ESPECIALLY IF YOU HAVE IOT
VOLUMES OF DATA SITTING IN YOUR
HAVE ALL OF YOUR DATA IN YOUR ANALYTICAL
ACROSS DB IS IN SQL DATABASE. IN
YOU HAVE TO CIMA AGRICULTURE AGNOSTIC
IS A REALLY GOOD QUESTION. MOST
WITH THE PIPELINES. PRETTY MUCH
NOT HAVE ANY SCHEMA. BUT ANY ANALYTICS
OR SPARK. WE'RE DOING THAT SCHEMA
FULLY AUTOMATED BY COSMOS DB. WE
AUTOMATICALLY DONE FOR YOU. >> THAT
UP WITH ONE FINAL QUESTION. WILL
DATABASES OTHER THAN SYNAPSE LINK.
DB IS BY NEARING THE SOLUTION. WE
OPERATIONAL DATABASES WITHIN THE
WE HOPE TO EXPAND IN THE FUTURE
AS WELL. >> GREAT. I THINK THIS
GOING TO PUT THIS TO USE RIGHT AFTER
YOU CAN SEE SOME OF THE COSMOS DB
PLEASE SUBSCRIBE TO OUR YOUTUBE
YOU SO MUCH EVERYONE. THANK YOU
WE ARE NOT AFRAID OF INNOVATING.
ALLEN IN. SQL IS MATURE, WE NEVER
WE ARE LOOKING TO BREAK THE BOUNDS
AGAIN. CORE VALUES SHOULD NOT CHANGE.
30 YEARS AGO ARE THE SAME THAT WE
THE DEFINING PRINCIPLES THAT ARE
SECURITY, DEVELOPER PRODUCTIVITY.
THAT CAN CONFINE US TO WHAT WE DO.
THE PUBLIC PREVIEW OF AZURE SQL,
OF IOT DEVELOPERS AND THE RELATIONSHIP
DO A LOT OF INNOVATION OUTSIDE THE
RELEASE NOT ONLY AZURE SQL EDGE
TO THE EDGE BUT COMES WITH THREE
MACHINE LEARNING SCORING CAPABILITY
FULL DATA STREAMING SUPPORT. TOGETHER
THE EDGE. A PLATFORM THAT IS NOT
THE NEW ADDITION, AZURE SQL EDGE,
HOW ENTERPRISES ACROSS THE VARIOUS
INTELLIGENT EDGE APPLICATION. MY
SQL EDGE TO DO MACHINE LEARNING
DEVICES OF THE BEST EXAMPLE SHOWS
ENGINE, RATHER AS A FULL PLATFORM,
DATA CLUSTERS. IT'S BUILT BY KEEPING
SCENARIOS FRONT AND CENTER. AS THE
MADE SURE SQL NOT ONLY EMBRACES
THE CHASM THAT EXISTS BETWEEN STRUCTURE
BIG DATA PLUS SHARES WE INTEGRATED
FULLY UNIFIED DATA PLATFORM. THE
TO DO ANALYTICS. >> THANKS. IT SEEMS
A LOT FROM THE EDGE, TO THE GROUND,
KNOW, WHEN SOME OF OUR CUSTOMERS
CLOUD THERE ARE A LOT OF DIFFERENT
CHOOSE FOR EITHER THEIR NEW WORKLOADS
SHOULD DEVELOPERS CHOOSE AZURE SQL?
WE ARE SEEING A RISE OF THE FULL
ARE LOOKING FOR THE MOST RELIABLE,
O TOP OF THAT, THEY WANT CONSISTENCY
THINGS SHOULD NOT BREAK WHETHER
OR ON EDGE. DEVELOPERS DON'T WANT
KNOBS TO GET THE BEST PERFORMANCE
ITS CORE IS ABOUT ENABLING DEVELOPERS
HARNESSING THE POWER OF DATA. AZURE
MAKE IT THE BEST DATA PLATFORM FOR
AZURE SQL HASTS MOST COMPREHENSIVE
SECURITY, ACCESS MANAGEMENT, THREAT
YEAR OVER YEAR INDUSTRY ANALYSTS
SQL AS THE MOST SECURE DATA PLATFORM.
QUERY POSSESSOR. CUSTOMERS DON'T
DEGREES. WE HAVE MACHINE LEARNING
THE PLAN AND ADD OR DROP INDICES
IN AZURE TODAY, WE HAVE OVER 6 MILLION
10 TRILLION YEARIES RUN EVERY DAY.
FORM STABILITY AND THE BROAD ADOPTION
2 TO 3 YEARS THE BIGGEST INVESTMENT
HYPER SCALE IS THE ONLY RELATIONSHIP
ONE DATA TO S PORT 200 TERRABYTE-PLUS
LEVEL OF DETAIL WE HAVE HUNDREDS
MORE PRODUCTIVE. FOR EXAMPLE, CHANGE
THAT PROVIDES AN EFFICIENT CHANGE
TO CREATE CHANGES TO DATA IN THE
RELATED TO THE CHANGES APPLICATION
FEATURES LIKE CHANGE TRACKING AND
MOBILE APPLICATIONS. >> THANKS.
MYSELF AND I WOULD LOVE TO SHARE
I DON'T KNOW IF YOU KNEW THIS BUT
I LIKE TO GO FOR A RUN EVERY MORNING.
IT'S THERE TO TRACK MY RUNS. AND
OF INFORMATION AND I CAN EVEN START
WORKOUT AND IT'LL START TO LOG IT.
WHILE I'M RUNNING WHICH HELPS IN
THE RUN IT'S GOING TO SEND THIS
IF I FLIP OVER TO THE PORTAL WHAT
LOGGING THE ACTIVITIES FOR ALL OF
IT'S CURRENTLY ABOUT 13 TERABYTES
NEEDS TO. HYPER SCALE IS GOING TO
FUNCTIONALITY OF AZURE SQL DATABASE
BEN FIGTS AROUND READ SCALE AND
NOW, ONE COMMON THING WE NOTICE
INCLUDED, TEND TO FORGET TO SELECT
OF THIS PROCESSING IS GOING TO INCLUDE
DETERMINE WHERE A WORKOUT ACTUALLY
A AS A SIMPLE EXAMPLE I'M GOING
I DID YESTERDAY. NOW, WHEN THE DATE
UPDATE THE RECORDS IN MY APP, TOO.
DATA FOR THE WORKOUTS I HAVE, OR
EDITED. I WANT TO DO AS LITTLE DATE
WHAT I DON'T HAVE LOCALLY. CHANGE
ALLOW ME TO DO EXACTLY THIS WITHOUT
CODE TO MAKE IT WORK. HERE, I CREATED
FROM AN API, AND IT BASICALLY RETURNS
VERSION. THE BEAUTY HERE IS THAT
THAT I DEFENSE WHICH IS GOING TO
SO IF I LOOK AT AN EXAMPLE, HERE
THE NEXT VERSION TO GET THE LATEST
IS ONLY THAT UPDATE OPERATION WE
HELP KEEP ME BE MORE EFFICIENT,
IS EVERYTHING IS PRETTY GREAT. IF
I CAN SEE THAT THAT WORKOUT WAS
SQL DATABASE AND IN THIS CASE HYPER
THAT ARE BUILT INTO THE SQL ENGINE,
YOU BUILD MORE INTELLIGENT AND FASTER
IS A GAME CHANGER. >> HELLO, EVERYONE,
