High Volume Real Time Contiguous ETL and Audit

Session Details

Presenter: Remus Rusanu
Time: 4:45 PM – 6:00 PM, Saturday, May 22, 2010
Location: Franz Hall, Room 223
Tags: Data, SQL

High volume contiguous ETL is always problematic, and even more so when near-real-time is desired. This presentation goes through a solution collects and aggregates security audit data for nearly 400000 machines, a contiguous 24x7 stream of nearly 200 events per second, using a budget tight solution that involves SQL Express, Service Broker and Database Mirroring.

Update tags: #devsat,  ADO.NET,  Agile,  AIR,  Amazon Web Services,  Analysis,  Android,  Apple,  Architecture,  ASP.NET,  Asynchronous Programming,  Azure,  BDD,  Blend,  Business,  C#,  Caching,  Career,  Clojure,  Cloud,  CMS,  Code Analysis,  Code Generation,  Composite Apps,  continuous improvement,  Continuous Integration,  Data,  Deep Dive,  Economy,  Event-based Programming,  ews,  Extensibility,  F#,  Flash,  Flex,  Functional Programming,  Games,  Hands-On,  HTML5,  Information Mining, Tracking Trends, Information Aggregation,  ipad,  iPhone,  JavaScript,  jQuery,  JVM,  Languages,  LINQ,  LOB,  MDX,  MEF,  Mobile,  Model-View-* Patterns,  NoSQL,  OData,  OLAP,  Open Source,  Parallel Programming,  Performance,  Phone,  PHP,  powershell,  Prism,  Rails,  Refactoring,  REST,  RIA,  Ruby,  Scala,  Security,  SEO,  Service Bus,  Service Orientation,  Silverlight,  SQL,  Team,  Test Driven Development,  To be attend,  Tools,  User Interface,  Video,  Visual Basic,  Visual Studio,  WCF,  WCF Data Services,  WCF+WF,  Web Apps,  WPF,  XAML,  XML,  XNA,  XPath,  XSLT,  xxx
Add a tag: