Behind the Scenes of Database Evolution

Server Data Migration

Multitenant database in Oracle 12c

By | Blog, Oracle Tips, Technology Tips & Tricks
One of the new features of Oracle 12c is multitenant databases. Multiple databases can be plugged in a big container database. Container database (CDB) is the primary database that comprises 0, 1 or many pluggable databases (PDB). This holds the controlfiles, datafiles, undo, tempfiles, redo logs and also the data dictionary for those objects that are owned by the root container. It is also called CDB$ROOT Pluggable Database (PDB) – these are the databases stored within the primary container database. Each PDB is a set of schemas, objects and non-schema objects. PDB is made up of only datafiles and tempfiles to handle its own objects which includes its own data dictionary containing information about only those objects specific to the PDB. PDBs appear to the end users as a non-CDB database. Seed PDB – A default PDB that the system uses as a template to provision other user-created PDBs. It is called PDB$SEED   Advantages of Multitenant database architecture Multitenant architecture reduces the requirement to create multiple instances. It offers the ability to have 252 PDBS per multitenant CDB. This increases hardware utilization and so reduce capital expenses. Upgrade and patching is made very simple. All underlying databases inside it (more…)

Sybase ASE SBE Upgrade Path

By | Blog, Database Technology Trends, SAP ASE, SAP Sybase, Sybase
Sybase ASE SBE is the entry level ASE server from SAP comparable to the standard editions of Oracle or Microsoft . For limited use or internal applications, its limitation of 256 concurrent connections and hard limit to physical CPU chips are not a problem. But the limitations to 2 CPU CPU sockets makes it nearly impossible to find hardware these days or migrating a physical server to a virtual environment. SAP replaced the ASE SBE server a few years ago with its new ASE Edge Edition server. This is actually a fully functional ASE server only limited to a max of 8 cores and it runs on virtual . You could just go ahead and purchase a license to the new ASE Edge Edition to overcome the limitations, but what does this mean if you already invested into the ASE SBE server? Good News SAP will now allow legacy Sybase SBE customers to get conversion credit for existing licenses. That credit can then be used to acquire ASE Edge licenses and execute the new license transaction on SAP paper. You will also get a prorated rebate for any paid that will be applied to any new (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…)
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 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…)
SQL Saturday #527 South Florida 2017

Join Dobler at SQL Saturday on June 10th in Fort Lauderdale

By | Blog, Events, SQL Server | No Comments
Join the team from Dobler Consulting on Saturday, June 10th at SQL Saturday #627 in Fort Lauderdale, . Dobler Consulting is a Gold Sponsor and will be represented by several of our SQL team. We invite all our SQL colleagues to stop by our booth, ask your SQL questions and say hi. Don’t miss our DBA Manager, Carlos Colon’s presentation Practical Uses for SQL Server 2016 Dynamic Data Masking where will explore how to set up Dynamic Data Masking for use in production support and for generating production-like test data For anyone interested in Data Warehousing, we will also be sharing information about XpressInsight, our data warehouse product, certified on SQL Server 2016. You can learn about the day long event in Fort Lauderdale and register, here. Find a local SQL Saturday Training Event near you. (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 | 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 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…)
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…)
Database Staffing

How to Hire the Right DBA, Remote or Onsite

By | Blog | No Comments
In this post, let’s take a closer look at how to hire the best 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 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…)


(813) 322-3240