#Azure #SQLDW, the cost benefits of an on-demand data warehousing

%3CLINGO-SUB%20id%3D%22lingo-sub-142733%22%20slang%3D%22en-US%22%3E%23Azure%20%23SQLDW%2C%20the%20cost%20benefits%20of%20an%20on-demand%20data%20warehousing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-142733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fservices%2Fsql-data-warehouse%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20SQL%20Data%20Warehouse%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bis%20Microsoft%E2%80%99s%20SQL%20analytics%20platform%2C%20the%20backbone%20of%20your%20Enterprise%20Data%20Warehouse.%20The%20service%20is%20designed%20to%20allow%20customers%20to%20elastically%20and%20independently%20scale%2C%20compute%20and%20store.%20It%20acts%20as%20a%20hub%20to%20your%20data%20marts%20and%20cubes%20for%20an%20optimized%20and%20tailored%20performance%20of%20your%20EDW.%20Azure%20SQL%20DW%20offers%20guaranteed%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fsupport%2Flegal%2Fsla%2Fsql-data-warehouse%2Fv1_0%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E99.9%20percent%20high%20availability%3C%2FA%3E%3CSPAN%3E%2C%20PB%20scale%2C%20compliance%2C%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-overview-manage-security%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eadvanced%20security%3C%2FA%3E%3CSPAN%3E%2C%20and%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-overview-integrate%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Etight%20integration%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bto%20upstream%20and%20downstream%20services%20so%20you%20can%20build%20a%20data%20warehouse%20that%20fits%20your%20needs.%20Azure%20SQL%20DW%20is%20the%20only%20data%20warehouse%20service%20enabling%20enterprises%20to%20gain%20insights%20from%20data%20everywhere%20with%20a%20global%20availability%20in%20more%20than%2030%20regions.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThis%20is%20the%20last%20blog%20post%20in%20our%20series%20detailing%20the%20benefits%20of%20Hub%20and%20Spoke%20data%20warehouse%20architecture%20on%20Azure.%20On-premises%2C%20a%20Hub%20and%20Spoke%20architecture%20was%20hard%20and%20expensive%20to%20maintain.%20In%20the%20cloud%2C%20the%20cost%20of%20such%20architecture%20can%20be%20much%20lower%20as%20you%20can%20dynamically%20adjust%20compute%20capacity%20to%20what%20you%20need%2C%20when%20you%20need%20it.%20Azure%20is%20the%20only%20platform%20that%20enables%20you%20to%20create%20a%20high%20performing%20data%20warehouse%20that%20is%20cost%20optimized%20for%20your%20needs.%20You%20will%20see%20in%20this%20blog%20post%20how%20you%20can%20save%20up%20to%2050%20percent%20on%20cost%20by%20leveraging%20a%20Hub%20and%20Spoke%20design%20while%20increasing%20the%20overall%20performance%20and%20time%20to%20insights%20of%20your%20analytics%20solutions.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%2206a8c3b4-1dfc-4584-9b08-72b4a611a140.png%22%20style%3D%22width%3A%20595px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F26520i331D01E1B00FA871%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%2206a8c3b4-1dfc-4584-9b08-72b4a611a140.png%22%20alt%3D%2206a8c3b4-1dfc-4584-9b08-72b4a611a140.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ERead%20more%20about%20it%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Fazure-sqldw-the-cost-benefits-of-an-on-demand-data-warehousing%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20blog%3C%2FA%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-142733%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20%26amp%3B%20Storage%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Warehouse%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Community Manager

Azure SQL Data Warehouse is Microsoft’s SQL analytics platform, the backbone of your Enterprise Data Warehouse. The service is designed to allow customers to elastically and independently scale, compute and store. It acts as a hub to your data marts and cubes for an optimized and tailored performance of your EDW. Azure SQL DW offers guaranteed 99.9 percent high availability, PB scale, compliance, advanced security, and tight integration to upstream and downstream services so you can build a data warehouse that fits your needs. Azure SQL DW is the only data warehouse service enabling enterprises to gain insights from data everywhere with a global availability in more than 30 regions.

 

This is the last blog post in our series detailing the benefits of Hub and Spoke data warehouse architecture on Azure. On-premises, a Hub and Spoke architecture was hard and expensive to maintain. In the cloud, the cost of such architecture can be much lower as you can dynamically adjust compute capacity to what you need, when you need it. Azure is the only platform that enables you to create a high performing data warehouse that is cost optimized for your needs. You will see in this blog post how you can save up to 50 percent on cost by leveraging a Hub and Spoke design while increasing the overall performance and time to insights of your analytics solutions.

 

06a8c3b4-1dfc-4584-9b08-72b4a611a140.png

 

Read more about it in the Azure blog.

0 Replies