Eric, agree it's not a ton more but Phil expressed it in more detail. This is basically my thoughts on it and where my comment about requiring less engineering (i.e....

Assuming the identity seeds were both 1, loading with IDENTITY_INSERT ON using the original identity *-1 (what Phil said) is where I would start the conversation. If the client strongly...

Definitely depends. It is typically not about how easy it is to recover it is about how fast you can recover and how highly available the system needs to be....

Alvin Ramard (12/29/2015)

---

Orlando Colamatteo (12/29/2015)

---

I have had people scoff at running staging databases in FULL, taking backups and including them in Availability Groups and have had people scoff at running...

I have had people scoff at running staging databases in FULL, taking backups and including them in Availability Groups and have had people scoff at running them in SIMPLE, not...

+1 for separate staging-database

It is true that once you make the decision to have tables your system depends on in a second database you will be increasing your system's footprint....

@Midnight, I think your understanding of the need to enable TRUSTWORTHY to use a SQLCLR assembly is misguided. Have a look at assembly signing when you get a chance. I...

RonKyle (12/19/2015)

---

I do use stored procedures for the final insert in the sense that there is a...

Eric M Russell (12/18/2015)

---

Renaming the real 'SA' account, and then creating a new (so called) 'SA' account with least privilege can be useful in those situations where developers and 3rd...

I never had it cause problems (with SPs and other patches but never tried a version...

KenpoDBA (12/17/2015)

---

No, you don't HAVE to have cmdshell when you work with the filesystem. There are a couple XPs to do something simple things, and you can write CLR....

Yeah, you don't need step 1 and 11 for this work.

While we are on the topic I recommend avoiding xp_cmdshell. I believe it sets a bad tone from a...

I used to rename sa to avoid brute force password attacks it. I haven't tried this in a while though (not sure you can even still rename it) because in...

It is not only code we need to pay attention to. Language features we choose to employ and system administration choices can also lead to insecure environments. Cross-system risks are...

Using SSIS may be intuitive to some folks. When the preference somehow makes T-SQL a poor choice in their mind in all conceivable cases is where good solutions are missed....