SQL CONVERT Examples, Error Handling, Database Mail and Data Quality

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [SQL Convert Examples for Dates, Integers, Strings and more]( In this article, we look at how to use the SQL CONVERT function to convert between data types such as date, integers, strings, and more.... [Read Now]( [mssqltips image]( ) [SQL Server Pathways in the Cloud]( ) Read this infographic by Fortune to find the best pathway for migrating and modernizing your SQL Server workloads in the cloud.... [Read Now]( ) [mssqltips image]( [SQL Server TRY CATCH, RAISERROR and THROW for Error Handling]( Learn about SQL Server error handling using TRY CATCH, RAISERROR, and THROW for stored procedures, triggers, and user-defined functions.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Analyze Live Data from Snowflake with SSAS]( Learn how to use the CData ADO.NET adaptor for Snowflake and SSAS Multidimensional to create a solution where users can connect live to Snowflake using tools like SSAS and Power BI. ... [Read Now]( [mssqltips image]( [Setting up Database Mail for SQL Server with SSMS]( In this tip learn how to setup and configure database mail for SQL Server.... [Read Now]( [mssqltips image]( [Best-of-class SQL Server Performance Monitoring and Alerting]( Learn about SolarWinds' SQL Sentry designed to monitor SQL Servers, collect Key Performance Indicators (KPIs), highlight poorly performing queries, identify performance-related issues, and send alerts to notify DBA teams promptly.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server Database Properties]( Finding out information about database settings is not that hard when you use Enterprise Manager or Management Studio, T-SQL commands such as sp_helpdb or query the system tables directly. But the way the information is returned may not always be th... [Read Now]( [mssqltips image]( [Improve Data Quality for SQL Server Reporting]( Poor data quality for any reason is very expensive in terms of man hours and decision making to all organizations. There are a number of ways to address the issue with both SQL Server Reporting Services and Power BI. Learn about Melissa's solution t... [Read Now]( [mssqltips image]( [Aggregate and Summarize Totals with SQL SUM]( In this article, we look at different examples of using SUM when aggregating and summarizing totals when working with SQL Server data.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]