SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cool Projects


Cool Projects

Author
Message
Nils Gustav Stråbø
Nils Gustav Stråbø
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3755 Visits: 3575
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.
Manie Verster
Manie Verster
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2323 Visits: 1030
Colin Daley - Friday, August 23, 2013 5:02 PM
Again! If this keeps up I am going to have to find a new hosting provider.It works for me here, and it was working when I posted. Please try again.

Just tried, not working.


:-PManie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
call.copse
call.copse
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5705 Visits: 2014
I was working on a project to track and manage bull semen. Is that cool? Anyone? Anyone? Hehe

My coolest project was probably mundane but valuable in that it optimised inventory with fewest lorry visits. It doesn't sound exciting I know but that has really saved a lot of petrol and distribution costs, I'm kind of proud to have saved my client a lot of money and done the planet a favour too, in a smallish but significant way. If you have millions spent on direct distribution costs then saving 20% - 30% is a big deal and I think their investment has really worked out.
Aaron N. Cutshall
Aaron N. Cutshall
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2869 Visits: 1087
Jeff Moden - Saturday, August 24, 2013 4:08 PM
On the outside world, my Dad, Brother, and I are submitting the paper work to (hopefully) win a Phase III contract (final testing and implementation phase) with the U.S. Navy on "Moden Fuel". We have 3 different versions depending on the application. MF1, MF2, and MFX.

That does sound pretty cool, Jeff! I really wish you luck on it as it sounds like a much better choice than the alternative.



"...when ye are in the service of your fellow beings ye are only in the service of your God." -- Mosiah 2:17
Aaron N. Cutshall
Aaron N. Cutshall
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2869 Visits: 1087
The work that I've been doing the past 10 years involves the use of clinical data to perform various sorts of clinical quality and utilization measures that monitor the quality care of patients, uncover inefficiencies in healthcare, and highlight areas that need attention to improve patient care. Through these efforts, patient care is improved and life-saving solutions are identified. I get to work with large volumes of data, innovate some pretty cool set-based procedures and perform all sorts of analytics, This is how data geeks get to save lives!


"...when ye are in the service of your fellow beings ye are only in the service of your God." -- Mosiah 2:17
ChrisM@Work
ChrisM@Work
SSC-Forever
SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)

Group: General Forum Members
Points: 43023 Visits: 20015
Jeff Moden - Saturday, August 24, 2013 4:08 PM
I actually can't talk about some of the projects that I've worked on recently or am working on because of NDAs and personal ethics concerning perceived company secrets whether they're actual "secrets" or not. I can talk about the very interesting partitioning project that I'm working on and am looking forward to writing an article about it. That will be a bit of a project itself.On the outside world, my Dad, Brother, and I are submitting the paper work to (hopefully) win a Phase III contract (final testing and implementation phase) with the U.S. Navy on "Moden Fuel". We have 3 different versions depending on the application. MF1, MF2, and MFX. I can't talk too much about the characteristics of the fuel because many of the characteristics are considered to be "classified", but I can tell you that it's a mono-propellant (burns in an anaerobic environment because it carries it's own oxygen in the fuel itself) and is so environmentally benign that if you water it down a bit, you can brush your teeth with it.It's designed to replace a really nasty fuel known as OTTO Fuel II which has a huge number of highly undesirable attributes including the release of a rather large quantity of a member of the Cyanide family during a single torpedo run. Not good stuff for littoral waters. Moden Fuel also costs about 5 times less than OTTO Fuel II. With "sequestering" going on in the government, that's a good thing. Moden Fuel also has several extreme tactical military advantages over OTTO Fuel II but I can't say more on that subject.No... Moden Fuel isn't something that you'd want to use in a car because oxygen is "free" in the air. There's no sense in chemically building oxygen into the fuel for such a thing.I also designed and built another prototype magnetic motor that was meant to run itself and a generator. As with the attempts of so many other folks, the attempt failed. Not giving up on that... Edison's team didn't come up with the light-bulb on the first hundred tries, either. :-D And, finally, we've been looking for a commercially available motor to continue tests of Moden Fuel with. It has to be an external combustion motor and it's not as easy to find one as you think. The only motors that we've found that actually work are the same motors that OTTO Fuel uses in torpedo's. Those are damned expensive and they actually leak a lot. OTTO Fuel burns so dirty that it actually clogs up those leaks. Moden Fuel burns ultra clean and won't clog such leaks. We can't use COTS turbines for two reasons... the exhaust/workinng "fluid" of Moden Fuel is too "wet" for standard turbines and most turbines require too high a speed to operate efficiently which would also require a fairly hefty gear reduction system. The closest we've come so far is a 2 piston steam driven motor but they make the damned things too heavy. So, we've been looking at some really weird alternatives including a vane motor, a "flexible piston" motor, several different renditions of Stirling Engines (really disappointed in the state of the art there... way too expensive for something so simple if you can find one that actually works), and an odd invention by my favorite inventor of all time, the Tesla Turbine. I might just have to build one of those myself with a couple of modifications thrown in to make it a whole lot more torquey than the current SOA would have it.


Funnily enough, I read all about Otto fuel and those funny little waggle plate engines in Western torpedoes a few months ago so I could relate to this, four years after the fact (missed it first time around). I guess the question is, why don't we use rocket motors like the Russkies and have our torpedoes scoot beneath the waves at hundreds of k's per hour? Or perhaps we do now...

“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)

