Jun
11
2012

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]
May
1
2012

SQL Server 2012 Property Search Assistant published

This post describes a utility program that makes it easier to set up the Property Search feature in SQL Server 2012. I have just published the source code for the SQL Server 2012 Property Search Assistant on Codeplex. The SQL Server 2012 Property Search Assistant is a small utility program that helps you to configure the Property Search feature which is new in SQL Server 2012 Full-Text Search. The Property Search Assistant is written in C#. About Property Search in SQL Server 2012 Why do I need the Propert... [More]
Apr
12
2012

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]
Mar
5
2012

How stopwords affect Property Search in SQL Server 2012 Full-Text Search

This post describes the effects of stopwords when indexing and querying document properties in SQL Server 2012 Full-Text Search. SQL Server 2012 Full-Text Search introduces the ability to search explicitly for document properties – such as Author, or even the Template that was used for a Microsoft Word document. For more information about property search, see the links later in this post. How stopwords affect the indexing and querying of document properties There's a very simple answer here – yo... [More]
Mar
1
2012

Metadata-driven dynamic data flows for SSIS, and new adapters

This post describes the enhancements in the latest release of a third-party library for SQL Server Integration Services. Support for SQL Server 2012, a long list of new source and destination adapters, and metadata-driven dynamic data flows are the highlights of version 1.6 of the SSIS+ library from CozyRoc, just released in beta. Ivan Peev of CozyRoc describes the significance of this new release: Our hope is that this new release [of the SSIS+ library] will make the SSIS platform easier to accept and use... [More]
Feb
27
2012

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]
Feb
22
2012

Querying for registered search properties and lists in SQL Server 2012

This post discusses the new Property Search feature in SQL Server 2012 "Denali" Full-Text Search. In particular, it shows you how to get a list of the search properties that you've registered and the search property lists to which they belong by using a JOIN. SQL Server 2012 "Denali" now lets you search specifically for the values of built-in or custom document properties, such as the "Author" of a Microsoft Word document. However, before you can run queries, you have to register the properties that you wan... [More]
Jan
25
2012

Excel driver now supported on server for use by SSIS

A year ago, I wrote a blog post to caution SSIS users that the ACE Provider and its Excel driver were not supported by Microsoft for use on the server. That position has changed - in certain circumstances! - as I learned today from SSIS dev manager David Noor. The download page for the ACE Provider now contains the following new paragraph: The Office System Drivers are only supported under certain scenarios, including: ... 2.To transfer data between supported file formats and a database repository, such as... [More]
Nov
17
2011

Get the Office 2010 Filter Pack for search in SQL Server 2012

SQL Server 2012 “Denali” installs the latest Microsoft word breakers and stemmers. However, it does not install the latest filters for Microsoft Office documents. If you want to use Full-Text Search or Semantic Search to index documents created by the most recent versions of Microsoft products, you have to download the latest filters. Get the latest filters To get the latest Microsoft filters: Download the appropriate version – 32-bit or 64-bit – from Microsoft Office 2010 Filter Pa... [More]
Nov
16
2011

Recompile VSTA scripts programmatically in SSIS

You can use the SQL Server Integration Services API to reconfigure a package dynamically, or even to create an entire package from scratch. Books Online doesn't say much about this. But the SSIS product team has provided the Package Generation Sample, and various bloggers and authors have described the process and the code. What if you want to add Script Tasks or Script Components programmatically? I blogged about this in 2008 - Adding a VSTA Script task programmatically. And now the big question. What if y... [More]