Learn how you can return data from one ADF pipeline for use in another.
The post Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics appeared first on SQLServerCentral.

While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. The Stack Exchange network logs a lot of web traffic – even compressed, we average well over a terabyte per month.
The post Normalize strings to optimize space and searches appeared first on SQLServerCentral.

If you haven’t had time to catch up on our latest full-length webinar on Cloud Migration, here’s an easy way to digest the tips from our experts in less than 20 minutes!
The post Mastering a cloud migration: 10 video tips appeared first on SQLServerCentral.

In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.
The post Improve Query Performance when SQL Server Ignores Nonclustered Index appeared first on SQLServerCentral.

Batch execution mode is a new optimization feature in SQL Server. In this Article, we'll explore how Batch execution mode works and how you can use it to get faster query results on Rowstore data.
The post Batch Execution Mode on a Rowstore in SQL Server 2022 appeared first on SQLServerCentral.

Learn how you can configure an Azure Data Factory pipeline that is triggered by an email being sent to an address.
The post Trigger the Execution of an ADF Pipeline from an Email appeared first on SQLServerCentral.

Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June 1970). Some more work followed up after that by other people, giving us normal forms and other things we have taken for granted for 50+ years.
The post First Normal Form Gets No Respect appeared first on SQLServerCentral.

This article looks at ways to clean up text data used in Power BI reports and charts for a more meaningful and consistent message.
The post Power Query Editor in Power BI for Formatting Text Columns appeared first on SQLServerCentral.