There are things that today are regarded as antipatterns which were the only reliable way of doing things yesterday.

Some features that are regarded as horrors (cursors and triggers spring to...

Gary Varga (4/25/2016)

---

....or more like...

Management accepts that security should have been a priority when the company gets...

When you say "Same seed over time" are you talking about using time as a seed?

I'll take this article on.

I went to an interesting talk given by a guy from NASA. One of the problems NASA face is that they may have a scientist whose lifes work is...

One problem with backups is what you have to do if you get a requirement to expunge a person's records.

The risk is that you accidentally restore expunged records from an...

Given that medical records have been a victim of Ransonware I think there...

I can understand deficits in terms of SSMS giving visibility but SYS.objects and INFORMATION_SCHEMA. ROUTINES identify them pretty clearly and also reveal lineage.

I'm reluctant to condemn any weapon in my...

Steve Jones - SSC Editor (4/14/2016)

---

Agile isn't about just coding whatever. Many of the successful projects are engineered well, with thought about what they will do, and won't do,...

I've spent a lot of time analysing project failures.

It boils down to breakdowns in communication and failure to check that communication has been successful.

Requirements are given and received. Both...

The value I got out of the original SQL Server 6.5 courses (admin & developer) was largely due to the trainer who was 26 but looked 46. He'd been...

There are still systems in common use out there with surprisingly short length naming restrictions. I seem to remember that there is something like an ANAME record for Linux...

Consistency is all otherwise it will be hell for all.

Trying to remember the CustomerNumber, AccNo, PersonId and any number of alternatives actually store the same thing until one day they...

Situations change over time.

I'd like to work in Canada but I'm reaching the age where emigrating from the UK would be far harder than doing so in my 20s.

With the...

Steve your last April Fool was for SQL Server on Linux!

If you can imagine it then it can be built

I've used it for trivial tasks. Have I got the wrong end of the stick in thinking of it as Bash for Windows but with access to the .Net...