New SQL Server 2022 Functions and Best Tips in September (MSSQLTips 10/3/2022)

[tag] [MSSQLTips.com]( Cannot see this MSSQLTips.com newsletter? [] [View in browser]( [SQL Server Performance Monitoring and Tuning Tutorial - Improve Performance Now]( [How to calculate the Range of a Data Set using the GREATEST and LEAST SQL Server 2022 Functions]( In this article, we look at how to calculate the range of a data set by using the new GREATEST and LEAST functions available in SQL Server 2022.... By Koen Verbeeck - [Learn More]( [Identify SQL Server Performance Problems Quickly and Efficiently]( Attend this webinar to learn how to quickly identify SQL Server performance problems and how to address the most important issues.... [Learn More]( [SQL Server DROP TABLE IF EXISTS Examples]( In this article we cover various ways to check if a SQL Server table exists before trying to drop the table to avoid the error Msg 3701 Level 11 State 5 cannot drop the table because it does not exist or you do not have permission.... [Learn More]( [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.... [Learn More]( [How is the data quality in your SQL Server databases?]( Data is being generated at breakneck speed, and more companies are moving towards a data-driven culture. But many data professionals and companies still struggle with the challenge to improve data quality and accuracy in their systems.... [Learn More]( [Monitor, Manage and Improve Database Performance]( Around the globe, SQL Server professionals are being asked to support more applications, infrastructure and code, while continuously ensuring all applications are performing optimally. That is a tough mission to uphold without a means to monitor, di... [Learn More]( MSSQLTips - Last Month's Top Ten Tips [How To Retrieve the Last Non-NULL Value in SQL Server]( [Create, Read, Update and Delete Data in SQL Server Tables]( [Getting Started with SqlQueryStress for SQL Server Load Testing]( [Azure Cloud Data Orchestration, Ingestion and Data Preparation]( [How to Build a Data Science Time Series Model with SQL Server]( [SQL GROUP BY Queries to Summarize and Rollup Sets of Records]( [SQL Date Calculation Simplifications in SQL Server]( [Build Conditional SQL Server Logic - SQL IF, BEGIN, END, ELSE, ELSEIF]( [Compare Data from Two SQL Server Tables]( [How to Expand a Range of Dates into Rows with the SQL Server Function GENERATE_SERIES]( [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}