This entry is going to be a collected list of practices for index, fragmentation, statistics, and general VLDB table and view maintenance. First off, a few obvious index practices. If a non-clustered index is not used, toss it. When a table has a record inserted, the duplicate of that is inserted into the non-clustered index.... Continue reading →

It seems that everywhere one looks in the ETL/OLAP/BI Industry Space there are no real canned applications. When I say canned application I’m talking about an application that from the ground up is all inclusive, managing the database, the ETL, the warehouse and any possible staging, and finally the Cube itself and reporting that sits... Continue reading →

Vista really is a lacking Microsoft Product. I’m not sure what the hell happened in comparison to Windows 2000 and XP. Both of those launches went rough, as usual, but not noticeably so. Vista however is just a dog within the industry these days. I’m sure it is even ceding a large number of customers... Continue reading →

The ASP.NET MVC is officially released in the .NET 3.5 Extensions CTP. This is part one of a multi-part series I’m going to do on getting a basic application up and running with good practice and solid test driven development process. Enjoy. First we’ll go over a quick review. What is MVC? MVC stands for... Continue reading →

This entry is going to be a complete diversion from my regular content. In a way though, it is directly related to software development and one of the most important aspects. It is vitally important that during the course of development that one TAKES BREAKS and has some fun. So with that… Over the last... Continue reading →