As was the case with me, I expect that many programmers not initially familiar with T-SQL, who start working on the platform will get exposed and then begin to harness...

Have we been prepared to handle change?

The formula in college is first a program of general classes and then later more specialty classes. The Microsoft certification I'm working on seems...

Technical personnel are not always invited to help solve a mission-critical business problem during the initial brainstorming stage. They're often involved later when they can be assigned specific tasks and...

Regarding number of round trips... In my implementation of spell suggestion, I use a single stored procedure call which uses a single T-SQL statement using a set-based approach even though...

I actually verified that there were duplicates. The row count was unexpected. So I followd up with a query checking for duplicates - you know - with a GROUP BY...

No triggers on table B.

Trigger Code (object names changed for anonymity):

CREATE TRIGGER u_PartInformation ON PartInformation FOR UPDATE

AS

-- Propagate updates to description fields.

IF UPDATE(part_num) OR UPDATE(headline_id) OR UPDATE(epd) OR UPDATE(catalog) OR...