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]
Earlier today I published a blog post about Looping over document similarity details in Semantic Search on the MSDN blog of the SQL Server Full-Text Search team. That post introduces the 3 built-in rowset functions that are provided by Semantic Search in SQL Server 2012 “Denali.” It also describes how to do something for which we don’t provide a built-in set-based function – that is, iterate over the documents that are similar to a source document, and ask why each document is simila...
[More]
The ADO.NET providers coming out of RSSBus make some interesting data sources available to SQL Server Integration Services packages through the ADO.NET Connection Manager and Source adapter. The documentation for each of these is available online and includes screen shots. Free trial downloads are also available.
Imagine how you could creatively transform, if not your fortune, at least your QuickBooks data, or filter a large volume of SMTP email, or report on the output of your PowerShell scripts.
The...
[More]
SQL Server Books Online is flabby and bloated. The structure and style are inconsistent. You can't find what you want. I know. I use BOL too when I'm writing T-SQL or learning an unfamiliar feature.
We're fixing that
We're fixing that, at least in SQL Server "Denali." We're reducing BOL itself - that is, the "product documentation" - to the minimum that you need to use the product successfully. This core documentation will now include just 2 things:
An introduction to each significant feature and its ...
[More]
The address of my Dougbert blog has changed slightly. Please re-subscribe to my blog feed at this new address:
Feed address: http://feeds.feedburner.com/DougbertsBlog
Web address: http://dougbert.com/blog/
I plan to continue blogging about SSIS and other SQL Server features.
I will not be posting any more on the old blog (http://dougbert.com/blogs/dougbert/). I intend to leave the past posts there. If you've saved or shared links to my past blog posts, they should remain valid.
Why the change?
I now...
[More]