AWS Select Consulting Partner

Dobler Consulting Achieves Select Partnership Status with Amazon Web Services – AWS

By | Press Releases
As part of the Amazon Partner Network (APN), Dobler Consulting is positioned to leverage your data, systems and software assets for migration and integration with the AWS cloud-based platform.   Tampa Bay, July 9th, 2019. Dobler Consulting, a Tampa based database management, and managed services firm is pleased to announce its newly achieved Select Partner status as part of the Amazon Partner Network (APN). APN Partners are certified business and technical consultants who help clients design, build, migrate and manage their production workloads and application software on AWS. “The AWS cloud platform has, and will increasingly continue, to rapidly transform the business and economic landscape for small and medium size businesses (SMB’s).” Said Peter Dobler, CEO of Dobler Consulting. “What our Select Partner certification means for our clients, is that we have the proven skills, tools, and processes to optimize your data and software assets to the AWS cloud-native architecture.” A review of trends that analyst are pointing to suggest that not only is cloud technology disrupting how SMB’s process data, but it is increasingly disrupting how IT professionals approach their work. Increased agility, scalability, and the restructuring of technical debt will challenge current organizational structures, current skill-sets and the (more…)

Why Consider Dobler Consulting for Your Custom Software Development

By | Custom Software
Custom software development projects are a close collaboration between the client and development team. Your development team will directly impact the success of your project, and your experience during the process.  Identifying the right development team for your project is about more than just finding knowledgeable coders. It involves finding the right combination of experience, knowledgebase, services, and personality. At Dobler Consulting, we handle comprehensive database management and technology services, and this puts us in a unique position to address custom software projects with a holistic understanding of the IT strategy. The result is more than just a development project. More Than Just Custom Software – Communication is a key aspect of the design process and requires bridging the gap between the business and tech languages. This is no easy feat, as most subject matter experts are proficient in one over the other. The resulting miscommunication can create challenges from the requirements phase all the way to implementation. Understanding the true goals of the software and how best to accomplish them from both a business and a software perspective means finding a team that can bridge those language barriers. At Dobler Consulting, we have built relationships with many companies through (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…)

Dobler Consulting Nominated for the 2018 Small Business Of The Year Award by the Tampa Bay Chamber of Commerce

By | Press Releases
Recognition of the Dobler Consulting’s Civic and Business Leadership Continues to Grow   Tampa Bay July 12th, 2018. The Tampa Bay Chamber of Commerce announced that Dobler Consulting is a finalist for the 2018 Small Business of the Year Award for companies between 21–50 employees. The awards are given annually and the winners will be announced in September 2018. The companies are evaluated on the criteria’s of operational management, community involvement, and ethical business practices. “This nomination from the Chamber means so much to us at Dobler Consulting,” said CEO Peter Dobler. “If there is one thing we have collectively learned over the years, is that there isn’t much our small team can’t do if we put our hearts and minds and backs into it. This personal can-do spirit, that small businesses have in abundance, is what brings empowerment and vitality to the Tampa Bay business community.” The importance of small business to the growth, innovation and job creation opportunities in the U.S. economy cannot be overstated. According to the Bureau of Labor Statistics, there are 29.6 million businesses with less than 500 employees compared to 19,000 with over 500 employees. Employees of small businesses represent 47.8 % of the (more…)
Database Support

What’s the Deal with Oracle 18c? (part 2)

By | Oracle
Last week we introduced Oracle’s database 18c, and focused on the new release structure and its increased accessibility on cloud environments.  If you missed this article, here’s a link to go check it out now before heading back over for part 2.  – What’s the Deal with Oracle 18c (part 1) This week we are focusing on more specific feature enhancements to those areas you have come to expect in an Oracle product.  Starting with security and moving on to platform architecture we are looking at how this newest release helps simplify your data management.  We will discuss key features from Database 12c that get exciting upgrades in this new release. Stability – Several new features increase the platform stability, including Real Application Clusters, Recovery Manager and Flashback.  Oracle takes advantage of the multi-server architecture to deliver enhanced backup and recovery features, and reduced downtime for scheduled activities. Security Enhancements – Oracle has always prioritized security and this newest version builds upon that foundation.  With simplified and optimized security protocols, this database will help you prepare for more stringent security requirements coming up in the General Data Protection Regulation (GDPR).  Here are just a few ways Oracle emphasizes security in (more…)
Security

What’s the Deal with Oracle 18c? (part 1)

