Week in Review + SQL Server Databases, Recover Recently Closed Tab in SSMS and SQL Server 2022 with Bob Ward (MSSQLTips 5/16/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Graphical Query Plan Tutorial - Get Started]( [SQL Database Overview]( [SQL Database Overview]( Learn about what a SQL database is, what is stored in a database and how to interact with a database.... [Recover Recently Closed Tab in SSMS]( [Recover Recently Closed Tab in SSMS]( Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.... [SQL Server Performance and Operational Monitoring for DBAs]( [SQL Server Performance and Operational Monitoring for DBAs]( Learn about the SQL Server performance and operational monitoring capabilities for DBAs with ManageEngine Applications Manager.... [Update only Year, Month or Day in a SQL Server Date]( [Update only Year, Month or Day in a SQL Server Date]( Date Modification | Sample Scripts - In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.... [Learn about SQL Server 2022 with Bob Ward]( [Learn about SQL Server 2022 with Bob Ward]( [Webcast] Introduced last November SQL Server 2022 is the most cloud enabled version Microsoft has ever released. But the excitement does not stop there, continued performance, features and security innovations continue to be released as they move cl... [Join SQL Server tables where columns include NULL values]( [Join SQL Server tables where columns include NULL values]( Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.... [SQL Server Data Cleansing for Data Stewards]( [SQL Server Data Cleansing for Data Stewards]( Learn about a solution built for Data Stewards enabling them to validate, lookup, cleanse, import and export data via an intuitive project-oriented framework.... [Handling error converting data type varchar to numeric in SQL Server]( [Handling error converting data type varchar to numeric in SQL Server]( We received the message "Error converting data type varchar to numeric" when we tried to import values that look like numbers. In this tip we will show a workaround to solve this issue.... [Seamless Monitoring and Reporting for SQL Server]( [Seamless Monitoring and Reporting for SQL Server]( Fully monitoring your SQL Server and its related environment can be quite a chore. The SolarWinds Server and Application Monitor (also known as SAM) provides a one-stop method to easily and seamlessly implement a top tier monitoring and reporting sy... How to modernize on-prem environments with Azure Arc Data Services Today more companies invest in hybrid and multi-cloud technologies for flexibility to innovate anywhere to meet their evolving business needs. To help our partners meet customer demand, on May 18 Microsoft is hosting a webinar on how to modernize on-prem environments with Azure Arc Data Services. Exclusive to partners, this 2-hour virtual event is designed to provide an overview of use cases and product capabilities, and most importantly, to showcase how you could expand your migration & modernization practice to customers' on-prem environments. We have two sessions scheduled and both are open for registration now. Come and join us on May 18! - EMEA Session, May 18, 2022, 9AM (BST, London) - [Registration Link]( - Americas Session, May 18, 2022, 9AM (PST, Seattle) - [Registration Link]( MSSQLTips Week In Review [Advanced Databricks Lakehouse Capabilities]( [Advanced Databricks Lakehouse Capabilities]( Learn about several different aspects of Databricks Lakehouse such as encryption, row level security, visually viewing query plans, SQL merge, change data capture and more.... [Build a Secure SQL Server REST API in Minutes]( [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.... [Easily Deploy SQL Server Failover Cluster Instance on AWS]( [Easily Deploy SQL Server Failover Cluster Instance on AWS]( In this article we learn how to build a SQL Server Failover Cluster on AWS along with the steps to deploy using the AWS Launch Wizard.... [How to Avoid Making Remote Desktop Connections to SQL Server]( [How to Avoid Making Remote Desktop Connections to SQL Server]( In this article we learn how to avoid having to make remote desktop connections to SQL Server and still be able to install, patch, read error logs and manage SQL Server.... [How to Encrypt and Decrypt CSV File in SSIS]( [How to Encrypt and Decrypt CSV File in SSIS]( In this article we look at how you can use a SQL Server Integration Services (SSIS) package to encrypt and decrypt data to and from a flat file.... [Power BI Desktop - What is it and how do I use it?]( [Power BI Desktop - What is it and how do I use it?]( Learn about Power BI Desktop the stalwart development tool used for the bulk of report and dashboard design work in Power BI.... [Search all String Columns in all SQL Server Tables or Views]( [Search all String Columns in all SQL Server Tables or Views]( In this article we look at T-SQL script you can use to search for a string in every table and view in every database or in a specific database.... [SQL Server CLR Table Valued Function]( [SQL Server CLR Table Valued Function]( Learn how to create table valued functions (TVF) using common runtime language (CLR) in SQL Server along with a couple of simple examples to get you started.... [Steps for Upgrading Always On SQL Servers and Skipping Versions]( [Steps for Upgrading Always On SQL Servers and Skipping Versions]( In this article we look at a checklist you can follow to upgrade an Always On SQL Server environment from one version of SQL Server to a later version.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}