Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Microsoft Business Intelligence and Data Warehousing

Garrett Edmondson, Independent Consultant MCITP & MCTS: 10+ years experience with BI stack.

Archives: December 2011

Learn SQL 2012

Microsoft is working on the next round of certification exams for SQL Server 2012. So now is the best time to learn about 2012. The best resources to use for preparing for the exams should all come MSDN.

The first is product documentation for 2012

Additionally, expect to see… Read more

0 comments, 1,005 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 28 December 2011

ETL from Oracle to SQL Server

I was recently asked to provide some performance tuning recommendations for an ETL process that extracts data from Oracle using Informatica (Unix) and loads it into some SQL Server Staging tables.

Initially the ETL process was taking  20+ hrs to complete. After some preliminary analysis it was determined that the… Read more

1 comments, 2,085 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 21 December 2011

Data Mining

Data mining techniques can be used in virtually all business applications, answering various types of businesses questions. In truth, given the software available today, all you need is the motivation and the know-how. In general, data mining can be applied whenever something could be known, but is not. The following… Read more

1 comments, 970 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 14 December 2011