SQLServerCentral / Discuss Content Posted by Yaroslav Pentsarskyy / Article Discussions / Article Discussions by Author / SQL Server as an IDS Tool / Latest Posts

RE: SQL Server as an IDS Tool

Yaroslav Pentsarskyy-353753 — Tue, 15 Aug 2006 22:06:00 GMT

Thanks for all your posts so far, it was really excited reading them all. When I finished my project and this article I started thinking of many other ways I could use SQL server to automate the analysis. It's amazing how can SQL be such an extensible solution - you can literally stretch it with no limits. Due to the time limit on the project I didn't implement Reporting Service or any other nice and universal way to analyze data; but in a real environment and with real requirements things can get even more exciting.

Grade for the project was 92% . Having IDS logs as the only artifact of the break in was pretty harsh challenge. Imagine millions of records and every record indicates malicious activity. The real problem was that 90% of those are false positives and the rest 10% needs to be nicely aggregated before it starts making sense. The last stage was to reconstruct steps of an attacker.

RE: SQL Server as an IDS Tool

Stephanie J Brown — Tue, 15 Aug 2006 18:17:00 GMT

A very clear article - makes me (a newbie also) want to run out and try it - if only I had SQL 2005 installed on my home machine! I'm dying to know what kind of grade you get on this project.

RE: SQL Server as an IDS Tool

Tim Cullen — Tue, 15 Aug 2006 10:04:00 GMT

I am glad to see you used SQL in such a useful way. I use DTS packages to pull information from each of our syslog servers into a database each night. So you are certainly on the right track...and I agree that you have made great progress in a short amount of time. Maybe stage 2 will be to incorporate Reporting Services in the mix (if you haven't already thought of that and didn't see it in the article). Keep up the innovative thinking!!!

RE: SQL Server as an IDS Tool

Paul Smith-221741 — Tue, 15 Aug 2006 01:48:00 GMT

Welcome to the magical world that is SQL Server

As A Newbie you have managed to master the DB Engine and SSIS in a very short time to come up with (IMHO) quite a useful tool.

I would take a look at some other posts around this site dealing with Log File processing e.g. IIS Logs. That might give you a pointer into using SSAS to produce analisable data cubes.

Keep up the good work

Paul

SQL Server as an IDS Tool

Yaroslav Pentsarskyy-353753 — Mon, 14 Aug 2006 15:47:00 GMT

Comments posted to this topic are about the content posted at temp