Savvy Managers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Savvy Managers

13 posts, Page 1 of 2

1 2 »»

Savvy Managers

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Monday, November 26, 2007 3:18 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 2:54 PM
Points: 31,410, Visits: 13,726

Comments posted to this topic are about the item Savvy Managers

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #426063

Loner

Posted Monday, November 26, 2007 9:18 PM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 7:05 AM
Points: 2,726, Visits: 2,925

My former manager was a saavy manager and he wrote all the ETL procedures before he became the manager. He attended the Microsoft BI conference too
but it did not mean he learned anything.
The data came from different sources. He built a database for every source. So the ETL system had at least over 20 databases. After that, there was a staging database to group all the data together to build the dimension tables and then another database to build the real dimension table. Since there was no DBA in the company, so he could do anything he wanted. :D

Post #426133

Phil Parkin

Posted Monday, November 26, 2007 9:53 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:17 PM
Points: 4,234, Visits: 9,470

Steve, don't want to be picky, but as it's the title of your article ... I think the word you're looking for is 'savvy' :)
PP

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #426142

Steve Jones - SSC Editor

Posted Tuesday, November 27, 2007 7:37 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 2:54 PM
Points: 31,410, Visits: 13,726

Doh!

That one always gets me. Must be my accent ;)

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #426378

Bob Hoffman-209065

Posted Tuesday, November 27, 2007 10:18 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 05, 2011 12:58 PM
Points: 230, Visits: 262

Dear Bbo,

Thank you for your recent purchase of {invalid item name}.
As a reminder, we offer an extended warranty for $0.00 per 100 years.

Please cantact me for further information.

Sincerely,

sj

Whistling

Post #426486

Steve Jones - SSC Editor

Posted Tuesday, November 27, 2007 10:43 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 2:54 PM
Points: 31,410, Visits: 13,726

That's data quality in Alaska for you!

Must be those cold data entry fingers that keep making mistakes. :P

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #426500

Bob Abernethy

Posted Tuesday, November 27, 2007 10:50 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:54 PM
Points: 149, Visits: 872

Sopmwtimes I wonder if data qualiuty is overrrated./

If e nd busers wer justa litle mor cargful tghen theere woulnd''t be sucha need for alll the work andepxpense that goes into dataquiality.

Anddd we coudl focus on more oimportant thing.s

Post #426503

Bob Hoffman-209065

Posted Tuesday, November 27, 2007 11:10 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 05, 2011 12:58 PM
Points: 230, Visits: 262

Fingers are plenty warm.

It's the thick seal skin gloves we have to wear that makes it hard to type!
:D

Isn't data validation part of that old saying "garbage in, garbage out"?

Or is that just an Oracle saying...

Post #426523

roger.plowman

Posted Wednesday, November 07, 2012 7:16 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 6:41 AM
Points: 317, Visits: 617

I find myself in strong disagreement with the editorial.

Sales people:

A) shouldn't be allowed near a computer without at least 3 armed guards to make sure they don't touch anything Laugh

B) NEED every error correction mechanism known to man

and

C) Need a dedicated team of error correction specialists to fix all the entry mistakes made by said sales people.

Lacking that (sigh) you must have strong editing controls at the front end to catch at least some of the bone-headed and (frankly) lazy mistakes and deliberate lack of data entry most sales people consider adequate.

Been there, done that, ate the tee-shirt from sheer frustration bordering on genocidal rage... (sales people are a seperate species, right? Hehe

)

Seriously though, the best time to correct any error is when it's made. Spell checking is the least of your problems when the sales force is allowed to enter data (shudder). Even having a DMZ and über-strong error checking won't help all that much because rejecting a record for data errors--even if you can find them (and most data errors aren't correctable since the data is either missing entirely or not verifiable without access to the actual paper records) isn't much less frustrating for the sales force than error messages at the front end.

Post #1381971

Eric M Russell

Posted Wednesday, November 07, 2012 7:40 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 2:02 PM
Points: 1,162, Visits: 3,333

When it comes to data quality in large enterprise organizations, what's essential is that the rules be formally documented (before development begins).

For example:
- If Col1 = 'A' then Col2 must be 1, 2, or 3.
- When Col3 is updated, then Col4 must also be updated with Date+Time EST.

The documentation must be continuously revised post-production as the business rules change, be published so that any user who queries the database has access to them, and be endorsed and promoted by mangement.

"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47

Post #1381983

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions