When all I had was msmq I used a simple DB design to give a persistent ordered queue.

It worked, was efficient and didn't increase the technology footprint.

These days tech such...

Beatrix Kiddo (1/29/2016)

---

Eric M Russell (1/28/2016)

---

At risk of revealing too much, I think I'm in this position right now, and wondering how on earth to get out of it without...

Good news Dad, your...

A good vulnerability test company will rip holes in anything with a weakness.

The level my team has to deal with is considering vulnerabilities in cloud hypervisors and steps...

Gary Varga (1/28/2016)

---

I am not being facetious here (I know, surprise) but perhaps putting the cyber security education and implementation remit under the Health & Safety umbrella might be all...

Very short employment periods, lots of...

It's migration per se. Could be for the purposes of absorption into the data warehouse or to replace the legacy system.

The overarching idea is to gain knowledge of the...

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...