Sort a List of Array Values, Replicate Data to Azure Synapse Analytics, SQL Cursors and Pivot vs UnPivot Examples (MSSQLTips 12/23/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server 2022 is now generally available]( [Bucket Sort Algorithm in Python to Sort a List of Array Values]( [Bucket Sort Algorithm in Python to Sort a List of Array Values]( Learn about how to implement a simple bucket sort algorithm using Python code to sort a list of array values.... [SQL Server 2022 is now generally available]( [SQL Server 2022 is now generally available]( Take advantage of the most cloud-connected release yet. SQL Server 2022 solves major challenges for data professionals by utilizing Azure for business continuity, seamless analytics, visibility, and governance over your entire data estate....... [Replicate Data to Azure Synapse Analytics with Azure Synapse Link for SQL]( [Replicate Data to Azure Synapse Analytics with Azure Synapse Link for SQL]( Learn about Azure Synapse Link to replicate one or more tables from Azure SQL Database or SQL Server 2022 to a dedicated SQL Pool in an Azure Synapse Analytics workspace....... [Correct SQL Server Blocking, High CPU, Excessive IO and more]( [Correct SQL Server Blocking, High CPU, Excessive IO and more]( Learn about how to address SQL Server performance issues such as blocking, high CPU utilization, excessive IO and more with SolarWinds Database Performance Analyzer....... [SQL Server PIVOT and UNPIVOT Examples]( [SQL Server PIVOT and UNPIVOT Examples]( In this article learn how to use PIVOT and UNPIVOT in SQL Server to transform your data output along with examples....... [Data Quality for Healthcare, Clinical and Life Sciences Projects]( [Data Quality for Healthcare, Clinical and Life Sciences Projects]( All companies fundamentally have the need to improve data quality for decision making. For healthcare, clinical and life sciences organizations, merging, reconciling and enhancing data is challenging for electronic medical records, clinical trials an...... [Find and Remove Duplicate Rows from a SQL Server Table]( [Find and Remove Duplicate Rows from a SQL Server Table]( Learn how to find and remove duplicate rows from a SQL Server table with and without a unique index....... [SSIS Components for Productivity, Connectivity and Performance]( [SSIS Components for Productivity, Connectivity and Performance]( Learn how to enhance native SSIS Packages with new connectivity options, components for productivity and exceptional performance with SolarWinds Task Factory....... [By Matteo Lorini - ]( [A closer look at CXPACKET wait type in SQL Server]( If you have a server that has more than one CPU core, you may experience high values of SQL Server CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact... [By Jeremy Kadlec - ]( [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 sequential ... [By Daniel Calbimonte - ]( [Study material for exam 70-535 Architecting Microsoft Azure Solutions]( Read this tip to find resources that will be helpful to pass Microsoft exam 70-535 Architecting Microsoft Azure Solutions.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}