SQL NULL Values, Snowflake Deadlocks, SQL CAST for Conversions and Ensemble AI Models (MSSQLTips 4/26/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [SQL Server Performance Monitoring and Tuning Tutorial - Improve Performance Now]( [See Azure SQL Managed Instance in Action - Tomorrow!]( Come learn about Azure SQL Managed Instance directly from Microsoft, register for the event this week and check out demos on: - New Link Feature - Setup and Configuration - New SQL Server Disaster Recovery options from on-premises - Offload reporting with Transactional Replication and scale to meet SLAs [Register Now]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Getting Started with Ensemble AI Models in SQL Server]( In this article, we look at an ensemble AI model which can be considered a collection of two or more AI models that complement each other to arrive at an outcome for a set of historical data. ... [Read Now]( [mssqltips image]( [SQL Server Performance Tuning and Operational Monitoring]( Learn about the SQL Server performance and operational monitoring capabilities for DBAs with ManageEngine Applications Manager.... [Read Now]( [mssqltips image]( [How Snowflake Creates and Detects Deadlocks]( In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Extending SSIS ETL Capabilities]( Learn how to enhance native SSIS Packages with new connectivity options, components for productivity and exceptional performance with SolarWinds Task Factory.... [Read Now]( [mssqltips image]( [Learn about SQL NULL values and how SQL Server handles NULL in Queries]( Learn about NULL values and how SQL Server handles NULL values when querying data from tables and how some functions handle NULL values.... [Read Now]( [mssqltips image]( [Improve Data Quality for Healthcare, Clinical and Life Sciences Projects]( All companies fundamentally have the need to improve data quality for decision making. For healthcare, clinical and life sciences organizations, merging, reconciling and enhancing data is challenging for electronic medical records, clinical trials an... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL CAST Function for Data Type Conversions]( In this article we look at how to use the CAST function to change the data type for some data as well as compare CAST, CONVERT and PARSE functions.... [Read Now]( [mssqltips image]( [5 Real World Customer Success Stories High Availability For Healthcare Providers]( In this whitepaper learn about 5 different healthcare providers and what they did to create high availability solutions for their applications and ... [Read Now]( [mssqltips image]( [Power BI DAX CONCATENATEX Function: How and When to Use It]( In this article we cover various ways join and concatenate data in Power BI by using the DAX CONCATENATEX function.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]