Business Insights
Business Insights

Blockchain: 7 Areas of Disruption

December 14, 2017

The blog post Discovering the potential of blockchain for your business, introduced the key concepts of the business blockchain, as explained by leading blockchain expert William Mougayar at Pythian’s 2017 Love Your Data conference. But what are the business implications…

Data as a Data Scientist Recruitment Tool

December 12, 2017

Everyone knows that data scientists are in high demand and recruiting them is very challenging these days, especially if you’re not a huge sexy brand-name company. What are these data scientists looking for in a company and how can you…

Creating engagement in your analytics project – 3 things you can do today

December 11, 2017

We all know the feeling: the new software is finally rolled out after months, or sometimes years, of hard work by your team. Then, instead of the sound of users calling to share how much the new software improved their…

Analytics is no longer a second class citizen

December 11, 2017

Early in my DBA career, when we were architecting systems, OLTP or transnational systems were designed for a much higher degree of availability than any other system. This is because they were typically used to serve a customer or critical…

Five questions to ask when choosing your cloud provider

December 11, 2017

The end of the year is approaching—the perfect time for your business to review your budget for cloud-based projects for the upcoming year. Today’s biggest cloud providers are offering a similar set of basic services at comparable prices. How do…

Advice from analytics pros: “Plan for 1000 sources of data and don’t move it any more than you have to”

December 8, 2017

“Plan for 1000 sources of data” and “Don’t move data any more than you have to.” These were just two of the many interesting best practices shared with a room of IT executives at TDWI’s Orlando analytics leadership summit earlier…

Love Your Data Gift Guide 2017 (for the data lover on your list)

December 7, 2017

Do you have a hard-to-buy-for data professional on your list this holiday season? If you’re shopping for a special data analyst, BI pro or data scientist, it’s not always easy to choose the right gift. So we thought we’d make…

How Artificial Intelligence and Machine Learning are Changing Data Intelligence

December 5, 2017

Flagged as a mega trend for 2017 and beyond, Artificial Intelligence (AI) is a term we often hear, but what is it, really? Gartner’s definition is this: Artificial Intelligence is technology that appears to emulate human performance typically by learning, coming…

The Natural Evolution of Data Warehousing—Where We Are Today

December 4, 2017

It’s a fact that technology is always evolving—rapidly. What’s new and hot today, may be old news and on its way to becoming obsolete tomorrow. Traditional data warehousing is no exception. We have been seeing that the old school data…

How to Migrate from Teradata to Google BigQuery

December 1, 2017

Google BigQuery is a serverless, highly scalable, low-cost enterprise data warehouse that helps data analysts become more productive. It enables extremely fast analytics on a petabyte scale. And its pay-as-you-go model makes it attractive for organizations looking to move away…

How the England and Wales Cricket Board Scored with Big Data

December 1, 2017

The England and Wales Cricket Board governs every aspect of the sport in those two countries, and it holds massive amounts of data generated by professional and amateur players alike. Since its founding in 1997, the ECB has collected information…

Black Friday and Cyber Monday: The Top 7 Tips For Getting Your Database Ready

November 21, 2017

Black Friday has been an American tradition for decades. Today, along with Cyber Monday, Black Friday is a worldwide marketing juggernaut. And retail analysts are expecting the 2017 edition to set new records. The National Retail Federation estimates that 69%…

Datascape Podcast Episode 17: Key Announcements from Microsoft Ignite

November 2, 2017

Today on the show we are going to be discussing the most interesting announcements that came out of the Microsoft Ignite Conference. To help us navigate this part of the Datascape, I have invited Warner Chaves back to the show….

Join Pythian at the Gartner Symposium/ITXpo in Barcelona

October 17, 2017

If you’re planning on attending the Gartner Symposium/ITxpo coming up on November 5-9, 2017 in Barcelona, Spain, make sure to visit Pythian’s booth located in the Emerging Technology Pavilion. Stop by to find out about our Analytics as a Service…

Advice for responding to the WPA2 security flaw

