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

Microsoft’s Data Warehouse offerings

If you are the decision maker in your company and you are tasked with purchasing one or more servers to be used solely for SQL Server and solely as a data warehouse, be aware there are options outside of the usual ordering a server and internally installing the hardware, OS, and SQL Server.

Fast Track Data Warehouse is a reference configuration optimized for data warehousing.  This saves an organization from having to commit resources to configure and build the server hardware.  Fast Track Data Warehouse hardware is tested for data warehousing which eliminates guesswork and is designed to save you months of configuration, setup, testing and tuning.  You just need to install the OS and SQL Server.  There are currently ten vendors who offer servers based on the Fast Track Data Warehouse architecture, such as HP Fast Track Solutions for Microsoft SQL Server.

Taking it a step further, there are two appliances from HP that further customize the servers along with installing all the software: HP Business Decision Appliance (BDA) and Microsoft and HP Business Data Warehouse appliance (BDW).  More info is at my blog Microsoft SQL Server Reference Architecture and Appliances.

If you are a larger company with a nice budget, and are looking at having a data warehouse in the hundreds of terabytes, then the Microsoft SQL Server Parallel Data Warehouse (PDW) might be an option.  This is a massive parallel processing option where all the hardware and software is installed for you at your location.  More info is at my blog Microsoft SQL Server Parallel Data Warehouse (PDW) Explained.

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


No comments.

Leave a Comment

Please register or log in to leave a comment.