Oracle Gold Partner

What’s New in Oracle’s Database 19c

By | Oracle
Oracle is one of the leading providers of database services with decades of experience at the top of the pack. Their new product releases are always exciting to watch, improving upon their legacy of client-focused products and services. Last year they released database 18c, the first of a new annual release schedule, that featured the revolutionary Autonomous Cloud database along with Multitenant Architecture, In-Memory Columnar Architecture, and Native Database Sharding. This year’s database 19c continues to build on the foundations set in previous years with a focus on stability and efficiency. If you are thinking about upgrading or migrating to Oracle’s database 19c, here are a few special features to expect in this newest version. New Features in 19c This database version comes with some exciting enhancements to make your job faster and easier. While the main focus of this development cycle has been on stability, there are a few new features focused on automating and optimizing for the client. Let’s look at a few of these enhancements. Automatic Indexing – Indexing items takes time and can mean a lot of busywork for your IT team. With Automatic Indexing, Oracle’s 19c uses machine learning algorithms to identify items, map and (more…)

Make the Most of Microsoft SQL Server with Management Studio

By | SQL Server
Microsoft SQL Servers are an industry leading choice for your workloads, but if you are not using Management Studio you may be making things harder for yourself. The additional service is designed to integrate with your SQL database engine and improve object management, database queries, and other management functionality. What is Management Studio? – SQL Server Management Studio (SSMS) was originally released with SQL 2005 and helps users access and manage their SQL instances. It is an integrated management interface that allows you to access your SQL Server, manage objects, write scripts and perform queries with a number of tools and features. It combines tools from Enterprise Manger, Query Analyzer, and Analysis Manager to get this job done. SSMS is easy to use with an intuitive User Interface (UI) and familiar design built on Visual Studio and will help improve your team’s management of SQL Server objects and elements Object Explorer – The interface is intuitive and makes accessing and managing your databases simple and efficient. The Object Explorer is a hierarchical navigation tree that allows you to locate and act upon objects in your environment. These objects can be databases, tables, etc. You can click through the tree to (more…)

What You Need to Know to Migrate Your Oracle Database to the Cloud

By | Oracle
Many organizations are making the switch from on-prem to cloud databases. These cloud native warehouses can provide more reliable and timely access, cost-efficiency, and automated backup and recovery. If you are using any on-premises version of Oracle Database, you might want to consider whether moving to the Oracle Database Cloud is right for your company. There are numerous migration methods, and the process can be very simple when you work with an expert. Try reviewing these key factors prior to selecting a migration method and save yourself some additional time. Know Your On-Premises Operating System/Platform and Version – Ensure you have a full understanding of the platform your company is currently working on along with the version. Are you using Windows, Mac OS, or Linux? There are some operating requirements that will be applicable depending on the migration method you are interested in adopting. Know Your On-Premises Database Version & Cloud Database Version – Are you currently using Oracle Database 11g, 12c CDB, or 12c Non-CDB? Depending on your response and the cloud version you are transferring to, Oracle has multiple migration options for you to choose from. For example, a move from on-premises Oracle Database 11g to Oracle Database (more…)
Database strategy and consulting services

Customer Case Study: Administrative Services Company Uses Managed Services to Replace IT Dept

By | Case Studies
Overview Business Situation: Client needed dedicated IT team to manage Microsoft SQL Server database and backups. Solution: Dobler Consulting’s Managed Services contract for ongoing support and consultation. Benefits: Low/No Maintenance, Ongoing Support, Maximize Efficiency, Lower Cost Option. Business Challenge Insurance Administrative Services (IAS) is a local company based out of Clearwater, FL. They provide innovative business solutions for insurance agencies and facilitate business processes for some of the country’s leading agencies. In 2010, the company recognized the daily management of the database and backups was impacting the productivity of their team. The company’s Microsoft SQL Server required management for upgrading, tuning, and scaling that took valuable time away from their core team. They decided that in order to optimize their potential they needed a dedicated IT team. However, to hire an in-house team would have been costly and time consuming. The required staffing, personnel, and HR resources that would be needed encouraged them to seek a different solution. Solution The solution for IAS was a contracted database administrator. This would give them the benefit of expert knowledge and increased resources, without the prohibitive staffing challenges. IAS selected Dobler Consulting to fill this role. Dobler’s managed services product provided ongoing database (more…)
Database strategy and consulting services

Customer Case Study: Leading Healthcare Provider Uses Managed Services to Support Sybase ERM

By | Case Studies
Overview Business Situation: ERM on Sybase needed level 1 support. Client’s current database administrators (DBAs) were taxed and losing productivity. Needed more Sybase experts. Solution: Dobler Consulting’s Managed Services contract for ongoing support and consultation. Benefits: Gained Sybase Expertise, Increased Productivity, Cost Effective. Business Challenge Healthcare is challenging enough without the added pressure of large scale database maintenance. One of the leading healthcare organizations recently learned this lesson. Their business processes are on an EMR application running on Sybase AIX. They realized their DBAs were bogged down with mundane on-call tech support. They were having trouble maintaining knowledgeable staff for these issues. Fewer people these days can claim expertise in Sybase, and the lack of available resources meant that this company needed help. They reached out to SAP and were referred to one of the top Sybase experts, Dobler Consulting. Solution The solution for this company is a Managed Services contract with Dobler Consulting. They are able to utilize Dobler’s team and expert Sybase knowledge to maintain the database on the back end. As a healthcare provider, it is vital that records be accessible at a moment’s notice. That is why it is so crucial to have support that is (more…)
Database strategy and consulting services

Customer Case Study: Custom Software Provider Increases Productivity Through Managed Services Support

