Miami-Dade County enhances critical services for citizens with Toad

50 %
50 %
Information about Miami-Dade County enhances critical services for citizens with Toad

Published on September 26, 2013

Author: Michael_Micalizzi

Source: slideshare.net

Description

Miami-Dade County has deployed DellTM ToadTM software to streamline database administration and development, enhancing critical services for citizens.

Miami-Dade County, which includes the city of Miami and nearly 2.5 million residents, is the most populous county in Florida, and the eighth-most populous county in the United States. It delivers the full range of government services for local citizens, including water and sewer services, solid waste services, police and fire services, and taxation services. These are supported by a range of back-end databases, from IDMS and IBM® DB2, to Microsoft® SQL Server® and Oracle® , which are managed by 21 database administrators (DBAs) from the county’s Enterprise Technology Services Department (ETSD). To ensure the database infrastructure is continuously available and aligned to the needs of internal end users and local citizens, the department’s DBAs needed to speed troubleshooting and streamline routine management tasks. In addition, the county’s database developers wanted faster, more intuitive tools for developing value- added database functionality that directly benefits internal end users and citizens. County enhances citizen-facing services After evaluating competing database development and administration tools, Miami-Dade County decided to deploy Dell™ Toad™ for Oracle® and Dell™ Toad™ for SQL Server® . Toad is the leading database development and administration tool, used by more than two million IT professionals around the world. With Toad, DBAs and developers are able to accelerate routine tasks and ensure the county’s mission-critical databases are constantly available. DBAs increase their productivity and accelerate issue resolution DBAs are able to accelerate key management tasks and speed up schema comparisons with Toad. Mike Beaudry, Oracle DBA at Miami- Dade County, says, “We find Toad Business needs Miami-Dade County needed to streamline database administration and development to ensure that critical government services are constantly available and aligned to the needs of local citizens. Solution The county deployed Dell™ Toad for Oracle and Dell Toad for SQL Server, which accelerate database management and development tasks. Benefits • County improves services for its citizens • DBAs increase their productivity and quickly resolve issues • Developers work smarter with improved data visualization • IT staff demand additional Toad licenses Solutions featured • Database • Toad Solutions Customer profile Company Miami-Dade County Industry Government Country United States Website www.miamidade.gov “We actually have a waiting list of DBAs and developers who want Toad on their desktops. They tell me they just can’t function without it.” Sue Camner, Senior Operating Systems Programmer and DBA Manager, Miami- Dade County County enhances critical services for citizens Miami-Dade County has deployed DellTM ToadTM software to streamline database administration and development, enhancing critical services for citizens

2 to be the best tool for doing schema compares; it’s very intuitive. We also use it to create scripts to recreate objects. Also, it’s about the nicest tool around in displacing all object dependencies for invalid objects.” DBAs are also able to discover missing objects in record time using the Toad debugger tool, and create reports up to five times faster than was previously possible. Sue Camner, senior operating systems programmer and DBA manager for Miami-Dade County, has been so impressed with how much Toad has increased her team’s productivity that she’s looking forward to making the product available to more of her employees in the near future. Developers work smarter with enhanced data visualization Toad has been invaluable to the county’s developers. Camner says, “We have SQL Developer from Oracle, which is free, but our people prefer to use Toad. A lot of times, SQL Developer didn’t provide enough functionality.” Specifically, Toad offers a faster, more intuitive way to view and extract information from databases. “The developers find it’s the best way to look at data. They rely on the tool to help them with that,” she says. “A lot of them use it to extract the DDL information, like a create table statement, and implement it from, for example, a test database to a production database.” IT staff demand additional Toad licenses Miami Dade’s IT staff have come to rely on the advanced capabilities of Toad so much that demand for additional licenses is escalating throughout the county. “ We actually have a waiting list of DBAs and developers who want Toad on their desktops,” says Camner. “They tell me they just can’t function without it.” Technology at work Software Toad for Oracle Toad for SQL Server Availability and terms of Dell Services vary by region. For more information, visit dell.com/servicedescriptions © September 2013, Dell Inc. Dell is a trademark of Dell Inc. This case study is for informational purposes only. DELL MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS CASE STUDY. Reference number: XXXXXXXX View all Dell case studies at dell.com/casestudies

Add a comment

Related presentations

Related pages

County enhances critical services for citizens

County enhances citizen-facing services ... County enhances critical services for citizens Miami-Dade County has deployed DellTM ToadTM software to ...
Read more

Miami-Dade County enhances critical services for citizens ...

×Close Share Miami-Dade County enhances critical services for citizens with Toad
Read more

Miami-Dade County; County enhances critical services for ...

Miami-Dade County improves services for citizens with Dell Toad that accelerates database management, administration and development tasks.
Read more

Case Study: Miami-Dade County Enhances Critical Services ...

... of local citizens. The county deployed Dell™ Toad for ... Miami-Dade County Enhances Critical Services ... Database Trends and Applications ...
Read more

Miami-Dade Police - Miami-Dade County

Important Global Message. The Miami-Dade County Emergency ... provide law enforcement services in a ... citizen of Miami-Dade County you can play a ...
Read more

And Miami Dade County | LinkedIn

View 26939 And Miami Dade County posts, presentations, experts, and more. Get the professional knowledge you need on LinkedIn. LinkedIn Home What is LinkedIn?
Read more

MDC - Official Miami Dade College Homepage

About MDC About Miami Dade College; Future Students; Leadership; ... Miami Dade College continues a tradition of cultural and artistic endeavor.
Read more

Homeland Security Bureau - Miami-Dade County

Commend a Miami-Dade Police Employee; Citizen ... tribal, and private sector partners, to enhance our ability to secure the homeland, ... Miami-Dade County ...
Read more