October 16, 2017

By now everyone’s likely heard about the serious vulnerability affecting the Wi-Fi security protocol WPA2 that secures the wireless communications of just about every consumer device out there. The Key Reinstallation Attacks (KRACK) allow an attacker to control the encryption…

Why You Should Consider the Cloud for a Modern Data Warehouse

October 12, 2017

  Your data warehouse modernization strategy can make or break your ability to derive value from traditional data sources (for example, your operations and financial data) as well as emerging data sources such as IoT data from devices and sensors,…

Can you run Hadoop in the cloud? And is it the right choice?

October 12, 2017

As the Director of Big Data and Data Science at Pythian, I often get questions from clients about the many solutions available to them to address their big data needs. Between Hadoop, cloud-based, and hybrid solutions, finding the best option…

Oracle OpenWorld 2017 Bloggers Meetup

September 5, 2017

DON’T PANIC. Yes, we are doing the OOW Bloggers Meetup this year. Yes, it’s the same time. Yes, it’s the same location. Yes, it’s more fun every year. What: Oracle Bloggers Meetup 2017. When: Wed, 04-Oct-2017, 5:30pm. Where: Main Dining…

Taking Your Data and Analytics to the Cloud

August 29, 2017

Live Webinar Taking Your Data and Analytics to the Cloud Thursday, September 28th at 2 p.m. ET REGISTER As the urgency to compete on analytics continues to revolutionize the business world, more and more organizations are moving their data to…

Join Top Data Experts at Pythian’s Love Your Data Conference in London

August 24, 2017

According to Gartner’s CIO 2017 survey, BI and Analytics continue to top IT investments. Are you an IT or BI business leader looking for ways to drive business outcomes with data and analytics?  If so, join Pythian on September 13,…

More Articles >

Technical Track
Technical Track

Log Buffer #533: A Carnival of the Vanities for DBAs

December 15, 2017

This Log Buffer Edition covers Cloud, Oracle, PostgreSQL, and MySQL.

Minimal Twitter to Google Pub/Sub example with Scala

December 13, 2017

Recently I was looking for a simple Twitter to Pub/Sub streaming pipeline and ended up with own implementation in Scala. I tried to make it as compact as possible. So I chose the dispatch and Google Pub/Sub client libraries for…

Top three considerations when documenting a microservice

December 13, 2017

Microservices have changed the way we architect, build, test, deploy, and operate our software. It should be no surprise then that microservices change our approach to software documentation. Following are the top three considerations when documenting a microservice. 1. Make…

Replicating in Google Cloud SQL using Tungsten

December 12, 2017

While investigating alternatives to migrate to Google Cloud SQL, I encountered a lack of support for external masters. However, it’s possible to overcome this limitation by replicating into Google Cloud SQL using Tungsten replicator. Cloud SQL is Google’s database-as-a-service solution,…

Microsoft SQL Server 2017: identity_cache and select into filegroup

December 12, 2017

Microsoft SQL Server 2017: Two Useful New Features This week I discovered two new features in Microsoft SQL Server 2017 that I think will be helpful to both developers and DBAs. These are two small changes, but they solve problems…

Apache Beam pipelines with Scala: Part 3 – Dynamic processing

December 12, 2017

In the third part of the series we will develop a pipeline to transform messages from “data” Pub/Sub using messages from the “control” topic as source code for our data processor. The idea is to utilize Scala toolBox. It’s much…

Apache Beam Pipelines With Scala: Part 2 – Side Input

December 12, 2017

In the second part of this series we will develop a pipeline to transform messages from “data” Pub/Sub topic with the ability to control the process via “control” topic. How to pass effectively non-immutable input into DoFn, is not obvious,…

Apache Beam Pipelines With Scala: Part 1 – Template

December 12, 2017

In this 3-part series I’ll show you how to build and run Apache Beam pipelines using Java API in Scala. In the first part we will develop the simplest streaming pipeline that reads jsons from Google Cloud Pub/Sub, convert them…

