Error Log Script, PostgreSQL, Azure Templates, and Replication

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [SQL Server to PostgreSQL Database Schema Conversion]( In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.... [Read Now]( [mssqltips image]( [Correct SQL Server Transactional Replication Issues with T-SQL and SSMS]( Learn how to address SQL Server transactional replication issues with these easy-to-follow steps using T-SQL and SSMS to troubleshoot and fix issues.... [Read Now]( [mssqltips image]( [Deploy and Configure PostgreSQL on an Azure Virtual Machine]( In this article, we walk through the steps on how to deploy and configure PostgreSQL on an Azure Virtual Machine.... [Read Now]( TODAY'S SCRIPT ON MSSQLTips -- Find Errors in SQL Server Error Log DROP TABLE IF EXISTS #errorLog; -- Use for SQL Server 2016 and later -- IF OBJECT_ID('tempdb..#errorLog', 'U') IS NOT NULL DROP TABLE #errorLog -- Use for Pre SQL Server 2016 CREATE TABLE #errorLog (LogDate DATETIME, ProcessInfo VARCHAR(64), [Text] VARCHAR(MAX)); INSERT INTO #errorLog EXEC sp_readerrorlog 0 -- specify log number - 0 is active log, 1 is archive log 1, etc. SELECT * FROM #errorLog a WHERE EXISTS (SELECT * FROM #errorLog b WHERE [Text] like 'Error:%' AND a.LogDate = b.LogDate AND a.ProcessInfo = b.ProcessInfo) Learn more: [Simple way to find errors in SQL Server error log](. RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Easy and Cost Effective way to Encrypt Every SQL Server Database]( Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.... [Read Now]( [mssqltips image]( [Azure Resource Management Templates to Simplify Cloud Entities]( In this article, we look at the Azure Resource Manager (ARM) tool to help you simplify the management of your Azure resources.... [Read Now]( [mssqltips image]( [Establish Secure Connections to Azure SQL using Service Principal Authentication with PySpark Code]( Learn how to establish secure connections to Azure SQL using Service Principal authentication so users can unlock the full potential of their data pipelines while maintaining optimal security and manageability.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]