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

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 hackers or for duress login...

John Hanrahan (4/21/2015)

---

The newest security is using USB keys to allow a user to login along with the password and physical access. It would have to be a pretty...

We need an action movie where the hero is a fed up IT guy. It seems like we always get marginalized as supporting...

On the Microsoft platform:

HDInsight for raw bulk storage, SSIS for connecting most anything to most anything else, SQL Server / SSAS for building the single version of truth database,...

mayurkb (4/17/2015)

---

Thank you again and understood.

Does everything that apply to data warehouse also apply to datamart? We are not really IT and not making a datamart for my company. We...

The user id + duress password combination should redirect to a "honeypot" server that mimics a production envrionment in such a way that it would take some time for the...

My experience has been that, for both data warehouses and transactional databases, disk I/O is the biggest bottleneck. If you're maxing out CPU, then look for recompiles or cursors.

Encapsulating the database through stored procedures does require a degree of constant communication and collaboration between the application and database team. For example, I've seen cases where app or BI...

Here is a good article written by Adam Machanic back in 2006 that advocates the use of stored procedures using the concepts of decoupling, cohesion, and encapsulation. Funny how, after...