BEEN CALLED -- THE ARM TEMPLATE
ARMS AND PLATES. WE CAN HEAR FROM
SHOW BEN. >> HI, DEAN, GREAT TO
THE CONTENT SO FAR. BLOWING ME AWAY.
TO HAVE YOU AS WELL CAN YOU LET
>> I'M A CLOUD SOLUTION ARCHITECT
RANGE OF ARCHITECT IN MICROSOFT.
AND GET THEM TO USE AZURE FUNDAMENTAL.
OUR PLATFORM AND I HELP THEM TO
AND PERHAPS REPLATFORM TO AZURE
AND CHANGES THEY MIGHT NEED TO MAKE
THAT. SO WE'RE TO GET PARTNERS AND
YOUR DAY JOB, WE'LL GET ON TO THE
BUT THIS IS BASICALLY INFRASTRUCTURE
INFRASTRUCTURE IS CODE. SHOULD I
IS IT AND SHOULD THEY CARE. >> FUNDAMENTAL
NEW. IT'S BEEN AROUND FOR SOME TIME.
YOUR ENVIERNLT ENVIRONMENT IN A
YOU WANT TO HAPPEN IN A TEXT READABLE
AND DEPLOY. SO FUNDAMENTALLY IT'S
THE THE PROCESS, LIKE PEOPLE HAVE
WELL UNDERSTOOD FORM THEY TAKE MANY
AND THAT GIVES PEOPLE A BUNCH OF
AND AUTONOMY AND SAFETY, THEY ARE
JUST CLICKING AROUND IN THE PORTER.
FRIENDS RIGHT CLICK PUBLISH. >>
BIT OF CONTROL AND A BIT OF GOVERNANCE
TO GO TO THE PRODUCTION RESOURCE
CASE, IF SOMEONE DID DELETE RESOURCES,
THEM QUICKLY AND PEOPLE UNDERSTAND
AND I'M NOT GOING TO DO THINGS MANUAL,
PARTICULAR TOOL THAT WE'RE GOING
ARM TEMPLATE VIEWER. THERE ARE OTHERS
PHYSICAL TALKIC ABOUT AZURE RESOURCE
JSON DOCUMENTS. ANOTHER POPULAR
THE SAME APPROACH. THIS INFRASTRUCTURE
IS DIFFERENT BUT THE OUTCOMES ARE
ON THE AZURE TEMPLATES THAT ARE
JSON FOR YEARS NOW IN DOCUMENTS
TO READ. SO THAT KIND OF SEGUES
TO MAKE THIS A WHOLE LOT EASIER.
OF THE BIG CRITICISM AND WE CAN
DIFFICULT TO READ AND HARD TO UNDERSTAND
VERY LARGE. SO I WANTED TO SEE
IT EASIER FOR PEOPLE TO UNDERSTAND
I LIKE MAKING VISUAL THINGS. AND
WE CAN MAKE A PRETTIER VERSION OF
>> NICE, AND BEFORE WE DIVE INTO
AND SHARE WITH THE AUDIENCE, THIS
YOUR DAY JOB, YOU WORK WITH PARTNERS
DID THIS COME ABOUT REALLY. >> THAT'S
ENGINEERING TEAM, OR PART OF ORGANIZATION
TO DEVELOPERS AND I'M A DEVELOPER
WAS VERY MUCH A SIDE PROJECT. I
IF I CAN TAKE THE JSON DOCUMENT
TO DO THAT AND SLOWLY WENT FROM
VISUAL STUDIO. AND TAKE AND VISUALIZE
ON EVENINGS AND WEEKENDS TO MY WIFE'S
STORY, YOU WORK AT MICROSOFT BUT
MESSAGE TO THOSE -- YOU WILL SEE
ARE BUILDING PROJECTS. TEAMS ARE
AND INTEGRATING IN PLACES LIKE THE
ENDED UP IN THE AZURE PORTAL AS
WAS AN EMPLOYEE OR PUSHED IT. IT
WAS A MEDIA RESPONSE THROUGH THAT
TO ME. AND THEY SAID THIS WAS A
AND THEY WERE FUNNY ABOUT GIVING
CODE. SO A GUY DID A LOT OF THAT
FROM VISUAL STUDIO AND GETTING TO
BEEN REALLY COOL. WE'RE LOOKING
IF YOU HAVE A COOL PROJECT IT'S
AZURE. >> IT'S FUNNY THEY DIDN'T
YEAH, THEY WERE FUNNY ABOUT THAT.
THE PEOPLE WATCHING WANT TO SEE
ARM TEMPLATES. >> ABSOLUTELY. LET
IN VISUAL STUDIO CODE HERE. I'M
THAT. I HAVE A COUPLE ARM TEMPLATES
PRETTY LONG OR ROBUST, IF YOU ARE
SEEN THIS BEFORE. IT'S 300 LINES
WITH ARM TEMPLATES AND SPENT TIME
WITH THIS IS THE DEPENDANCIES. SO
ONCE IT'S INSTALLED TO THE MARKETPLACE.
THE ARM TEMPLATE AS A VISUALIZATION.
SOMETHING YOU CAN INTERACT WITH
CLICK ON EACH ICON AND GET MORE
PART IS A RESOURCE. IT'S NOT STATIC.
WILL UPDATE. FOR EXAMPLE, I CAN
I MADE A MISTAKE AND LEFT SOMETHING
PAST AND GIVE A CLEAR HINT SOMETHING
TO IT. >> THAT'S COOL. SO SOMETIMES
IS A LITTLE LINE THAT SAYS A SYNTAX
ALWAYS OBVIOUS . >> YEAH, HARD TO
IT EASIER. THESE TEMPLATES CAN BE
SO IF I CLICK IN A DIFFERENT JSON
FOR INFRASTRUCTURE. IT CAN BE ANY
AND SQL DATABASE ALL INSIDE THE
TO THIS THE NAMES AND LABELS WILL
APP INSIGHT AND THE VIEW UPDATES
VISUAL FEEDBACK ON WHAT YOU ARE
A BUNCH OF BUTTONS ON THE TOP THERE.
HERE. WHAT ELSE CAN THEY DO. >>
THERE. THEY'RE THE SAME. LET ME
HAS BEEN BROUGHT TO THE AZURE PORTAL.
TO GO TO THE PREPRODUCTION VERSION.
PRIVATE TO MICROSOFT SUPER SECRET
ABLE TO SEE THIS FEATURE. SO FROM
EXPORT TEMPLATE. SO I CAN GO INTO
RESOURCE BUTTON, THAT'S BEEN THERE
NEW. BUT WHAT IS NEW IS VISUALIZE
THE TEMPLATE AND LET YOU VISUALIZE
WITH A VM IN IT AND VISUALIZE THE
1 WHAT THE RESOURCES ARE IN THE
>> EVEN IF I DIDN'T EVER OFFER MY
I'M CALLING IT. I LIKE THE COMMENT
SOURCES THESE DAYS. EVEN IF I PUT
THEM, I CAN STILL COME IN HERE AND
TODAY AND GET THIS VIEW. >> THESE
STILL SHOW THEM. SO A WHOLE BUNCH
IT OUT TO SNAP THIS. SO A BIT MORE
FEATURE, TO SNAP THESE TO A GRID.
EVERYTHING OUT. AND THERE ARE OPTIONS
OR MAKE A GUESS TO TRY AND LAY IT
IF IT WAS A BUSY I MIGHT WANT TO
RULES, I MAY HAVE HUNDREDS, I CAN
SUBSTRING OF AT THAT MOMENT AND
IT. WHEN I HAVE SOMETHING I'M HAPPY
HAVE ACCESS TO AZURE. I CAN USE
WITH A PRESENTATION AND SHARE WITH
I HAD TO WHIP TOGETHER DRAMS I PUT
AND DO THIS. THAT'S AWESOME. >>
THANK YOU SO MUCH FOR SHARING THIS
VERSIONS VISUAL STUDIO CODE VERSION
I GUESS, YOU CREATED AND THEN THE
THE DIFFERENCE BETWEEN THE TWO OR
>> ABSOLUTELY, I THINK WE HIT IN
TEMPLATE, YOU PROBABLY WANT TO USE
HAVE THE FILE ON THE MACHINE IN
YOU ARE NOT USING TEMPLE LATES AT
TO GET AN UNDERSTANDING ON WHAT
IF YOU ARE COMFORTABLE WRITING ARM
EXTENSION VERSION. EVERYONE ELSE
WE CAN'T TALK ABOUT THIS ALL DAY.
THANKS FOR YOUR TIME, AND IF PEOPLE
MAYBE YOU CAN RESHARE WHERE TO FIND
VERSION IS IN THE RC. PORTAL AZURE.
IN THE VS MARKETPLACE AND FROM THERE
WELL. YOU CAN LOOK AT THE CODE.
WE'LL TALK TO MORE GUESTS ON THE
BREAK. >> HI, WHEN SATYA IN THE
TALKED ABOUT MILLIONS OF APPS DEVELOPING
WHEN I THOUGHT ABOUT THIS, WHO WOULD
OF US IT DEVELOPERS, OR EVEN CITIZEN
OUR CHILDREN, BECAUSE THEY'RE THE
WORLD OF THE FUTURE. SO I ASKED
TO DO TO HELP THEM OUT ALONG THE
WITH HELP. THIS SESSION WAS FOR
AND SHARED IN A RANGE OF GAMES ON
STORY READING COMPETITION. >> ONE
TELL YOU. >> LEO AND ROBIN BUILT
THE ADULTS TO SEE THE POTENTIAL
>> WE'RE TRYING TO CREATE A POWER
AROUND. >> FANTASTIC I'LL NOW HAND
YOU WHY POWER APPS ARE GOOD FOR
TOOL THAT IS EASY TO USE AND EASY
APPS WITHOUT ANY CODE. SO PARENTS,
ON POWER APPS TODAY. IF YOU WANT
AND GET INVOLVED THE SEARCH POWER
I'M A PM ON THE ENGINEERING TEAM
HAVE THE SESSION IN 2 PARTS. FIRST
AND DEMOS TO CHECK OUT AND THE SECOND
HAVE THE QUESTIONS POSTED IN THE
THROUGH THE SESSION, OR SAVE TO
TO TAKE AS MANY AS WE CAN. OVER
JOINING TODAY TO LEARN ABOUT OUR
CONTAINER. AT THE END OF MY PRESENTATION
LINKS TO DOWNLOAD TODAY'S DECK AND
BACK AND RELAX AND LEARN ABOUT SQL
PARTS AN A PART OF SQL SERVER ON
SQL SERVER 2019 WITH FUNCTIONALITY
WHY SQL SERVER ON LINUX, WHY AS
PLATFORM FOR YEARS OF SQL SERVER
PERFORMANCE. THE STORY OF CAPABILITY
THE CODE ONCE AND DEPLOY, ON THE
WITH AZURE SQL EDGE IN THE DATA
AZURE VM OR IN A KUBERNETES ENVIRONMENT,
CAPABILITIES WITH DEVELOPERS WITH
CAPABILITIES INCLUDING FOR DATA
AND AS A DEVELOPER YOU WANT TO USE
AND WE HAVE THAT ON SQL SERVER ON
PLATFORM AND OPEN SOURCE. WE LAUNCHED
ME IF PEOPLE ARE USING IN IN PRODUCTION,
IN ITALY ABLE TO MIGRATE THE EXISTING
DO THAT AND MAKE IT PRODUCTIVE IN
A LOOK AT HOW SQL SERVER ON LINUX
THIS PROBLEM YOU WANT TO RUN A PYTHON
AND YOU HEARD ABOUT THE SERVICES
T SQL INTERFACES BUT THE DATA IS
ACCESS. SO HOW ARE YOU GOING TO
MODEL AND GIVE ACCESS TO THE ORACLE
POLLGY BASE TO ALLOW YOU TO DO THAT
I'LL BRING UP A TOOL AZURE STUDIO.
ON MAC, WINDOW OR LINUX AND IN THIS
ME TO COMBINE TEXT TO MARK WHAT
THE RESULTEDS ARE SAVED IN THE NOTEBOOK.
I'M GOING TO CREATE SOMETHING CALLED
GOING TO STORE METADATA TO SQL SERVER
WHAT USE A BUILT IN DRIVER PROVIDED
WITH MICROSOFT SUPPORTS THOSE. AND
CALLED AN EXTERNAL TABLE. IT'S LIKE
IT'S IN THE EXTERNAL DATA SERVER.
WILL REDIRECT QUERIES THROUGH THE
MAP OF THE ORACLE COLUMNS, MAPPING
THE SQL SERVER SYSTEM WHERE IS THE
ORACLE SIDE. NOW WITH POLYBASE,
THAT ACCESS THE DATA TABLE AND ALL
NEED WILL BE PULLED FROM ORACLE
SQL IS MAPPING THAT FOR ME. AND
HERE I CREATE A SQL VIEW AND EXTRACT
FROM THE FACT I'M USING ORACLE OR
RENTAL DATA. ONE OF THINGS I WANT
MODEL IS TRAIN A MODEL. SO WE'LL
SAVED MODEL AND STORE IN A TABLE.
AND THEN WHAT WE'RE GOING TO DO
PROCEED YOUR, THAT WILL ALLOW US
MODEL. YOU CAN SEE IN THE CODE THERE
ONE IS A QUERY USING THE RENTAL
TRAINED MODEL. SO WHEN THIS PROCEDURE
THE MODEL ON ORACLE DATA USING THE
RUN THE MODEL. I USE THE SAME THING
PYTHON CODE. IN THIS CASE IT'S DIFFERENT.
GOING TO ORACLE WITH THE SAME YEAR
PREVIOUS YEARS AND THE INPUT PARAMETERS.
BE THE PREDICTIONS SO WHEN THIS
STORED IN THE TABLE IN SQL SERVER,
BASED ON THE MODEL PREVIOUS L SAVED.
SAVED IN THE SQL TABLE AND NOW I
IS PRETTY AMAZING ALL WITHIN T-SQL.
A SQL VIEW AND NOW I CAN DO MACHINE
SERVER. LET'S GO IN OTHER NOW AND
CONTAINER A VERY POPULAR TOPIC.
TO USE A CONTAINER. SO ONCE YOU
GETS YOU UP AND RUNNING IN SQL IN
WANT TO USE FREE SOFTWARE AND WE
IS A FREE VERSION OF SQL SERVER
IN PRODUCTIONS A SIMPLE SWITCH CAN
SERVER ARE GREAT FOR DEVOPS SCENARIOS
THESE PROOF POINTS, CLUSTERS THAT
WITH SQL SERVER IN KUBERNETES. AZURE
IN THE CONFERENCE, AND AZURE ARCH
RIGHT NOW. THAT RUNS IT AS WELL
ARE PROOF POINTS OF IT RUNNING IN
OF SQL SERVER WITH DEVOPS. CONSIDER
OF DEVELOPERS AND SHARING A SQL
RUNNING ON TOP OF EACH OTHER, YOU
CONFIGURATION SERVER BUT OTHER DEVELOPERS
KEEP CLYDING ON A SHARED ENVIRONMENT,
POWER OF AZURE PIPELINES TO DO AMAZING
HAVE FOR A YAMMER FILE. THIS IS
IN A JOB. IN MY CASE IT'S USING
AND BUILD THE CONTAINER, AND RUN
CUSTOM CONTAINER THAT WILL CREATE
THAT DOES AN APPLICATION TEST. SINCE
FILE TO COMPOSE THE CONTAINER, SO
A CHANGE TO THE COMPOSE AND CHANGE
IS A MINER UPDATE TO SQL SERVER,
OVER TO GITHUB FOR DESKTOP AND I'M
GITHUB REPOSITORY, SO I'LL SAY HERE
AND COMMIT IT AND PUSH THIS UP TO
DOING THIS WAY THE AZURE PIPELINE,
WHAT I MAKE CHANGES IT RECOGNIZES
JOB. CAN YOU SEE THE JOB ALREADY
TO GO THROUGH A PROCESS OF BUILDING
TALK ABOUT WHILE THAT JOB IS RUNNING
BIT. I SHOWED YOU THE DOCKER COMPOSE
WITH. AND HERE IS A HOST FOR SQL.
SO THIS CONTAINER CAN CREATE A DATABASE
CAN CONNECTED TO THIS SERVER RUNNING
CONTAINER. TO CREATE A DATABASE
USE YOUR TOOLS IMAGE AND CREATE
THAT WILL BE COMMAND LINE TOOLS
WILL HAPPEN THIS SHELL SCRIPT WILL
SQL COMMAND TOOL TO RUN THIS SQL
IT LOOKS LIKE CREATING A DATABASE.
NOTICE THE DEMANDS IN THE MIDDLE.
FOR CHANGES FOR THE DATABASE. THIS
ENVIRONMENT WITH MY PIPELINE. I
THE CHANGES. AND SO FOR THE APPEAR
THIS WILL RUN A SQL SCRIPT AS WELL.
APPLICATION HERE AND THE SQL SCRIPT
LET'S LOOK AT THE PIPELINE AND SEE
FINISHED. WE STARTED UP THE CONTAINER
DATABASE RUNNING THE SCRIPTS AND
QUERY, THIS IS REALLY POWERFUL STUFF.
IT AUTOMATICALLY SPUN UP A VM AND
SPUN DOWN THE VM. THIS IS MAIZING
SQL CERTIFY SERVERS, LET'S TALK
TO FOCUS ON INTELLIGENT PERFORMANCE
ENHANCE TO RUN IT FASTER WITH PROCESSING
THAT EXAMPLE OF INTELLIGENT QUERY
WITH NO CODE CHANGES TO MAKE A CONFIGURATION
LET'S LOOK AT AN EXAMPLE. BACK OVER
NOTEBOOK HERE WHERE I CREATE A STORED
PATTERN. PRIOR TO SQL 19 WE ESTIMATE
ROWS IN THERE YOU MIGHT NOT GET
IS AN EXAMPLE OF ITERATION OF 25
I GET ABOUT 21 SECONDS TOTAL EXECUTION