The two sessions I will be presenting at DevTeach in Vancouver BC will be the following:
Using FILESTREAM and FILETABLES in SQL Server – Configuring and Using FILESTREAM and FILETABLES in SQL Server
Developers love to use SQL Server to store files, but this causes headaches for the DBA, finally a reasonable solution for file storage in SQL Server FILETABLES and FILESTREAM. SQL Server 2008 and 2012 add the new features of FILESTREAM and FILETABLES. Learn how to configure and manipulate files in your SQL Server with FILESTREAM, then learn how to do everything that FILESTREAM sounds like it should do with FILETABLES. With FILETABLES inserting is as easy as drag and drop.
SQL Server Performance for Developers
For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to properly use parameterized queries, using the query analyzer, and avoiding common SQL Server performance pitfalls.
Both presentations are first thing in the morning, one is first thing on Monday, and the second is in the morning on Tuesday. Presenting first thing in the morning is my favorite time, then I don’t have to spend the day thinking about how my presentation will go.
Looking at the other sessions at DevTeach it looks really interesting, and I am looking forward to attending the conference.