GilaMonster (7/27/2016)

---

Eric M Russell (7/26/2016)

---

Rod at work (7/26/2016)

---

If, "The market is too starved for talent to be at a job you kinda like or don't like at all.", I don't...

Auto formatted code can look a bit dry. If you think it's worth spending a little money on genuine hand crafted SQL formatting (with all the little ticks and imperfections...

Rod at work (7/26/2016)

---

If, "The market is too starved for talent to be at a job you kinda like or don't like at all.", I don't see any evidence of...

A CXPACKET (packet exchange) wait state means that one or more operations in your execution plan is running parallel and execution has paused to wait for one of the threads...

David.Poole (7/26/2016)

---

I get the point about 10x data loads but that is stress testing rather than unit testing.

Stress testing is incredibly important. The reason for separating out unit, integration,...

I wouldn't blame a botched deployment at a national financial services corporation on one single person. When it comes to enterprise scope deployments, you definately want more than just one...

.. The situation changed slowly. So slowly, I didn’t totally notice at first. I found my co-workers and boss took me for granted. More and more I was only doing...

Steve Jones - SSC Editor (7/25/2016)

---

Eric M Russell (7/25/2016)

---

When I'm writing a new SQL query, I'll mockup 10x the amount of data currently in production for the subset of tables...

When I'm writing a new SQL query, I'll mockup 10x the amount of data currently in production for the subset of tables that are relevent to query, so I can...

It depends on the organization and the project, but one barrier to unit testing is that many database development teams simply develope or deploy in discrete units. SQL coding has...

Sean Lange (7/20/2016)

---

Eric M Russell (7/20/2016)

---

Within the stored proceure, you could contain most of your T-SQL, or at least the most sensive parts, encrypted in a varbinary(max) variable. The symmetric...

Within the stored proceure, you could contain most of your T-SQL, or at least the most sensive parts, encrypted in a varbinary(max) variable. The symmetric key could then be supplied...

It seems to me that most database breaches are the result of hackers exploiting web based applications with public facing surface area. For example, unencrypted wifi on point of sales...

No more tears.

ALTER SERVER ROLE [sysadmin] DROP MEMBER [<USER_NAME>];

USE <DB_NAME>;

ALTER ROLE [db_owner] DROP MEMBER [<USER_NAME>];

When it comes to protecting your data from big brother, encryption and good lawyer will buy you some time to ponder your next legal move. Meanwhile, however, you will still...