December 2007 - Posts

Wednesday, December 26, 2007 11:54 AM

Index, Fragmentation, Statistics - A List

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
posted by adron | 1 Comments
Filed Under: ,
Wednesday, December 26, 2007 11:00 AM

BI Applications?

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,
posted by adron | 1 Comments
Filed Under: ,
Wednesday, December 26, 2007 10:20 AM

Vista Slaughtered

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
posted by adron | 4 Comments
Filed Under:
Tuesday, December 25, 2007 1:11 AM

The Oncoming Microsoft ASP.NET MVC - Part 1

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
posted by adron | 3 Comments
Filed Under: ,
Thursday, December 20, 2007 9:26 PM

Red Line to the Games

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
posted by adron | 4 Comments
Filed Under:
Tuesday, December 18, 2007 10:55 AM

SaaS is Alive and Rocking!

SaaS, or Software as a Service, isn't new.  But it sure seems to be that way with what is coming from that software model these days.  It finally has grown legs and is taking off running. One of the services that SaaS can provide is business
posted by adron | 1 Comments
Filed Under:
Tuesday, December 18, 2007 8:40 AM

Advertisement Forewarning and Videos

I recently dug into Google's AdWords and AdSense to see how they work.  With that I've decided to toss some somewhat non-intrusive advertisements on my site.  So if you have a moment or two, shoot a comment to me in regards or better yet toss
posted by adron | 0 Comments
Filed Under:
Friday, December 14, 2007 11:08 AM

MagicISO Purchase

I recently did a write up on Magic ISO software, great stuff.  So great I made a purchase of the software that will create bootable disks.  Their software really is king of the heap for ISO management. Technorati Tags: MagicISO del.icio.us
posted by adron | 0 Comments
Filed Under:
Friday, December 14, 2007 10:56 AM

Camtasia and SnagIt Purchased...

I finally broke down and bought em'!  The main reason I finally went ahead and did this is because of the free Camtasia 3.1.3 offering that TechSmith put out not too long ago.  The $299 price was initially just too much for me, I didn't need
posted by adron | 2 Comments
Filed Under:
Wednesday, December 12, 2007 11:13 PM

Error Message 666, The Evil Kills

"666    16    Maximum system-generated unique value for a duplicate group exceeded for table ID %d, index ID %d. Dropping and re-creating the index may fix the problem; otherwise use another clustering key." So today when
posted by adron | 0 Comments
Filed Under:
Wednesday, December 12, 2007 12:00 PM

Mount ISO Image in XP, Vista, or Server OS

I came upon the need to mount an ISO image to the local OS, often I've done this on a running VM image, but that is built in.  On the native Microsoft OS there really isn't a setup to do this. To the rescue comes Magic ISO Maker.  I first noticed
posted by adron | 1 Comments
Filed Under:
Tuesday, December 11, 2007 11:02 AM

InfoQ and Agile Leading the Curve

I listened to the The Value of Agile Leadership to the Enterprise while working on getting prepared for some meetings this morning and checking e-mail.  Excellent speaking engagement with a lot of top notch guys;  Bud Phillips (Capital One Financial),
posted by adron | 1 Comments
Filed Under: ,
Monday, December 10, 2007 1:00 PM

Deliver On Time or Working Software

It would be nice, and often can be done, a delivery of on time and working software.  The axiom of on time, working, or cost comes into play here.  I just want to discuss (and rant) a little about on time and working software. Sometimes during
posted by adron | 0 Comments
Filed Under: ,
Monday, December 10, 2007 11:05 AM

ASP.NET MVC Is Out!

For more check out the Microsoft ASP.NET 3.5 Extensions.
posted by adron | 0 Comments
Filed Under: ,
Friday, December 07, 2007 11:19 AM

Cardinality :: Tip o' The Day

A quick tip o' the day.  I also posted this answer on WikiAnswers for the question, "What is the cardinality of a data type eg integer?" "Cardinality is the total number of unique occurrences of an entity (e.g. person, organization, or transaction)
posted by adron | 1 Comments
Filed Under:
Thursday, December 06, 2007 4:02 PM

Strong Project Teams

Teams, teams, project, more projects, ideas, goals, and all that stuff.  I work a regular job like most guys, but for some reason I feel that I have to step beyond that and do more.  Maybe it is my desire to shoot for the riches that success
posted by adron | 0 Comments
Thursday, December 06, 2007 3:07 PM

Kick Ass Table Variables in T-SQL

Table variables are another "tool belt" item that one must have when really digging into various SQL tasks.  Oracle and other real databases also have this capability, but I'm going to, as usual, discuss the Microsoft SQL variant of the table variable
posted by adron | 0 Comments
Filed Under: ,
Wednesday, December 05, 2007 10:10 AM

Bytes, Bits, Giga, Mega, and Tera :: Tip o' The Day

I think I did this right.  I needed bit and byte specific counts for each. It sometimes is useful in today's age, so I figured I'd post it.  It never hurts to know about the underlying fundamentals of the hardware we developers write software
posted by adron | 0 Comments
Filed Under:
Tuesday, December 04, 2007 11:15 AM

Finding A Week in T-SQL :: Tip o' The Day

Recently I needed to identify a week within a T-SQL Query.  First off I figured I would want to know what day it is, then I could easily figure out a week time frame. To verify what day you have selected, use the following code: IF DATENAME(weekday,
posted by adron | 0 Comments
Filed Under: ,
Monday, December 03, 2007 9:04 AM

CodePlex Time

Over the weekend I made several attempts to download the BlogEngine on CodePlex by Mads Kristenson several times.  The problem, was that the site kept timing out.  I'm not sure if the local Comcast Service was having another issue or if the
posted by adron | 0 Comments
Filed Under: , ,
Sunday, December 02, 2007 7:58 PM

Word Posts, Vista Reload, and General Maintenance

I sat down Friday afternoon to unwind and play a little Supreme Command. Instead of being able to play, some program that came on my machine with the original load started working away. Of course this action was without my permission. It created a
posted by adron | 0 Comments
Filed Under: