A number of us will be attending SQL PASS 2010 next week, both presenting some great content around AppFabric, StreamInsight and SQL Server, and hanging out with our SQLCAT colleagues (wearing the same shiny green shirts!) in the SQL Server Clinic and Ask-The-Experts. We’ll be presenting:
Thursday, November 11 4:00 PM – 5:15 PM
StreamInsight ships with SQL Server 2008 R2, and provides complex event processing for tackling high volume, low latency analytics and data processing challenges. This talk will explain the business goals and target scenarios for StreamInsight, its architecture, and how to leverage StreamInsight to complement extant data processing and BI capabilities by exploring a series of customer implementations (including Sunday Night Football, and the 2010 Winter Olympics) for large scale real time web analytics.
AD386A SQLCAT: Optimizing application workload & performance by leveraging AppFabric Cache along with SQL Server
Tuesday, November 9 3:00 PM – 4:15 PM
Today, more and more data is being exposed via interactive web applications such as social networking, news, sports, video sharing, etc. Such web sites can now be accessed via different devices such as mobile phones, netbooks and easily exposed to 1000s of users. Hence, application architectures must leverage distributed application caching along with the database tier for building highly scalable, high throughput and highly available systems. In this session, we will cover some of the lessons learned based on customer engagements for AppFabric Cache, Microsoft’s distributed caching solution, with some performance data.
Wednesday, November 10 1:30 PM – 2:10 PM
With all the hype about NoSQL going around in the SQL community its about time we looked at a Microsoft’s distributed cache-aside solution, AppFabric Cache. In this session we will briefly go over what AppFabric Cache is, what it can and cannot do, as well as some of the compelling features that make it a complimentary product to SQL Server. We will go over some real-world examples on how AppFabric Cache can co-exist with SQL Server and increase performance. In addition, we will compare the speed of the AppFabric Cache in comparison to SQL Server 2008 in both queries and inserts/updates. This chalk-talk will go more in-depth into some of the information presented in the SQLCAT Optimizing application workload & performance by leveraging AppFabric Cache along with SQL Server session.
In addition, don’t forget to check out all of the great SQLCAT presentations!