Archive for category MS SQL
Automatic Email Alerts From Any SQL Query
Posted by Eric in .NET 2.0, Desktop Applications, MS SQL on September 2, 2009
Problem Reminder emails were needed to be sent out to remind sales staff to follow up on projects. Solution I developed a simple command line executable that takes 1 parameter which is an XML file. The contents of the XML file would look something like: <?xml version=”1.0″ encoding=”utf-8″ ?> <Settings> <ErrorEmail> <Email>email@gmail.com</Email> </ErrorEmail> <SummaryEmail> <Email>email@gmail.com</Email> [...]
E-manage Mobile Portal
Posted by Eric in .NET 3.5, ASP.NET, MS SQL, Web Applications, Web Services on August 18, 2009
Background: E-manage is a business management application. It is capable of managing customer databases (CRM) as well as projects, invoices, purchase orders, and inventory to name a few. The e-manage client application runs on a users desktop and uses Microsoft .NET as foundation along with a Microsoft SQL Server as the back-end. Problem: Getting information [...]
eManage Search for Blackberry
Posted by Eric in ASP.NET, Blackberry Enterprise Server, Blackberry MDS Runtime, MS SQL, Web Services on August 17, 2009
Background: Our CRM software contains a huge list of contacts that are only available from within the software application. Problem: It becomes a challenge when a sales team member is out of the office (on the road) and needs a customer’s phone number or email address. It is typically not feasible to boot up their [...]
Inventory Application
Posted by Eric in .NET 2.0, ASP.NET, Desktop Applications, MS SQL, Web Applications on August 17, 2009
Background: As for any company, physical inventory time is never fun. Our inventory software did not have a good interface for doing this. Problem: The process of taking physical inventory was long and tedious. The process typically involved printing our a huge list of parts, write in the quantity next to the part, then someone [...]
Company Intranet
Posted by Eric in ASP.NET, MS SQL, Web Applications on August 17, 2009
Background: A company I worked for had a new Internet (external) web site built. Problem: We already had a working Intranet (internal) site, but my company wanted to make the Intranet (internal) site to have a similar look and feel of the Internet (external) site. They also wanted it to be more database driven so [...]
Installation Schedule 2.0
Posted by Eric in AJAX, ASP.NET, MS SQL, Web Applications on August 17, 2009
Background: This project had a similar background to the Install Schedule application. We started using a software package called eManage (I worked for this company later and built a mobile web application to interface with their database) to manage several areas of our business. The software has a built in calendar that can be used [...]
Desktop Tools
Posted by Eric in .NET 2.0, Desktop Applications, MS SQL, Web Services on August 17, 2009
Background: I created a single page web page that was set as the background using the Active Desktop function of Windows XP. This web page allowed you to search the employee database for phone numbers or extensions. It also had a section to calculate shipping for certain items my company sells. Problem: Active Desktop started [...]
Custom Conversion Application
Posted by Eric in AJAX, ASP.NET, Desktop Applications, MS SQL, Web Applications, Web Services on August 17, 2009
Background: One of the many things my company does is file room conversions. To make this short and sweet, a file folder may need to be moved to a new location. In the process the folder may need a new label applied to the folder. This is simplistic example of a conversion. A client requested [...]
Cell Phone Usage
Posted by Eric in AJAX, ASP.NET, MS SQL, Web Applications on August 17, 2009
Background: My company uses Sprint as a cellular provider. Paper bills are 300+ pages and arrive in a box. Sprint offers a service to download cell data at the end of each month (for a cost). Problem: Flipping through the bill was very cumbersome and took sometimes several hours. My company wanted an easy way [...]
Installation Schedule
Posted by Eric in ASP, Javascript, MS SQL, Web Applications on August 17, 2009
Background: This is what started it all (at least at my previous employer). The company I worked for company sells stuff and that stuff has to be installed by a professional installer. They have a large staff of professional installers. They have a lot of stuff that needs to be installed. See where I am [...]
-
You are currently browsing the archives for the MS SQL category.
Technologies
