SQL Variable Performance Issues, DBA Checklist, Azure Tips and Microsoft Fabric API

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [API for GraphQL in Microsoft Fabric]( Learn how to share data currently stored in a Microsoft Fabric warehouse using a GraphQL API along with the steps to set this up.... [mssqltips image]( [Amazon RDS Custom for SQL Server]( Learn about scenarios that make Amazon RDS Custom the ideal choice for SQL Server in the AWS Cloud - managed services with application flexibility and granular control to the OS and database.... [mssqltips image]( [Azure Managed Instance Download and Restore SQL Server Backup]( Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [Get Free Access to Azure SQL Database for a Lifetime]( Read this article to learn how Azure offers free access to an Azure SQL Database serverless configuration for a lifetime.... [mssqltips image]( [Easily Create Non-Sensitive Copies of Production Databases]( Learn how to obfuscate sensitive data and personally identifiable information (PII), all while ensuring the data remains useful for testing and analysis. Explore how DataVeil can help you mitigate risks, ensure compliance, and maximize the quality of... [mssqltips image]( [SQL Local Variables and Performance Issues]( In this article, we examine the effect of local variables on T-SQL queries and how these could potentially cause performance issues.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [Cheat Sheet for SQL Server DBA Daily Operations]( This article contains various code fragments and scripts that could be used to manage and check on SQL Server and databases.... [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]( [SQL Server Loop through Table Rows without Cursor]( Comparison of SQL loop through table row options with a SQL Server Cursor versus a While Loop. ... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]