Sounds like a Sarbanes-Oxley-related item. Since the leadership of a company is now criminally liable for the data used to run their company, they are now taking steps to...

Why store this in the table at all? If the "feeder" columns ever change, then you'll have to run the update for it again. Why not leave it...

Unfortunately it's been a couple of years since I did that, and I'm in a totally different job and role, so the details are pretty much lost, but if I...

I've done things similar to this (importing mainframe data into SQL) using SSIS (and Business Objects too, for that matter) and it was very straightforward and easy. Is there...

OK, so what you're wanting is a list of services that a particular customer has signed up for:

Name Services

----- -------------------------------------------------------------

Polly Checking, Savings, Credit...

One other aspect of a vocational eduction v. a more formal college education is that when that vo-tech graduate gains some experience and wants to further their education and enrolls...

I have 30+ years in the industry, in various positions ranging from QA to development to DBA to BA to leader to owner, and in my role as Owner I...

Cool, thanks, learn something new every day. The only thing that Google popped up was in reference to a district in Malasia or interior decorating! Now, about that...

Sigh...shouldn't — couldn't — someone from SSC edit and vet these articles before they're published? Especially editing? "Dinding" seems to be an obscure term; the mighty dictionary.com didn't...

But what if the question wasn't "make a million ethically or some-way-higher-amount unethically", but instead was what if you could make a way-higher-amount unethically -or- be ethical but you end...

Are you SURE you only need 180 days of data in this table? What is your data retention policy? You HAVE a data retention policy, right? We're...

Nicely done; looking forward to the rest of the articles.

I created an Excel/VBA solution for my current gig that read in the metadata for the tables and columns into a...

Michael Valentine Jones (3/3/2011)

---

ACinKC (3/3/2011)

---

I don't know if companies still have to do this, but ten years ago when I owned my development shop, we had to fill out a...

I don't know if companies still have to do this, but ten years ago when I owned my development shop, we had to fill out a form for each position...

Well said, G-Squared! I always come prepared with a list of questions for the interviewers to see if they are on their toes as well (and to show that...