Grant,

I just tried that Extended Event session on my Dev box and it's not capturing anything 🙁 I tried a simple store procedure reading from a simple table and...

Grant Fritchey (3/10/2016)

---

This is easy and difficult at the same time. Tracking an individual table, I assume you want READ/UPDATE/DELETE/INSERT is not something normally done. It's very easy with a...

Eric M Russell (1/21/2016)

---

sql-lover (1/21/2016)

---

Eric M Russell (1/21/2016)

---

sql-lover (1/21/2016)

---

Eric M Russell (1/21/2016)

---

The DMV dm_exec_procedure_stats returns one row for each cached stored procedure plan. There can be multiple cached plans for...

Eric M Russell (1/21/2016)

---

sql-lover (1/21/2016)

---

Eric M Russell (1/21/2016)

---

The DMV dm_exec_procedure_stats returns one row for each cached stored procedure plan. There can be multiple cached plans for a single procedure (database_id,...

Jacob Wilkins (1/21/2016)

---

Just for clarification, it looks like the primary key is just on database_id and object_id; schema_id is not included. I don't think that's the issue, though.

One way I...

Eric M Russell (1/21/2016)

---

The DMV dm_exec_procedure_stats returns one row for each cached stored procedure plan. There can be multiple cached plans for a single procedure (database_id, object_id). The column 'plan_handle'...

I've played a bit with it. If your SQL boxes are virtual and you have the budget, I would strongly consider it....

I have this as...

JamesMorrison (1/11/2016)

---

Since SQL Server doesn't really release memory once it has it, how does this impact in the overall environment of a VM Host that is trying to share CPU...

Perry Whittle (1/12/2016)

---

modify does not allow the user to take control of any folders or files within the parent folder where the permissions are granted (assuming inheritance has not been...

Eddie Wuerch (10/13/2015)

---

I'm not sure about SQL Server 2012, but with versions prior, old stats on tables with 1 billion+ rows would cause shocking CPU consumption during compilation.

Once stats...

Alright ... I will use any of those later at home or during the weekend and play around.

I did it long time ago but we used a third party tool and it was to read the Tlog backup of an important client for recovery purposes. I honestly...

GilaMonster (9/24/2015)

---

It can't be restored, but it can be opened in a hex editor and read raw. Won't be easy, but string data won't be that hard to get out....

anthony.green (9/24/2015)

---

What do you define as confidential information?

Things like Red-Gate SQL Compare can read a diff backup to get the schema, unsure on Data Compare

http://documentation.red-gate.com/display/SC11/Working+with+backups

SQL Compare can retrieve the schema...