TOP N, SQL STUFF, SQL REPLACE, Monitoring Tools and more (MSSQLTips 4/11/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Return TOP (N) Rows using APPLY or ROW_NUMBER() in SQL Server]( In this article, we will compare APPLY to ROW_NUMBER() for returning the TOP (n) rows from a SQL Server table.... [Read Now]( [mssqltips image]( [Monitor physical, virtual, and cloud SQL Server environments]( Reduced availability and performance of Microsoft SQL Server can severely impact the critical applications that it supports. SQL Diagnostic Manager for SQL Server provides robust SQL Server monitoring functionality that covers the performance of the ... [Read Now]( [mssqltips image]( [Extend your Power BI Reports with Analysis Services 2022 Data]( This tip walks through the steps of how to combine data from SQL Server Analysis Services SSAS 2022 with other data using Power BI Desktop.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [SQL Server Monitoring On-premises and Cloud for Management and DBAs]( The use of SQL Server in the cloud continues to grow, but there is still the need to manage on-premises installations. Learn about one tool that can help you manage all of your SQL Server installations whether they are on-premises or in the cloud to ... [Read Now]( [mssqltips image]( [SQL STUFF vs SQL REPLACE vs SQL WRITE in SQL Server]( Learn about the similarities and differences of STUFF, REPLACE, and WRITE when working with SQL Server text data.... [Read Now]( [mssqltips image]( [The flexibility of hybrid options with Azure SQL Managed Instance]( Learn how Azure SQL Managed Instance can support your hybrid approach. You will learn how to leverage the link feature for Azure SQL Managed Instance to: use Azure services without migrating, build a disaster recovery site in Azure, offload read-only... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [New functions in SQL Server 2022 - LEFT_SHIFT and RIGHT_SHIFT]( Learn about the new functions LEFT_SHIFT and RIGHT_SHIFT in SQL Server 2022 and how these functions could be used.... [Read Now]( [mssqltips image]( [SQL Server Survey - Please Share Your Expertise]( [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.... [Read Now]( [mssqltips image]( [Azure Databricks Version Control for Notebooks]( Learn about how to setup and configure source control when using Azure Databricks notebooks in this article we look at how this can be done with GitHub.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]