Author Archives: reagan
I passed the Microsoft MCTS 70-445 exam!
I passed the Microsoft SQL Server 2005: Business Intelligence Implementation & Maintenance (70-445) exam this morning.
Posted in Certification
Leave a comment
Facebook is the next MySpace: The curse of online success.
I know this post deviates from the content of this blog, but I will get back on track in my next post
Almost everyone today knows what Facebook is, and that can actually be a bad thing.
Posted in Social Networking
Leave a comment
Building a Raw Data Warehouse in SQL Server 2005 – Part 2
This is part 2 of 5 of the series”Building a Raw Data Warehouse in SQL Server 2005.” If you would like to start at Part 1, you can view it here:
Posted in DataWarehouse
Leave a comment
Data Warehouse Performance – Indexes
We are now dealing with index fragmentation on our data warehouse. After loading, updating, deleting, inserting, etc. hundreds of MB worth of data over the past month, the indexes that we initially created for the DW have become severely fragmented. This is one of the causes of the performance issues in the Data Warehouse.
Posted in DataWarehouse, Indexes, Performance
Leave a comment
Raw Data Warehouse Performance Issues
I am going to take a small break from the first series of this blog to discuss performance issues and considerations. This will only apply to data warehouses with raw data only (relational, not OLAP cubes).
Posted in DataWarehouse, Performance
Leave a comment