Our Blog

The Dobler Blog

A Wealth of Information from the vault of Dobler Consulting

Oracle

Oracle 12c New Feature – Multiple Indexes On The Same Column Or Set of Columns

By | Oracle Tips, Technology Tips & Tricks | No Comments
Starting with Oracle 12c, on same column or same set of columns can be created, as long as only one index is visible, and the indexes are physically different. It is not possible to create two bitmap indexes on the same column or set of columns. Example: Create a table ind_test1 SQL> create table ind_test1(id number, dept  varchar(20), start_dt date); Table created. Insert rows SQL>  insert into ind_test1 values(111, 'TEST', to_date('01/01/2000','mm/dd/yyyy')); 1 row created. SQL>  insert into ind_test1 values(222, 'DEVL',  to_date('10/25/2011','mm/dd/yyyy')); 1 row created. SQL>  insert into ind_test1 values(333, 'TEST',to_date('05/22/1999','mm/dd/yyyy')); 1 row created. Select * from ind_test1 table SQL> select * from ind_test1; ID DEPT                 START_DT ---------- -------------------- --------- 111 TEST                 01-JAN-00 222 DEVL                 25-OCT-11 333 TEST                 22-MAY-99     Create the first index on start_dt column. By default, Oracle creates B-tree index. SQL>  create index idx1_ind_test1 on ind_test1(start_dt); Index created.   Now, create a second invisible index on the same column SQL> create index idx2_ind_test1 on ind_test1(start_dt) invisible; create index idx2_ind_test1 on ind_test1(start_dt) invisible * ERROR at line 1: ORA-01408: such column list already indexed   Index failed because these 2 are the same type of indexes. You can create a bitmap index on the same column. SQL>  (more…)

Greater Tampa Chamber of Commerce: Benchmark Visit – Austin, TX 2017

By | General Announcements | No Comments
A group of over 100 business leaders from  Tampa embarked on a trip to Austin, TX with the Greater Tampa Chamber of Commerce. This annual benchmark visit is one of the highlights of the year. This year’s edition was the 19th benchmark trip. The objective of the trip is to engage with local officials and business leaders to exchange experience and ideas across a wide area of interests. A secondary benefit is, that you spend 3 days in buses, airplanes and events with your fellow trip colleagues in close quarters. I made many new friends in this trip I will cherries for years to come. The events span from a great reception at the 3ten ACL club with an amazing live band to breakfast with the major of Austin, a visit to Austin City Hall (the group shot was taken on the step of city hall), lunch at the angel investor incubator Capital Factory to dinner in small groups in the live music capital of the world. Closed out with lunch at Coopers BBQ where we listen to the young entrepreneurs of Austin, the angel investor network and Rob Balon, who put a very entertaining finish to the trip. The (more…)

Dobler Consulting Recognized by Inc5000 as Top IT Services Company in Tampa Bay

By | Company News, General Announcements, What's New | No Comments
For the first time in its company history, Dobler Consulting was featured in the prestigious Inc5000 listing. The class of 2017 named 79 companies from the Tampa Bay area among the nation’s fastest growing companies. To join the ranks of Tampa Bay’s fastest growing companies on the national stage is a great honor. We know how hard it is to achieve growth and success on an accelerated path. Congratulations to our fellow neighbors and Inc5000 honorees from the Tampa Bay. The Tampa Bay Times published a prominent article and quoted; “Among the 11 IT services firms ranked here, Tampa’s 55 employee Dobler Consulting Services landed at the highest spot at No. 1002 on the Inc.5000 with a growth rate of 432 percent. Peter Dobler founded the business in 2008.” We’ve been working hard to build an organization modeled on providing critical services to companies around the globe who are in need of database management, design, support and migration. As part of our accelerated growth and dedication to supporting any database platform, we added Microsoft Gold Partner (Data) and an Oracle Gold Partner to our list of achievements. Being featured on the Inc5000 list is not just a huge honor, but (more…)

Dobler Consulting Achieves Microsoft Gold-Certified Partner Status

By | Press Releases, SQL Server | No Comments
September 2, 2017, TAMPA, FL— Dobler Consulting (doblerconsulting.com), a leading information technology and database services company, offering a broad spectrum of services to clients ranging from start-ups to Fortune 50 in a variety of industries, announced today that it has achieved Gold-Certified Partner status with Microsoft. The Gold Certified Partner status is the highest level within the Microsoft Certified Partner program. Dobler Consulting has demonstrated knowledge and expertise in multiple areas to achieve Gold Certified Partner status. Microsoft Certified Professionals must pass exams that prove their skills meet our standards. “Dobler Consulting continuously works to find new and innovative ways to improve skill proficiency and client outcomes. Our Microsoft Gold Certified Partner status demonstrates our knowledge of Microsoft database technology through testing and client references. We’ve successfully implemented projects to the complete satisfaction of our clients,” says Peter Dobler, Founder & CEO at Dobler Consulting. “And, we’re excited about the opportunities to engage in more Microsoft-based client engagements as a result of achieving this distinction.” Achieving the Microsoft Gold Partner status ensures our new and existing client base, that the Dobler team is highly qualified to take on the most complex Microsoft challenge.   About Dobler Consulting (more…)

