I got a lot of invite from Linkedin from a lot of recruiters. I think the trend is using Linkedin to find the candidate.

This is from BOL.

AFTER

Specifies that the DML trigger is fired only when all operations specified in the triggering SQL statement have executed successfully. All referential cascade actions and constraint...

In every job step, you can choose which step to go when it fails and which step to do when it succeeds. When one step fails, I will choose...

Sometimes it is not the developers are lazy, they are actually incompetent.

I tried to explain to a developer and a DBA how to write dynamic SQL, both looked at me...

I join Linkedin to expand my network. I was able to re-connect some of my old co-workers. As a matter of fact, I got my new job because...

How do you do your insert statement?

The insert statement should not have DateInserted field, then table will populate the current datetime in that field.

First of all, what do you want to know? Do you want to understand the system and how it works? The diagram basically explained to me how the...

One question: am I working for the VP or am I working for a manager under the VP? That makes a big difference.

I once worked for this company and...

I like stored procedure especially I wrote a lot of stored procedures which dynamically did different based on the parameters. For example I wrote a procedure that automatically bcp...

I agreed there were many lazy developers around. Many developers just knew a few basic commands and somehow they could do their jobs. They used the same...

I guess my comment about them not meeting expectations (good or bad) is over the life of the employee. They might work one way for 6 months and then change,...

Just try to do this in SQL Server 2000

ALTER TABLE dbo.FQCurriculum ADD CONSTRAINT

PK_FQCurriculum PRIMARY KEY CLUSTERED

...

I worked at many different companies and each company had its own culture. The people at one company were totally serious and would not take any joke. On...

It is a good article but where do you find those people? Some of the quality that they are looking for has to do with the company. How...

I also would have to agree with the premise behind this quote. Folks in IT tend to be logical folks who see a right way and wrong way and...