Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to deliver validated, pre-configured solutions that reduce the complexity of implementing a data warehouse on SQL Server Enterprise Edition. The Data … Continue reading →
No, Superdome X is not the name of the stadium where they played in the last Super Bowl. Rather, Superdome X is HP’s top of the line server running Windows Server 2012 R2 and SQL Server 2014 Enterprise Edition or Windows Server 2016 … Continue reading →
Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics Conference. Here are the PowerPoint presentations: Overview of Microsoft Appliances and Building an Effective Data Warehouse Architecture. Overview of Microsoft Appliances … Continue reading →
As a follow-up to my blog Dell Quickstart Data Warehouse Appliance for SQL Server 2012, Dell announced the availability of the second appliance in the Quickstart family: the Quickstart Data Warehouse Appliance 2000 (QSDW2000). This is a pre-built appliance for data warehouses … Continue reading →
In the next few weeks there will be an update to the SQL Server Parallel Data Warehouse (PDW) called “Appliance Update 3” or “AU3”. More than just a cumulative update, an Appliance Update is a complete refresh on the entire solution including software, hardware, … Continue reading →
As a follow-up to my blog Microsoft SQL Server Reference Architecture and Appliances, Dell recently announced the future availability of Dell Quickstart Data Warehouse Appliance based on SQL Server 2012. Right now only HP has a Business Data Warehouse appliance (BDW). Basically these … Continue reading →
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG. Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes As a followup to a question from the presentation about clustering the appliances, I … Continue reading →
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (DBC) (see my blog about the other two appliances). In short, this appliance consolidates databases into a single, virtual environment. In more detail: Many customers continue to struggle with … Continue reading →
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 … Continue reading →
Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and database consolidation solutions in a very short time, with all the components pre-configured and pre-optimized. These appliances include all the … Continue reading →
Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server 2008 R2 that was released in December 2010. PDW is Microsoft’s reworking of the DatAllegro Inc. massive parallel processing (MPP) product … Continue reading →