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…)

Dobler Consulting Achieves A Silver Microsoft Partner Certification To Compliment Its Gold

By | Press Releases
Data Analytics + Data Platform Certifications Creates Synergistic Value For Microsoft Clients   Tampa Bay April 23rd, 2018:  Over the past 6 months, Dobler Consulting has achieved what only 5% of all Microsoft’s Service Partners ever achieve – Gold and Silver Certification. Silver Certification for Data Analytics means that Dobler Consulting is now a premier specialist in helping their clients turn data into actionable insights by using business intelligence, big data, and advanced analytics best practices. This vertically compliments Dobler’s Gold Certification for Data Platform achieved two years ago. This certifies skills competency and security assurances for work on big data SQL databases in on-site and hybrid environments. “Our certified vertical data competency will further enable our clients to more quickly innovate and implement new data-driven insights. This is a very exciting time to be in our business as the barriers between the company and the consumer begin to blur and merge.” According To Peter Dobler, CEO of Dobler Consulting. “Agile data infrastructure, combined with advanced analytics and creativity are making this epic transformation possible.” The convergence of data infrastructure to data solutions is now an exponentially accelerating trend. IDC reports that growth of the Big Data and Analytics will (more…)

Dobler Consulting Celebrates Ten Year Milestone as a Managed Solutions Provider

By | Press Releases
  Remote Database Administration An Idea Whose Time Has Come…   Tampa Bay – February 22nd, 2018: In 2008 Peter Dobler, CEO and Founder of Dobler Consulting had an idea. He saw that database volumes were growing exponentially, that they were increasingly less secure and the talent pool of skilled Database Administrators (DBAs) was shrinking. His entrepreneurial idea was to attract the most talented DBA’s, give them the very best tools, training and processes; then remotely service large corporate databases more scalably and securely as a managed solution. “In 2008 the concept of Remote Database Administration was novel thinking to many, but not all, corporate CIOs,” said Dobler “I am forever grateful to the early adopters who saw that data growth, security and talent could either be an existential threat or a competitive opportunity for their enterprises.” The implications of exponential data growth are alarming, the research firms IDC confirms that from 2013 – 2020 data will grow from 4.4 trillion gigabytes to 44 trillion – a 10X factor. The Bureau of Labor Statistics projects an 11% increase in the need for DBAs. And the Ponemon Institute estimates the average data breach cost US companies $3.5 million in 2017, with a 27% (more…)
sybase recovery services

In-Memory Databases vs Intel NVMe NUMA

By | Blog, Database Technology Trends, SAP HANA, Sybase | No Comments
For the past few years, the hot topic for database vendors was the in-memory database. The general belief was and maybe still is, that server memory is getting cheaper and density will continuously improve. For the most part, this has been the case, maybe not as extreme as predicted. However, the data storage needs for databases increased at a much faster pace during the same time, which created another problem. Going beyond 1TB of memory in a single server will quickly become very expensive. A 1TB database used to be called very large. This attribute is now applied to the 5-10 TB databases servers. In-memory databases are needed where read and write performance are equally important. Traditional databases improve read performance by caching data in memory, but there is no way to improve write performance. To be ACID (Atomic, Consistent, Isolated and Durable) compliant, data must be written to persistent storage. An in-memory database achieves this by writing every transaction in parallel to a high-performance storage. In many cases this is a flash drive on the PCI bus or a SSD drive. But every write action must be stored away from Memory (RAM) to be ACID compliant. There are many (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 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 (more…)

Protecting Your Database from Ransomware like WannaCry

By | Blog | No Comments
You may have heard about the recent WannaCry cyberattack that infected hundreds of thousands of computers worldwide. The ransomware holds a computer hostage until the user pays some amount of money (ransom) to the hacker or until a patch is made and installed. Why did it spread so quickly and how can you prepare for the next one, especially if you are a DBA? It’s not a matter of if, it’s a matter of when. Why were the attacks so effective? When this particular ransomware emerged on May 12th 2017, it had used an exploit on Windows systems that had been addressed by a critical patch two months earlier in March 2017. So, if end users kept up to date with receiving the latest critical security patches as they became available, they would have avoided being infected. Unfortunately, many businesses were not adequately prepared for an attack like this because maintain updates and they did not have the right security processes in place. It’s critical that companies are proactive in the measures they take to mitigate the risks involved with today’s cyber threats or they will become vulnerable. Lack of preparedness is one of the biggest factors why this cyber (more…)
SQL Server MySQL Sybase SAP SharePoint MongoDB Oracle Cassandra

Remote Database Support | Sybase | SQL Server | Oracle

By | Blog, Oracle, Preserved Content Pages, SAP HANA, SAP Sybase, SQL Server, Sybase | One Comment
Get Around the Clock Database Support at an Affordable Price. Traditional remote database support services offer services based on your install base, if you need it or not. We offer a new approach of database managed services that goes beyond the databases and covers the entire user experience of any application. Remote DBA Support Plans and Pricing   We Support These Systems SAP Sybase ASE 16 SAP Sybase IQ SAP Sybase Replication Server SAP Sybase PowerDesigner SAP Sybase PowerBuilder SQL Anywhere SAP HANA SAP BusinessObjects Microsoft SQL Server 2016 Microsoft SharePoint Oracle Database 12c Golden Gate Oracle RAC Oracle Enterprise Manager MySQL Times Ten In-Memory Database Discover the Difference Managed Oracle Database Services Can Have on Your Business The basic concept of a remote database support is to lower the cost of database administration. Traditionally, remote database support was offered to large enterprise corporations with entire teams of databases. The goal was to do the same at a lower cost. This is just another form of outsourcing.   The Right Remote Database Support Service Model For You Our remote database support approach is one of the most flexible in the business. It is geared towards small and medium businesses that have a one or more applications (more…)
Database Maintenance

3 Risks due to Lack of Routine Database Maintenance

By | Blog | No Comments
Relationships with databases are surprisingly similar to those between people. If we don’t regularly dedicate time and resources to maintaining and nurturing them, they may not be there when we need them the most. Since it has become increasingly clear to industry executives, C-suites, and other thought leaders that data is the hottest commodity, protecting yours should be a top concern. There is no reason to risk losing your entire database, which could have catastrophic consequences. Let’s examine a few of the risks of failing to perform regular database maintenance. False Conclusions About Productivity You might have one database or you might have several. In either case, all data is organized in structures sharing one trait: associated indexes that allow data to be located efficiently. Database indexes need constant updates and adjustments. Without regular maintenance, indexes become fractured, making data retrieval cumbersome and time-consuming. From the outside, it could seem that you need to add staff to your team to complete tasks on time while the underlying problem is a system running slowly due to unmaintained indexes. False conclusions about productivity levels can have devastating financial impacts. Security Breaches Database security is simple common sense, but the associated risks with (more…)