Store and index your documents in less than 5 minutes

This blog post describes an article that I recently published on the Microsoft TechNet Wiki titled, "Store and Index Documents in SQL Server 2012 - An End-to-End Walkthrough." I recently published an article on the TechNet Wiki that highlights two new features in SQL Server 2012 that make it both easier and more valuable to store your documents and files in the database: FileTables, and Semantic Search. The wiki article captures a timed walkthrough of the steps required to configure a SQL Server 2012 docume... [More]

Creating a Full-Text Index on a FileTable in SQL Server 2012

This post describes how to select the appropriate indexes, columns, and options when creating a full-text index over the documents and files stored in a FileTable in SQL Server 2012. The FileTable feature in SQL Server 2012 makes it easier than ever to store documents and files in the database – you can simply drag them into the folder that represents the table in Windows Explorer, or you can save them directly from Windows applications like Microsoft Word or Excel. At the same time, SQL Server 2012 e... [More]

FILESTREAM filegroups can contain multiple files in SQL Server 2012

This post describes a new FILESTREAM feature in SQL Server 2012 that enhances the I/O scalability of FILESTREAM data. In SQL Server 2012, a FILESTREAM filegroup can now contain more than one file. You can improve I/O scalability for FILESTREAM data by placing different files within the same FILESTREAM filegroup on different volumes. This feature eliminates the need for complicated workarounds that use partitioning and multiple FILESTREAM filegroups. The following example creates the BlobStore1 database. The... [More]