Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

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.


No comments.

Leave a Comment

Please register or log in to leave a comment.