T-SQL Coding and SQL Server 2022 Productivity Tips (MSSQLTips 2/17/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Azure SQL Managed Instance - The broadest SQL Server engine compatibility]( [SQL STUFF vs SQL REPLACE vs SQL WRITE in SQL Server]( [SQL STUFF vs SQL REPLACE vs SQL WRITE in SQL Server]( Learn about the similarities and differences of STUFF, REPLACE, and WRITE when working with SQL Server text data.... [Accelerate modernization in the cloud with the broadest SQL Server engine compatibility]( [Accelerate modernization in the cloud with the broadest SQL Server engine compatibility]( Accelerate application modernization with the latest managed SQL Server capabilities in the cloud. Keep using familiar tools and SQL Server features when you move your custom and vendor-provided apps to Azure SQL Managed Instance....... [My Favorite T-SQL Enhancements in SQL Server 2022]( [My Favorite T-SQL Enhancements in SQL Server 2022]( A few of the most useful changes in SQL Server 2022 so far are GREATEST, LEAST, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES and I will cover each one and show practical use cases. ...... [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...... [How to use the New WINDOW Clause in SQL Server 2022]( [How to use the New WINDOW Clause in SQL Server 2022]( In this tip, we'll introduce the new WINDOW clause in SQL Server 2022 and it can simplify queries with multiple OVER clauses....... [Easy and Cost Effective way to Encrypt Every SQL Server Database]( [Easy and Cost Effective way to Encrypt Every SQL Server Database]( Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner....... [Add and Subtract Dates using DATEADD in SQL Server]( [Add and Subtract Dates using DATEADD in SQL Server]( Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function....... [Improve Your Data Warehouse Now]( [Improve Your Data Warehouse Now]( 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?...... [By Greg Robidoux - ]( [How do You Identify Object Dependencies in SQL Server]( In this article we look at different ways to determine if one SQL Server database object is dependent on another database object.... [By Tim Ford - ]( [SQL Server function to convert integer date to datetime format]( In this tip we look at code you can use to convert an integer date into a datetime format. This is an issue you will face when working the history data for SQL Server Agent Jobs.... [By Daniel Calbimonte - ]( [Study material for exam AZ-400 Microsoft Azure DevOps Solutions]( If you are preparing for Microsoft AZ-400 Exam Microsoft Azure DevOps Solutions take a look at these list of resources to get you prepared.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}