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 believe 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…)
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…)
Case Study: Creating a high-performance Sybase environment rivaling SAP HANA

Case Study – Get SAP HANA Performance Out of Your SYBASE Database for 1/10th the Cost

By | Blog, Case Studies | No Comments
As Sybase continues to get more difficult to justify, many organizations are feeling the pressure to upgrade to SAP HANA, rewrite their applications and/or migrate to a different database platform like SQL Server or Oracle. What if you could get a few extra years out of your current Sybase installation? What if you could have a high-performance Sybase environment that can match the speed of HANA? Would you be interested in learning how? A Sybase Environment that Rivals SAP HANA is Born Click to read our Case Study Overview Element Fleet Management is the world’s largest fleet management services company. After acquiring GE Fleet, they anticipated an exponential increase in data and needed to update Sybase to handle significant increases in demand and usage. They challenged Dobler Consulting to architect and validate a solution so their Sybase could handle what they were expecting with the addition of GE Fleet. We were up to the challenge!   “Modernizing the existing traditional server/storage configuration was not an option. The solution was to build it on Intel’s NVMe™ based NUMA platform.” Download our our Case Study Overview where we share the story about migrating Elements existing servers to Intel’s NVMe based NUMA platform. When it was all said and done, Dobler (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…)

Dobler Consulting is Pleased to Announce the Formation of Its Board of Advisors

By | Press Releases | No Comments

Tampa, FL (PRWEB) April 11, 2017

Dobler Consulting, LLC. (doblerconsulting.com) is pleased to announce the formation of its Board of Advisors.

Founded in 2008, Dobler Consulting empowers businesses to get the most from their databases with expertise in SAP, Sybase, Microsoft and Oracle.

Read More

SQL Server MySQL Sybase SAP SharePoint MongoDB Oracle Cassandra

Remote Database Support

By | Blog, Oracle, Preserved Content Pages, SAP HANA, SAP Sybase, SQL Server, Sybase | No Comments
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…)

SAP Sybase Replication Server 15.6 | Real Time Loading into SAP Sybase IQ

By | White Papers | No Comments

SAP Sybase has developed a new, innovative and dynamic staging technology, allowing full use of the native, high-speed data load mechanism SAP Sybase IQ offers . . . Real Time Loading (RTL).

RTL addresses the need to have another system prepare the data for load by taking real time data movement from the source database, and applying staging technology to the data transfer in the background.

Up until now, the only option for loading data from an Online Transaction Processing (OLTP) database . . . airline reservation systems, financial transactions, etc., into a SAP Sybase IQ data warehouse was a so-called staging process. Staging means that the OLTP is isolated from the data warehouse loading process to ensure data integrity, due to the rapidly changing data content in the OLTP database systems.

Direct replication into SAP Sybase IQ was limited to low data movement environments. The reason lies in the fundamental differences on how SAP Sybase IQ processes data, and data movement strategies SAP Sybase Replication Server applies.

SAP Sybase IQ is a column vector database. Retrieving a single row requires assembling the row from each column component. This process makes row by row processing ineffective, and the so- called “trickle feed” loading of SAP Sybase IQ nearly impossible. The advantage of a column vector database is in the unmatched speed for complex data retrieval operations and data aggregation on huge data sets.

Download the White Paper for FREE!!

Read More

SAP Showcase

By | | No Comments
SAP Showcase Whatever Your Needs, Dobler Consulting Is Ready to Be Your Database Partner for Success SAP Adaptive Server Enterprise Drive faster, more reliable data processing – for less – with SAP Adaptive Server Enterprise (SAP ASE). This affordable relational database management system (RDBMS) is designed for high-performance transaction-based applications involving massive volumes of data – and thousands of concurrent users. SAP IQ Get simpler, more affordable big data analytics and warehousing with SAP IQ. Tap into big data at the speed of business – with SAP IQ. This highly optimized RDBMS is now faster and more efficient for extreme-scale data warehousing and big data analytics. SAP HANA Run your business in real time. Analyze Big Data at the speed of thought and drive rapid innovation – with our market-leading in-memory computing platform, SAP HANA. It’s the relational database management system reimagined – for both Big Data analytics and transactional processing. The solution brings speed, scalability, and data management to a whole new level. With and the SAP HANA in-memory computing platform, we can help you dramatically accelerate your analytics, business processes, and sentiment data processing. SAP BusinessObjects BI, Edge edition Gain the insight you need to seize opportunities – (more…)
IQ Database Services

Three Top Database Strategies

By | Database Technology Trends, Oracle, SAP HANA, SAP Sybase, SQL Server, Sybase | No Comments

Choosing a database is one of the most critical decisions your business will ever make. It goes without saying that the right database can foster growth, while the wrong one can limit it. And it is a decision that is not easily reversible. Read More

%d bloggers like this: