T-SQL Tuesday #070 – The Enterprise

Invitation and roundup from Jen McCown.

Here is your invitation for T-SQL Tuesday #70, and the topic is:

Strategies for managing an enterprise

We define “enterprise” in a number of ways, but I tend to default to two definitions: “the things I’m in charge of” and “anything I don’t want to do manually”.  In other words, you don’t need a large shop to have yourself an enterprise. Of course, feel free to modify the definition to what works for you.

So. How do you manage an enterprise? Grand strategies? Tips and tricks? Techno hacks? Do tell.

T-SQL Tuesday #071 – SQL Server Audit

Invitation from Sebastian Meine.

For this month, I would like to invite you to write about Auditing. Auditing is certainly a security related topic, and with that fits right in with the August topic (Encryption).

But don’t write this up as yet another “boring” security topic. There are other use cases for auditing too. The built-in SQL Server Audit feature for example can be used to track down how many different applications are accessing a particular table.

The result of a SQL Server Audit

There are several approaches you can take with this topic. You could tell us a story:

  • Have you encountered a situation where auditing saved the day?
  • Where you able to stop an ongoing attack because auditing alerted you?
  • Have you encountered a situation, in which auditing would have been helpful, but was not set up?
  • Have you worked with the SQL Server Audit feature? What is particularly interesting to you about it?
  • Do you think that everybody should use some form of auditing? Let us know, why.
  • Do you think auditing is a waste of resources? We would like to hear more.
  • Are you forced to be compliant? Under what regulation? HIIPA, PCI, CCC? How did auditing help to get you compliant?

If stories are not your thing, let us know how you use auditing. Or, write about how to use a fascinating piece of SQL Server Audit.

  • What are the advantages and disadvantages of SQL Server Audit over other possible audit implementations, like triggers, traces, Extended Events or external tools like log file readers?
  • How can you use SQL Server Audit to see if a particular table or procedure is still in use?
  • What is the difference between a Server Audit Specification and a Database Audit Specification and when should you use which?
  • SQL Server Audit is based on Extended Events. What does it offer that XEs do not provide?

Finally, you could go totally meta:

  • How do you audit the audit? How do you make sure that the audit does not just get disabled by an adversary?
  • How do you monitor your audit log to make sure you get alerted when something irregular is happening?

I hope I was able to spark your interest. I can’t wait to see you (or at least your post) next week at the party.