Corporate information is a critical differentiator for organizations and their customers. Financial intelligence, personally identifiable information (PII), trade secrets and other proprietary information are common forms of data stored in databases. In order to protect this information from internal and external misuse or attack, businesses must implement security measures as close to the data as […]
In our last post, we shared the 4 most important areas of database security and discussed how to safeguard your Oracle environment with best practices for Authentication and Access Controls. In this post, we continue with a breakdown of Oracle database security best practices for Secure Oracle Configuration and Database Auditing. Secure Oracle Configuration Secure Listener Configuration Listener authentication should be local OS user. Implement […]
I’ll be the first one to point out that there is no exact science when it comes to conducting an interview. There are many methods, formats, and schools of thought for how recruiters can most effectively select quality candidates to fill open opportunities. The Plight of the Non-Technical Technical Recruiter Understanding a candidate’s work history, determining […]
The purpose of this post is to provide a step-by-step guide to the migration of OBIEE 11g to OBIEE 12c. The method outlined in this documentation is “Out-of-place”: were a new OBIEE 12c installation is performed followed by a migration of relevant files to the new installation using the BI Migration Tool. This new tool generates […]
There is no question that running a successful IT managed services business requires a technically competent team with the ability to quickly troubleshoot issues in crisis situations. But having worked in the high tech industry for over 20 years, I have learned that effective communication and other “soft skills” have a bigger impact on building […]
Have you lost or deleted a control file from an Oracle database? We’re here to help! Follow the steps below to recreate the control file. 1. If you try to take the backup of control file using the below command, when the control files are deleted you will get the following error. Instead, get the […]
One of the biggest selling points of Oracle’s engineered system Exadata is its storage offloading capability. Storage offloading allows data to be instantly filtered when it is read from storage, reducing the amount of data that is sent and processed by the database. One of the filter operations storage offloading performs is join filtering via […]
Now that you have a good design (see posts on documentation and data model), it is time to focus on the performance of the data warehouse from both the loading of the data warehouse from the source systems via ETL to the running of the reports and presentation of analytics to the end user. Below is a checklist […]
In our last post here we talked about documentation best practices for data warehousing. In this post we’re going to focus on data modeling and the key information that you need to know. Data ModelThe data model is where all of the action takes place. Now that your documentation and naming conventions are defined and you have formally established […]
One of the most frequently asked questions when starting a Data Warehousing initiative is: “What best practices should I be following?” In this series of posts, we will outline our recommendations to follow when building a data warehouse – starting with data warehousing documentation. Data Warehousing Best Practice: Documentation A successful data warehouse implementation boils down to […]