SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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………………….


The SQL Professor

Chris Yates is a Database Administration Manager with over thirteen years of experience in the SQL industry. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions accompanied by a strong development background. He enjoys helping others in the SQL Server community and does this by contributing on several SQL forums, creating “The SQL Professor”, and speaking at several SQL functions. His passion and focus is not only with technology but also helping others along their way and career path.

Comments

Leave a comment on the original post [chrisyatessql.wordpress.com, opens in a new window]

Loading comments...