Oracle service secrets: more performance with less load-balancing

December 11, 2017

A huge but often overlooked aspect of tuning cluster databases is workload management. That means controlling on which and how many nodes a RAC database should actively work. The default service and most intuitive configuration is to spread the workload…

Log Buffer #532: A Carnival of the Vanities for DBAs

December 8, 2017

This Log Buffer Edition covers Cloud, Oracle, MySQL, and PostgreSQL.

Love Your Data Gift Guide 2017 (for the data lover on your list)

December 7, 2017

Do you have a hard-to-buy-for data professional on your list this holiday season? If you’re shopping for a special data analyst, BI pro or data scientist, it’s not always easy to choose the right gift. So we thought we’d make…

Enter Amazon Aurora Serverless

December 6, 2017

More often than not, database administrators have to fight to get high loads out of their databases. It could be ad hoc queries, urgent reports, overflown jobs, or simply high frequency and volume of queries by the end users. DBAs…

MySQL Crashes on DDL statement: A Lesson on purge threads

December 5, 2017

Recently there have been several issues reported to me about DDL activity causing MySQL crash scenarios. In one case it stemmed from dropping multiple databases, one after the other in rapid succession. But in the case that I was recently…

Oracle database upgrade on RDS AWS and SPM baselines

December 5, 2017

A couple of days ago I saw a question posted online asking about how AWS upgrades an RDS Oracle database and what happens with SPM baselines. To be more precise whether the existing Oracle SPM baselines would survive the upgrade…

The Natural Evolution of Data Warehousing—Where We Are Today

December 4, 2017

It’s a fact that technology is always evolving—rapidly. What’s new and hot today, may be old news and on its way to becoming obsolete tomorrow. Traditional data warehousing is no exception. We have been seeing that the old school data…

Exploring Couchbase Server – Datascape Podcast Episode 19

December 4, 2017

On today’s show we welcome Terry Dhariwal to take us further into our exploration of NoSQL databases and talk about Couchbase Server. Terry started his career as a developer in 2003 after completing a computer science degree. His love of…

How to Migrate from Teradata to Google BigQuery

December 1, 2017

Google BigQuery is a serverless, highly scalable, low-cost enterprise data warehouse that helps data analysts become more productive. It enables extremely fast analytics on a petabyte scale. And its pay-as-you-go model makes it attractive for organizations looking to move away…

Locating Most Current Record using ROW_NUMBER() vs. Index Full Scan (Min/Max)

December 1, 2017

Very often when reading data, we need to locate the most current record for a set of conditions. One typical example is that we read the data to find the most recent order for a particular customer. In this simple…

Log Buffer #531: A Carnival of the Vanities for DBAs

December 1, 2017

This Log Buffer Edition covers Cloud, Oracle, SQL Server and MySQL.

Log Buffer #530: A Carnival of the Vanities for DBAs

November 27, 2017

This Log Buffer Edition covers Cloud, Oracle, SQL Server, and MySQL.

More Articles >

Pythian Life
Pythian Life

My Internship Experience at Pythian

September 28, 2017

I remember nervously walking out of one of King’s Cross St Pancras Station’s numerous exits searching for the 7 Stanley Building. I wandered through the morning rush in the heart of London, and I was overwhelmed, out of place and…

Pythian at All Things Open 2017

September 25, 2017

All Things Open 2017 is coming up fast, and Pythian is proud to be supporting one of the largest open source-focused conferences in the US! All Things Open is a conference in Raleigh, North Carolina on October 23-24, 2017. ATO…

Has “Google-ing it” Gotten Better Over Time?

August 14, 2017

Just Thinking… Have you noticed the subtle shift in how we search for information on the Internet…? In the past when I wanted to find something, I would start a web browser (before Tabs came along) and go to www.google.co.nz….

How to hold a great team meeting with remote employees

July 21, 2017

I want to talk about something that I initially did very poorly when I first became a remote manager in hopes you can learn from my mistakes – Team Meetings. When I started having my first team meetings as a…

My Co-op Experience at Pythian

May 17, 2017

I returned to Pythian for my co-op term this past winter (it’s worth mentioning that previous to this, I had already completed two four month terms as a Software Development Intern at the company). The fact that I came back…

Join CEO Paul Vallée and Top Data Experts at Pythian’s Love Your Data Conference in NYC

May 3, 2017

Every year, leaders from every industry are presented with a buffet of conference opportunities to choose from. The pull to attend the biggest and shiniest is strong as event organizers lure potential attendees with swag bags, explosive branding and the…

PerconaLive Santa Clara 2017 in Review

May 3, 2017

PerconaLive Santa Clara 2017 happened last week and Pythian is pleased to have been able to sponsor the event. I really enjoyed several of the keynotes. In particular was Baron Schwarz’s keynote on Observability and Distributed Monitoring. Booking.com’s Monitoring without…

Pythian Named One of Canada’s Top Employers for the Fourth Consecutive Year

April 25, 2017

Ottawa, ON– April 25, 2017 Pythian, a global IT services company that helps businesses compete by adopting disruptive technologies, announced today that it has been named one of Canada’s Top Small & Medium Employers for the fourth consecutive year, a…

2017 Annual Open Source Database Community Dinner in Santa Clara

April 17, 2017

Once again, Pythian is organizing the traditional Open Source Database Community dinner in Santa Clara! When: Tuesday April 25, 7pm-10pm Where: David’s Restaurant, a short 5-minute walk from the Santa Clara Convention center. Tickets: Register here! Among the attendees will…

Collaborate 17 – Las Vegas, Pythian is Comin’ for Ya!

March 10, 2017

There are endless reasons to attend the upcoming Collaborate 17 conference (April 2 – April 6).  They include, but are not limited to, the following: Three of Oracle’s biggest and most influential users groups are hosting the event (shout out…

Pythian at the PerconaLive 2017 Open Source Database Conference

March 1, 2017

With PerconaLive 2017 coming up in a couple of months, go ahead and get excited! The conference is being held in Santa Clara, California from April 24-28, 2017. While you’re there, be sure to add these Pythian sessions to your…

Five Reasons Businesses Should Consider Pythian in 2017

January 24, 2017

Hilary Smith and Sarah Killoran discuss why businesses should work with Pythian in 2017.

Pythian: More Than Just a Co-op

January 23, 2017

Megan Macphee writes about her co-op experience in the Pythian HR department.

Pythian Opens New European Office in London

January 18, 2017

Pythian is expanding its global footprint in Europe with a new larger office in the tech hub of London and a significant investment in sales and technical resources. Pythian’s revenue from its European region has grown by more than 150%…

2016 Last Minute DBA Holiday Gift Guide

December 16, 2016

Do you have a hard-to-buy-for DBA on your list? Whether you’re a manager looking for something to give your talented people, or someone with a special DBA in your life, we know it’s not always easy to choose the right…

Being a Pythianite

September 26, 2016

  It has been seven months since I started working for Pythian and it doesn’t feel like it at all. The main reason is the full time work from home option that we enjoy here. I couldn’t agree more when my…

Aim for Exceptional: Reflecting on my Employment at Pythian

August 5, 2016

Shawn Melton, SQL Server Database Consultant at Pythian, discusses how his employment at Pythian differs from past jobs, and why.

Embracing Lifelong Learning In The IT Industry

June 20, 2016

Alejandro Cordero, Lead Database Consultant at Pythian, discusses the importance of lifelong learning in the IT industry.

Pythian Sponsors Another Successful Technovation Challenge!

May 30, 2016

Stephanie Caron, Marketing Manager at Pythian and Ottawa Chapter Program Coordinator for Technovation, talks about the conclusion of this year’s event.

What’s Holding You Back From Giving Back?

April 15, 2016

Heidi Hauver, VP of HR at Pythian, reflects on the importance of giving during National Volunteer Week.

More Articles >