Our Blog

The Dobler Consulting Blog

A Wealth of Information from the vault of Dobler Consulting

Dobler Consulting Becomes Member of MSPAlliance

By | Company News, Press Releases
Tampa Bay, FL. March 13th 2018 — Dobler Consulting today announced that it has become a member of the MSPAlliance. MSPAlliance is the oldest Managed Services group and the only Accrediting and Standards based body created specifically for the Managed Services Industry. With over 30,000 corporate members worldwide, the MSPAlliance is a very powerful and influential global network of IT professionals. MSPAlliance works in a collaborative effort with service providers, technology enabling vendors, governmental bodies as well as other industry associations, to further the acceptance of the managed services and cloud industry to the business consumer. MSPAlliance Member companies’ are able to achieve MSP and Cloud Certifications including, SSAE 16 Audits and ultimately achieve certification through the MSPAlliance MSP/Cloud Verify Program™ “We are delighted to have Dobler Consulting as a member of our global association,” said Celia Weaver, MSPAlliance president. “By upholding the MSPAlliance Managed Service Provider’s Code of Ethics, Dobler Consulting will work with MSPAlliance, as well as their industry peers, to help ensure the integrity of the managed services and cloud profession.” “A simple way to understand emerging trends in the technology sector, is to study the membership of the MSPAlliance” suggest Peter Dobler, CEO of Dobler Consulting. (more…)

Dobler Consulting Celebrates Ten Year Milestone as a Managed Solutions Provider

By | Press Releases
  Remote Administration An Idea Whose Time Has Come…   Tampa Bay – February 22nd, 2018: In 2008 Peter Dobler, CEO and Founder of Dobler Consulting had an idea. He saw that volumes were growing exponentially, that they were increasingly less secure and the talent pool of skilled Administrators (DBAs) was shrinking. His entrepreneurial idea was to attract the most talented DBA’s, give them the very best tools, and processes; then remotely service large corporate databases more scalably and securely as a managed solution. “In 2008 the concept of Remote Administration was novel thinking to many, but not all, corporate CIOs,” said Dobler “I am forever grateful to the early adopters who saw that data , security and talent could either be an existential threat or a competitive opportunity for their enterprises.” The implications of exponential data are alarming, the research firms IDC confirms that from 2013 – 2020 data will grow from 4.4 trillion gigabytes to 44 trillion – a 10X factor. The Bureau of Labor Statistics projects an 11% increase in the need for DBAs. And the Ponemon Institute estimates the average data breach cost US companies $3.5 million in 2017, with a 27% (more…)
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…)

Tampa Bay Technology Leadership Association’s New Leader – Peter Dobler

By | Press Releases
Tampa Bay, February 13th, 2018   Longtime entrepreneur, civic leader and technology activist Peter Dobler will assume the leadership of the Tampa Bay Technology Association (TBTLA) as President in 2018. Dobler is the founder and CEO of Dobler Consulting llc, a 10 year old, remote database administration managed solutions firm.   The TBTLA mission is simple and civic – to connect today’s leaders in information technology, with the new emerging IT talent in the region, to make Tampa Bay a hub of 21st century digital innovation. “TBTLA is about the nurturing and mentoring of talent; it is an investment in the long-game.” according to Dobler. “Part of the exciting growth of Tampa Bay as a regional technology cluster is because, almost 20 years ago, IT leaders made this an inter-generational civic commitment.”   TBTLA offers events, social networking opportunities and mentoring to area schools, colleges and businesses, including a direct partnership with the University of Tampa’s Information and Technology Department’s GETSMART (Get Everyone to Study Math And Related Technology) Program. Dobler’s goal is to expand the scope and reach of TBTLA in the coming year through a deeper engagement with the Tampa Bay emerging technology innovation cluster.   Dobler has been (more…)
Sybase

Sybase ASE SBE Upgrade Path

By | Blog, Database Technology Trends, SAP ASE, SAP Sybase, Sybase
Sybase ASE SBE is the entry level ASE 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 ASE SBE server a few years ago with its new ASE Edge Edition server. This is actually a fully functional ASE 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 ASE Edge Edition to overcome the limitations, but what does this mean if you already invested into the ASE SBE server? Good News SAP will now allow legacy Sybase 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 & CEO 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 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 information technology[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 finance, 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 , 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 on same column or same set of columns can be created, as long as only one index is visible, and the are physically different. It is not possible to create two bitmap 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 . 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…)

Get your complimentary database consultation
from Dobler Consulting