Artis has been doing a ton of work recently with the APS appliance, and I have really enjoyed boiling down some of the lessons learned into presentation form. Speaking on a technology like APS is incredibly rewarding when you see everyone's jaw drop at the query performance and the hardware stats.
I recently had the pleasure of presenting a session entitled One is the Loneliest Number: Scaling out your Data Warehouse to a local SQL Saturday crowd. The slides can be found here.
If your current data warehouse is overworked and underpaid, maybe it needs a friend to share the load. Do you want to be able to scan your 1TB fact table in 20 seconds? Do you want to maintain performance even if data volumes triple without rewriting any code? Do you want a data warehouse which extends to the cloud?
This demo heavy session will be a deep dive into scaling out your data warehouse onto the Analytics Platform System appliance from Microsoft and querying it with familiar T-SQL. You will learn performance tuning best practices for taking advantage of a distributed data warehouse. See demos of hybrid connectivity to Azure Blob Storage through a technology called Polybase and learn how a modern data warehouse can handle structured data, semi-structured data, and streaming data.
In case you're wondering about the title, it's a Three Dog Night song, so of course we had to start the session by watching the rather silly video.
Adopting a Modern Hybrid Data Warehouse
In the next few weeks I will be speaking in Houston and Dallas:
Do you want to be able to get results much faster from really large data sets? Are you and your team tired of waiting for slow reports to complete? Do you want to be able to scan your 1TB fact table in 20 seconds?
Join Microsoft and Artis Consulting to learn about the Modern Data Warehouse and how it can handle structured data, semi-structured data, and streaming data with the Analytics Platform System (APS) appliance and the recently announced Azure SQL Data Warehouse from Microsoft. In this interactive lunch session, you will:
See demos of hybrid connectivity to Azure Blob Storage through a technology called Polybase
Learn how to scale out your data warehouse onto the APS and query it with familiar T-SQL
Learn the underpinnings of a distributed data warehouse which can scale to satisfy even the most demanding workloads
Hear a case study of a company that is revolutionizing their business and their industry with a modern hybrid data warehouse
Together we will answer the question of whether migrating to the APS appliance is the next step for your overworked data warehouse.