I think every DBA should sit down with the application development team at least once a year and...

For many of us, the role hasn't changed, it's just been defined using a new acronym, which makes it a lot easier if someone asked what we do.

DevOps, I...

Charles Kincaid (4/22/2015)

---

Eric:

In Japan would that be floor 4, and for the same reason?

Jeff:

Are you older than me? I guess that it could happen.

Also don't mess with disabled folks....

lptech (4/22/2015)

---

Simply not allowing access would put the person using the duress password at risk of serious injury or death. The duress code would have to lock down the building,...

ScottPletcher (4/22/2015)

---

Eric M Russell (4/22/2015)

---

ScottPletcher (4/22/2015)

---

With an existing table, you already know what the length of the columns will be, whether varchar or not. The formula provides you with...

ScottPletcher (4/22/2015)

---

With an existing table, you already know what the length of the columns will be, whether varchar or not. The formula provides you with the additional overhead SQL...

lptech (4/22/2015)

---

In the Charlie Hebdo attack, the terrorists forced an employee at gunpoint to swipe her card to get into the building. So a duress password on top of the...

LearnSQL!!! (4/22/2015)

---

Hello,

What is the best way to forecast\estimate space for non-clustered index on a table?

Example :

Table name : Test123

Row : 170000000

Reserved : 18000000 KB

Data : 70000000 KB

Index: 40000000...

Really, Google itself is just a massive honeypot used by marketing dicks to brand us and retail our browsing habits.

jay-h (4/22/2015)

---

Eric M Russell (4/22/2015)

---

...However, the actual error message is a shill. If the perp tabs over to Google and searches on "Error: 8514294078", now their IP address (and maybe...

Wayne West (4/22/2015)

---

Law enforcement has a honeypot...

There is no need for sp_executesql.

This should work as is.

SET @AlterSQL = 'ALTER TABLE ' + @DestinationTableName

+ ' ADD ' + @TempColumn + ' int;'

EXEC (@AlterSQL)...

Without a firewall, anti-virus software, or enforced security policy; this company can't really say with any degree of confidence what they're infected with or what their employees are doing with...

SQLRNNR (4/21/2015)

---

I have thought about this from time to time. I imagine the implementation would not be much different in principle than a honeypot.

Give them an account and password...

Wayne West (4/21/2015)

---

Eric M Russell (4/21/2015)

---

So did we learn anything today, or was this mostly an offbeat topic?

What do you guys think about the honeypot database server to attract...