I've got at least 2 jobs on the strength of people coming across articles on SQLServerCentral.

It's always worth cultivating contacts. It's a small world out there and contractors are...

Good suggestion. Why not submit an article on the use of Data Profiler?

I've not used the SSIS...

Row counts are in the tables created in the Validate schema.

For approximate row counts on tables the safety check query uses the SYS.partitions system view. This relies on statistics...

Bill Talada (1/26/2016)

As for guids, I switched all int keys to guids on a large database and got a general 20% improvement in speed. I'd guess a 64 bit...

The trick here was to try to encapsulate what a human would do but in code.

If you do this sort of thing once in a blue moon then manual approaches...

I play badminton and have seen a low ranked pair beat a far more skilled opposition simply because the no-hopers worked well together.

I've seen various personality assessment schemes such as...

Teams are so complex! People with similar personalities may work well together or they may clash.

Some of the oddballs end up being the binding force within the team.

I'm not sure...

The editions are just away of charging what the market will bear. It's like discount coupons. It let's a company broaden its potential customer base with and artificial...

Have you come...

I can understand doing this for a very limited number of datasets. I think it would create problems for Kimball data warehouse systems where we need slow changing dimensions....

People want craftsmanship if they don't have to pay for it. They're prepared to pay for flat pack quality that will last until they are in a new job

Andy, it's not just that it is an expense it's whose expense it is.

The instant it becomes and IT expense non-IT loses interest. If IT identifies the problem and...

There used to be a bug in the cluster install of SQL2008R2 that set the collation for the server incorrectly no matter what you specified. I'm not sure if...

In my world buy vs build raises the question of who integrates the solutions and what is required to enable that to happen.

If you build it then could you sell...

It depends what your base knowledge is and whether you understand the fundamental principles.

If you don't understand the principles you will be learning by rote and unless you are one...