John's profileSQL 2005 Full Text Searc...PhotosBlogLists Tools Help

John Kane Kane

Interests
"Words matter - Write to learn what you know."
Photo 1 of 16

SQL 2005 Full Text Search

If it is to be, it is up to me!
May 19

Live Search from Desktop to Enterprise...

Thi week Microsoft anounced new Search products that extend Windows Desktop Search (WDS) to the Intranet (Corporate Enterprise Search) to links with its Internet search engine - MSN Search or soon to Windows Live Search. Below are some recent links to Microsofts product anouncments:

Worst Microsoft Product Name Ever  (source: http://www.microsoft-watch.com/)
 On Wednesday, the Microsoft branding department hit a new low. Microsoft has decided to christen the new Windows desktop search application (that can search your desktop/Intranet and Internet), due to go beta later this year, as "Windows Live Search." But there already is a Windows Live Search – the Internet search service that is currently in beta. Are the two products the same? No, the Softies said. Are they related? Nope. We've decided we're going to try using Windows Live Search A (for the desktop app version) and Windows Live Search S for the MSN service. We're not the only ones who think two "Windows Live Search" products are one too many. 

Enterprise Search Offerings: Microsoft Versus Google 
http://www.eweek.com/article2/0,1895,1963321,00.asp
http://ideas.live.com/programpage.aspx?versionId=9d28cdac-851d-4e72-96db-fd95dfc0f7c2
http://blog.seattlepi.nwsource.com/microsoft/archives/103541.asp?source=rss

New Microsoft Enterprise Search Products in the Pipeline 
 Microsoft Chairman Bill Gates on Wednesday is hosting 100 or so of the world's top CEOs as part of Microsoft's tenth annual CEO Summit. As part of the event, Gates is taking the wraps off several new Microsoft search offerings under development, including a new desktop search application, a new SharePoint Sever for Search SKU and a Knowledge Network add-on to SharePoint that is designed to harness the internal brain power of customers' "experts." The desktop search app is due to go to beta in the summer or early fall. The new SharePoint Server for Search and Knowledge Network products are slated to ship in fall 2006. 
--
Enterprise Search Offerings: Microsoft Versus Google 
http://www.eweek.com/article2/0,1895,1963321,00.asp
May 17

Re-launch of SQL 2005 Full Text Search in 2006...

I've been pre-occupied with other issues lately and have not updated this blog in some time, so today and going forward I'll start updating this more frequently with both personal notes and views as well as technical information on both SQL Server 2000 Full-text Search and SQL Server 2005 FTS!
 
If there are any topics you want me to write about or provide more details, let me know by posting a comment and I'll reply with a new blog entry on that topic. It helps me to know that others are reading this and getting value out of it. I'm also going to move forward with a new website and blog from there as well, but for now I plan on continuing to blog here!
 
Thanks!
John
November 04

Desktop Search news items...

Google Desktop 2 has upgraded, and has supposedly graduated from being a beta. There is a new mapping plug-in in the side bar, but this in particular seems very beta quality to me. (It's very hard to use - the sidebar does not accept drag and drop, so you must type in where you want to go, and there is no "go" or "Search" button, so you can't simply paste with the mouse, since you must then touch the keyboard to use the enter key).

Ask Jeeves Desktop Search has been upgraded - see the blog for full details. One of the features they particularly claim is increased stability.

Yahoo have introduced a
new mapping beta. This goes against the grain, and requires Flash, which I think is a backwards step, and also falls in to the same trap as Virtual Earth did of believing that America is the only location that counts.

Yahoo also slightly redeem themselves by offering a
new mapping API, which does offer an AJAX based embedded map, and also a REST based geocoding service (again unfortunately only for America).
--  via
Zmarties blog

The relatively new market for Desktop Search is approx. 1 year old, so these new upgrades at this time is not surprising, but so far no news on upgrades to Microsoft's Windows Desktop Search (WDS). Although, a lot of speculation in the microsoft.public.msn.search newsgroup about a Corporate / Enterprise / Intranet version of WDS...

New XQuery 1.0 and XPath 2.0 for Full Text Search

Michael Rys, SQL Server PM for XML features provides news on "XQuery 1.0 and XSLT 2.0 are now in Candidate Recommendation "  as well as XQuery 1.0 and XPath 2.0 for Full Text Search:

W3C has released a new working draft for the XQuery 1.0 and XPath 2.0 Full-Text [Search] part:

October 27

SQL Server 2005 has RTM'ed !!

 
The Developer Edition of SQL Server 2005 is available for subscribers on MSDN. A few editions of Visual Studio 2005 are also available. I don't have any word on when other editions will be available.
via SQLTeam.com

Michael Rys - The light at the end of the tunnel is bright sunshine!  - We have RTM'ed today!

Today, we have released SQL Server 2005 and VisualStudio 2005 and the .Net Framework 2.0 to manufacturing. This means the code is baked, done, shipped,... :-). It will be downloadable from MSDN within the day and available through the other channels in a couple of days. The following is just a teaser for all the cool things SQL Server 2005 will provide. Read the rather impressive list here.
via
SQL PASS Blog

UPDATE: From Michael Rys  blog:

Enterprise Readiness:

  • Multi-platform support: X32, X64 (WoW and native), IA64 Native, Numa Aware
  • Multi-instance support with 7.0, 2000 and of course 2005
  • Mobile, Tablet, Express (free), Workgroup, Standard and Enterprise – If we don’t have it, you don’t need it…
  • Table Partitioning – partition by key easily – drop a partition and add a new one, no need to delete millions of rows
  • Upgrade Advisor – (scan your existing 7.0 and 2000 servers and SP’s and get ready for an easy upgrade)
  • SQL Server Management Studio – built in the VS IDE and able to manage all services from one UI
  • Enhanced Full Text Search – Integrated backup/restore, thesaurus support, 100x faster for index build
  • ONLINE: index build, page/file restore, concurrent log and db backup, memory add, fast recovery (online during rollback) – all operations on-line…
  • Column level encryption
  • Off-by-default – reduced attack space
  • Code signing
  • Vastly improved diagnostics – Watson dumps allow us to fix 80%+ of customer issues – NO CUSTOMER REPRO -, Dedicated admin thread, Dynamic Management Views (see current server activity)
  • Database Snapshots – point-in-time query and reporting
  • IPV6 support
  • No more “general network error” – specific error messages for all errors.
  • Automatic replication of schema changes
  • Merge replication 2-5x faster
  • Built-in Oracle to SQL Server replication – the only way to go… :-).
  • HTTPS synch for mobile users

More to follow relative to SQL Server 2005 Full-Text Search features, functionality, tip & tricks! I'll use the new keyword "SQL2005FTS" with future postings. You heard it here first!

 
John Kane
SQL 2005 Full Text Search Blog
http://spaces.msn.com/members/jtkane/