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


Cool Projects


Cool Projects

Author
Message
Colin Daley
Colin Daley
SSC Journeyman
SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)

Group: General Forum Members
Points: 82 Visits: 72
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.
Jim P.
Jim P.
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1857 Visits: 2215
Well my recent past DOS batch script was to come up with a system to get all the logins from over a 100+ individual domains and then load it into a SQL DB to evaluate them.

The most recent I just finished today was to setup a backup of an Interbase DB with 7-Zip to a directory on the 100+ individual domains/servers. And that includes a rolling seven day zip with e-mails daily to the pertinent users.

Basically the right people get an e-mail with an attached Excel file. If you don't see a backup for this morning in the Excel file that means you need to look at the server.

I did the same with a different app several months ago. Since then it has dropped the recovery time from days to about 25 minutes.

And I'm over five years late to the party. I think it's cool.



----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
kzhen
kzhen
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 37
At work we started using RabbitMQ for our messaging backbone about 12 months ago, we are going to start using more and more as new projects are developed. So I thought why not see if I could build a custom component for SSIS to read from a RabbitMQ queue.

It turned out to very interesting, so I wrote 5 blog posts about it here: http://kzhendev.wordpress.com/2013/07/31/custom-ssis-components/

It was a really great learning experience, as I learnt a lot about how to build custom components, but also more about the internal working of SSIS Smile

With that all wrapped up, I have now moved onto looking into StreamInsight, I managed to create my first real-time application which reads events from RabbitMQ, does some processing then outputs via SignalR to update a chart on a webpage in real-time: http://kzhendev.wordpress.com/2013/08/22/real-time-analytics-for-twilio/
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)

Group: General Forum Members
Points: 216034 Visits: 41986
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.

--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
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)

Group: General Forum Members
Points: 216034 Visits: 41986
CGSJohnson (8/23/2013)
Is the dearth of responses an indication that we are all just working on mundane projects?! Or is it too early?!


Nope... I can't speak for others but it's because I've been attacked by a terrorist on all fronts. I'll bet you know him. His name is "Bin Buzy". :-D To coin a phrase, "It's no longer a matter of how many sticks I have in the fire... it's now a matter of how many fires I have sticks in." :-P

--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
John Hanrahan
John Hanrahan
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1225 Visits: 1468
One of the cooler projects I got to work on was a PayPal competitor from 2 large competitors. The project ended up failing because PayPal was already BIG but it was intellectually very challenging.

A way less technical one but very satisfying was one I did without management approval (they just turned a blind eye). I created a system that replaced over 30 spreadsheets into a series of tables with a .Net maintenance screen. Tasks that used to take 8 hours went down to 15 minutes not to mention the data was now self correcting.
sing4you
sing4you
Right there with Babe
Right there with Babe (798 reputation)Right there with Babe (798 reputation)Right there with Babe (798 reputation)Right there with Babe (798 reputation)Right there with Babe (798 reputation)Right there with Babe (798 reputation)Right there with Babe (798 reputation)Right there with Babe (798 reputation)

Group: General Forum Members
Points: 798 Visits: 2093
John Hanrahan (8/26/2013)
One of the cooler projects I got to work on was a PayPal competitor from 2 large competitors. The project ended up failing because PayPal was already BIG but it was intellectually very challenging.

A way less technical one but very satisfying was one I did without management approval (they just turned a blind eye). I created a system that replaced over 30 spreadsheets into a series of tables with a .Net maintenance screen. Tasks that used to take 8 hours went down to 15 minutes not to mention the data was now self correcting.


PayPal won't play with me so I would love to see a competitor arise. Too bad it didn't workCrying
CGSJohnson
CGSJohnson
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2756 Visits: 1686
Yep...I know him well, Jeff. :-)
Michael Lysons
Michael Lysons
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2226 Visits: 1452
We're adding a new A&E system at work. But we need this system to also update our existing hospital PAS. So, the project is to intercept HL7 messages from the A&E system, parse them and put the data into SQL Server, and then trigger scripting software that puts that data into the PAS. The scripting software asks like a human typing into the system in effect. We have to do it this way because the PAS won't accept HL7 messages and process them.

The project involves Ensemble (integration engine, parsing/routing HL7 messages etc), Summit Healthcare's SST, SQL Server, and a VB.NET exe. I'm involved in all of it bar the Ensemble stuff. This is a live, 24/7 transactional system, something we've not developed before as we are data monkeys.

But the exciting project is that I've just finished my second iOS game, Discbord, and I'm working on my third game at the moment. Not sure what that game is going to be yet as I am working on a number of ideas before selecting the one I really want to make.
Ells
Ells
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2484 Visits: 931
I think my cool project days are over. Some interesting stuff with cars, radar and other control software. Most of my projects now are Data warehouse and BI. That used to light my candle but most of the work seems to be unpicking someone elses mess and getting it to work.

Think I need a new challenge

E.
Crying
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