Today on the show we are talking to John Laham about the Google Cloud Next Conference which took place earlier this month in San Francisco. John currently works at Pythian as a Cloud Solution Architect focusing primarily on the Google Cloud.
John originally comes from a networking background and made his way to becoming a full stack engineer. From there he shifted into the cloud and has been working with it for seven years.
San Francisco, CA (Google NEXT) – March 7, 2017 – Pythian, a 400-person global IT services company that helps businesses adopt disruptive technologies to better compete, announced today that it has achieved the newly announced Google Cloud Partner Specialization in Data Analytics.
In this blog post I’ll demonstrate a scenario where dropping a potentially ‘unused’ index can have a negative influence on the optimizer’s cardinality estimation. Having columns with logical correlation and skewed data can cause difficulties for the optimizer when calculating cardinality. This post will also address what we can do to help the optimizer with better cardinality estimates.
Visual Studio Code (aka VSCode or just Code) has been around for a few years now. The 1.0 release came out in April of 2016 and from there we have seen feature after feature added with every release. VSCode is a free, cross-platform source code editor that offers you the ability to perform development operations like debugging or running task. It is has become more and more popular with each release and is picking up use in PowerShell development.
Today we are talking to special guest, John Schulz , about the Cassandra Database System. We will explore the basics and compare it to conventional Relational Database Management Systems (RDBMS), include some use cases, best practices and a provide a few helpful tips for you to get started learning Cassandra.
Pythian to showcase cloud-based analytics and data solutions at Google NEXT
Ottawa, ON – March 2, 2017 – Pythian, a 400-person global technology services company that helps businesses adopt disruptive technologies to better compete, announced today that it has achieved its Google Cloud Premier Partner status, and will showcase its cloud-based data and analytics services and solutions at the Google NEXT 2017 conference, in San Francisco (March 8-10).
There are very few of us who aren’t impacted when major cloud service providers experience failures. Either our productivity is affected when cloud-based business tools go down, or we are inconvenienced when consumer services like video or music streaming are interrupted.
In this episode, I am joined by my colleague and Oracle expert, Bjoern Rost, who will help guide us through Oracle licensing, what’s changed, and how it’s going to affect us. We’ll also discuss licensing on prem and in the public cloud.
Parallel execution in Oracle seems to be a topic of myths, mysteries and misunderstandings. In this post I hope to clear up at least one of them by diving into a discussion about parallel DML. Actually, I want to show you two things that can go wrong with it.
My demo setup and case are pretty simple, I just create two copies of dba_objects:
I started hearing the term ‘data lake’ a few years ago but didn’t pay a ton of attention to it. Today, the term’s still around and so is the hype. According to this article on Wikipedia (https://en.wikipedia.org/wiki/Data_lake) the term is poorly defined and has morphed significantly since it was coined by James Dixon.
SQL Server is a conventional RDBMS created in partnership between Microsoft and Sybase in ~1989. Since then, SQL Server has only ever run on the Windows operating system.
Infoworld ranked SQL Server as the second most popular database (along with MySQL). SQL Server is considered by many to be in the top 3 database systems (for popularity), competing head to head with Oracle’s database product.
For much of my career as a DBA, I spent a lot of time working on issues that technology and software are eliminating. Issues like space management, performance management, building new systems and configuring complex availability options like Clustering.
Why is this changing? There are many reasons, but the most prominent are: mature Virtualization technologies, the public cloud, cheaper hardware, and significantly better automation tools.
A little while ago after a question from a customer about supporting Oracle products on the Google Cloud Platform (GCP) I decided to take a look for any updates to the Oracle public cloud support policies. The document can be easily found on the Oracle website. I quickly noticed some significant changes in the new version of the document.
Like many organizations, yours is likely under pressure to reduce costs and resources, while increasing storage capacity and compute power. In response, many are making the leap to the cloud or at least seriously investigating cloud platforms. While the DBA role is still critical in this new world, DBAs need to modernize their skills to keep up as their companies make the move toward the cloud. That’s why we created this list of 5 key skills you will need in the cloud.
There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take backups into AWS S3 is one of the most efficient methods in terms of costs and backup/restore performance.
In this post I will show you how to install, configure and use Oracle Secure Backup to take your Oracle database backups to AWS S3. This method can be used for Oracle database version 9.2 or higher.
In this example, database version is 12c and platform is Linux x86_64.
Organizations today are under pressure to reduce IT costs and resources while increasing storage capacity and compute power. In response, many are making the leap to the cloud or at least seriously investigating cloud platforms as a way to address these needs. They also want to take advantage of the promise that cloud solutions will help them introduce new revenue streams through capabilities like big data analytics, mobile applications or the Internet of Things.
Who here takes the time to adjust default values for SQL Server Configuration after installing it? Unless your company has specific Post-Installation Tasks procedures/document, SQL Server configurations are left as is until an issue comes along. If you are doing your job diligently, there are a few items you’d want to configure after installation not just for security but also for performance.
As an IT Manager you may be thinking of acquiring a data warehouse to develop insights for your business. You are presented with a number of options like installing it in your own data center, using a cloud service or even purchasing a hardware/appliance ready for this purpose. This is a quick guide to help you compare certain options. The article will not describe any specific product.
If you’re anything like me, you’re a lost student trying to carve your path in a world of endless opportunities. Before starting at Pythian I only knew one thing I needed in a career; happiness. Did I ever hit the jackpot!
Storage Spaces Direct (S2D) is a new feature of Windows Server 2016 that takes the ‘software-defined storage’ concept to the next level. The value proposition is that instead of deploying expensive SAN hardware, similar results can be achieved by pooling commodity storage and controlling it with commodity Windows Servers.
I decided to write this blog post after reading some comments on my older posts and several online discussions where people had problems with replicating activity related to tablespaces, and users management for Oracle databases. In particular, people wanted to replicate users and tablespaces creation and some other actions related to their management such as granting privileges and quotas. Let’s have a look at how it can be done using GoldenGate.
Many companies are cutting costs and gaining a major boost in scalability, agility and innovation potential by moving their enterprise applications to the cloud. Amazon Web Services (AWS) has proved to be an especially popular platform because it supports pretty much any use case you might imagine. This flexibility may be why it has more than a million active customers.
I was reminded recently of a project I did during a DevDays week at WebAssign in 2014. The engineering department wanted to move a large dataset into MongoDB, and my DevDays experiment was to demonstrate the Tungsten Replicator’s role in translating data from MySQL to MongoDB.