By | Oracle
Oracle’s newest release, 18c, is out, and I know what you’re thinking: what happened to 12.2.0.2?  Is it really time for a whole new version?  Well rest assured, this is not really a whole new version. It’s an entirely new method of naming that more accurately reflects what has been going on for years.  The old model of multiple release versions and patch sets wasn’t doing justice to the database.  The multiple release model led many to shy away from adopting any first release database for go-live workloads.  But honestly, for years the patch sets have been full releases in all but name. So now Oracle has decided to change its release schedule, and each annual release will be named after the last two digits of the year.  The plan is to speed the release of smaller changes while avoiding the massive overhauls that used to come with first releases.  What would have been database 12.2.0.2 is now 18c, and 12.2.0.3 will instead be 19. They have also gotten rid of the Patch Set Updates and Proactive Bundle Patches.  Instead we will now get Release Updates (RU) and Release Update Revisions (RUR).  So now that we understand the new release (more…)

Expanding the Market: MS SQL Server 2017 and Linux

By | Blog, Database Technology Trends, SQL Server
Microsoft’s exciting cross-platform product, SQL Server 2017, is poised to reach a whole new audience. Recently this industry leader has joined the growing trend of support for open source solutions.  Our team is continually investigating new innovations for our clients, and we wanted to share what we have discovered about new features and performance. Why Now? Linux is becoming increasingly popular thanks to its security, stability, and efficiency.  Its design protects against virus and malware attacks with a complex architecture and secure user account structure.  With more and more businesses choosing Linux, Microsoft realized they were forcing clients to manage multiple environments by keeping SQL Server only on Windows.  Rohan Kumar, then General Manager of Microsoft Database Systems, discussed the decision with Frederic Lardinois for Tech Crunch.  “We had a couple of discussions in the past where it wasn’t approved,” he told Lardinois, but four years ago his team recognized the value of expanding, so they pitched the idea once again. “The biggest surprising part was that we were expecting a whole lot of back and forth. It was really surprising to see how quickly the decisions got made,” recalls Kumar. How? With the company’s support in place, Kumar’s team needed (more…)
SQL Server

Planning And Executing A Successful SQL Server Database Migration

By | White Papers | No Comments

By Carlos Colon / DBA Manager at Dobler Consulting

Migrating an existing database to SQL Server can be a taunting task. No matter if your current database is Oracle, Sybase, DB2 or MySQL, the core of the migration tasks are almost always identical. A SQL Server database migration project can be broken down into 6 steps.

1. Analysis
2. Planning
3. Build
4. Migrate, Test, Fix, Repeat
5. Deployment
6. Support

This presentation will walk you through these steps and in addition will also cover these topics:

– Typical SQL Server Migration Plan
– Key Deliverables
– Database Migration Steps
– Brief Overview of SQL Server Migration Assistant Tool (SSMA)
– Common Problems in Database Migrations

Download the Guide For FREE!!

Read More

SAP ASE Always-On

SAP ASE Always-On Replication / Combining HA and DR – Best of both worlds

By | SAP ASE | No Comments
The recent introduction of SAP’s Always-On HADR solution, (licensed) feature of Adaptive Server Enterprise, will have former Sybase clients thinking, “why did we ever toss Sybase in favor of brand X?” After all, Wall Street was built upon on the speed and reliability of Sybase software. No other product came close to its dataserver, replication server, and client/server ground-breaking technology. ASE and Replication Servers still play an integral part in our data services, especially with regard to speed, data integrity, and heterogeneous capability. I’ve been working with these two products for over 20 years from Replication Server 11.0.2 (when I used to pull my hair out) to the most recent 15.7.1 SP305. Now, in the post-Sybase era, the ASE/RS tag team has been given a fresh tank of oxygen and continues to thrive in the marketplace. Through the introduction of practical, user-desired features incorporated by SAP, Always-On HADR continues to be a cost-effective, reliable, robust solution for many clients planning or upgrading an OLTP, HA, or DR environment.SAP ASE Always-On HADR option Dobler Consulting has performed extensive evaluation and testing on the SAP Always-On HADR feature. SAP ASE Always-On HADR Option Dobler Consulting has performed extensive evaluation and testing on (more…)
Tampa Bay SQL User Group

Event – Planning and Executing a Successful SQL Server Database Migration

By | Blog, Events | No Comments
Hillsborough SQL User Group Meeting – 4/27/2017 Please join us at a new location for the Hillsborough SQL User Group on Thursday, April 27th.  Dobler Consulting will be hosting our group at the Corporate Center I – Conference room (Suite 122) located at the West Shore entrance to the International mall.   The address is: 2202 North Westshore Boulevard Suite 122 Tampa, FL 33607 Parking is available at the west entrance (airport side).  Please follow the Visitor parking signs past the garage and around the fountain. Featured Presentation: Planning and Executing a Successful SQL Server Database Migration Carlos Colon, DBA Manager Dobler Consulting Migrating an existing database to SQL Server requires much more than just moving the schema and data. They key to a successful database migration effort includes designing the target system, identifying all components from the existing system that will need to be migrated, and allowing adequate time for changes and testing. In this session we will discuss all the different database components and configuration items that will need to be considered during the migration effort, how to utilize the SQL Server Migration Assistant as a planning and implementation tool, what components cannot be migrated (and what can be done (more…)