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]
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]
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]
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]
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]
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]
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]
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]
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]
SQL Server 2012 “Denali” Full-Text Search introduces a new custom proximity operator, which we’ve been calling “customizable NEAR.” The new NEAR operator lets you query with 2 optional requirements that you could not previously specify:
The maximum gap between the search terms.
The order of the search terms. (For example, “John” must appear before “Smith.”)
Here is a partial example of the new NEAR operator:
CONTAINSTABLE (Documents, Content, 'NEAR((...
[More]