AWS Glue ETL service
Loading Amazon Redshift Data Utilizing AWS Glue ETL service
27 Dec 2017

Your CIO has made the decision to move to AWS and now you’re left wondering how to move your Enterprise Data Warehouse (EDW) on Teradata: should you opt for using Teradata Software Tiers on AWS Marketplace with EC2 instances, or consider migrating to Amazon Redshift? The latter option looks interesting, but there’s one big issue: Redshift doesn’t support stored procedures. You’ve got a plenty of procedural code as part of your Extract-Transform-Load (ETL) processes, but it’s not clear how you can move it to Redshift. In this article, we’ll look into how regular data loading jobs can be moved to Redshift using AWS ...

Webinar 2.9 Followup (Episode 12 – Columnstore Indexes)
19 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.9 – Columnstore Indexes If you missed the session, or would like to watch the recorded session, the recording will be available soon. Don’t miss the next webinar on January 9th: Viewing Query Plans!   The registration link will be posted here when available, In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Se...

Amazon Redshift Performance Tuning Tips
Using Amazon Redshift performance tuning tips to reduce query times by 800%
14 Dec 2017 , Andrei Ivanov

Often database administrators experience decreases in query performance with Amazon Redshift as the size of data increases. The problem becomes even more significant when we start talking about regularly executed queries. Design time decisions that were made with the given the statistics at the start of the project may not make sense with the new data and query patterns. So, this means that the Amazon Redshift cluster requires some optimization. See how these Amazon Redshift performance tuning tips can improve query execution times when users start noticing performance issues. Amazon introduced a feature called Redshift Optimization for the...

Webinar 2.8 Followup (Episode 11 – Compression)
12 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.8 – Data Compression     If you missed the session, or would like to watch the recorded session, the recording is available here.   Don’t miss the next webinar on December 19th: Columnstore Index Storage!   You can register here,   In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Server I...

Webinar 2.7 Followup (Episode 10 – Partitioning)
05 Dec 2017

Thanks to everyone who attended! You can get the slides and demo files here: Webinar 2.7 – Partitioning     If you missed the session, or would like to watch the recorded session, the recording is available here.   Don’t miss the next webinar on December 12th: Data Compression!   You can register here.   In addition, I am publishing a list of the upcoming topics. Please be aware they are subject to change or re-ordering. It’s not complete at this point, but it does show the planned topics for the next several months.  I will be updating it periodically. Related posts Why Learn About SQL Server Internals? Webi...