April 2022 Top Tips, Azure Data Factory Webinar, Microsoft ETL Tools and Azure SQL Database Change Data Capture (MSSQLTips 5/2/2022)

[tag] [MSSQLTips.com]( Cannot see this MSSQLTips.com newsletter? [] [View in browser]( [SQL Server Performance Monitoring and Tuning Tutorial - Improve Performance Now]( [Overview of ETL Tools in the Microsoft Data Platform – Part 1]( In this article we look at various ETL tools to help with importing data into SQL Server such as Integration Services, Azure Data Factory and Azure Logic Apps.... By Koen Verbeeck - [Learn More]( [Configure and Query Change Data Capture (CDC) data for Azure SQL Database]( Learn how to setup and use Change Data Capture for Azure SQL Database including steps to enable and query the data from the CDC tables.... By Rajendra Gupta - [Learn More]( [Introduction to Azure Data Factory]( [Webcast] Azure Data Factory (ADF) is the tool in the Azure cloud for creating your data pipelines. It allows you to move and transform data from a multitude of sources to as many possible destinations. In this session, we will give an introduction t... [Learn More]( [Using MERGE in SQL Server to insert, update and delete at the same time]( In this tip we look at an example to help you better understand how the SQL Server MERGE statement works.... [Learn More]( [Monitor, Manage and Improve Database Performance]( Around the globe, SQL Server professionals are being asked to support more applications, infrastructure and code, while continuously ensuring all applications are performing optimally. That is a tough mission to uphold without a means to monitor, di... [Learn More]( [SQL Convert Date to YYYYMMDD]( In this article we look at different ways to use the date format YYYYMMDD in SQL Server.... [Learn More]( [Simple SQL Server Data Masking and Protection]( Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly. Learn about how DbDefence protects your data.... [Learn More]( [SQL Server Download Quick Links]( SQL Server download quick links are included in this tip for the SQL Server engine, Express Edition, Service Packs, tools and more. Be sure to bookmark this page to use as a quick and comprehensive reference guide.... [Learn More]( [How do you correct your SQL Server Data?]( [Survey] With the proliferation of data across the globe, data quality, accuracy and management present significant challenges for data professionals in the SQL Server community. Share your experiences.... [Learn More]( MSSQLTips - Last Month's Top Ten Tips [PowerShell for the DBA – FOR and WHILE Loops]( [SSIS Bad Habits: Inefficient Data Staging Strategies]( [Power BI Desktop - The What, Why and How]( [Getting Started with SQL DATEDIFF and DATEDIFF_BIG Functions with Use Cases]( [SQL Server Ports for Various Components]( [Snowflake vs Azure SQL Database]( [How to Import Excel Sheet into SQL Server Table]( [SQL Server vs Oracle: Encrypt Communication using TLS 1.2]( [ETL to Extract, Transform and Load Data for Business Intelligence]( [Understanding the DATEADD SQL Function and its use cases]( [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}