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

Which aspect of this do you need advice on?

Create a table to contain one row for each DBA along with their contact details and what days of week / hours...

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

---

Eric M Russell (7/19/2016)

---

I was listening to a web developer talk about some fundamental changes in a web platform. In this case, an older system...

I was listening to a web developer talk about some fundamental changes in a web platform. In this case, an older system was being replaced completely with a new one,...