sam 55243 (12/18/2015)

---

Hi Eric,

Your solution will work however I have one query . Can I handle lock/deadlock issue with this approach. For instance if in any of the sub-procedures there...

Ed Wagner (12/19/2015)

---

Eric M Russell (12/18/2015)

---

Orlando Colamatteo (12/18/2015)

---

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

Is the transaction log competing for space with the data files or another database? Perhaps there is no need to actually shrink the log, just let it recycle.

Alternative technical approaches aside (I'd at least give 3NF a fair shot), first challenge whether an EAV solution is needed. I would interview the users and run some aggregate queries...

Luis Cazares (12/21/2015)

---

I wouldn't rate it as high. I felt it was just a mashup of the previous movies. Taking so many elements of the previous movies made it predictable.

I...

I think the whole concept of a 'SA' account is a bad idea, because essentially it's an account which has full access and which can be sharable across users. It...

Orlando Colamatteo (12/18/2015)

---

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

Michael L John (12/18/2015)

---

If you love what you are doing, spending hours on hours "geeking out" is fun, not work.

This becomes an issue when there are situations created that...

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 party tools think...

Alastair Marshall (12/18/2015)

---

The realty of work is that the longer the hours we work on a given day, the less productive most people become. Who hasn't been there well into...

I'll work outside regular hours, if something critical is broken, or if there is a project with an approaching deployment and there are still some unresolved tasks (but only if...

It's not an issue of fashion; there are some scenarios where SQL Server account authentication is required (or at least practical), like when linking to server instances on a different...

A quick Google search for (+"SQL SERVER" +SSDT +PowerShell + Automation) did not turn up anything useful except for answered inquiries in Microsoft forums stating that it's not supported at...

The data comparison feature you're using in Visual Studio; is that the same thing as the SQL Server Data Tools plugin? I've found an MSDN article which seems to suggest...

ZZartin (12/17/2015)

---

Eric M Russell (12/17/2015)

---

Sean Redmond (12/17/2015)

---

It is the over-compartmentalisation that does it. I was a year into a job as a DBA and I had gotten a grip on...