Cloud Management Considerations, Azure Auto-Failover Group, SQL Server 2022 and Week in Review (MSSQLTips 12/5/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server 2022 is now generally available]( [Efficient Cloud Management Considerations]( [Efficient Cloud Management Considerations]( If you want to use cloud resources efficiently, learn how to make sure you fully address five main areas of cloud management: costs, regulations, resources, identity, and deployment automation.... [Configure Auto-Failover Group for Azure SQL Database and Azure SQL Managed Instances for SQL Server]( [Configure Auto-Failover Group for Azure SQL Database and Azure SQL Managed Instances for SQL Server]( This tip will show how to configure auto-failover groups for Azure SQL Database and Azure SQL Managed Instances for SQL Server.... [SQL Server 2022 is now generally available]( [SQL Server 2022 is now generally available]( Take advantage of the most cloud-connected release yet. SQL Server 2022 solves major challenges for data professionals by utilizing Azure for business continuity, seamless analytics, and visibility and governance over your entire data estate....... [SQL Server Subquery Example]( [SQL Server Subquery Example]( In this part of the temporary data store tip series we look at using subqueries to select data as well as how to use for inserts, updates and deletes....... [How To Troubleshoot SQL Server Using Wait Stats]( [How To Troubleshoot SQL Server Using Wait Stats]( One of the first things you should check when investigating SQL Server performance issues is wait statistics - as these can often point you in the direction for further analysis. Attend this webinar to learn more about SQL Server wait stats and how t...... [Different Ways to Format Currency Output in SQL]( [Different Ways to Format Currency Output in SQL]( In this article we look at different ways to format currency output in SQL Server and most notably the different options the FORMAT function provides....... [Quickly Pinpoint SQL Server Performance Issues]( [Quickly Pinpoint SQL Server Performance Issues]( My team needs to quickly pinpoint the performance issues in my SQL Server environment. With all of the demands at work, our team needs to find and understand the issues, then review the code and take corrective actions. We need to ensure our produc...... [Learn the SQL WHILE LOOP with Sample Code]( [Learn the SQL WHILE LOOP with Sample Code]( In this article we will look at examples of a SQL Server WHILE loop in T-SQL and discuss alternatives like a CTE and cursor....... [Microsoft SQL Server Data Warehouse Data Quality, Cleansing, Verification and Matching]( [Microsoft SQL Server Data Warehouse Data Quality, Cleansing, Verification and Matching]( Data Quality | SSIS Workflow | Downloadable Solution - How can we clean, validate and enhance our Contact dimension in our SQL Server Data Warehouse without writing code?...... MSSQLTips Week In Review [Configure Active Geo Replication for Azure SQL Database]( [Configure Active Geo Replication for Azure SQL Database]( Learn how to set up and configure a failover database for Azure SQL Database using Active Geo-Replication.... [Deploy and Configure Azure SQL Managed Instance]( [Deploy and Configure Azure SQL Managed Instance]( This article covers how to deploy, configure and test the managed instance version of Azure SQL Database using the General-Purpose edition.... [Heapq Module in Python: Using Heaps and Priority Queues]( [Heapq Module in Python: Using Heaps and Priority Queues]( In this tutorial, learn about Python priority queues and heaps, how do they relate, and how to use the heapq module in Python.... [How to get a date and time from a SQL Server RowVersion value with T-SQL]( [How to get a date and time from a SQL Server RowVersion value with T-SQL]( Check out this article to help you figure out real dates and times when using a SQL Server RowVersion value.... [Monitor SQL Deadlocks in Amazon RDS for SQL Server]( [Monitor SQL Deadlocks in Amazon RDS for SQL Server]( Learn how to configure and capture SQL Server deadlocks when using Amazon RDS for SQL Server.... [Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back]( [Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back]( Learn how to control which SQL Server transaction will get rolled back when a deadlock occurs by using DEADLOCK_PRIORITY.... [SSIS Bad Habits: Decreasing SSIS Package Performance]( [SSIS Bad Habits: Decreasing SSIS Package Performance]( This tip will explain some mistakes SSIS developers usually make when designing ETL and how they should be avoided to help improve performance.... [Strategies to Improve SQL Server Storage Performance]( [Strategies to Improve SQL Server Storage Performance]( Learn about important considerations for SQL Server Professionals building and managing large databases - storage, lower life cycle environments, performance, IO, backups, snapshots, DBCCs and more.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}