Smarter SQL Server Performance Tuning, SQL Metadata, Microsoft Fabric and Replace SQL Cursors

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Metadata to Manage Stored Procedures, Functions and Views]( In this article, we look at using SQL Server metadata to better manage SQL code for things like stored procedures, user-defined functions, views, and more.... [mssqltips image]( [SQL Server Disaster Recovery Strategies]( Being able to recover our data in the event of an outage is a critical aspect of managing SQL Server. But how do we plan for the worst? What technologies are available to us? And how do we implement a disaster recovery strategy when the worst has jus... [mssqltips image]( [Query Microsoft Fabric GraphQL API from an External App]( This tip covers executing a Microsoft Fabric query using GraphQL API from an external application, introducing opportunities for data sharing, and exposing data through custom code.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [Smarter SQL Server Performance Tuning]( In this webinar, we look at how to optimize performance for SQL Server environments using a cost-based approach versus just optimizing the slowest code.... [mssqltips image]( [Mastering SQL Server Local and Global Temporary Tables]( In this article, we walk through the syntax for creating SQL Server local and global temporary tables and some use cases for when and how to use them.... [mssqltips image]( [SQL Server Best Practices for Data Quality]( Data Quality | SSIS Integration - Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a ... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [SQL Server Management Studio New Features]( Learn about some of the new features and functionality of SQL Server Management Studio 20.... [mssqltips image]( [Build a Secure SQL Server REST API in Minutes]( Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner.... [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.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]