AWS Partner Network (APN) Blog

Tag: SQL

How to Build a Real-Time Gaming Leaderboard with Amazon DynamoDB and Rockset

For microservices that predominantly write data, Amazon DynamoDB provides an “always on” experience without the need for careful capacity planning, resharding, and database maintenance. These capabilities make DynamoDB a popular database service for various parts of game platforms like player data, game state, session history, and leaderboards. Learn how to pair Amazon DynamoDB with an analytics solution like Rockset to automatically index your data for fast search, aggregations, and joins at scale.

Read More

How Kloia Helped GoDataFeed Modernize Monolithic .NET Applications with AWS Serverless

Many enterprises have .NET Framework legacy applications they need modernize and convert to cloud-native. One of the largest product feed automation and optimization platforms, GoDataFeed has a back-end platform that ingests millions of items of catalog data from multiple sources. Learn how Kloia addressed GoDataFeed’s challenges by transforming their legacy .NET Framework monolithic application into a .NET Core-based decoupled architecture.

Read More
Cognizant-AWS-Partners

Change Data Capture from On-Premises SQL Server to Amazon Redshift Target

Change Data Capture (CDC) is the technique of systematically tracking incremental change in data at the source, and subsequently applying these changes at the target to maintain synchronization. You can implement CDC in diverse scenarios using a variety of tools and technologies. Here, Cognizant uses a hypothetical retailer with a customer loyalty program to demonstrate how CDC can synchronize incremental changes in customer activity with the main body of data already stored about a customer.

Read More

Running SQL on Amazon Athena to Analyze Big Data Quickly and Across Regions

Data is the lifeblood of a digital business and a key competitive advantage for many companies holding large amounts of data in multiple cloud regions. Imperva protects web applications and data assets, and in this post we examine how you can use SQL to analyze big data directly, or to pre-process the data for further analysis by machine learning. You’ll also learn about the benefits and limitations of using SQL, and see examples of clustering and data extraction.

Read More
Zadara_AWS-Competency

Microsoft SQL Standard Clustering Across AWS Availability Zones with Zadara Storage as a Service

With Zadara offering Storage-as-a-Service across Availability Zones, the platform’s centralized storage services release the ability to connect multiple Microsoft (MSSQL) servers in a standard Windows Server Failover Cluster model to a single set of shared storage volumes. This removes the need for MSSQL Enterprise Edition licensing and the doubling up of Amazon EBS disk for Amazon EC2 instances. In this post, explore the use of high availability MSSQL Standard Clustering on AWS with Zadara.

Read More
CloudZero_AWS-Partners

Improving Dataset Query Time and Maintaining Flexibility with Amazon Athena and Amazon Redshift

Analyzing large datasets can be challenging, especially if you aren’t thinking about certain characteristics of the data and what you’re ultimately looking to achieve. There are a number of factors organizations need to consider in order to build systems that are flexible, affordable, and fast. Here, experts from CloudZero walk through how to use AWS services to analyze customer billing data and provide value to end users.

Read More
AWS Partner Network

The Most Viewed APN Blog Posts in 2019

Take a look at the most popular APN Blog posts in 2019. Our goal with this blog is to share timely and relevant news, technical solutions, partner success stories, and more from Amazon Web Services and the AWS Partner Network (APN) specifically. The APN is the global partner program for AWS and helps tens of thousands of organizations across the world build, market, and sell their AWS-based offerings. Thank you for reading, and Happy New Year!

Read More
Datacoral_AWS Solutions

Building Serverless Data Pipelines on Amazon Redshift By Writing SQL with Datacoral

Amazon Redshift is a powerful yet affordable data warehouse, and while getting data out of Redshift is easy, getting data into and around Redshift can pose problems as the warehouse grows. Datacoral is a serverless data platform that manages metadata changes, data transformations, and orchestrating pipelines for data consumers. In this post, learn how to write Redshift SQL to represent data flow, and how serverless data pipelines get automatically generated for that data flow.

Read More