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…..
- Why data warehousing in the cloud
- Scalable DW fundamentals
- 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)
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….Share…Learn > 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
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.
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.
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
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
Rohan Kumar, General Manager of Microsoft, takes the stage hyping up SQL Server 2016. We keep hearing the word “Sharing” among databases.
- In-Memory Analytics
- 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