By | Case Studies
Overview Business Situation: Routine Maintenance requiring too much time. Pulled focus from client project tasks. Needed less hands-on maintenance. Solution: Migrate from Azure to AWS and use Dobler Consulting for ongoing managed services. Benefits: Performance Improvement, Increased Stability, Lower Maintenance. Business Challenge This client is a premier supplier of premium customer loyalty software. The team spends their time designing and implementing custom software solutions for their clients, but they recently found themselves devoting more and more time to their internal solutions. Their IT infrastructure required frequent attention for routine maintenance and support. This attention took time and focus away from client facing activities and decreased productivity. The team needed a solution to handle the day-to-day maintenance that would free them up for more strategic work. The client had devised a corporate strategy to migrate from Azure to Amazon Web Services (AWS) to minimize maintenance needs. They used this opportunity to add Dobler Consulting for their ongoing support. Solution Dobler began their relationship with the company to support their database migration from Azure to AWS. Dobler’s team managed a successful migration and proved to be a valuable partner throughout the process. During the migration, Dobler managed the company’s IT requirements and (more…)
Database strategy and consulting services

Customer Case Study: Financial Technology Powerhouse Upgrades and Migrates Sybase Database in Record Time

By | Case Studies
Overview Business Situation: Older hardware and software were taxing resources with poor performance and stability. Solution: Migrate from AIX to Linux and upgrade to latest Sybase version (ASE 16). Benefits: Performance Improvement, Increased Stability, Lower Maintenance. Business Challenge The financial services firm was using Sybase on AIX to run mission-critical processes, but performance and stability issues were becoming increasingly problematic. This system took a lot of manpower to maintain. It also lacked the necessary scaling and performance to improve their processing. They decided to upgrade to the newest version, ASE 16 and to migrate to Linux OS. This decision was just the first step. Now they were faced with the issue of time. The client needed to complete the project within just a few months so they could have the system back up and running for year end processing. With a short window in which to complete the project, they needed a partner who could act fast. Dobler Consulting stood out as a Sybase expert who could help steer them toward the smoothest and quickest implementation. Solution Dobler Consulting worked together with the company to plan and implement the IT project in an unprecedented amount of time. Using templates planned from (more…)
Database strategy and consulting services

Customer Case Study: Leading US Bank Company Moves SAP ASE to AWS for High Availability, Scalability and Cost Savings

By | Case Studies
Overview Business Situation: Outdated platform lacked high availability and scalability needed. Required frequent oversight and dedicated team to manage. Solution: Migrate from AIX to AWS and upgrade to latest Sybase version (ASE 16). Benefits: Cost Savings, Increased Availability, Performance Improvement. Business Challenge This company is one of the largest US banks with 755 branches and multiple financial products. Such a large organization needs an efficient, scalable computing platform. At the time, they were managing their workload with an older version of Sybase on AIX. This required constant management with a dedicated in house data center, and infrastructure team. Updates, patches, and hardware overhauls were becoming costly and time consuming. The company recognized that a cloud platform could increase their team’s productivity and better support the high demands of the financial services business. After careful consideration, they decided to upgrade to the latest version of Sybase (ASE 16) and migrate from AIX to Amazon Web Services (AWS). Solution With such a large-scale critical workload to migrate, fidelity and security were key considerations. The company’s team knew a Sybase expert would help ensure a smooth transition. They selected Dobler Consulting for this role. Dobler’s team devised an IT strategy that increased high (more…)
Database strategy and consulting services

Customer Case Study: Major US Airline Migrates Mission-Critical Systems to Increase Stability and Performance

By | Case Studies
Overview Business Situation: Old Sybase version needed upgrades but potential downtime was a big problem. Needed strategy to upgrade without downtime. Solution: Upgrade Sybase to latest version (ASE 16) and migrate to newest Linux platform. Benefits: Cost Savings, Increased Availability, Increased Stability, More Scalabillity. Business Challenge The airline industry is fast paced and relies on incredible computing power to maintain performance. This major US airline manages massive workloads on a 24/7 basis. The company had been operating Sybase ASE on Linux for years, but was in need of a system upgrade. In 2016, performance challenges and high overhead reinforced this need. The decision was made to upgrade to ASE 16 to improve high availability rates and system stability. In order to maintain services throughout the process, downtime needed to be minimized, so they needed help to devise a specialized upgrade strategy and implementation plan. Solution Their Director of IT knew the major challenge would be avoiding downtime throughout the process. They needed a Sybase expert to help plan and manage the project. The company’s team reached out to SAP so that they could identify the best person for this critical job. They were referred to Peter Dobler and his company, (more…)

Peter Dobler of Dobler Consulting to Take Over Role as President of TBTLA

By | Company News, General Announcements
The start of 2018 is accompanied by exciting news for Peter Dobler, Founder & CEO of Dobler Consulting. With Dobler Consulting listed as one of the Top 50 Fastest Growing Companies by the Tampa Bay Business Journal and a Finalist for the Small Business of the Year awards, it comes as no surprise that Peter Dobler has been appointed to take on the role as the next President of the TBTLA.   The TBTLA, or Tampa Bay Technology Leadership Association, is a local non-profit organization whose membership is limited to current and former technology executives. Its two-fold mission is to apply the collective experience of the membership to real-world technology problems, and to mentor students – and other professionals – who are anticipating careers in information technology[1]. The most important way the TBTLA achieves this goal is through their successful GETSMART program. Established in 2001, the TBTLA is one of the many reasons why Tampa Bay is becoming a booming technology hub for business of all sizes.   The TBTLA partnered with the University of Tampa’s Information & Technology Management department to create GETSMART. GETSMART, short for Getting Everyone to Study Math and Related Technologies, is an educational and mentoring (more…)