30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

Building FILESTREAM solutions with SQL Server 2008

SQL Server 2008 provides the new FILESTREAM storage attribute, which stores binary data in the NTFS file system. In this session you will learn, how you can use this new storage attribute directly within T-SQL code, and how you can it from client applications through the native Win32 Streaming IO API. Furthermore you will learn about the performance inpacts and penaltis you have to worry about when using FILESTREAM in real-world applications. For very large mission-critical applications you will also see how you can combine FILESTRAM with the partition feature of SQL Server 2008.

Speaker focus

Klaus Aschenbrenner

Klaus.jpg
Klaus Aschenbrenner works as a Software Architect for in Vienna - Austria. Klaus has worked with the .NET Framework and especially with SQL Server 2008 from the very beginning. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. He currently travels around the world teaching clients the core concepts of SQL Server 2008. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.

Klaus Aschenbrenner's blog http://www.csharp.at



Downloads

No items to download

Other sessions from this conference

Denormalisation –having your cake and eating it.
Design patterns for SSIS Performance
Designing and Tuning high speed data loading
Event Driven Cube Performance and Security Monitoring
Fast Track Foundations: Get Serious about Sequential I/O
Getting Started with SQL Azure
High Availability in the Real World!
High performance functions
Improving Database Performance by Removing the Database
Inside the SQL Server Query Optimizer
Introduction to Performance Tuning Analysis Services 2008
Lessons Learned from 128 Core OLTP Testing
Make your DBA life better using SQL Server technologies - notes from field & best practices
Monitoring and Tuning Parallel Query Execution
Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory
Optimizing tempdb and temporary object use
Performance Management for SQL Server with SCOM 2007
Performance Monitoring & Tuning - Documented Tips & Tricks
Performance Troubleshooting made easy with PAL
Photograph: SQL Server Crash Dump Analysis
Scaleout scenarios with Service Broker
SQL Server 2008 Reporting Services Scalability and Performance
Supercharge MDX performance using MDX Studio
Transaction Log Performance Tuning, Stop shouting Timber!