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
The amounts of data available to us are growing at an exponential rate, due to the prevalence of the internet in modern life. Businesses have an increasing need to categorize the data that they process and format it in ways that are accessible to both staff and customers alike.Explore
The number of people using the internet has increased dramatically over the past few decades, rising from a mere 350 million users to over 4 billion in 2019. This rise in usage means that there are 12x more people now using the internet in 2019 compared to 2000, resulting in a massive increase in the amounts of data being processed daily.Explore
For those of you in the dark, Tableau is a top CRM and analytics platform that was recently acquired by Salesforce. Along with data and business analytics, Tableau delves into data visualization: presenting data in a way that is understandable even to the non-analyst.Explore
Tableau is a business intelligence and analytics platform that was built to transform raw datasets into easily understandable visualizations. The top CRM and analytics platform was recently acquired by a customer relations management firm, Salesforce, which gives a solid backing to Tableau’s reputation as one of the industry’s leading data visualization firms. This emerging technology firm has helped with customer digital transformations for many large corporations, such as Amazon, Walmart, and Lenovo, who have discovered the benefits of visualizing their data with Tableau.Explore
Whether you’re aware of it or not, predictive analytics—the practice of analyzing past and present data to predict an outcome—is everywhere. Using technology like neural networking, machine learning, and artificial intelligence, predictive analytics firms are forecasting the future in everything from banking and finance to healthcare and child services.Explore
Organic and Artificial Intelligence are both converging at an increasing rate, namely due to considerable strides in computational power improvements, investment into AI research and an expanding pool of data to analyse. Much like the human brain, these AIs are trained to find patterns in the information they analyse—whether auditory, visual or alphanumeric data.Explore