Hello Hello
Hello,
I suppose I should say something about why I wanted to start this about AS.
For the past 14 years i've worked on databases. In the beginning, we had file systems with pointers from the files into each other as location access points. I had to maintain the home-grown software on this miniframe environment that distributed the indexes, assigned new entries into each file, deleted entries and handled updates. With only one other programmer in the shop, we wrote everything that handled the data to the user's interface via dumb terminals.
So when we reengineered this system into the client-server world I got to know Microsoft SQL Server 6.5, and like wow man, it did everything for you! No more low-level data management code! Just some stored procs, triggers, and making new tables was simple. I realized we had been doing everything the hard way. Along the way I picked up a working knowlege of Visual Basic 4, 5, 6 and now dot-net.
Dot-net is cool--so far i've not had to do any windows api calls to do get around the stuff VB doesn't let you do.
Recently I've been working on a project at work to look a creating OLAP cubes. Lot to learn! I've just finished about a 2 month dive into the deep end of the pool with this technology. Figured out some things that work, and many that don't. So by now if you read this far you know I”m no expert at OLAP, but am very willing to learn the technology and do it right.
So far i've created DTS scripts to copy data down from different sources, and developed a sequence of stored procs to scrub the data into a form olap'able :). Used that data to create cubes and for the most part the data has been matching its source.
Enough for now...i'm thinking about finally getting some certifications too. I just need to get past the fact i really HATE tests!
--dao, one of a rare breed--the Girl Geek.