Subscribe to this blog
Microsoft Business Intelligence and Data Warehousing
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, 672 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, 914 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, 447 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 14 December 2011