Our Blog

The Dobler Consulting Blog

A Wealth of Information from the vault of Dobler Consulting

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

Sybase ASE SBE Upgrade Path

By | Blog, Database Technology Trends, SAP ASE, SAP Sybase, Sybase
SBE is the entry level server from SAP comparable to the standard editions of Oracle or Microsoft SQL Server. 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 SBE server a few years ago with its new Edge Edition server. This is actually a fully functional Enterprise server only limited to a max of 8 cores and it runs on virtual servers. You could just go ahead and purchase a license to the new Edge Edition to overcome the limitations, but what does this mean if you already invested into the SBE server? Good News SAP will now allow legacy 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 maintenance paid that will be applied to any new maintenance (more…)

Peter Dobler of Dobler Consulting to Take Over Role as President of TBTLA

By | Company News, General Announcements
The start of 2018 is accompanied by exciting news for Peter Dobler, Founder & of Dobler Consulting. With Dobler Consulting listed as one of the Top 50 Fastest Growing Companies by the Tampa Bay Business Journal and a Finalist for the Small Business of the Year awards, it comes as no surprise that Peter Dobler has been appointed to take on the role as the next President of the TBTLA.   The TBTLA, or Tampa Bay Technology Leadership Association, is a local non-profit organization whose membership is limited to current and former technology executives. Its two-fold mission is to apply the collective experience of the membership to real-world technology problems, and to mentor students – and other professionals – who are anticipating careers in [1]. The most important way the TBTLA achieves this goal is through their successful GETSMART program. Established in 2001, the TBTLA is one of the many reasons why Tampa Bay is becoming a booming technology hub for business of all sizes.   The TBTLA partnered with the University of Tampa’s Information & Technology Management department to create GETSMART. GETSMART, short for Getting Everyone to Study Math and Related Technologies, is an educational and mentoring (more…)

Raju Chidambaram Wins the 2017 Indo-US Business Man of the Year!

By | Company News, General Announcements, What's New
Raju Chidambaram – Indo-US Chamber of Commerce’s Business Man of the Year Raju Chidambaram, the Managing Partner and CTO at Dobler Consulting, LLC was just named the Indo-US Chamber of Commerce’s Business Man of the Year. Raju Co-Founded Dobler Consulting in 2008 with his long-term friend Peter Dobler. The company has since expanded and is now comprised of 50 employees that work to provide turnkey database solutions for many fortune 500 companies specialized in , Health Care, Manufacturing, Media and Services industry throughout the U.S. and Canada. Annually, during the Banyan Ball, its signature event, the Indo-US Chamber of Commerce announces its Business Man of the Year. This Year, Raju was named 2017 Indo-US Business Man of the Year. After 25 years of extensive experience in the database and technologies, Raju has worked for Fortune 500 companies such as AT&T, Wells Fargo, Micron and Nielsen Media Research. Raju’s expertise ranges from designing, developing and implementing complex, heavy volume Database Solutions. Raju received his Masters in Computer Science and a certified Project Management Professional (PMP). This year, Dobler Consulting has received much recognition such as the Tampa Bay Business Journal’s FAST 50, a nominee for Small business of the year, as well as (more…)
Data Migration Support

Invisible Columns in Oracle 12c

By | Oracle Tips, Technology Tips & Tricks
Invisible column is a new feature in Oracle 12c.  Invisible columns provide a convenient way to change a table’s structure without having to edit the existing applications using that table.   Invisible columns can be created at the time of table creation using CREATE TABLE command                                 SQL> create table inviscol_test                                 2  (compno number,                                 3  compname varchar(20),                                 4  compcode varchar(10) invisible);                                 Table created.   existing visible columns can be modified to invisible using ALTER TABLE command                                 SQL> alter table inviscol_test modify (compname invisible);                                 Table altered.   How does it work?   The insert statement where we don’t specify the column names will fail.                                 SQL> insert into inviscol_test values (101,'ABCD','A101');                                 insert into inviscol_test values (101,'ABCD','A101')                                 *                                 ERROR at line 1:                                 ORA-00913: too many values                                 Explicit column names should be included in the insert statement.                                 SQL>  insert into inviscol_test(compno, compname, compcode) values                                 (101,'ABCD','A101');                                 1 row created.   If invisible columns are not listed in the insert statement they are set to NULL                                 SQL>  insert into inviscol_test values (201);                                 (more…)
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, multiple indexes 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…)

Eltima Port Vitualization Technology

By | White Papers | No Comments
The advanced USB and COM port redirection technology developed by our experienced engineers is compatible with multiple operating systems and works over any distance. Such flexibility lets our customers easily integrate the technology into their own industry-specific software and hardware products.   Download the White Paper: Eltima Port Vitualization Technology   (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 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…)

Get your complimentary database consultation
from Dobler Consulting