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

dndaughtery (7/20/2016)

---

Hey guys, had one of my team members drop our main table by accident. Is there a way to prevent a table from being truncated or dropped? I tried...

There is an existing operator, schedule, notification framework for use by SQL Agent and SQL Alerts, and you may be able to leverage these existing tables. What you're wanting to...

We've all been in situations where the organization has a legacy application for which there is no designated owner; meaning that the developer who built and supported it left years...