Proudly Serving Ohio
Ohio SQL Server Development Since 1995
Stay passionate about delivering innovative enterprise solutions.
My first experience with SQL Server was in 1995 when I was a Visual Basic developer for Nabisco Planters Lifesaves of RJR. The Nabsico SQL Servers were at that time running on OS/2 Warp.
SQL Server is a relational database management system created by Microsoft through it's partnership with Sybase. The Microsoft partnership with Sybase and Microsoft was able to keep older versions pursuant to contract and continue to develop SQL Server but not under the Sybase name. In face initial versions of SQL Server ran best on IBM OS/2 before the Windows platform.
Ohio Customers
Some information I know about Ohio is I believe the state was admitted or ratified to the United States around or about 'March 1, 1803'. Ohio is located around latitude '40.367474' and longitude of '-82.996216' and has a population of roughly '11,799,448 million'. If I remember correctly the capital is 'Columbus' and the largest city is 'Columbus'.
In fact, SQL Server is intended to compete against Oracle and IBM. The latest versions of SQL Server features include self-tuning, self organizing, and self maintaining. All with the goal to provide near-zero downtime.
Why Use SQL Server?
SQL Server includes features usually reserved for high-end database products. For example:
- Replication (Data Transformation Services )
- Full Text Search
- Analysis Services
- Reporting Services
- Data Workflows
Word of Mouth
Take a moment to read related case studies and testimonials below around my experience with Sql Server.
Case Study
When RJMW a leader in Catastrophic Insurance needed a system to turn around insurance estimates faster they came to me. What I created for them was a cutting-edge claims and adjuster deployment system that took 7 day turnarounds to 3.
"Eddie has been a fantastic help in updating our claims system software. He has always been responsive and has come up with innovative ideas that have transformed how we do business. I would highly recommend Eddie and his company to anyone that needs custom software done."
April , 2016
Jay Crisp | USA
Director of TAP and Special Operations
RMJW
Case Study
First Med EMS Ambulatory services needed a custom document management solution that encompassed scanning in-house ScanTron styled documents via ADF (Automatic Document Feeder) scanners. The goal was to forgo the purchase of expensive ScanTron equipment and recognize scanned OCR (Optical Character Recognition) and OMR (Optical Mark Recognition).
My solution saved First Med EMS over 100,000 the first month work began on the project with a home-grown Electronic Document Management System (EDMS) which automatically scanned both sides of pages through the Automatic Document Feeders. His scanning engine was smart enough to ignore blank pages on the Epson GT-S50 scanners tested. Resulting scans were slammed into a SQL Server Full Text search database and saved as OLE Blob Image format.
Saving images in the database resolved a huge industry problem of file pointers to disk locations which was slower on retrieval difficult when locating files where folders could have 200,000+ images or more making research painfully slow. I utilized Lead Tools Recognition engine to zone out all OCR/OMR areas for extraction of key values into the database with all appropriate key and search values filled in.
"I knew when I interviewed Eddie, he was what the organization needed. His expertise proved me to be right. He was invaluable and created a Scantron replacement system we are very proud of. Eddie also created a drivers manifest with turn-by-turn directions and built a location system for our ambulances."
December, 2013
Chris Martin | USA
CEO
Life Ambulance Services (First Med EMS)
"Eddie and I worked on a Document management system, OMR/OCR, secure FTP, and scanning applications. The company would often change their programming requirements, but Eddie quickly continued to produce software updates. Eddie's dedication and strong knowledge in .NET, computer networking, and Microsoft SQL helped the company to achieve its goal. He was able to assist in developing custom applications that could not be satisfied by expensive boxed software."
December, 2013
Jeremy Travis | USA
Help Desk
Life Ambulance Services (First Med EMS)
"Eddie, great job on EDMS (Electronic Document Management System), when your back in Wilmington I will treat you to a steak dinner!"
August, 2013
Robb Stone | USA
CTO
Life Ambulance Services (First Med EMS)
"Eddie, EDMS is working flawlessly across 60 stations and the users are not reporting problems with scanning. Great job!"
February, 2013
Jonathan Laughnan | USA
Help Desk
Life Ambulance Services (First Med EMS)
Case Study
Let's talk drug manufacturing for a minute and Banner Pharmacaps. Banner hired me to govern all Visual Studio .Net development for migrations from VB.Net to C# as well as all new windows and web development. Banner had me write a capsule seam check application to communicate to a $70,000 OGP microscope to monitor gel cap seams to help eliminate production issues for leakers etc.
Eddie worked with the Banner Validation department to ensure all CGMPs / GxP / GAP Analysis, reporting, GAMP5 and GMP FDA understanding and compliance was met. He even implemented Banners first SDLC document system to assist in proper documentation.
"Eddie was a pleasure to work with. He is very knowledgeable and a very patient professional."
4/16/2012
Darlene Bryant | USA
SAP Systems Analyst III
Patheon (Formerly Banner Pharmacaps)
"Eddie, great work on the Capsule Seam Check application. Let's hope they use it."
1/12/2012
Gary Brown | USA
IT Supervisor
Patheon (Formerly Banner Pharmacaps)
Case Study
Synergy Broker needed assistance with their clients' web sites so they selected me to develop client sites with hosting which allowed them the maintain their own content eliminating all the content modification fees normally associated with web site maintenance.
"Eddie has many talents and has a deep understanding of web development, technology, and social media. He is an outstanding programmer and has worked on some amazing projects. I recommend Eddie because he has more eCommerce experience and ideas how to be successful on the web than anyone I have ever met."
6/2/2011
Donna Smith | USA
Owner
Synergy Broker
Case Study
When Syngenta needed software for their crop protection division, they looked to me to deliver a system that updated sales territories on a data warehousing system built by Robin Hooker. I delivered a Visual Basic 6.0 framework to ensure all sales territories mapped back to correct postal zip codes and across custom geographic coverages.
"Eddie is great at writing processes that are reusable. He was always looking for ways to improve processes."
4/3/2001
Steve Allen | USA
Oracle Developer
Syngenta
Case Study
I have assisted such banking giants as Wells Fargo (Wachovia) and Bank of America in highly visible projects up to an 11 billion dollar Asset Management Package where I was assigned to the project where he led as the Lead Developer Architect, Project Manager and Business Analyst. After throwing me to the wolves in banking and the success we had other banking clients such as Bank of America jumped at the opportunity to have us assist them.
"You are a great asset to the team Wachovia and I am glad I had the pleasure of working with you. If I had my own company, I would love to have you as my IT director. (Note: I created RECMTMS for Jimmy which managed $11 billion in bank assets)"
1/11/2006
Jimmy Gray | USA
Director of Finance
Wachovia Securities
"Jimmy's users are pleased with the RECMTMS application and reports. Excellent news as always."
12/1/2004
Lori Spencer | USA
Corporate Investment Banking Technology
Wachovia Securities
Case Study
My start in the food industry started when we wrote software for Nabisco to manage from a marketing perspective how they stacked up to the competition. Critical to this was the ability to monitor competition. I was given the daunting task of writing a system to monitor at the product and geographical level what competitors were doing with existing product and new product.
I delivered CATS (Competitive Activity Tracking System) which allowed Nabisco and Planters & Life Savers divisions to keep abreast of competitor changes in the market place. This competitive advantage was unheard of in the industry. I cannot disclose how competitive information is gathered in the field but the final system, included actual pre-release product images from actual competitor bagged product, competitor price sheets and more.
I also assisted in implementation of IRI Customer Sales syndicated data for in-house processing (savings in excess of $2 million) which the company was utilizing for competitor information as well by loading the IRI data for easy distribution to the entire organization. This data combined with CATS made for a competitive arsenal still unmatched since 1991.
"Great work Eddie! Clearly the whole company is benefiting from your VB expertise and your continuous sharing of routines you have developed through Townhall."
3/24/1995
Dave Pettigrew | USA
Sales & Marketing
Nabisco / Planters & Life Savers
"Thank you for all the functions and subs that you put into the libraries. I've only used a handful so far, but they have saved me a lot of time. They are all easy to use and understand"
3/23/1995
Jonathan Shema | USA
Developer
Nabisco / Planters & Life Savers
"The implementation of the IRI Consumer Sales databases on the MVS machine in Wilkes Barre was a success! All systems GO! Thanks to a tremendous show of effort from our Information Processing Services group, IRI and our dedicated Marketing Systems Team the project has been completed on-time and without any loss of service to users as full access has been maintained through the project. Project savings in excess of $2 million."
7/14/1994
Joe Farrelly | USA
Sr. VP & CIO
Nabisco / Planters & Life Savers
"I think Eddie has done a good job on reviewing the present market for this type of software; I wish more developers would put this level of effort into it. Eddie's assertion, confirmed by Ahmed, that native DB-LIB is the fastest access path to SQL Server is absolutely correct."
4/25/1994
Greg DiGiovanni | USA
Development Manager
Nabisco / Planters & Life Savers
"Bruce: My main man (Eddie Drye) has been a great help to me down here.... He has some things published in Townhall y'all might be interested in. Yesterday we the entire process up as a PIF and this is the result. I'm putting this one to bed."
9/22/1994
Larry Leonard | USA
AS/400 Senior Developer
Nabisco / Planters & Life Savers
"Thank you for your hard work and cooperation on our first validation process. I really appreciate your attitude and initiative in following up through the various stages of this process. I am looking forward to many successful validations to come!"
6/15/1994
Robert Bowden | USA
Sales
Nabisco / Planters & Life Savers
"Just wanted to add my appreciation concerning the fine work Eddie and Dave did for the first Account Review database update. As you know, support of the Account Review system, Is a top priority of the LifeSavers management team. Your group has done an excellent job assuming these key responsibilities. Thank you!"
6/15/1994
Earl Godwin | USA
Sales
Nabisco / Planters & Life Savers
One cannot deny that SQL Server offers a lot of bang for the buck, when compared to IBM or Oracle. Ilike how it is tightly integrates with Windows and it works beautifully with Visual Studio.
Microsoft DB-Lib Legacy
DBLIB (stands for DataBase Library) is a Microsoft proprietary Call Level Interface consisting of C functions and macros (compare to Oracle OCI) that can be used to access Microsoft SQL server 2000 from the applications programmed in third-generation languages (mostly C). It was the original interface, and it became a legacy interface with introduction of Microsoft SQL Server version 7.0.
The DB-Library API has not been enhanced beyond the level of SQL Server version 6.5, which means that even if you are able to use it for communication with Microsoft SQL Server 2000, you would be limited to only the feature set of its 6.5 version (which was all the rave back in 1997).
The principles of DBLIB do not differ much from Oracle's OCI interface: you include the header files to get all the definitions into your C program, then you compile and link it. Samples of the DBLIB applications are installed with the Microsoft SQL Server 2000 in default directory \Microsoft SQL Server\80\Tools\Devtools\Samples\DBLib.
DBLIB is the fastest interface to the MS SQL Server. You can find more help about programming DBLIB in the Microsoft documentation, but keep in mind that this interface quickly becomes obsolete (though you might not have much choice if your server is version 6.5, or 6, or - just don't tell anyone - version 4.2, capable of running in MS-DOS and OS/2 environments).
If at any point you decide to reach to me just know the area codes I am familiar with for Ohio are '216, 220, 234, 330, 380, 419, 440, 513, 567, 614, 740, 937'. For Sql Server assistance you will find my rates very reasonable for Ohio. Now just keep in mind my time zone is 'Eastern Standard Time (EST)' and I know the time zones in Ohio are 'Eastern Standard Time (EST)' in case you wish to call me. Anyway let me continue.
Why Partner With Me?
I've been creating SQL Server-based applications since the Sybase days. The majority of enterprise class applications we've written were based on SQL Server. These applications are all fast, secure and stable. I have many years of real-world, large enterprise SQL Server experience, including:
- Experts in every version of SQL Server back to OS/2
- Extensive experience with Data Conversion, Integration and Reporting
- Years of Data Scrubbing / Data Massaging
- Experience with large Full Text Search eCommerce databases with over 10 million skews
- Many projects large Windows projects with connectivity to SQL Server
You know, I don't make it out to Ohio much but I would like to see the 'Cardinal' state bird. I am a little familiar with the Ohio 'Scarlet carnation' state flower as well. However, I do not know much about Ohio's state tree the 'Ohio Buckeye'. Fishing is fun to me perhaps I would like reeling in the Ohio 'No Official Fish' state fish. Anyway, sorry I went off topic. Let me continue.
Expert in SQL Server (All Versions)
I have been developing in SQL Server since Version 1.0 when Microsoft partnered with Sybase. SQL Server has grown over the years to compete directly with Oracle on a playing field no other database comes close to venturing. MySQL is on the move though but still not able to keep up with the features and speed of Oracle and SQL Server. I have the experience, so call us today to get your coding started.
Need Assistance?
Ever have an idea about a product or service but lack the ability to develop that idea? Are you looking for a reliable person/firm to build your software? Perhaps you are in need of someone to manage projects and teams?
Word of Mouth
[ Latest 10 ]