Reducing Application Errors with Application Continuity

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

5 Ways MS SQL Server Enhances Data Integrity

By |
We’ve entered a time in which high quality data is at the heart of operating a successful organization. For many companies these days data IS the business. For others, data is a driver. In both scenarios its critical to maximize your data’s efficacy, and this means being sure you can trust that data. I’m talking about data integrity. It’s essential to be able to trust your data, and that means using a database you can trust that is actively working toward ensuring your data.  Microsoft SQL is a longstanding leader in the game. Their database offers top of the line stability and data integrity. If you are concerned about ensuring your data integrity this database might just be right for you. Why Microsoft SQL Server? - Microsoft SQL Server 2019 features upgrades that will give your organization greater access to large amounts of valuable data quickly. Once it’s released, querying multiple sources of data, both structured and unstructured, will be simpler and more secure than ever. MS SQL preview CTP 2.0 is now available in preparation for the upcoming official release. If you’re interested in experiencing some of the new features beforehand, consider downloading it soon. In the meantime, here (more…)
SAP ASE Always-On

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

By | | 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…)
Database Staffing

How to Hire the Right DBA, Remote or Onsite

By | | No Comments
In this post, let’s take a closer look at how to hire the best database administrator for your company. Establish and Share Your Expectations For the benefit of your company and your potential candidates, clearly define the DBA’s role and your expectations in a thoughtful, detailed job description. Provide a thorough, specific list of daily and periodic tasks the DBA will perform. Clarify whether the DBA will be providing production support, development support, or support for a hybrid of the two, wherein several third party applications are involved. Production vs. Non-Production DBAs The prime objective of a production database administrator is to keep your system running with as little disruption as possible. A DBA in this scenario, would rather keep today’s business processes running before taking radical actions to resolve an issue, this is a case by case decision and needs careful consideration. A non-production DBA is more likely to approach things differently, using trial and error and being more cavalier about when to perform system reboots, checks and maintenance. DBAs should instinctively seek to isolate the problem, minimize its impact on workflow, and keep the production system running. A key trait to actively seek in a DBA is the (more…)

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

By | | 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

Free Webinar: Database Managed Services - 30 Minutes Can Save You a Whole Lot More

By | | No Comments

Join us for the "Database Managed Services - 30 Minutes Can Save You a Whole Lot More" Webinar,

Thursday, April 9th, 1pm EST

For the past couple of years cloud computing and hosted managed services are dominating and reshaping the IT landscape. There is no slowing down in sight. Actually the pace how companies are moving their operations into the cloud is accelerating. Read More