Hello Dear Reader! It's that time of the year again, time for the PASS Summit and the streaming Keynote. Here we go!
11/5/2014 10:05 AM
T.K. takes the stage again. Announces that Azure ML is available for free today, you just need a live ID. He's got the slide from the beginning up. They did a really good job of showing an end to end story here.
11/5/2014 9:53 AM
James Phillips takes the stage to talk about Power BI and Power Pivot, he's showing us the visualizations, and how to take the big data that Joseph showed us and consume it as a user.
We are getting a really nice overview of PowerBI on the web. When the video posts I'll get a link in there, because this is moving to fast for good descriptions.
11/5/2014 9:38 AM
Demo of Stretch table was really awesome. Not sure how much I can say about this at this point.
But this could have huge potential.
Sanji comes out to do a demo in-store analytics using an x-box Kinect. Showing heat map made in power maps. They can see where people are hanging out, so they can understand shopping behavior in a store. How do they consume that data quickly. Using Azure Data factory to show orchestration, and lineage in the cloud.
They are walking through Azure ML, showing how to use a work flow to process past data to make predictions on future buying patterns.
We now see how this will work on a mobile app. Cortana is on the mic talking, making product recommendations after Sanji check's in. She recommends beer mugs. Then she shows him where to find them on the in store map. Very very cool.
11/5/2014 9:19 AM
Sneak peak of the technology with Mike Zwillig from the SQL Team takes the stage. He starts with a demo on Pier 1 imports. He talks about the issues of getting data reporting from a data mart.
Neat demo he asks the audience to go to a website and click on items to buy them. He then shows real time reporting of what is being purchased using an *writeable nonclustered Columnstore on an IN-MEMORY OLTP TABLE*. Awesome.
11/5/2014 9:10 AM
Tracey leaves the stage and we move on to Maximizing performance & availability. T.K. talks about how running SQL DB across all of Microsoft has forced them to think not just as engineers but as DBA's.
Not sure if I heard this right but T.K. just said they are working on In-Memory ColumnStore. That would be HUGE. We see a list of business that are currently using the cloud and on-prem in very clever and very performant ways ensuring millisecond response times. He discusses that Samsung has achieved x24 performance with In-Memory OLTP.
We now play a video from Dell on how they are using In-Memory OLTP. They say they have achieved x4, performance.
T.K. is announcing that SQL DB will have significant improvements in T-SQL Compatibility, larger indexes, Parallel queries, extended events, and In-Memory Columnstore for data marts. Wow. There it is. If it is in SQL DB, does that mean we will see this in the box product?
11/5/2014 9:01 AM
Tracey continues his demo showing how they can use JSON files to change the schema of their search pattern, based on marketing promotions. Using the Shard Utilization heat map that shows how to add processing power, monitor usage, how to scale over different regions. How you can change the SQL DB scale. This was very cool.
One more thing. They GA'ed a new feature last week, they are going to take their Pier 1 main database, they show the load on it. They want to configure geo-replication. On the map they show all of their deployments. Tracey is replicating the main database to Asia. There were three clicks to do that. Very impressive. I would like to see what the bandwidth requirements are for that, this may require a further look.
11/5/2014 8:46 AM
T.K. continues, we are adding 40% data in the world every year. We need to have and form a Data culture. Three key tenants:
1. Harness new data types
2. Tackle big data
3. Deliver solutions faster
His vision of the system development lifecycle is to transform & analyze, Visualize & decide, and capture & manage. He puts up a slide showing how the different Microsoft platform stack relate to these items. We will focus on capture & manage because that is where the data platform stack fits in. He's stressing that this is an 'and' world not an 'or' world. They want their platform to tie together like never before. More talking points, capture a diverse set of data, achieve elastic scale, maximize performance & availability, and simplify things with the cloud.
Here's a couple of highlights from the past year. Cloud first, Mobile first. Get used to hearing that. He is discussing advances in Azure Document DB, Azure HDInsight, Analytics Platform System, and Azure Search.
The ability to scale for 2014 is very impressive. 640 logical cores.
A partner, Tracey, from Peir 1 imports comes out to display intelligent search using fuzzy logic. He is demoing searching for Orange Pumpkins. They are using Azure search and two lines of code.
11/5/2014 8:35 AM
Tom introduces the Executive VP's of SQL Server T.K. Rengarajan, James Phillips, and Joseph Sirosh to help share the vision they have for the Data Platform stack. A video shows of the three talking about their backgrounds and area's of expertise. It's interesting that they are all relatively new to being the EVP's for SQL Server. Should be interesting to see how this brings about new features, or what their view on expanding the stack is.
A video is now playing of different vendors and early adopters of the Microsoft stack, discus and how they are currently using the stacks. T.K. Rengarajan takes the stage. He talks about his ba
ckground and studying under Dr. Dewitt. He speaks about his family and two daughters, he is invested in WIT because he hopes they have wonderful career in technology.
He discusses about how he loves MAPs, using maps to navigate family vacations. He discusses using MapQuest ('remember MapQuest, he says'). Then GPS made trips even easier, and this is a natural way to see how data and technology has changed our lives.
11/5/2014 8:25 AM
PASS President Tom Larock starts off on stage. He welcomes the first timers and points out that we are currently streaming live to over 50 countries. Tom ask for a round of applause for Microsoft for making the best data platform on the planet.
Tom is giving us an overview of the road so far. How PASS was started and founded. From the first
PASS Summit with 1,200 attendees to today with 5,899 attendees. Since it's inception PASS has produced 1.3 Million hours of training.
Tom asks us to think about where we were five years ago, and where you are now. He asks you to look at your future in the same way. "Growth is never by mere chance; it is the result of forces working together."- James Cash Penney.
Tom is addressing the changes PASS has made to have a larger umbrella. He is asking people to get involved in growing PASS. Meet new people, learn & grow, volunteer, join a chapter, or talk to the Board of directors.
Tom is discussing some of the events available at the Summit. The SQL Cat Team, 50% off Microsoft Certifications, Birds of a feather luncheon, the Women in Technology Luncheon, and Speaker Idol. Tom Thanks the exhibitors and vendors. There is an Exhibitor Reception tonight form 6 pm to 8 pm.
Okay Dear Reader, this was a great way to kick off the Summit. I’m off to finish up some prep before my first presentation today. See you soon!