Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Advice from Aunt Kathi

Kathi Kellenberger is a Sr. Consultant with Pragmatic Works. She is an author, speaker and trainer.

Archives: September 2007

Clustered Indexes

I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports and automating stuff. One of the apps at the law firm where I work is our document managment system (DMS). Over the years I have learned that the vendor did…

Read more

0 comments, 527 reads

Posted in Advice from Aunt Kathi on 30 September 2007

DTS vs Linked Server

We are trying to move to version 2 of our accounting data warehouse (more likely called a datamart), but it just doesn't have everything the department needs yet. So, we still have version 1 running, a system that gets updated just once each month instead of each night. The warehouses were… Read more

2 comments, 613 reads

Posted in Advice from Aunt Kathi on 25 September 2007

Writing in my sleep

When I first got into IT full time 10 years ago, I noticed that my mind was constantly solving programming problems or thinking of programs I could write. If I had someone else to talk to at the time, I was a normal human, or at least as normal as…

Read more

0 comments, 522 reads

Posted in Advice from Aunt Kathi on 25 September 2007

PASS Report Part 2

This was my 5th year at PASS and every year I enjoy catching up with old friends and meeting many more.

SUNDAY

I arrived safely and was in my hotel room by about 2 pm. I am the Program Committee Manager and the board member I report to, Bill Graziano,…

Read more

0 comments, 504 reads

Posted in Advice from Aunt Kathi on 23 September 2007

PASS Report

Somehow between the sessions, networking and socializing I never found time to post anything last week. So, I'm going to post two summaries, one for what I learned, one about the social stuff.

MONDAY

I attended Itzik Ben-Gan's all day pre-con session. He covered a lot of material and it…

Read more

0 comments, 527 reads

Posted in Advice from Aunt Kathi on 23 September 2007