Reuben Cooley’s Post

[ETL Webinar] Migrate Your SSIS Skills to Azure Data Factory Intended for: BI/Data Warehouse Developers and Data Engineers with SSIS (or other ETL tools) experience but little to no ADF experience. Azure Data Factory (ADF) is now looked at as the replacement of SSIS in the cloud. Learn what you need to know to make the transition from SSIS to ADF in this webinar. Register Today >>> https://lnkd.in/eCNsb3Bt #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #migration #azure #cloud #azuredatafactory #businessintelligence #etl #ssis #adf #datawarehouse

[Free ETL Webinar] Migrate Your SSIS Skills to Azure Data Factory Azure Data Factory (ADF) is now looked at as the replacement of SSIS in the cloud. Learn what you need to know to make the transition from SSIS to ADF in this webinar. Target Audience: BI/Data Warehouse Developers and Data Engineers with SSIS (or other ETL tools) experience but little to no ADF experience. Register Today >>> https://lnkd.in/exn5yqaY #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #migration #azure #cloud #azuredatafactory #businessintelligence #etl #datawarehouse #ssis #adf

[Free ETL Webinar] Migrate Your SSIS Skills to Azure Data Factory Azure Data Factory (ADF) is now looked at as the replacement of SSIS in the cloud. Learn what you need to know to make the transition from SSIS to ADF in this webinar. Target Audience: BI/Data Warehouse Developers and Data Engineers with SSIS (or other ETL tools) experience but little to no ADF experience. Register Today >>> https://lnkd.in/e54MqXeh #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #migration #azure #cloud #azuredatafactory #businessintelligence #etl #datawarehouse #ssis #adf

[ETL Webinar] Migrate Your SSIS Skills to Azure Data Factory Intended for: BI/Data Warehouse Developers and Data Engineers with SSIS (or other ETL tools) experience but little to no ADF experience. Azure Data Factory (ADF) is now looked at as the replacement of SSIS in the cloud. Learn what you need to know to make the transition from SSIS to ADF in this webinar. Register Today >>> https://lnkd.in/exGbc3s8 #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #migration #azure #cloud #azuredatafactory #businessintelligence #etl #datawarehouse #ssis #adf

[ETL Webinar] Migrate Your SSIS Skills to Azure Data Factory Intended for: BI/Data Warehouse Developers and Data Engineers with SSIS (or other ETL tools) experience but little to no ADF experience. Azure Data Factory (ADF) is now looked at as the replacement of SSIS in the cloud. Learn what you need to know to make the transition from SSIS to ADF in this webinar. Register Today >>> https://lnkd.in/eqGry_Sf #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #migration #azure #cloud #azuredatafactory #businessintelligence #etl #datawarehouse #ssis #adf

[ETL Webinar] Migrate Your SSIS Skills to Azure Data Factory Intended for: BI/Data Warehouse Developers and Data Engineers with SSIS (or other ETL tools) experience but little to no ADF experience. Azure Data Factory (ADF) is now looked at as the replacement of SSIS in the cloud. Learn what you need to know to make the transition from SSIS to ADF in this webinar. Register Today >>> https://lnkd.in/eVv6S7hu #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #migration #azure #cloud #azuredatafactory #businessintelligence #etl #ssis #adf #datawarehouse

Need some help with your data? https://lnkd.in/ewP92dGh #dataengineer #dba #sqlserver #powerbi #azure #mongodb #posgresql #consulting #snowflake #redshift #bigquery #aws #azure #sql #developer

Maximize Your AWS Budget: 3 Practical Tips for Data Loading to Redshift & Athena 🔹 leverage compression - Convert your data into columnar formats like Parquet before loading. These formats compress and organize data by column, significantly reducing the amount of data scanned by Redshift and Athena, leading to lower query costs. 🔹 leverage S3 for cost saving - Store raw data in S3 and use it as a staging area before moving to Redshift or querying directly with Athena. Implement lifecycle policies on S3 to transition older data to cheaper storage classes like S3 Infrequent Access or Glacier to save on storage costs. 🔹 off peak is cheaper - Use AWS Lambda to automate data loading processes during off-peak hours. This not only ensures you’re using resources when they’re cheaper but also avoids traffic spikes that can affect performance and costs. But the best of them all is, in case you are paying external vendors for ETL, consider self running the pipelines to save 99% of your cost. Here's a guide to replace 5tran https://lnkd.in/eKs7abiT And here's one to replace Segment: https://lnkd.in/eGmkB_Jj

AWS Aurora and its Zero-ETL feature is a nice addition to simplify integrations between an OLTP database - Aurora - and a DW - Redshift. One of the major issues with this integration is writing the ETL pipeline, which can be time-consuming to develop and maintain. With Zero-ETL, this integration is done almost seamlessly between these 2 engines. Now, an improvement for this was introduced, which allows to filter tables on this integration, which allows to save costs from both the integration side and the DW storage, as less, non-important data is filtered from the pipeline. Alternatives for this, if you wish to have more control over it, would be to use AWS DMS or Apache Airflow, for example. Worth a try. https://lnkd.in/ecUU83YF

Today's blog takes a look at the Azure SQL Migration Extension for Azure Data Studio. Make your migration experience to Azure SQL a smooth transition with this valuable tool. You can read the full post at the URL below: https://lnkd.in/gYTnJ-8p #sqlserver #sqlserverdba #sqltips