Replace SQL Cursors, New SSMS Features, SQL Server 2022 Upgrade Options and more

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Replace SQL Cursors with OUTPUT and MERGE]( In this article, we look at various ways to avoid cursors by using set-based operations with OUTPUT and MERGE to ensure your SQL code can scale.... [mssqltips image]( [Stay Protected - Upgrade to SQL Server 2022]( Join Bob Ward for a demo packed webinar + live Q&A on your options for the rapidly approaching SQL Server 2014 end of support including: Extended Security Updates enabled by Azure Arc plus the benefits of upgrading to SQL Server on AMD EPYC... [mssqltips image]( [New Features - SQL Server Management Studio 20]( Learn about some of the new features and functionality of SQL Server Management Studio 20.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [Determine SQL Server Databases Free Space]( One of the functions of a DBA is to keep an eye on free space within the database and database files. The auto grow feature is great as a last resort, but proactively managing the database files is a better approach. Also, this information can be u... [mssqltips image]( [SQL Server 2022 Upgrade Options]( Learn about the latest SQL Server 2022 and on-premises innovation. This includes tips and tricks to take advantage of your upgrade while staying compatible. See how data center modernization with the latest AMD processors will help with management, s... [mssqltips image]( [Correct SQL Server Data Quality in SSIS]( Learn about the Melissa Data Quality Solutions for SSIS.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [Query All Databases Across Multiple SQL Servers and Store Results in Table]( In this article, learn how to query all databases on multiple SQL Servers and store the results in a single table.... [mssqltips image]( [SQL Server Monitoring and Troubleshooting Simplified]( Learn how SQL Sentry enables SQL Server DBAs to pinpoint performance problems in minutes to minimize the impact to organizations. ... [mssqltips image]( [Data Transformation and Migration Using Azure Data Factory and Azure Databricks]( In this article, learn how to use Azure Data Factory and Azure Databricks for data integration to manage a variety of data formats, including batch-streaming and unstructured and structured data.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]