Event – Planning and Executing a Successful SQL Server Database Migration

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

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

Avoid DBA Burnout: 5 Steps for Management

By | Blog | No Comments
As the importance of database administrators – DBAs – continue to grow, along with a strong economy that offers an abundance of DBA job openings, many companies are concerned about the threat of DBA turnover. Your DBA is responsible for the performance, integrity, and most importantly, the security of your database every day, including nights, weekends, and holidays. Any down time, and your company can suffer lost revenue, or even worse, a significant data breach. The nature of this work lends itself to burnout because it is a daily, ongoing challenge and seemingly never complete. With these constant stresses, many DBAs often feel overlooked and as though they perform a thankless job. Some fear they’re only noticed when the inevitable hiccups in database systems occur. There is no shortage of job opportunities for talented DBAs, and there are only so many to go around. More and more companies are making it a priority to keep their DBAs happy to avoid burnout and thereby minimizing the chance they will proactively seek out a new opportunity. Following are some practical ways to keep your DBA engaged at your company to reduce the risk of turnover. 5 Steps to Prevent Burning Out Your (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

Dobler Consulting Announces Sponsorship of Tampa Bay Business Journal 2016 CIO of the Year Awards

By | Press Releases | No Comments

Local Database Services Company Supports Tampa Bay’s IT Community by Sponsoring the 2016 CIO of the Year Awards and Luncheon

 

Tampa, FL (August 19, 2016) – Dobler Consulting, a Tampa-based information technology and database services company offering a wide spectrum of world-class services, is excited to announce that it will be a sponsor of the Tampa Bay Business Journal (TBBJ) 2016 CIO of the Year Awards. Created to recognize leadership and technical excellence in the information technology field, the TBBJ CIO of the Year Awards will be presented at a luncheon on August 25, 2016, at the Straz Center for the Performing Arts in Downtown Tampa.

Read 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

Sybase Cluster

Remote Database Service: Empowerment For Your DBA

By | Database Technology Trends | No Comments

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

Database Consulting Services 1

The Top Five Reasons to Have a Database Managed Services Contract

By | Database Technology Trends | No Comments
More and more businesses are looking at the advantages of a database managed services contract. It makes good business sense, it makes good technical sense, it makes good administrative sense. Here are five reasons to consider. Round the Clock Availability. Is your database administrator available 24 hours a day, 365 days a year? What if you have a data emergency when he or she is on vacation? With a database managed services contract, your database administrator is there regardless of business fluctuations, holidays, or time of day. The Global Talent Shortage. Your database needs to be under the care of staff with responsibility for capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, backup, and data recovery. Can your organization afford a team including a specialist in each of those ten areas? At Dobler Consulting, we cover our clients for all those specialties. Cost. How much are you paying in salaries and other costs of employment for your database administrator(s)? Much more than you would pay on a yearly contract, believe me. Another consideration: What is the cost of downtime? Measure it in lost revenue, regulatory fines, and expenditures on remediation. Under a database managed services contract, you (more…)