The ability to remove an individual's records is a legal requirement in the UK. It is intended for data that is inaccurate or false.

We also have the European Court of...

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

---

Cloud providers know this, but I think they'd like to get you to code better. After all, they want successes and more customers, not just...

I've just submitted the article on RAND(). I'm not sure if it is quite what you had in mind.

Let me know and I will alter it as you see...

I've been using AWS for the past 12 months. The beauty of it is that I have more time using the DB rather than managing it.

I'd be fascinated to...

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