New SQL Server 2022 Features, Migrate Database to Google Cloud and Week in Review (MSSQLTips 10/24/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [5 things to look for in a database monitoring tool - Read now]( [New and Enhanced Features in SQL Server 2022]( [New and Enhanced Features in SQL Server 2022]( Learn about some of the new features and enhancements in SQL Server 2022 and things you should consider adopting when moving to SQL Server 2022.... [How to Migrate a SQL Server Database to the Google Cloud using Cloud SQL]( [How to Migrate a SQL Server Database to the Google Cloud using Cloud SQL]( In this article, we look at how to migrate a SQL Server database to the Google Cloud using Cloud SQL.... [Monitoring: The ROI of Build vs. Buy]( [Monitoring: The ROI of Build vs. Buy]( There and pros and cons to building a monitoring system versus purchasing one: in other words, the ROI of build vs. buy. In this blog post, Grant Fritchey discusses when you should build, and when you should buy.... [SQL Server CROSS APPLY and OUTER APPLY]( [SQL Server CROSS APPLY and OUTER APPLY]( SQL Server introduced the APPLY operator, which is like a join clause and it allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between the join and APPLY operat... [Is a hybrid cloud the solution right for your SQL Servers?]( [Is a hybrid cloud the solution right for your SQL Servers?]( Enterprises are looking to provide business continuity across on-premises data centers and disaster recovery within the public cloud. This presentation guides you through the outline of how to ensure data is available wherever and whenever needed, to... [Rolling up multiple rows into a single row and column for SQL Server data]( [Rolling up multiple rows into a single row and column for SQL Server data]( I need a way to roll-up multiple SQL Server rows into one row. I know I can roll-up multiple rows using Pivot, but I need all of the data concatenated into a single column in a single row. In this tip we look at a simple T-SQL approach to accomplish ... [Optimize SQL Server Monitoring for Operational and Performance Needs]( [Optimize SQL Server Monitoring for Operational and Performance Needs]( Learn about how SQL Monitor saves significant time for operational tasks and performance monitoring for large SQL Server environments with instances on premises, in the cloud, running in virtualized environments, clusters, and Availability Groups.... [How to Get Current Date in SQL Server]( [How to Get Current Date in SQL Server]( In this article we will explore the different options for getting the current date from SQL Server and understand when to use one option over the other.... [SQL Server Transparent Data Encryption Alternative]( [SQL Server Transparent Data Encryption Alternative]( Our challenge is to offer the organization a seamless solution across numerous applications as well as editions and versions of SQL Server. How can we properly encrypt our SQL Server data to protect the organization?... MSSQLTips Week In Review [Create SQL Server Stored Procedures, Views and Functions]( [Create SQL Server Stored Procedures, Views and Functions]( Learn how to create SQL Server stored procedures, views, and functions with these various examples outlined in this article.... [Data Analysis with SQL Server Logarithmic Functions LOG() and LOG10()]( [Data Analysis with SQL Server Logarithmic Functions LOG() and LOG10()]( In this article, we look at how to use the SQL Server system functions, LOG and LOG10, to get logarithmic data values to be used for data analysis.... [Drop All Tables in SQL Server and Generate a List of Objects to Drop]( [Drop All Tables in SQL Server and Generate a List of Objects to Drop]( Learn how to drop multiple SQL Server objects with just one command and how to quickly generate a list of objects to drop.... [Money and Decimal Data Types for Monetary Values with SQL Server]( [Money and Decimal Data Types for Monetary Values with SQL Server]( In this article, we look at the differences between storing monetary values in SQL Server using the money data type versus the decimal data type.... [Refresh a Power BI Dataset using Microsoft Power Automate]( [Refresh a Power BI Dataset using Microsoft Power Automate]( Learn how to refresh a Power BI dataset by integrating Power Automate into the report.... [SQL Cheat Sheet for Basic T-SQL Commands]( [SQL Cheat Sheet for Basic T-SQL Commands]( In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table.... [SQL Server Indexes to Improve Query Performance]( [SQL Server Indexes to Improve Query Performance]( In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.... [What are the most popular SQL Server jobs?]( [What are the most popular SQL Server jobs?]( Learn about the current demand for SQL Server-related jobs and the trends for various positions as well as salary-related information.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}