The ability to do after-hours stuff from home is a god-send, no question. I live 30+ minutes from work, so being called in after hours is definitely non-trivial, especially for...

I *DON'T* work for Red Gate software, and I can tell you their SQL Compare and Data Compare are a god-send for the lone-wolf developer. If I had to track...

RonKyle (6/27/2016)

---

It depends on the developer, but in most cases no. When I was a developer, it was okay,...

Sean Redmond (6/27/2016)

---

What's the point of having DBAs if people believe that ORM tools will do it all?

Veeam does backup and point-in-time restores.

It seems to me that one side of...

Eric M Russell (6/24/2016)

---

roger.plowman (6/24/2016)

---

Ah, clearly you are unfamiliar...

Ah, clearly you are unfamiliar with the miracle that...

The ERD is supposed to create the DDL for you. That's what it's *for*... 😀

Being a lone wolf developer I've not had the luxury of NOT designing databases from scratch. Been doing it for 16 years now and learned a few things along the...

I would have thought the lack of a GO after the GRANT would have left permissions unchanged for the final SELECT. This is something I've run into with SQL Server...

Steve Jones - SSC Editor (6/2/2016)

---

First, that's not what's happening. The patches are tested, run through...

The whole "let's release this stuff NOW and worry about patches later" is stupid.

Who *wants* to have to update so often? Certainly not DBAs. Not MS's customers. The whole idea...

I'm a real fan of surrogate keys (using identities) and use them almost exclusively as both primary key and clustered index. My application's domain allows me to use 4 byte...

That's what audits are for... 😀

I create roles in the database that always match AD roles. That makes it child's play for the AD admins to create security groups the DBA needs, then have the...

Using a hex number was a 'trick'. 😛

Glad I smelled a rat and didn't think "oh, ASCII 65 is an A" so I actually ran the code. It was then...