(Connor McDonald) We had an AskTOM question recently about how to calculate the IRR, ie, the Internal Rate of Return.
Community
Types & Subtypes
(Michael McLaughlin) This article teaches you how to use subtypes or subclasses. You can define an object type with or without dependencies. Object types can have two types of dependencies.
Choosing Between Oracle’s Bitmap and Function-based Indexes
(David Fitzjarrell) NULL values can be a performance issue as, absent an index of some sort, searching for them involves a full table scan. For small tables (less than 10,000 rows) this usually isn’t a time sink; however, in enterprise tables (with millions of rows) a full table scan can consume con
Cooking angular.js with Typescript
(Bohdan Stupak) Typescript starts to gain more and more popularity because of static typing offering its benefits.
2018: When VS Code Eclipsed Visual Studio IDE
(David Ramel) I wonder if Microsoft knew what it had on its hands back in 2015 when it created Visual Studio Code, the little code editor that could.
MySQL High Availability On-Premises: A Geographically Distributed Scenario
(Marco Tusa) In this article, we’ll look at an example of an on-premises, geographically distributed MySQL high availability solution.
First steps with Oracle Self Service Integration Cloud
(Lucas Jellema) An important part of enabling optimal use of SaaS applications is integrating various functions in said applications. Events in one application need to have an effect in others.
SQL Server 2017 Step By Step Installation Guide
(Rajendra Gupta) Microsoft SQL Server 2017 has many new features. In this previous tip, we installed a database engine with the SQL Server 2017 installer. In this tip, we will explore installing SQL Server 2017 along with other features such as R services, Python, SSIS, etc.
Services In Angular
(Mohammad Irshad) In this article, we are going to utilize the Angular Services. Service is nothing but the class having certain operations for a specific purpose. We use Services in Angular to share data among the components.
SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array
(Pinal Dave) This was an interesting error which I received while trying to uninstall SQL Server. In this blog, we would learn how to fix error Index was outside the bounds of the array, which might come during uninstallation of SQL Server.