Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

I started my career in IT nearly 10 years ago and have remained influenced and driven by two particular technology initiatives - Business Intelligence and Data Warehousing. Opportunities for partnership, learning, and innovation will continue to present themselves as we strive to meld people, business, and technology. I look forward to these opportunities as I am fulfilled by my membership to a scientific community that is driven by the development and execution of technology solutions that enhance the way we live and conduct business.

Archives: August 2012

Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused

There is a way to view the size of a particular PDW database using the DBCC_pdw_showspaceused command via the NEXUS query editor. Executing the steps below will allow the developer to view sizes (in Mb) for the following columns:

Reserved_Space
Data_Space
Index_Space
Unused_Space
PDW_Node_ID

Follow the steps below in NEXUS… Read more

0 comments, 132 reads

Posted in Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence on 28 August 2012

Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations

There are a few basic pitfalls that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data Warehouse (PDW) environment. Like anything else, with proper planning and attention to detail, one can side-step two significant PDW perils more commonly known (or much less commonly known) as the… Read more

5 comments, 231 reads

Posted in Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence on 27 August 2012

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog