Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Cool Projects Expand / Collapse
Author
Message
Posted Thursday, August 29, 2013 7:19 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 1,880, Visits: 3,465
The latest "cool" project I worked on was an "integration" between SQL Server and ElasticSearch.
The full text engine in SQL Server is just not good enough, so we wanted to use something else, but without losing the real-time update of the full text index when changing data in the tables. We ended up with ElasticSearch because it is very easy to work with (REST and JSON based), and very easy to manage and expand.

The "integration" is based on Service Broker, triggers on the tables that is responsible for sending messages, and a Windows service (written in .NET) that listens for new messages and writing updates to ElasticSearch.
Post #1489709
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse