In Part I, we examined the on-premise and cloud upgrade options available for SQL Server 2008 as it reaches EOL. For scenarios where memory management challenges or database operations have proved difficult, Snowflake is also a strong option, which is increasingly the default choice for many data warehouse and data lake offerings. Snowflake has been built from the ground up as a cloud-native data warehouse. The service separates both compute and storage, thereby allowing the two to independently scale. Snowflake can natively load and optimize both structured and semi-structured data and make them available via SQL. With fast, flexible, and easy to work workflows powering simple and advanced functions, users can run a highly scalable database. By natively running on AWS EC2 and S3 instances and offering compatibility with Azure services such as Azure Blob Storage and Compute options (introduced in 2018), Snowflake offers users optimal choices while freeing them from legacy upgrades.
Prior to examining the SQL Server 2008 to Snowflake migration prerequisites, let us briefly examine the major upgrade considerations. Snowflake is a true serverless cloud-based database and scales as resource needs like CPU, memory, and storage change. There’re various articles on the technical capabilities of Snowflake and why it is a viable cloud database to replace legacy databases.
Let’s examine the prerequisites for migrating from SQL Server to Snowflake.
Migration to Snowflake is much easier with Trianz’s Evove - a unique, highly automated migration technology. Evove produces a 95% migration of legacy data platforms to Snowflake’s state-of-the-art, cloud architecture with proven reliability and quality. Watch Video. In a recent use case, a customer had a 250TB box for redundancy and failover. The previous solution had a lot of expensive data sitting on it and Snowflake, Azure or AWS can act as a lower cost offload with equal performance in some cases for data and queries on other data platforms such as Teradata. If clients are still under contract with legacy vendors, Trianz can help you optimize your hybrid environment. As part of Evove, we can analyze and help select workloads that are better suited to Snowflake to free up your powerful TD boxes for heavy workloads.
For all your data footprint and migration conversations, you can reach out to us at [email protected].
Director of Analytics Practice
Kireet Kokala is a senior data technologist leader in the Data and Analytics Practice at Trianz who helps clients with digital transformation and data monetization. The Data and Analytics Practice works with enterprises to achieve significant competitive advantage via modern cloud technologies, with a particular focus on the Snowflake Computing ecosystem.
Contact Us Today
Better Insights in the Cloud Data analytics is not an entirely modern invention. The term “big data” was coined in the 1990s to describe massive data sets often used in the finance, science, and energy sectors. Since then, both the amount of data produced and the computing power it requires have grown at an astonishing rate. The tools and techniques honed through various scientific disciplines provide a platform for businesses to accelerate growth and make the most of their place in the market.Explore
What is Predictive Analytics? Predictive analytics is the practice of analyzing past and present data to predict a future outcome. Today, every industry from insurance and finance to healthcare and child services uses neural networking, machine learning, and artificial intelligence to build predictive models to solve complex problems and support better and faster business decisions.Explore
What is ITOM? IT operations management (ITOM) can be defined as the process of managing and maintaining an organization’s network infrastructure. An IT team is typically tasked with this work, covering aspects of computing such as compliance, security, and troubleshooting. This team works with internal and external network users, offering advice and remediation to overcome technical obstacles and maintain effective service delivery.Explore
Putting Data to Work Recently, one of the world’s largest global shipping companies was seeking to identify new revenue opportunities; specifically, they were interested in monetizing their data by building other, related business intelligence products for different industries. Like many other businesses, they had found themselves sitting on a mountain of actionable data without any processes in place to explore or leverage said data. Their intentions were now pointed in the right direction, but what they were missing was a data monetization strategy.Explore
The Data Tide Businesses in the digital age are inundated with data as it floods in from multiple channels. This data is both a challenge to wade through and an absolute goldmine. Its tremendous potential can be harnessed to communicate meaningfully with audiences and advance an organization’s brand awareness in the public eye. The problem is, however, that raw data itself can’t tell a compelling story to most people. It needs to be woven together artfully to create a narrative that connects with a specific audience. This is where data-driven storytelling comes in.Explore