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 22, 2013 8:24 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:11 PM
Points: 31,368, Visits: 15,837
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
Post #1487615
Posted Friday, August 23, 2013 4:12 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, December 18, 2014 5:28 AM
Points: 1,623, Visits: 1,411
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
Post #1487716
Posted Friday, August 23, 2013 5:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 19, 2014 5:55 AM
Points: 155, Visits: 285
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.
Post #1487773
Posted Friday, August 23, 2013 6:15 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:20 AM
Points: 2,923, Visits: 1,874
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
Newbie on www.simple-talk.com
Post #1487783
Posted Friday, August 23, 2013 6:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 11:37 AM
Points: 37, 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.
Post #1487785
Posted Friday, August 23, 2013 6:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 11:37 AM
Points: 37, Visits: 59
Cool project! I've always been intrigued about using Visio to visualize data from SQL Server...
Post #1487789
Posted Friday, August 23, 2013 6:39 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Saturday, December 13, 2014 9:58 AM
Points: 858, Visits: 1,353
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. :)



Post #1487797
Posted Friday, August 23, 2013 6:49 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, December 19, 2014 6:51 AM
Points: 3,876, Visits: 343
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.


Post #1487802
Posted Friday, August 23, 2013 6:51 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 7:01 AM
Points: 514, Visits: 2,082
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.
Post #1487803
Posted Friday, August 23, 2013 6:54 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:24 PM
Points: 492, Visits: 2,041
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. :)


The Inquire tab in Excel 2013 is
Post #1487807
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse