10:01
Lights are coming up. It’s time to rock!

10:00
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.

9:59
Three patters of intelligence. Go try them out. Confluence of cloud, data and intelligence.

9:58
Can start to predict where the Pokémon are. Power BI, Azure SQL Database, R, Machine Learning.

9:57
Using R to create visualization. Deploying a tabular module to a URL! Data is in the cloud not a database.

9:56
What is the activity for each Pokémon? Where are the Pokémon?

9:55
Pokémon Go will be in the demo.

9:54
Demo from Jen Stirrup!!!!! Data Whisperer!!

9:53
Python tools for VS. R tools for VS. Azure Jupyter notebooks.

9:52
Redgate Data Platform Studio for Fully automated migrations.

9:51
New tools for upgrades. SQL Server migration assistant, data migration assistant, data experimentation assistant.

9:50
New algorithms in R.

9:48
Keeps power flowing.

9:47
Connected Drone video. Power line inspections.

9:46
Deep learning. Customer story Eastmark systems.

9:45
The power of the intelligent lake
Super-elastic DW. BI at the speed of thought
Big cognition

9:44
What if this was applied to all books?

9:43
Us to keep track of which books characters are in. Graph to see how characters are feeling. Heat map, trace emotions of key characters.

9:42
Build an interactive guide on top of results.

9:41
Sentiment analysis. Join key phrases to sentiments.

9:40
War and Peace. It is hard to keep track of the characters. It is unstructured data.

9:39
Intelligent queries using a SQL language U-SQL.

9:38
Julie Koesmarno up next to demo.

9:37
The How-Old.net app, captioning captionbot.ai.

9:36
Cognitive Services APIs. Very advanced tasks.

9:35
Bring your own intelligence, python, R.

9:34
3 data lake services. Hyper-scale storage optimized for analytics. Big data queries as a services. HDInsight clusters as a service.

9:33
Connect any tool. This is the tabular model. Extremely fast. Patabyte scale. Use Power Bi Session after this demonstrates this solution.

9:32
Azure Analysis Services in preview!!!! Pay for what you need, scale up and down. Bring in any data source.

9:31
Free trial of Azure SQL Data Warehouse.

9:30
No one wakes up and thinks about price of an electron.

9:29
Need to visualize the data.

9:28
Price of energy changes every 5 minutes.

9:27
The electric grid. One-directional power for 100 years. Now the data is flowing multiple ways. Consumers are also producers.

9:26
Scott Smith Integral Analytics.

9:25
Video. Stop, scale up, scale down.

9:24
Petabytes of data with analytics. Four services on Azure. Azure SQL Data Warehouse. It is a true elastic data warehouse.

9:23
Intelligent Lake. The rice equations. 40 ZB in 2020, much from sensors. An earth size rice bowl.

9:21
The game has new versions, but they don’t have to care about schema changes.

9:20
Showing a globe that shows where the matches are made. It is pretty busy out there.

9:19
1.9 M matches made each day. Matches between players to play games.

9:18
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.

9:17
This is the official game of the Walking Dead. The show and game are integrated.

9:16
Showing us a video Season 7.

9:15
Kalle Hiitola, Next Games. Walking Dead No Man’s Land, the number 1 game on Apple App Store. Built on Azure.

9:14
Store petabytes of data 99.99% availability. ACID consistency.

9:13
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.

9:12
That is amazing!

9:11
Now time to restore the database that was backed up on a Windows box. Now run a query.

9:10
He is copying a backup file. Now connecting with SSMS.

9:09
Next, configure the database. Installed in a few seconds. Now to start up.

9:08
SQL Server on Linux. Here is a demo. Command line install process.

9:07
145 TB FastTrack with 1.2 PB of user data. 24 TB of RAM. On premises or in Azure.

9:06
Better together with Windows server. Fast Track Architecture.

9:05
Intelligent Database Service — use machine learning to find attacks

9:04
Can the optimizer be made better?

9:03
All reporting tools just work

9:02
Took about 33 seconds across 5 different data sources.

9:01
Pretty complicated join

9:00
Data living in Teradata, Oracle, SQL Server, MongoDB, Hadoop

9:00
Demo, largest number of flights to Seattle from which city?

8:58
PolyBase to connect to non-SQL data. THen can query as it if was a SQL table

8:57
Solution uses AG. Analytics run on secondaries

8:56
HTAP solution scaled out.

8:55
Improved performance 100X in discount pricing app. There is a session on Thursday talking about this.

8:54
57% of the 3 B airline tickets are priced by PROS. The airlines respond to requests within 20 ms.

8:53
Apply data science to real world business problems.

8:52
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.

8:51
Jack Henry and associates processes 1.3 M loans / sec with this software running against SQL Server 2016.

8:50
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.

8:49
1 M predictions per second

8:48
SQL Server was able to process 1 M transactions per second.

8:47
that is the load on entire Visa cc processing. SQL can handle it

8:46
3 transactions per second. Raise to 56,000 transactions per second.

8:45
R script in a stored procedure.

8:44
Demo time. Fraud detection in real time.

8:43
R is the fastest growing language in analytics. Run R on column store indexed in-memory table.

8:42
Real-time analytics on production data. GA: 11/15/2016 1st fully managed HTAP in Azure SQL DB. Hybrid analytics and processing

8:41
Rohan Kumar — Intelligence DB
We are the number 1 database!! In-memory analytics (column store) + In-memory OLTP.

8:40
30 Billion database transactions a year running on SQL Server!!

8:39
Tap technology. Has SQL Server 2016 behind it. Very fast credit card processing.

8:38
Microsoft is the leader in the Gartners magic quadrant. Playing a video

8:37
Any data with Polybase and analytics with R.

8:36
SQL Server 2016 is a comprehensive platform that runs on premises or the cloud, and Linux (next year).

8:35
Intelligence DB. Push intelligence to where data lives. Share models between applications.

8:33
3 major innovations: Intelligence DB, Intelligent Lake, and Deep Intelligence

8:32
Intelligence in every software. Get deep predictive intelligence by integrating R and machine learning.

8:31
Azure machine learning is changing lives. A.C.I.D = Algorithms Cloud IOT Data

8:30
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.

8:28
Joseph Sirosh, head of data platform. Data can change lives.

8:27
Meet at least 5 new people this week. Visit the Microsoft area to ask your questions.

8:26
Visit our sponsors in exhibit hall. Thanks to the sponsors!

8:25
PASS will help you achieve your potential!

8:24
She is the leader in Louisville and a regional mentor!

8:23
MALA!

8:23
Volunteers drive PASS. Sounds like it is time for the PASSion award!

8:22
PASS is the one community for all data professionals. 300 chapters, 250K members, 170 countries.

8:20
500 Microsoft engineers and specialists onsite!

8:19
Adam Jorgensen, PASS President, on stage welcoming us.

8:18
Lights down, Welcome to PASS!

8:15
Watch the keynote live at http://PASSsummit.com

8:00 am
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.