SQL JOIN Types with Examples, Data Enrichment in Lakehouse, Relative Strength Index, SQL Functions and more (MSSQLTips 12/15/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Developer Enemy #1: Bad Data]( [SQL JOIN Types with Examples]( [SQL JOIN Types with Examples]( In this article we take a look at the different types of JOINs that you can use in SQL Server to join tables along with examples and additional references.... [How to Change Hostname of Various Linux Systems]( [How to Change Hostname of Various Linux Systems]( In this article we look at how to change the host name for a Linux server running on Red Hat Linux, SuSE Linux or Ubuntu.... [Developer Enemy #1: Bad Data]( [Developer Enemy #1: Bad Data]( Bad data lurking in your database? Melissa can help you find, fix, or flush your bad data with 37+ years of expertise in data quality, address verification and identity resolution. Download our solutions catalog today to explore free trials and POCs.... [Implement Data Enrichment in Lakehouse using Synapse Analytics Mapping Data Flow]( [Implement Data Enrichment in Lakehouse using Synapse Analytics Mapping Data Flow]( In this tip we explore another common Lakehouse transformation, data enrichment, when using Azure Synapse Analytics.... [Powerful SQL Server Data Cleansing and Processing]( [Powerful SQL Server Data Cleansing and Processing]( The constant data management moving target tends to overwhelm the SQL Server DBAs and Developers with the need for immediate response of updating the validation and import code to then load the data to meet the business requirements between the organ... [Compute the Relative Strength Index for Time Series within SQL Server]( [Compute the Relative Strength Index for Time Series within SQL Server]( In this article we cover how you can use T-SQL code to compute Relative Strength Index using Time Series data along with examples and explanations of the code.... [Need to Migrate from a Legacy Data Warehouse?]( [Need to Migrate from a Legacy Data Warehouse?]( Learn how to connect Microsoft SQL Server Analysis Services (SSAS) multidimensional MDX cubes with Snowflake to modernize your data warehouse.... [SQL Server RIGHT Function]( [SQL Server RIGHT Function]( See it in action! The RIGHT function is used to provide the right part of a string according to a specified number of characters.... [Monitor, Manage and Improve Database Performance]( [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... [By Greg Robidoux -]( [How to rename a SQL Server database]( In this tip we look at different ways to rename a SQL Server database. ... [By Arshad Ali -]( [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.... [By Ray Barley -]( [SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions]( I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Our Privacy Policy]( | [Constant Contact Data Notice]( Sent by newsletter@mssqltips.com