Allan Mitchell and myself are doing a double act, Allan is becoming one of
the leading guys in
the UK on StreamInsight and will give an introduction to this new exciting technology; on top of that I'll being talking about SQL Server Disk IO - well, "Disk" might not be relevant anymore because I'll be talking about SSD and IOFusion - basically I'll be talking about
the underpinnings - making sure you understand and get it right, how to monitor etc... If you've any specific problems or questions just ping me an email
[email protected].
To register for
the event see: http://sqlserverfaq.com/events/217/SQL-Server-and-Disk-IO-File-GroupsFiles-SSDs-FusionIO-InRAM-DBs-Fragmentation-Tony-Rogerson-Complex-Event-Processing-Allan-Mitchell.aspx
18:15 SQL Server and Disk IOTony Rogerson, SQL Server MVPTony's Blog; Tony on TwitterIn this session Tony will talk about RAID levels, how SQL server writes to and reads from disk,
the effect SSD has and will talk about other options for throughput enhancement like Fusion IO. He will look at
the effect fragmentation has and how to minimise
the impact, he will look at
the File structure of a database and talk about what benefits multiple files and file groups bring. We will also touch on Database Mirroring and
the effect that has on throughput, how to get a feeling for
the throughput you should expect.19:15 Break19:45 Complex Event Processing (CEP)Allan Mitchell, SQL Server MVPhttp://sqlis.com/sqlisStreamInsight is Microsoft’s first foray into
the world of Complex Event Processing (CEP) and Event Stream Processing (ESP). In this session I want to show an introduction to this technology. I will show how and why it is useful. I will get us used to some new terminology but best of all I will show just how easy it is to start building your first CEP/ESP application.