Practically all database related breaches can be prevented by setting up user accounts with least privilege. Create a role that grants exec permission to only those stored procedures that the...

The problem with metrics is that most company's simply don't have an official standard. Ask ten different managers (in the same department) to examine a piece of code, and you'll...

For years I've been drinking about two cups of coffee a day with no concerns, but not because some guest on a morning TV news show suggested it's good for...

I guess it depends on the conext of the situation, but...

What I like are the realestate websites where you can see actual floor plans or recorded video allowing a virtual tour. A picture is worth a 1,000 data items.

The problem is that 3rd party websites that aggregate listings from multiple sources can't be too choosy about their data, because they have no control over the data entry etiquette...

Regarding different types of database automation, I like referential integrity and check constaints, because it automatically rejects bad data at the point of insertion. Otherwise, the developer or DBA has...

Participating in forums like SSC is for database professionals what weightlifting and practice drills are for professional fire fighters. If you're fighting fires every day, then something is seriously wrong,...

Or a technical recruiter.

:rolleyes:

lcasamen (2/8/2011)

---

Thanks for the quick replies! I don't need to worry about gaps in sequences - Oracle loses values on rollback too, and I just need matching functionality. Long term...

Regarding job descriptions with too many technical requirements and resumes full of bogus experience, in many cases it's the result of a 3rd party recruiter acting as an intermediary and...

The forthcoming version of SQL Server, codenamed "Denali" will have a sequence type object that functions similar to Oracle's sequence. However, just like an identity, it can also result in...

I think it's common (not right but simply common) for IT people to fudge the truth on their resume or during job interviews. For example, someone who has a solid...

Mammals survived the Cretaceous asteriod impact because they were warm blooded, able to immediately adapt to both warm or cold environments. That, plus the fact that they were omnivores, feeding...

The org chart says I'm a database developer, but on a normal day I spend more time writing ad-hoc SQL queries and researching data issues than I do writing T-SQL...