Tag Archives: Filetable

SQL Saturday #132 Files

Posted on June 12, 2012 by way0utwest

Uploaded here if you need them. These are the PPT deck and the code. UnstructuredData.zip EncryptionPrimer.zip

Posted in Blog | Tagged , , , , | Comments Off on SQL Saturday #132 Files

Creating a Filetable

Posted on June 5, 2012 by way0utwest

How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable data. Then you just do this: — Create a filetable CREATE TABLE AuthorDrafts AS FileTable GO The only optional part … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Creating a Filetable

Create a Filestream Filegroup for Filetables – SQL Server 2012

Posted on May 14, 2012 by way0utwest

Once you’ve enabled filestream, the next step is to add a filegroup to your database to hold the filestream data. This is pretty easy to do, and I’ll show you the SSMS and code versions. If you want to know … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Unstructured Data in SQL Server

Posted on March 28, 2012 by way0utwest

Abstract: More and more of our data does not fit neatly into a structured, relational model of rows and columns of data. In this session, you will learn about how SQL Server stores unstructured data, with a special emphasis on … Continue reading →

Posted in Presentations | Tagged , , , , | 3 Comments