Get Database Insights Across Your Environment (MSSQLTips 5/3/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [SQL Server Integration Services Tutorial - Start Learning]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Get Database Insights Across Your Environment]( Learn how to improve your database efficiency with SolarWinds Database Insights, which combines two enterprise-ready products: Database Performance Analyzer (DPA) and SQL Sentry. ... [Read Now]( [mssqltips image]( [Five Costly Myths About High Availability in Cloud]( Separating the facts and myths of HA and DR in cloud deployments can help you save money and reduce risk of downtime and data loss.... [Read Now]( [mssqltips image]( [SQL RAISERROR to Better Handle Errors]( Learn how and why to use RAISERROR in your SQL Server code to be able to better handle errors that may occur during code execution.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [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 sequen... [Read Now]( [mssqltips image]( [Email Validation Simplified with Web API and SSIS]( Email based validation is more than just a simple RFC check, this is where Melissa's Global Email Verification with a web-based API and SSIS delivers valuable data to SQL Server Professionals.... [Read Now]( [mssqltips image]( [SQL NOT IN Operator]( This tip will cover the SQL NOT IN operator and explain the functionality and use cases with several NOT IN examples. ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server Connection Strings using SqlClient, OLDEDB and ODBC]( In this article we look at different ways to define a connection string to connect to SQL Server using SqlClient, OLDEDB and ODBC connections.... [Read Now]( [mssqltips image]( [Seamless Monitoring and Reporting for SQL Server]( SolarWinds SAM provides a one-stop method to easily and seamlessly implement a top tier monitoring and reporting system for your SQL Servers and entire infrastructure.... [Read Now]( [mssqltips image]( [Enabling xp_cmdshell in SQL Server]( In this tip we look at how to enable xp_cmdshell for SQL Server and some of the errors you may encounter when using xp_cmdshell as well as how to disable xp_cmdshell.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]