Not sure, need to do it at the UGs locally, then probably some SQL Saturdays. Though I'm not sure I want to do 3 a day. Usually committed for 2...

LOL, no, no audit for me. I am working on an auditing presentation, and in research /testing, I built a bunch of questions and writing.

Katherine Fraser (7/30/2010)

---

I'll be using Service Broker to log the accesses, sending encrypted messages, and storing it in a database encrypted with TDE. I'm not sure what the volume...

bwillsie-842793 (7/30/2010)

---

Does SQL Server have an integrated audit function built in? Something that would let you audit changes to particular fields in tables and grab date, time, userid, and...

LOL, that's funny. Actually a friend from the SQL world is coming to the SQL Saturday in Denver, and bringing his wife to meet mine 😛

Some companies in the US...

These events are all free, with limited budgets. You would have to ask each individual organizer...

The Colorado event is in South Denver, #52

http://www.sqlsaturday.com/52/eventhome.aspx

bbop1322 (7/30/2010)

---

Now, if someone wants to share what types of Audits they have setup for HIPAA purposes i would be able to get that promotion, jk, but it would be...

The question was not asking about defaults, so...

I don't think you can. You can set a retention period, but I believe that reuses space, similar to overwriting something on a tape. However it doesn't free up space.

You...

You can restore FROM a snapshot, but you cannot restore A snapshot.

The backup would seem to be trivial. Read pages from snapshot or source db, write to disk.

Hmmm, a suggestions....

Note that I wouldn't recommend this. I'd move each backup to a new file. If you have any issue with this file, and you could over time, you lose lots...

If the data is inside a transaction on the insert, it might not appear until the transaction commits.

It's got to be something in the data. Your test view definition only returns one row, so it's not really a view test.

If you use < and < instead of...

It's got to be in the conversions and the data. You're relying on implicit conversions here. You ought to be using quotes and ensuring the correct date is being used.

Or...