SQL Triggers, Power BI Connections, Convert APPLY to JOIN and Data Quality in ETL Pipelines

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Convert OUTER APPLY and CROSS APPLY Joins for Snowflake]( This article shows how you can convert OUTER APPLY and CROSS APPLY joins using LEFT JOINS in Snowflake since OUTER APPLY and CROSS APPLY are not supported.... [Read Now]( [mssqltips image]( [Reduce your SQL Server Costs in the Cloud]( Customers have increasing demand to optimize SQL Server costs in the cloud and in this webinar we will look at how AWS Compute Optimizer provides proactive cost optimization recommendations while still providing the needed resources for your database... [Read Now]( [mssqltips image]( [An Introduction to SQL Triggers]( Learn about SQL Server triggers and how to use them for inserts, updates, and deletes on a table, along with step-by-step examples.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Seamless Monitoring and Reporting for SQL Server]( SolarWinds SAM provides a one-stop method to easily and seamlessly implement a top tier monitoring and reporting system for your SQL Servers and entire infrastructure.... [Read Now]( [mssqltips image]( [Connect Power BI to Azure Data Lake Gen2 Storage for Reporting]( Learn how to connect Azure Data Lake Gen2 storage to Power BI to develop reports and charts using files stored in Azure.... [Read Now]( [mssqltips image]( [Learn How NextGen Healthcare uses the Cloud]( [Video - Case Study] Learn about the best practices and journey undertaken by NextGen Healthcare to migrate to the cloud. From goals, challenges, business drivers, migration options and more.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server Cursor Example]( A SQL Server cursor is a set of T-SQL logic to loop over a predetermined number of rows one at a time. The purpose for the cursor may be to update one row at a time or perform an administrative process such as SQL Server database backups in a sequen... [Read Now]( [mssqltips image]( [Improve Data Quality in Your ETL Pipelines]( Learn about the Melissa Data Quality Solutions for SSIS.... [Read Now]( [mssqltips image]( [SQL Database Snapshots for Reporting, Auditing and Data Recovery]( In this article we look at how to create a SQL Server database snapshot and how snapshots can be used for reporting, auditing and more.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]