PASS Summit Keynote 2 – Release 2

pass_2016_website

Dr. David DeWitt is getting ready to take the stage to a huge ovation and is thrilled to be back at PASS Summit.

Haha, bring back #BringBackRimma is a twitter tag that he has put in place….looking forward to hearing Dr. David DeWitt speak today…..

  1. Why data warehousing in the cloud
  2. Scalable DW fundamentals
  3. A look at 3 leading competitors

Why Data Warehousing in the Cloud

Reduce time to insights

Dynamic adjust capacity

Appliances will always be the gold standard and cloud is somewhere in between, but there is no “free lunch”

No CapEx and low OpEx

Go from conception to nsight in hours

Rock bottom storage prices

Simple upgrade process

Flexibility to scale up/down compute capacity

Scalable DW Fundamentals

Interesting to see partitioned parallelism as a point that discusses software building blocks.

Hardware failures carrying over into the cloud…..yes this does happen.

What are some alternatives to scalable DW designs? Shared-Nothing and Shared-Storage.

Shared-Nothing is the gold standard; can be designed and scaled indefinitely.

*Storage and compute are co-located*

Shared-Storage is stored on remote storage (SAN, Azure, S3)

Demos occurring………………….

PASS Summit Keynote 2 – Release 1

pass_2016_website

Grant Fritchey taking the stage to talk about the financial health of PASS.

250k members , 170 countries, and 87% global representation – outstanding.

73% return into the community; focused on being a one global community

119 SQL Saturday Events held in 2016; have had pretty solid growth over the course of 2012-2016

Six 24 hours of pass in 5 different languages

A new PASS BA Event in Chicago coming up; be on the lookout for details.


Denise talks about what does PASS mean to you? Interesting question so ask yourself; what does PASS mean to you?

Professionals discover, create, and network those are some of the topics that have been addressed.

Connect….ShareLearn > but as technology progresses and grows so do we.

PASS with a new BRAND……yep that’s right. New shirts are flying out for the new brand.

A new website is on it’s way (work in progress) with a launch date of early next year.


11:45 WIT luncheon today sponsored by SentryOne (ticket required – check with the registration desk)

Speaker idol at 4:45 round 2


 

 

 

PASS Keynote Part 2 – Live Coverage

pass_2016_website

 

Good morning from PASS Summit in Seattle, Washington. Like yesterday I will be live blogging the event. The same format of the blog will apply with up to 5 releases every 15 minutes.

Yesterday was a great first keynote, and from what it appears attendees are pretty excited to see what the second keynote will hold.

If you get a chance check out the blog and look forward to keeping you informed.

 

PASS Summit Live Keynote – Release 5

pass_2016_website

Julie Koesmarno, Senior Project Manager at Microsoft, takes the stage to talk about business analytics utilizing War and Peace.

Tracing emotions of each key characters via a heat map…..pretty cool to see application of SQL Light language.

Cognitive capabilities managed with big data……


Deep learning is everywhere; this means that SQL Server 2016 falls into that category. Seeing a demo on drone functionality and feeling the pulse of the power grid


Jen Stirrup (Data “Whisperer”) takes the stage and talks Pokemon…..yes folks Pokemon but there is more than that.

Utilizing Power BI for the activity for each Pokemon sprinkled in with some “R”. The data itself is stored in the Azure SQL Database with utilizing the Azure Services.

 

 

PASS Summit Live Keynote – Release 4

pass_2016_website

Document DB: Blazing fast planet-scale NoSQL:

  • Guaranteed Low Latency
  • Elastically Scaling Storage
  • Elastically Scaling Throughput
  • No Impedance Mismatch
  • Choice of Consistency
  • Enterprise Level SLA

Azure + DocumentDB with leading game technology. A game and TV show integration of Walking Dead that brings exclusive clip content into the game using Azure media services.

15 million installs

120 GB of new data each day

11,500 DocumentDB requests per second

43 million Walkers eliminated each day

1.9 million matches made each day utilizing DocumentDB

1 million guilds

10 million chat messages per day

250 million leader board entries


Integral Analytics Scott Smith VP of Product has come on stage that discusses how data science and software company that provides core operational, planning, and valuation applications for utilities and other participants in the electric-energy industry.

Visualization of data that is important being able to keep lights and data centers running with giving respect to the electric grid – – all using the Azure Data Warehouse capabilities.

Electric Grid: from 100K to 500M records per 1M customers a day in the past 5 years

PASS Summit Live Keynote – Release 3

pass_2016_website

 

Justin Silver, Scientist Pros, takes the stage……

Taking data science out of the lab settings and placing it into real world scenarios.

Azure has tremendously been able to allow enhanced functionality into the realm of data science bridging the gap 100x faster with SQL Server 2016.

Microsoft is the only vendor that has the depth and breathe to handle the capacity the Pros company needs in order to succeed.


Sneak preview after Just leaves the stage……HTAP solution scaled out.

What can we do to solve a data visualization problem within SQL server and how can we expand its capabilities. SQL Server 2016 shipped with Polybase to  help provide this type of solution….the always on functionality can replicate 10 times the data from where we were in the past.


Intelligent Database Service – machine learning to capture behaviors for intelligent capabilities.

Better together with Windows Server – unparalleled SMP capability

_________________________________________________________________

Yes folks…just saw a restore onto SQL Server running on Linux…..installed SQL; restored backup from windows…..keeps getting better.

22,000+ registrations >50% of fortune 500

 

 

PASS Summit Live Keynote -Release 2

pass_2016_website

Rohan Kumar, General Manager of Microsoft, takes the stage hyping up SQL Server 2016. We keep hearing the word “Sharing” among databases.

Intelligent Database:

  1. In-Memory Analytics
  2. In-Memory OLTP

Wow, 100X faster analytics + 30x faster transactions

Azure SQL database is the first in the world to support HTAP technology

Two worlds coming together – industry leading in-memory enhancements with built-in advanced analytics with R

One million transactions per second using SQL 2016 – that’s right….you heard that.

R services integration into SQL 2016 – is pretty powerful