Dobler Consulting, LLC Secures 9th Spot at The Tampa Bay Business Journal’s Fast 50 List

By | Press Releases | No Comments
Tampa, July 26th 2017 – With the rapid growth of businesses in Tampa Bay, The Tampa Bay Business Journal (TBBJ) annually highlights many of the fastest growing companies within the Tampa Bay region. The Tampa Bay Business Journal’s Fast 50 includes privately held companies local businesses are ones in which experience impressive revenue growth over the past three years. An additional criterion includes being a company privately held and locally owned and has to have been in operation since 2013. Also, the business must have maintained annual revenue of at least $1 million in 2014 or $5 million in 2016 with consecutive annual revenue growth from 2014 to 2016. These companies are required to be headquartered in Hernando, Hillsborough, Manatee, Pasco, Pinellas, Polk or Sarasota counties. This year marks the third year in which Dobler Consulting, LLC has been nominated the prestigious honor of being named in Tampa Bay Business Journal’s Fast 50. Dobler Consulting is a database services and information technology company that provides a wide spectrum of world-class solutions to clients in a variety of industries including manufacturing, media services, healthcare, transportation, and financial services. Founded in 2008 by Peter Dobler, Dobler Consulting employs a team of 50 (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 . 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 drive on the PCI bus or a SSD drive. But every write action must be stored away from Memory () to be ACID compliant. There are many (more…)
Oracle Gold Partner

Dobler Consulting Becomes Oracle PartnerNetwork Gold Level Partner

By | Press Releases | No Comments
July 17, 2017 – Dobler Consulting Services LLC, a database services and solution company, today announced that it has achieved Gold Partner status in Oracle PartnerNetwork (OPN). By attaining Gold Level membership, Oracle has recognized Dobler Consulting for its commitment to establish Oracle related knowledge in delivering professional services to its Oracle clients and for uniquely addressing the challenges of joint customers migrating into the Oracle Cloud.   “Thanks to our recent growth, we’ve been able to diversify our services while still maintaining the highest levels of expertise,” said Peter Dobler, CEO and Founder of Dobler Consulting, LLC. “As an Oracle Gold Partner, we have created a new department which is dedicated to Oracle service delivery, focusing on cloud deployment.”   With its Gold status, Dobler Consulting receives the benefit of being able to start developing specializations that will allow them to grow their business, increase their expertise, reach higher levels of customer retention, and create differentiation in the marketplace. Gold members also become eligible to resell all Oracle Technology products and can apply to resell Oracle Applications and Industry Solutions. In addition, they receive access to Oracle account representatives and My Oracle Support updates for all products, discounts on (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 (SSMA)
– Common Problems in Database Migrations

Download the Guide For FREE!!

Read More

SAP ASE Always-On

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

By | SAP ASE | 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 on 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, , 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 , 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 on (more…)
small business of the year

Dobler Consulting is a Finalist for Tampa’s Small Business of the Year Award

By | Company News | No Comments
The Greater Tampa Chamber of Commerce has announced its finalists for the 37th Annual Small Business of the Year Award. Dobler Consulting is honored to be a finalist. The Greater Tampa Chamber of Commerce understands the impact that small businesses have on our community and economy. There will be multiple awards presented. There are three main categories based on the number of employees along with two additional categories recognizing outstanding leaders and startup companies. Judges will evaluate each business on operational management, community involvement, and ethical business practices. We strive to excel in each of these areas to make a difference in our company and community. Being a part of this process is exciting! We look forward to showing the judges what Dobler Consulting stands for and how we feel our company stands out compared to others. The awards ceremony will take place September 8th, 2017 at theStraz Center in Tampa where the winners will receive recognition and their awards. Congratulations to all the finalists: Outstanding Leader Vincent Cassidy, Majesty Title Services, LLC Topher Morrison, Key Person of Influence Kim O’Brien, AccountAbility Staffing 5-20 Employees Bella Prana Yoga and Meditation C&K Architects/Interiors Inc. Loupin Construction Sessums Black Caballero Ficarrotta, PA (more…)

Get your complimentary database consultation
from Dobler Consulting

%d bloggers like this: