Lights are coming up. It’s time to rock!
Video. Blind person. Smart Glasses tell him what is going on around him. Tells who is around and their emotions. Take a picture of the menu. It tells him hot to hold phone and helps him navigate the menu.
Three patters of intelligence. Go try them out. Confluence of cloud, data and intelligence.
Can start to predict where the Pokémon are. Power BI, Azure SQL Database, R, Machine Learning.
Using R to create visualization. Deploying a tabular module to a URL! Data is in the cloud not a database.
What is the activity for each Pokémon? Where are the Pokémon?
Pokémon Go will be in the demo.
Demo from Jen Stirrup!!!!! Data Whisperer!!
Python tools for VS. R tools for VS. Azure Jupyter notebooks.
Redgate Data Platform Studio for Fully automated migrations.
New tools for upgrades. SQL Server migration assistant, data migration assistant, data experimentation assistant.
New algorithms in R.
Keeps power flowing.
Connected Drone video. Power line inspections.
Deep learning. Customer story Eastmark systems.
The power of the intelligent lake
Super-elastic DW. BI at the speed of thought
What if this was applied to all books?
Us to keep track of which books characters are in. Graph to see how characters are feeling. Heat map, trace emotions of key characters.
Build an interactive guide on top of results.
Sentiment analysis. Join key phrases to sentiments.
War and Peace. It is hard to keep track of the characters. It is unstructured data.
Intelligent queries using a SQL language U-SQL.
Julie Koesmarno up next to demo.
The How-Old.net app, captioning captionbot.ai.
Cognitive Services APIs. Very advanced tasks.
Bring your own intelligence, python, R.
3 data lake services. Hyper-scale storage optimized for analytics. Big data queries as a services. HDInsight clusters as a service.
Connect any tool. This is the tabular model. Extremely fast. Patabyte scale. Use Power Bi Session after this demonstrates this solution.
Azure Analysis Services in preview!!!! Pay for what you need, scale up and down. Bring in any data source.
Free trial of Azure SQL Data Warehouse.
No one wakes up and thinks about price of an electron.
Need to visualize the data.
Price of energy changes every 5 minutes.
The electric grid. One-directional power for 100 years. Now the data is flowing multiple ways. Consumers are also producers.
Scott Smith Integral Analytics.
Video. Stop, scale up, scale down.
Petabytes of data with analytics. Four services on Azure. Azure SQL Data Warehouse. It is a true elastic data warehouse.
Intelligent Lake. The rice equations. 40 ZB in 2020, much from sensors. An earth size rice bowl.
The game has new versions, but they don’t have to care about schema changes.
Showing a globe that shows where the matches are made. It is pretty busy out there.
1.9 M matches made each day. Matches between players to play games.
They are a small team but have pulled off a global game. 120 Gb of new data each day. 11,500 DocumentDB requests per second. 43 M walkers eliminated each day.
This is the official game of the Walking Dead. The show and game are integrated.
Showing us a video Season 7.
Kalle Hiitola, Next Games. Walking Dead No Man’s Land, the number 1 game on Apple App Store. Built on Azure.
Store petabytes of data 99.99% availability. ACID consistency.
We have just doubled the platforms that SQL Server will run on. We live on The Planet of the Apps. Global apps. The fastest database for planet-scale is DocumentDB. NoSQL database.
That is amazing!
Now time to restore the database that was backed up on a Windows box. Now run a query.
He is copying a backup file. Now connecting with SSMS.
Next, configure the database. Installed in a few seconds. Now to start up.
SQL Server on Linux. Here is a demo. Command line install process.
145 TB FastTrack with 1.2 PB of user data. 24 TB of RAM. On premises or in Azure.
Better together with Windows server. Fast Track Architecture.
Intelligent Database Service — use machine learning to find attacks
Can the optimizer be made better?
All reporting tools just work
Took about 33 seconds across 5 different data sources.
Pretty complicated join
Data living in Teradata, Oracle, SQL Server, MongoDB, Hadoop
Demo, largest number of flights to Seattle from which city?
PolyBase to connect to non-SQL data. THen can query as it if was a SQL table
Solution uses AG. Analytics run on secondaries
HTAP solution scaled out.
Improved performance 100X in discount pricing app. There is a session on Thursday talking about this.
57% of the 3 B airline tickets are priced by PROS. The airlines respond to requests within 20 ms.
Apply data science to real world business problems.
Justin Silver, Scientist PROS. How many here flew to this conference? How was the price determined? PROS helps companies like airlines figure out prices using data science and massive datasets.
Jack Henry and associates processes 1.3 M loans / sec with this software running against SQL Server 2016.
Predict loan defaults. 20 M loans, an R model, advanced reporting for credit unions product. In real time predict what happens if credit score changes, interest rate changes, etc.
1 M predictions per second
SQL Server was able to process 1 M transactions per second.
that is the load on entire Visa cc processing. SQL can handle it
3 transactions per second. Raise to 56,000 transactions per second.
R script in a stored procedure.
Demo time. Fraud detection in real time.
R is the fastest growing language in analytics. Run R on column store indexed in-memory table.
Real-time analytics on production data. GA: 11/15/2016 1st fully managed HTAP in Azure SQL DB. Hybrid analytics and processing
Rohan Kumar — Intelligence DB
We are the number 1 database!! In-memory analytics (column store) + In-memory OLTP.
30 Billion database transactions a year running on SQL Server!!
Tap technology. Has SQL Server 2016 behind it. Very fast credit card processing.
Microsoft is the leader in the Gartners magic quadrant. Playing a video
Any data with Polybase and analytics with R.
SQL Server 2016 is a comprehensive platform that runs on premises or the cloud, and Linux (next year).
Intelligence DB. Push intelligence to where data lives. Share models between applications.
3 major innovations: Intelligence DB, Intelligent Lake, and Deep Intelligence
Intelligence in every software. Get deep predictive intelligence by integrating R and machine learning.
Azure machine learning is changing lives. A.C.I.D = Algorithms Cloud IOT Data
Many children in India drop out of school. They do not get to reach their potentials. Student drop-out prediction service to prevent children from dropping out and improve education.
Joseph Sirosh, head of data platform. Data can change lives.
Meet at least 5 new people this week. Visit the Microsoft area to ask your questions.
Visit our sponsors in exhibit hall. Thanks to the sponsors!
PASS will help you achieve your potential!
She is the leader in Louisville and a regional mentor!
Volunteers drive PASS. Sounds like it is time for the PASSion award!
PASS is the one community for all data professionals. 300 chapters, 250K members, 170 countries.
500 Microsoft engineers and specialists onsite!
Adam Jorgensen, PASS President, on stage welcoming us.
Lights down, Welcome to PASS!
Watch the keynote live at http://PASSsummit.com
I have arrived and have my laptop set up in the ballroom for the opening keynote. I can feel the energy in the room as #sqlfamily members say hello.