U.S. Bancorp Piper Jaffray, a subsidiary of Minneapolis-based U.S. Bancorp, provides individuals, institutions and businesses with a full range of investment products and services. Founded in 1895, the company has grown to become the 11th largest brokerage firm in the nation with over 100 offices in 18 states. The company holds a national reputation for its expertise in fundamental and technical research as well as debt and equity financing for growth companies in key industries. In addition, a few Oracle and Sybase servers remain in-house. Weeldreyer's work is concentrated onmore than 100 SQL Server databases, several of which are over 20 gigabytes.
Applications range from fraud detection to teller staffing, web banking and data security.
Prior to its introduction to the Embarcadero Lifecycle Management solutions, U.S. Bancorp Piper Jaffray relied on Microsoft's SQL Server Enterprise Manager. While satisfied with that product, Weeldreyer found Embarcadero's flexibility, functionality and user-friendly interface unlike anything he had worked with before. You have to have an image of your database. Your ability to comprehend what's going on with a system is greatly improved by being able to see that picture and move it around into formats that make sense to you. And for altering and migration, DBArtisan saves the team hours each day.