{"id":1323,"date":"2014-03-20T16:34:00","date_gmt":"2014-03-20T23:34:00","guid":{"rendered":""},"modified":"2024-01-22T22:49:00","modified_gmt":"2024-01-23T06:49:00","slug":"modernizing-your-data-warehouse-with-microsoft","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/03\/20\/modernizing-your-data-warehouse-with-microsoft\/","title":{"rendered":"\u201cModernizing\u201d Your Data Warehouse with Microsoft"},"content":{"rendered":"

Data warehousing technology began as a framework to better manage, understand, and capitalize on data generated by the business, and it worked extremely well for many years. This is a space that Microsoft knows well with warehousing capabilities since 1995 with SQL Server.<\/p>\n

However, there are several forces working to stretch the traditional data warehouse. Data volume is expanding tenfold every five years. Even the most robust SMP warehouse will require costly forklift operations to a larger and more expensive hardware footprint to keep up with the growth. Companies are using real-time data to optimize their businesses as well as to engage in dynamic, event-driven processes. The variety of new data types is proliferating with over 85 percent of new data coming from non-relational data such as logs, mobile, social, RFID, and devices.<\/p>\n

Modernizing your data warehouse with new technologies can help you meet the needs of today\u2019s enterprise to connect all volumes of any data with agile and familiar BI to business decision makers. This was validated by The Data Warehousing Institute (TDWI) who published a checklist<\/a> to enable the modern data warehouse.\u00a0 At a high level, your new warehouse must be able to handle:<\/p>\n