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


Cool Projects


Cool Projects

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139046 Visits: 19408
Comments posted to this topic are about the item Cool Projects

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
CGSJohnson
CGSJohnson
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2654 Visits: 1686
Is the dearth of responses an indication that we are all just working on mundane projects?! Or is it too early?!

I would like to get into seeing how SQL Server plays with NoSQL...I think that there is some implementation of Hadoop in SQL Azure?! Only if I had more time!

- Chris
lshanahan
lshanahan
UDP Broadcaster
UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)

Group: General Forum Members
Points: 1435 Visits: 438
I work at a biorepository and we have around 700-800 extreme- and ultra-low temperature freezers (mostly -80C for mechanical and -185C for liquid nitrogen). They're monitored 24/7 by two separate servers running third-party software developed by GE/Kaye systems.

I created a solution that exported data from these two servers, imported it into an operations database in SQL Server and updated where necessary. It also serves as the data source for a Visio-based layout that we use as a map of our repository. The map displays the status of the units, their associated alarm points and will display further data about the unit or alarm tag by clicking on it. We also installed Visio Viewer on our workstations to display it in Internet Explorer so we saved on licensing costs.

Finally, it checks to be sure that units containing samples have their assocated alarm point turned on and emails a number of people if they aren't.

Prior to starting that project, I knew some SQL, but had no exposure to SQL Server. Needless to say I've learned a thing or three.

Right now I'm working on a solution to centralize production data that is currently kept in around 40 separate Excel spreadsheets (each staff person has one they fill out manually and the data is currently collected by using DDE in an Access application). Data consistency is, as you can imagine, a challenge. I'm creating a single application for data entry that will serve as the front-end for a SQLServer database. SSIS plays a role doing some additional data validation but eventually will include a component to transfer the data to a to-be-created data warehouse. That data warehouse is my personal Everest at the moment.

Our business unit collects a lot of data, but it isn't always the right data and it's not collected and stored in a structure that enables us to leverage it. And a fair amount of this data is mission-critical as in determining how much we bill our clients, labor costs, etc.

____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
Dave Poole
Dave Poole
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16068 Visits: 3403
I'm experimenting with an old fashioned technique of dealing with strings using SQL CLR to see if it still has benefit.
I'm also trying to blend in test driven development.

LinkedIn Profile
www.simple-talk.com
fificito
fificito
SSC Journeyman
SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)

Group: General Forum Members
Points: 77 Visits: 59
We just went productive with a debit card authorization system. This a very high performing solution and I have been involved from the conceptual design, several years ago. This is like a version 3.0 of the original product. This has been the toughest test we have passed, due the the very high transactional volumes and we passed it, not without some minor adjustments.
fificito
fificito
SSC Journeyman
SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)

Group: General Forum Members
Points: 77 Visits: 59
Cool project! I've always been intrigued about using Visio to visualize data from SQL Server...
Peter Schott
Peter Schott
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2656 Visits: 1930
On the tech side, I'm trying to learn more about BIML, PowerPivot, and PowerQuery. Seeing some of the built-in functionality in Excel 2013 has given me a handful of ideas about how we could possibly use that for some short-term solutions for our customers.

Personally - we're prepping for a newborn within the month. That has led to painting, purchasing, and fixing stuff around the house as we get ready. Not necessarily cool in the things I'm doing, but excited about the reason behind those projects. Smile
lionfan91
lionfan91
SSCertifiable
SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)

Group: General Forum Members
Points: 5270 Visits: 431
My project is a client/server .NET application that supports electronic warfare (EW) mission data for US Air Force combat aircraft, particularly the F-22 Raptor and F-35 Joint Strike Fighter. The application currently consists of 59 individual .NET projects in a single solution and is “modularized” so that the individual projects implement certain pieces of functionality. We can distribute the DLLs for individual projects to only those users who need the module’s capabilities. The data is stored in SQL 2008 R2 (two separate servers) and currently consists of 10 individual databases with about 35GB of data right now. What the application does is collect Intelligence data from a myriad of sources and lets EW engineers analyze and manipulate the data to develop “mission data” that gets loaded onto the aircraft and drives systems such as radar warning, countermeasures, threat identification, etc. The majority of users are located at a single location in Northwest Florida, so the app is loaded on their PCs and links to the SQL Server, but we do have remove users in California. The network the application resides on isn’t capable enough to allow client install on their PCs – the data connections timeout, so we installed the application on a terminal server and those users connect via Remote Desktop, so the only data being passes is the graphical data. Works pretty well.



sing4you
sing4you
Right there with Babe
Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)

Group: General Forum Members
Points: 764 Visits: 2093
My cool may be your mundane. One of the contractors here refactored a couple of my projects into OO written in C#. I am now learning this and am finding it very cool.
sqldriver
sqldriver
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2072 Visits: 2536
Peter Schott (8/23/2013)
On the tech side, I'm trying to learn more about BIML, PowerPivot, and PowerQuery. Seeing some of the built-in functionality in Excel 2013 has given me a handful of ideas about how we could possibly use that for some short-term solutions for our customers.

Personally - we're prepping for a newborn within the month. That has led to painting, purchasing, and fixing stuff around the house as we get ready. Not necessarily cool in the things I'm doing, but excited about the reason behind those projects. Smile


The Inquire tab in Excel 2013 is Smooooth
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