Upcoming SQL Server Events, T-SQL and Snowflake Development Tips and more (MSSQLTips 2/23/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Stored Procedure Tutorial]( [Snowflake for SQL Server Developers - NULL Functions - Part 2]( [Snowflake for SQL Server Developers - NULL Functions - Part 2]( Learn about NULL functions that exist in Snowflake but not in SQL Server like NVL2, ZEROIFNULL, EQUAL_NULL, and IS_NULL_VALUE. ... [SELECT DISTINCT SQL Command to Return a Unique List of Values]( [SELECT DISTINCT SQL Command to Return a Unique List of Values]( Learn about the SELECT DISTINCT SQL command to return a unique list of values from SELECT queries along with several examples.... [SQL Server in Azure - Learn about the latest offerings]( [SQL Server in Azure - Learn about the latest offerings]( Learn how Microsoft Azure SQL Managed Instance can simplify your daily operations, eliminate app refactoring, accelerate app modernization and open new scenarios for data mobility between on-premises and the cloud....... [Database Monitoring and Management - Manage more, better and for less]( [Database Monitoring and Management - Manage more, better and for less]( Multiple database platforms, tools and time-consuming troubleshooting only increases the complexities, costs and IT’s efficiency. With dbWatch Control Center, it is possible to monitor and manage more instances on various platforms with greater effic...... [SQL Server ROW_NUMBER for Ranking Rows]( [SQL Server ROW_NUMBER for Ranking Rows]( This article covers how to use SQL Server ROW_NUMBER() which is a ranking function that returns a rank value for each row in a group or groups. ...... [Maximizing Uptime: High Availability for SQL Server and Multi-Platform Environments]( [Maximizing Uptime: High Availability for SQL Server and Multi-Platform Environments]( Learn about key high availability considerations for SQL Server, and how to design and implement a robust and effective high availability solution in multi-platform environments....... [Tame the Most Demanding Virtualized SQL Server Environments]( [Tame the Most Demanding Virtualized SQL Server Environments]( With the busiest and most performance challenged SQL Server workloads being virtualized, the setup, configuration and management of your VMware environment is absolutely critical for success. Come learn tips, tricks and best practices for virtualizi...... [SQL COUNT and SQL COUNT DISTINCT in SQL Server]( [SQL COUNT and SQL COUNT DISTINCT in SQL Server]( This tip shows several examples of COUNT and COUNT DISTINCT to show how SQL Server handles them differently....... [Calculating Costs for Microsoft SQL Server]( [Calculating Costs for Microsoft SQL Server]( This white paper looks at how costs can be controlled with sufficient understanding of the Microsoft SQL Server licensing process....... [By Mohammed Moinudheen - ]( [Setup SQL Server Database Mail to use a Gmail, Hotmail, or Outlook account]( Database Mail | Configuration - In this tip we will walk through how you can setup SQL Server Database Mail to use email services like Gmail, Hotmail or Outlook. ... [By Jeremy Kadlec - ]( [SQL Server Cursor Example]( A SQL Server cursor is a set of T-SQL logic to loop over a predetermined number of rows one at a time. The purpose for the cursor may be to update one row at a time or perform an administrative process such as SQL Server database backups in a sequential ... [By Nat Sundar - ]( [Importing JSON Files Using SQL Server Integration Services]( In this tip we look at how to import JSON files using SQL Server Integration Services.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}