Shahryar Hashemi

Solution Architect

1
Blog posts
setting up SQL Server on Linux
Greater performance with lower cost with SQL Server on Linux Data Warehouse
21 Aug 2019

What do you do when your data science team needs to perform read-only data warehouse queries against your mission-critical online transaction and batch processing database? Our customer Getty Images had exactly this problem with their production AWS deployment of SQL Server 2014 AlwaysOn on EC2 instances. Their data science team was performing read-only queries over 4 terabytes of historical data. These queries are ad-hoc and look at multiple months of historical data for analysis. The queries would consume all available I/O on the production databases environment and impede the performance of the primary workload. This blog talks about how w...