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

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

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…)
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…)
fastest growing companies in Tampa

Dobler Consulting Ranked 17 on Tampa Bay Business Journal “Fast 50” 2016

By | Press Releases, What's New | No Comments

CEO Peter Dobler Cites Employee Engagement and Client Satisfaction as Keys to the Database Services Company’s Ongoing Success

 

Tampa, FL (July 22, 2016) — Dobler Consulting (doblerconsulting.com), a leading information technology and database services company offering a wide spectrum of services to its clients, recently ranked 17 on the 2016 Tampa Bay Business Journal “Fast 50”—a listing of the 50 fastest-growing, privately held companies in the Tampa Bay area. This is the second such award for Dobler Consulting, who ranked No. 10 on the 2013 Fast 50 list.

Read 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

Sybase Cluster

Remote Database Service: Empowerment For Your DBA

By | Database Technology Trends | One Comment
Consider your database administrator (DBA). Most DBAs spend their workdays on capacity planning, installation, configuration, migration, performance monitoring, security, troubleshooting, backup, and data recovery — after they have resolved all the trouble tickets and answered all the panic-stricken user calls.

Read More

SQL Server 2005 End of Support – To Migrate or Not to Migrate?

By | SQL Server | No Comments

On April 12, 2016, Microsoft will totally stop supporting the SQL Server 2005. This is not a new or unexpected development, as it has been on the “extended support” phase of its lifecycle since early 2011. Microsoft is encouraging existing users of this database to migrate to newer versions within the SQL family or to make the switch to Azure. Read More

%d bloggers like this: