Replicating MySQL to Snowflake with Kafka and Debezium—Part Two: Data Ingestion

Here we go again Hello, and welcome to this second part of my “Replicating MySQL to Snowflake” series. If you landed here from a web search and missed part one, you can take a look here: part one. What’s up?…

Read More >

Save Costs by Consolidating SQL Server On-Prem or in the Cloud

There’s a lot of buzz around consolidation nowadays, as well as some fear of change. You may want to consolidate your SQL Server environments to save on maintenance and license costs, and also potentially on hardware and the size of…

Read More >

Global Analytics with Azure Cosmos Db and Synapse Analytics – SQL On The Edge Episode 21

A few months ago, Microsoft revealed that they were looking into adding a capability of querying Cosmos Db data through Spark and this immediately got me thinking into the new scenarios this would enable. The most ambitious is the capability…

Read More >

Tips that Help Alleviate Pressures on DataOps

Data is hard. Its always been hard, and it’s not getting easier. We always have more of it, there are more sources to integrate, it changes all the time, the quality is questionable, and the business wants it all right…

Read More >

Our Commitment to You During COVID-19

In light of the continued spread of Coronavirus (COVID-19) globally, we want to let our clients know how Pythian is prepared to continue providing the high standard of service you’ve come to expect. Our leadership team has developed an action…

Read More >

The top 5 reasons you need a data governance strategy

The concept of good governance is key to any high functioning society and economy. It helps establish and maintain trust between constituents and their representatives, along with setting the stage for people and organizations to operate within a well-defined framework…

Read More >

Increase your data visualization/reporting velocity and performance with proper semantic layers

We have all seen it before.  You finally get access to new data sources and want to extract insight from that data. You open your favorite reporting or data visualization tool, connect and start updating the tool’s semantic layer. The…

Read More >

How to choose the best data management option

As your data estate ramps up to a data empire, more and more of your users are vying for––and expecting––better access to this wealth of internal and external information. That’s why finding the right home for your data is so…

Read More >

Big Data on Microsoft Azure – HDInsight

Introduction   The best definition you going to find for data is that data is the new oil in today’s world. Starting from that, we can define a new horizon and a new way of looking at how we treat…

Read More >

Analyzing Open.Canada.Ca datasets with Power BI

My friend Chris Jaja recently posted on LinkedIn about the awesome work his team has been doing with the Open Government Portal at the Treasury Board of Canada Secretariat. This is a great initiative and it gave me another excuse…

Read More >