SQL SUM for Aggregations, Azure Storage, ALTER TABLE and New Disaster Recovery Option from Microsoft (MSSQLTips 4/20/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [SQL Server Graphical Query Plan Tutorial - Get Started]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Mount Azure Storage and Cosmos DB to Azure Databricks]( In this article, we will walk through how to mount different types of Azure storage like Azure Blob Storage, Azure Data Lake Gen 2, Azure SQL, and Azure Cosmos DB, to Azure Databricks for data-related projects.... [Read Now]( [mssqltips image]( [Simple SQL Server Disaster Recovery 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]( [mssqltips image]( [Aggregate and Summarize Totals with SQL SUM]( In this article, we look at different examples of using SUM when aggregating and summarizing totals when working with SQL Server data.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Quickly Diagnose SQL Server Performance Issues]( Learn about how to address SQL Server performance issues such as blocking, high CPU utilization, excessive IO and more with SolarWinds Database Performance Analyzer.... [Read Now]( [mssqltips image]( [Change SQL Server Table Structures with SQL ALTER TABLE]( In this article, we look at how to make changes to SQL Server table structures using T-SQL commands to add, delete and change columns in a table.... [Read Now]( [mssqltips image]( [Improve Data Quality for SQL Server Reports]( Poor data quality for any reason is very expensive in terms of man hours and decision making to all organizations. There are a number of ways to address the issue with both SQL Server Reporting Services and Power BI. Learn about Melissa's solution t... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Snowflake Temporary Tables vs. Transient Tables]( Learn about temporary tables and transient tables when using Snowflake along with their similarities and differences and when to use these types of tables.... [Read Now]( [mssqltips image]( [Quickly Deploy SQL Server on Linux using AWS Launch Wizard]( Learn how to quickly deploy a SQL Server on Linux (standalone) on Ubuntu (Linux) using AWS Launch Wizard.... [Read Now]( [mssqltips image]( [Enforce data integrity rules on your Delta tables using Synapse Mapping Data Flow]( In this article, we look at ways to enforce data integrity when working with Delta Lake tables when using Azure Synapse Analytics. ... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]