Troubleshooting a failure when upgrading to Oracle 18c

WhenI was upgrading Grid to 18c, the final step was to run gridSetup.sh -executeConfigTools, which failed. Unfortunately, the error provided was not very descriptive or useful. In this post, I will demonstrate how I went about troubleshooting the failure. To…

Read More >

Running new Oracle DBSAT version 2.1.0 against Autonomous Database

Recently Oracle released the newest version of the “Database Security Assessment Tool” (DBSAT 2.1.0). This version is certified to run against Oracle Cloud DBCS (PaaS) and Autonomous Databases. Also, the Discoverer option can now find sensitive and personal data in…

Read More >

How to Restore SSISDB to another Server and Migrate the SSIS Catalog

It is easy to get this one wrong. SSISDB is just a database, after all, and I’ve seen a number of instances where it was restored to another server and a number of errors/issues crop up. After all, SSISDB is…

Read More >

Reduce costs by adding a data lake to your cloud data warehouse

By Lynda Partner, VP Analytics as a Service and Danil Zburivsky, Director of Engineering When it comes to data warehouse modernization, we’re big fans of moving to the cloud.  The cloud brings unprecedented flexibility that allows you to easily accommodate…

Read More >

How to solve an SSIS Deployment Error

Problem: You are deploying a SQL Server Integration Services Package to the SSIS Catalog and it keeps on failing with the following error: The error seems daunting but the main information to take away is: The server may be running…

Read More >

Top big data analytics trends hold true well into 2019

The overall importance of data and information within organizations has continued to grow. We’ve also seen the continued rise of megatrends like IoT, big data – even too much data – and of course, machine learning. That’s along with the…

Read More >

Save Time With This Quick OCI CLI installation

This is more of a personal reminder than anything else, but hopefully it helps save some time for others trying to install the OCI CLI on their local Linux machines. The idea is to have a very basic set of…

Read More >

Anthos Is The Future of Cloud Transformation

This blog post is co -authored by Alex Zadorozhniy – DevOps Technical Director and Bill Fraser – Principal Consultant in Customer Service Delivery at Pythian. On Tuesday, Google announced the general availability of Anthos, a re-branding of its Cloud Services Platform,…

Read More >

Introduction to Azure Database Migration Service – SQL On The Edge Episode 19

Azure has a rich set of offerings in terms of database platform services. We have the full family of SQL Server-based databases (single, pool, managed instance, data warehouse), open source first-party Database-as-a-Service for MySQL, MariaDb and PostgreSQL and the NoSQL…

Read More >

How to Configure X11 for Vagrant Box

“Good artists copy, great artists steal” – Pablo Picasso I am currently using Vagrant boxes from Mikael Sandström (oravirt) and unfortunately, it did not have X11 configured. Typically, using CLI is better for automation; however, there may come a time…

Read More >
Page 1 of 34012345...10...Last Page »