Nov
2
2011

How near is NEAR in SQL Server 2012 Full-Text Search?

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]
Oct
31
2011

More sample queries for Semantic Search in SQL Server 2012

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]
Oct
4
2011

Custom ADO.NET providers make interesting data available to SSIS

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]
Apr
20
2011

Please re-subscribe to my Dougbert blog at its new address

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 this blog (http://dougbert.com/blogs/dougbert/). I intend to leave the past posts here. If you've saved or shared links to my past blog posts, they should remain valid. Why the change?... [More]
Apr
18
2011

Books Online slims down at last on the Denali diet

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]
Apr
18
2011

Welcome to my Dougbert blog at its new address

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]
Jan
7
2011

Excel driver not supported on the server

This statement about the ACE Provider and its Excel driver caught my attention on an internal discussion list at Microsoft on 12/26/2010:"The current support position from the Office team responsible for the ACE provider (both 32-bit and 64-bit) is that it is unsupported to use the ACE provider on any server-based system. Over here in the XYZ team, we have gone around and around with them and they are very clear. What you are trying to accomplish, regardless of the ‘bit-ness’,  is tech... [More]
Dec
6
2010

PowerShell with SSIS: More insights, installable extensions

Occasionally in the past I've mentioned approaches to using PowerShell to manage SQL Server Integration Services (SSIS). More recently I came across Sev17, the blog of PowerShell fiend Chad Miller. Chad has found limitations in the SSIS API that make it challenging to create an SSIS Provider for PowerShell. In the meantime, he has other insights to offer on the subject, as well as installable extensions for PowerShell. Chad's blog posts about SSIS and PowerShell including SSIS Reporting ... [More]
Dec
4
2010

Dec 14 webinar - Loading Spatial Data into SQL Server with FME

I have mentioned SAFE Software before as the most visible provider of tools and components for working with spatial data in Microsoft SQL Server, with or without Integration Services. SAFE recently announced a free 1-hour Webinar on Tuesday, December 14, 2010 - "Loading Spatial Data into SQL Server with FME". More information: Sign up for the Webinar Read more about SAFE Software and SQL Server Here is the description of the Webinar from their Web site: "This free webinar demonstrat... [More]
Nov
28
2010

Exploring the SSIS discussion with Social Gadgets

These fascinating SocialGadgets from FUSE Labs at Microsoft Research give us some insight into current discussions about SQL Server Integration Services in the social media. Read more about the projects from FUSE Labs in this blog post from LiveSide.Net:FUSE Labs brings new projects – Spindex, Project Emporia, SocialGadgets, and Montage Note: I wanted to embed the live widgets in this post, but my blog software refused to display the IFRAMEs that host the embedded widgets. Explore them "live&qu... [More]