SQL Server - The What, Why, and How of Filegroups

Presented by: Jes Schultz Borland

Running Time: 64 min

More and more of your data doesn’t fit neatly into a structured, relational model of rows and columns of data. In this session you’ll learn how SQL Server stores unstructured data, with a special emphasis on how to use Filestream, which integrates SQL Server with the NTFS file system by storing varbinary(max) binary large object data as files stored within the file system. You’ll also learn about the new SQL Server 2012 filetable feature, which builds on Filestream and provides the ability to read, write, and update Filestream objects directly through the file system. Demos will provide a look at how Filestream works and how you can use FileTable in SQL Server 2012. This session is designed for DBAs and developers who need to learn how to manage large quantities of unstructured data.