Archive for the ‘Features’ Category

Event Notifications 101 – Intro to Event Notifications

Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server.В  And I told you all about how to use SQL Audit to monitor what’s going on in your databases.В  Remember that?В  If you do, you might also recall that I mentioned there being more than one [...]

April 15, 2013  Tags: , ,   Posted in: Features  2 Comments

NEOOUG meeting – Oracle 12c

Last week I attended the Northeast Ohio Oracle Users Group’s (NEOOUG) first meeting of 2013.В  The main topic of the day was the upcoming release of Oracle 12c.В  The “c” stands for “cloud”, and the focus is on making private cloud environments easier to deploy and manage. Pluggable Databases Up til now in Oracle, every [...]

January 31, 2013  Tags:   Posted in: Features  No Comments

SQL Audit – User-defined Audit Events

One thing I failed to touch on during my series on SQL Audit was the use of user-defined events in audits. This was brought to my attention in a comment by one of my readers. He was trying to make use of user-defined events and was having a problem getting the output to actually write [...]

October 18, 2012  Tags: , ,   Posted in: Features  No Comments

SQL Audit 302 – Deploying the Audit Solution with Powershell

This is it, ladies and gentlemen.В  One last post and I promise I won’t mention the word audit for at least a week. Before we begin, let’s take a moment to recap what we’ve covered so far: SQLAudit 101 – Creating a basic audit SQLAudit 102 – Reading audit output SQL Audit 201 – Creating [...]

August 29, 2012  Tags: , , ,   Posted in: Features, Powershell  One Comment

SQL Audit 301 – Using Powershell to Manage Audits

Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell and SMO. Managing SQL Audit objects via PowerShell is actually pretty simple, even for a newbie like me. And I’m proud to say that these might be the first PowerShell scripts I’ve written that were [...]

August 13, 2012  Tags: , , ,   Posted in: Features, Powershell  2 Comments