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

I believe the vast majority of SQL Server DBAs and developers understand the virtues of leveraging stored procedures for practically all database access. It's the application developers you have to...

Peter Schott (4/17/2015)

---

Wouldn't it make sense to use DDL triggers to capture all schema changes at that point and log all of the changes to some DB to which the...

Wayne West (4/17/2015)

---

Eric M Russell (4/17/2015)

---

Below is a script I use to quickly zip through every database, looking for objects that have been created or modified in the past 24...