Is SQL PaaS Right for You?

By | Azure
With the arrival of the new year, you might be considering how SQL Server can better fit your company’s growth in 2019.  SQL Platform as a Service (PaaS) could be a viable option for managing essential database operations. With PaaS, your SQL Server workloads would run as a hosted service in the cloud with most database management functions maintained by the cloud service provider instead of your IT team. Top Reasons to Consider PaaS Operates completely within the cloud. PaaS provides developers with an environment to develop and deploy applications entirely within the cloud. This includes complex enterprise applications your company may need to solve business problems and simple cloud-based applications. Scaling is easy. You can pay-as-you-go. Service providers allow you to take advantage of advanced development tools as you need them, giving you more value at an affordable rate. Your bottom line increases. You no longer need to purchase software licenses, application infrastructure, or development tools. Finally, your development team can have the opportunity to focus on managing the applications and services they create while the cloud service provider manages the rest. Decrease coding time. The development tools PaaS can provide include some pre-coded application components (i.e., security features, directory services, workflow, etc.) (more…)

Understanding Blockchain, the Trending New Tool

By | Database Technology Trends
There’s been an increasing amount of buzz around blockchain technology lately, and people are more interested than ever before. “A new technology that functions as a distributed ledger within a decentralized network and promises greater security, lower transaction costs, etc.” is usually how it’s described. But what does all of this really mean? What is Blockchain? In its simplest form, Blockchain is a digital ledger (consider the general ledger your organization’s finance/accounting teams use) that stores information across a network of computers. It stores information in batches called “blocks,” that are linked together in a chronological fashion, similar to a chain of blocks. This information can be virtually anything, but try imagining it in terms of a financial transaction, since that’s probably the easiest to visualize. To illustrate, here’s what happens when you make a purchase: Imagine purchasing new software online from Microsoft (for illustrative purposes only). The block would store the date, time, and dollar amount of your purchase. It would also log information about who is making the transaction. For security purposes, your name would be recorded as a unique “digital signature,” more like a username instead of your actual name. Once your block has been verified and (more…)

Ron Hymer Chosen To Lead New, Data Intensive, Custom Software Development Division

By | Press Releases
TAMPA BAY, FLA. JANUARY 21, 2019 Dobler Consulting is pleased to announce that Ron Hymer, a recognized thought–leader in custom software development, will be joining the Dobler team to lead their client-centric software development practice. Hymer brings to Dobler years of experience designing and implementing data-intensive software solutions for national and regional business in a variety of sectors. “We are excited to have such a savvy business technologist like Ron join our team,” said Peter Dobler, President of Dobler Consulting. “The trend we’re seeing for 2019 and going forward is that business not only need expert managed services for their expanding enterprise data assets; they now need to more expertly leverage those assets through integrative, fine-tuned, custom software applications that are niche specific. Ron gives us this expertise and leadership.” According to Gartner’s Top 10 Strategic Trends for 2019, this trend of fine-tuned software customization is driven by the combinatorial effects of strategic technologies: AI–driven development, edge computing, augmented analytics, blockchain, and security to create smart spaces for innovation, collaboration and immersive experiences. “I have worked in data leveraged software development for over twenty years, and there has never been a more exciting time where the convergence of technologies has (more…)

How to Make Power BI Work for You

By | Database Technology Trends, SQL Server
If you’re searching for software that will enhance your analytics process while making it simpler and more flexible, Power BI is worth looking at. It provides tools that the non-technical users on your team can use to perform analytics with minimal help from the IT team. You can create intuitive models, data visualizations, and dashboards and share them with whoever you want. What is Power BI? –Power BI is a cloud-based analytics software service consisting of a combination of tools (i.e., visualization, self-service data analysis, etc.) that allows users to connect to multiple data sources—no matter where the data resides— and create customized, coherent insights. It’s not exactly new since many of its components were in the market prior to its 2015 release. For instance, Microsoft released Power Pivot as an Excel add-on in 2010. This tool alone is a game changer as it gives analysts the tools to import large volumes of data, create relationships between the data, and perform powerful analysis using PivotTables and Pivot Charts. Using Power BI, you can further manipulate these datasets to perform more complex analyses. Utilize All Components of Power BI – Power BI consists of many components. Users find some more useful (more…)

Reducing Application Errors with Application Continuity

By | Database Technology Trends
The database and application work hand in hand. When a client interacts with features on your website the application calls back to the database, and the database responds by giving it the right information or action. It’s a well-orchestrated conversation. When something happens that stops the conversation the application doesn’t get what it needs and the customer receives an error. This is where application continuity comes in. The idea is to enable maximum continuous communication between the application and your database instances even if there is an outage. This is a massive step in maintaining data integrity and improving the end user experience. The first step in understanding continuity is virtualization. This means that your database layers are virtualized in the stack and your infrastructure can create multiple nodes and instances for your workload, shuffling transaction and processing usage as needed. It is useful for scaling up and down easily and allows more redundancy to protect in case of outages. When one node goes down, whether for scheduled maintenance or unexpected failure, the other nodes are there to take its place and your customer is never the wiser. There are some software products that can help you design this virtualization (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…)