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

Usability Comparison White Paper: Informatica vs. Ab initio

By | White Papers | No Comments

This report is an evaluation of two leading Extract, Transform and Load (ETL) tools, Informatica and Ab initio. In spite of long history of data ware housing, business intelligence and data integration industry, it is not an easy to decide which ETL tool is best suited for the organization needs as both Ab initio and Informatica offers a complete ETL solution and both are leaders in the Market.
The purpose of this usability study is to evaluate usability of each solution with respect to various criteria like cost, modularity to support seamless integration with other applications/tools, analytical reporting performance needs, volume and variety of data, loading performance, scalability, ease of use, self-sufficiency, simplicity, compatibility etc. If cost is not a concern Ab initio can be preferred for performance, processing of high volume of data and easy to develop perspective. Informatica provides a broad range of Data Integration products like Informatica PowerCenter, Informatica Data Integrator Hub, Informatica Cloud etc. and hence it boasts of a broader data integration capability. Specific offerings, future scope, ongoing enhancements, data integration capabilities, hardware and operating system requirements, architectural differences, maturity in various market segments etc. are detailed for both solutions.

Download the White Paper for FREE!!

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

Dobler Consulting Announces the Formation of our Board of Advisors

By | Company News | No Comments
The team at Dobler Consulting would like to welcome Charles Dall Acqua, Vincent Addonisio, and Doug Pace as our strategic advisors. “Each advisor brings their own unique knowledge and experience and will be a strong sounding board to help the company meet our growth expectations,” says Peter Dobler, CEO and Founder of Dobler Consulting. Read the Advisory Board Press Release here. Learn more about our Advisory Board here. Dobler Consulting Announces the Formation of our Board of Advisors was last modified: April 17th, 2017 by Peter Dobler (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…)
XpressInsight at HiMSS17

XpressInsight to launch at HiMMS17

By | Company News, Press Releases | No Comments
Dobler Consulting is proud to announce that XpressInsightTM will launch at the HiMSS 2017 Conference in Orlando starting February 19, 2017. XpressInsight is our new FaaS – Framework as a Service – solution for organizations who want to rapidly build a data warehouse and business intelligence solution at a lower cost. We’re planning to provide a lot more information about XpressInsight in the coming weeks and months. You can read the Press Release here or visit our new XpressInsight page to learn more. If you have any questions or would like to learn more about XpressInsight, contact us and one of our representatives will reach out to you promptly. XpressInsight to launch at HiMMS17 was last modified: February 15th, 2017 by Peter Dobler (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

CIO of the Year Partners

Dobler Consulting Congratulates the Winners of the Tampa Bay Business Journal 2016 CIO of the Year Awards

By | Blog | No Comments
Last week, Dobler Consulting was proud to join the Tampa Bay Business Journal, CDW and Tampa-based IT services company Cologix, in celebrating the exceptional leadership, innovative spirit and technical excellence of nine local IT professionals at the 2016 CIO of the Year Awards. These outstanding individuals were recognized at a formal luncheon hosted at the Straz Center for the Performing Arts in beautiful Downtown Tampa.   Here are the Tampa Bay Business Journal CIO of the Year Winners: Government – Todd Bayley, Pasco County Government Healthcare – Timothy Thompson, BayCare Health System Non-Profit – Chad Lewis, Tampa Preparatory School Private-Large – Scott Cashette, Albertelli Law Private-Medium – Michael Geis, myMatrixx Public – Kimberly Anstett, The Nielsen Co. Emerging Leader – Stephanie Davis, Cox Target Media/Valpak   Additionally, awards were given to companies who deployed IT solutions in innovative ways to deliver exemplary results: Best Big Data & Analytic Project – Catalina Marketing Innovative Technology Project – Triad Retail Media   All of us here at Dobler would like to express our heartfelt congratulations to the winners. Additionally, we’d like to recognize all the award nominees whose technical skill and leadership exemplify the highest standards and qualities one would expect of (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