Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence
Archives: October 2012
Parallel Data Warehouse (PDW) Tip: Proof of Concept (POC) Guidelines
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field for successful POC engagements, we must, at a minimum, consider the following guidelines.
Guideline 1: Identify Existing Roadblocks and De-scope
Major POC challenges can manifest themselves in many different forms… Read more
0 comments, 993 reads
Posted in Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence on 23 October 2012
Visio 2010 Workaround: Application Hangs when opening ‘Database Model Diagram’ template
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’.
The program VISIO.EXE version 14.0.6122.5000 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center…
5 comments, 1,039 reads
Posted in Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence on 18 October 2012
Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to perform an initial data load of table or even go through the PDW-specific steps to perform a ‘trunc and load’ of… Read more
2 comments, 1,625 reads
Posted in Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence on 15 October 2012
Parallel Data Warehouse (PDW) How-To: Using BACKUP and RESTORE DATABASE on PDW
Before we get to the backup and restore syntax, its worth noting that the Parallel Data Warehouse (PDW) appliance architecture offers an environment that greatly enhances backup times (due to dedicated storage and network interfaces, see the following post for more information - http://saldeloera.wordpress.com/2012/07/09/lesson-1-of-parallel-data-warehouse-basic-architecture-overview/). Summarized below, the observable backup… Read more
0 comments, 4,599 reads
Posted in Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence on 4 October 2012