Group: General Forum Members
Points: 222716 Visits: 42003
Aaron N. Cutshall - Friday, July 14, 2017 5:39 AM
Jeff Moden - Saturday, August 24, 2013 4:08 PM
On the outside world, my Dad, Brother, and I are submitting the paper work to (hopefully) win a Phase III contract (final testing and implementation phase) with the U.S. Navy on "Moden Fuel". We have 3 different versions depending on the application. MF1, MF2, and MFX.

That does sound pretty cool, Jeff! I really wish you luck on it as it sounds like a much better choice than the alternative.


It hasn't worked out and the inventor of the fuel, my Dad, has passed away. The reason why it didn't work out is because we were aiming at propulsion improvements (using the fuel) of certain torpedoes for the U.S. Navy and their FMS (Foreign Military Sales) and the Navy didn't reveal that they already had a major improvement project going on (although it had nothing to do with propulsion methods) . The problem, it appears, is that there was big money involved with modifying the torpedo sensors, electronics, and programming to do something that, as a major side effect, Moden Fuel would have made such a modification totally unnecessary and would have cost a whole lot less. We even designed the relatively inexpensive engine modification they would need to do to burn MFX and extend the range of the torpedoes but it was their engine and so we were at their mercy. They played us like a fiddle.

Once we finally realized what was going on, we shifted gears to UUVs (Unmanned Underwater Vehicles) and MUVs (Manned Underwater Vehicles) and ran into a similar problem. It seems that people selling batteries and battery powered propulsion systems also have powerful lobbyists that we don't have. It's a real shame... instead of having to remove a vehicle from the water, charge it for 16 to 24 hours (and maybe have the damned thing melt down or explode as Lithium based batteries have earned the reputation of doing), and then return it to the water, it could have been "Gas'n'Go" while in the water and the duration between refuelings would have been a fair bit less than the duration between battery charges meaning that the vehicle could have done its job longer instead of spending so much time in transit for recharges.

Heh... it's almost as bad as trying to convince Microsoft that there's a need for a high performance, built in "Tally" sequence generator.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Stephen Frick
Stephen Frick
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 36
http://www.colindaley.com/translator/translator.php
Colin Daley's Grammar Translator URL
Stephen Frick
Stephen Frick
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 36
http://www.colindaley.com/translator/translator.php
Colin Daley's Grammar Translator URL
(Sorry for the double post. I failed to find a 'delete post' option.)
Aaron N. Cutshall
Aaron N. Cutshall
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2869 Visits: 1087
Jeff Moden - Friday, July 14, 2017 6:40 AM
The problem, it appears, is that there was big money involved with modifying the torpedo sensors, electronics, and programming to do something that, as a major side effect, Moden Fuel would have made such a modification totally unnecessary and would have cost a whole lot less.

It's all about making the money now as opposed what's best in the long run. That's why our highways are so terrible and so expensive because no one wants to put money into doing it right the first time but seem to have no problem in putting money into it constantly. If more people had their focus on the long-term goal and not worry about making big bucks right now, our society would be much better off. If not for oil companies worrying about today's profits, we'd all be driving cost-effective, efficient electric cars today.

Unfortunately, software development isn't much different. Whatever is easiest to patch now, not rewrite bad code, and quickest and most profitable to ship out the door today is always considered over long-term benefits. (sigh)



"...when ye are in the service of your fellow beings ye are only in the service of your God." -- Mosiah 2:17
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search